SQL Server Dba Online Training

Course Duration : 30 Hrs
Learners : 200
Reviews : 4.6

KITS SQL Server Server DBA Online Training Course will impart you the necessary skills to become a successful DataBase Administrator. It starts from the basics to the advanced level and shows the way to clear the Certification

KITS Online Training Institute provides best Microsoft SQL server DBA online training by well trained and certified trainers. We are delighted to be one of the best leading IT online training with best experienced IT professionals and skilled resources. We have been offering courses to consultants, companies so that they can meet all the challenges in their respective technologies. Training given by KITS are of high quality and we also provide cost effective learning. We Also Also provide Server Access. In this course you can gain knowledge on Constructing and Managing Databases, Handling Server and Database Security, Granting and Revoking Permissions, Streamlining Tasks with Jobs, Alerts and Database Mail and Database Maintenance and Monitoring. We also provide other courses like Sql Server Developer.

SQL Server 2016 Installation
Server Components and Purpose
Firewall Options and Instance Rules
Service Accounts, Purpose and Usage
Authentication Modes & Logins
Instance Configuration Options
Testing Multiple Installations
Management Studio (SSMS) Tool Usage
Shared Features and Client Components
Troubleshooting the failed Instance
Moving the System Dbs
Establishing Downtime For Maintenance
Precautions for Maintenance Activities
Service Packs and Patch/hotfix Activities
Server Upgrades and Precautions
Planning for Maintenance Activities
Pre Database Maintenance Activities
Post Database Maintenance Activities
Steps for doing the Side by Side Migration
Migration with Backup and Restore Method
Migration with Copy Database Wizard
Migration with Attach and Detach Method
Migration of the Logins and Fixing Orphan users
Crosscheck after Migration
Process Plan for doing the Migration
Steps to be taken Prior to Migration
Troubleshoot if any issues with Migration
Merits/Demirits of theSide by Side Migration
Migration of the Jobs and SSIS packages
Import and Export utility
Scripts for copying the tables with data
Configuration of the Network Protocols
Dedicated Administator Connection(DAC) configuration
Configuration of the Database Mails,Operators,Alerts
Database (DB) Mail Configurations
Securing DB Profiles : SMTP Accounts
DB Mail Profiles and Public Tokens
Creating Operators and Emails
What is RAID Levels and chosing the Best suited for All DBs
Database Configurations
Attaching and detaching SQL Server databases.
Configuration of the Network Protocols
Dedicated Administator Connection(DAC) configuration
Configuration of the Database Mails,Operators,Alerts
Database (DB) Mail Configurations
Securing DB Profiles : SMTP Accounts
DB Mail Profiles and Public Tokens
Creating Operators and Emails
What is RAID Levels and chosing the Best suited for All DBs
Database Configurations
Attaching and detaching SQL Server databases.
What is TempDB
Optimization of TempDB
Curroption of TempDB
How to troubleshoot and avoid common tempdb issues
How to monitor and tune tempdb performance
Starting and Stopping the SQL Server Services
Configuration Manager
Net commands
Command Prompts and SQL CMD
Starting the Dbs in Single user Mode
Starting in Minimal Mode and case study
Resolving the issues System DBs
Rebuilding the System Dbs and Master Db
What is a database and a database management system (DBMS)
Tasks of a Database Administrator
ACID Properties
The Life Cycle of a Query
The Relational and Storage Engines
The Buffer Pool
A Basic Select Query
A Simple Update Query
Recovery
Difference between Checkpoint and LazyWriter
Types of System Dbs
Startup Parameters
Licencing of SQL Server
Pages & Types of Pages
Extents and Types of Extents
Managing Extents
Real Time handling Log file issues
Database Catalog and Storage Options
Data Files : Purpose and Storage
Filegroups : Purpose and Usage
Log files : Purpose and Audits
Virtual Log files and DMVs for troubleshooting
Shrinking the Log files
Sizing and Placement – Data Files
Sizing and Placement – Log Files
Locations and Sizing Recommendations
Filegrowth and MAXSIZE Options
Scripting Database Structures
Security
Security Architecture
Fixing the Server Roles
Creating Logins
Creation of the Alias
Fixed Database Roles
Database Users
Permissions
Grating object level permissions
Schemas and User Mappings – Usage
SQL Server Agent and Monitoring the Agent logs
Troubleshooting the Jobs with help of Logs and Event Logs
Steps for creation of Jobs with different steps(CMD,SSIS etc)
Job Activity Monitor and History Deletes
Testing Job Failures and Notifications
Database Maintenance Plans (SSIS)
DB Maintenance Strategies & Schedules
Backup Files and Space Management
Reorganizing Indexes with DB Maint. Plans
Monitoring tools used for SQL Server Monitoring
Log file Viewer and Maintenace of Log File Viewer
Activity Monitor
Database reports
Monitoring Processes in T-SQL
sp_who and sp_who2
sys.dm_exec_connections
Multiserver Management
Central Management Servers and Server Groups
Trace Flags
Backups Concept and Mechanism
Backups Usage and Limitations
Data Backups – Syntax and Types
Log Backup Mechanism and Use
Tuning Database Backup Operations
File Backups and Filegroup Backups
COMPRESSION, CHECKSUM and STATS
Remote Backups and Security Options
Backup Jobs and SQL Agent Service
Scheduling Backups & Strategies
FILELISTONLY and VERIFYONLY Options
Compatibility, Recovery Model Options
Working with Recovery Models & Backups
Backups using UI and SSMS Tool
COPY_ONLY Backups and Importance
Point-In-Time Restores & Recovery
Overwrite Options for DB Restores
Realtime issuse with backup management
VLDB optimization
Log Shipping Overview
Configutation of the Log Shipping
Deploy Log Shiping
Log Shipping Role Changing
How to deal with Log Sync issues
DB Mirroring Architecture & Use
Mirroring Configuration Scenarios
Backups & Restores for Mirrors
Automatic Fail-Over Procedures
Manual Fail-over Options & Scenarios
PARTNER OFFLINE Conditions & Options
DB Mirror Monitors and Commit Loads
Architecture
Availability Group Replicas and Roles
Availability Modes
Types of Failover Supported
Allowing Read-Only Access to Secondary Replicas
Availability Group Example
Confi gure a New Availability Group
Confi gure an Existing Availability Group
Availability Group Failover Operation
Secondary Replica Client Connectivity
AlwaysOn Group Dashboard
Monitoring and Troubleshooting
Understanding SQL Clustering Need
SQL Server Clustering Architecture
Windows Server Installation Options
SP Installation and Quorum Options
Verifying SQL Cluster Installation
Software RAID Configuration and Issues
SQL Server Cluster Installation (VM)
Add Nodes to SQL Server Cluster
SQL Group and AD Syncup Operations
SAN System for Shared Data Storage
Replication Overview
Replication Components
Replication Types
Implementing Replication
Setting Up Snapshot Replication
Setting Up Distribution
Implementing Snapshot Replication
Implementing Transactional
Scripting Replication
Monitoring Replication
Replication Monitor
Replication DMVs
Understanding the Memory

Windows and Memory
Physical Memory
Tuning 32-Bit Systems
Tuning 64-Bit Systems
SQL Server Memory
Understanding Wait Statistics
Locks an currency
Lock Types
Blocking and how to monitor the blocking
DMVs for monitoring the blocking
Impact of blocking and how to improve the blocking
Audits – SQL Server Profiler Tool Usage
What is Deadlock
Tace flag 1204 and 1222
capture teh Deadlocks from graph and Profilers
How the deadlocks are cleared
How the deadlocks managed by SQL Server
Table and Index Architecture
CLuster and Non Cluster indexes
What is Heap
Cluster index structure
Non Cluster index structure
Index fragementation
Scan and Seek in indexes.
Missing indexes.
DMVs for checking the indexes
What is DTA
SQL Trace and Server Trace
What is Wait stats and DMVs
Common Causes of High CPU Usage
Missing indexes
Outdated statistics
I/O
Disks
Performance counters for Disk I/Os
What is Paging and Page Fault
Types for Page Fault
Dynamic Management Views
Types of Wait Stats and Causes

Self-Paced

  • Learn at your convenient time and place
  • Grab the practical exposure of the course through high-quality videos
  • Learn from basic to advanced level of the course led by real-time instructors

Online

  • Get a live demonstration of every topic by our experienced faculty
  • Get LMS Access of every session after the completion of the course
  • Gain the stuff to get certified

Corporate

  • Can enroll for Self paced, Live (or) the class mode of training
  • Engage in online training lecture by an industry expert at your facility
  • Learn as a full day schedule with discussions, exercises, and practical use cases
  • Design your own syllabus based on the project requirements
The trainer is a real-time expert and has a significant amount of technology
Irrespective of your class attendance, every session will be recorded. Soon after the completion of the class, you can able to access the videos
During the course, the trainer will provide the environment to execute the practical's.
Once you contact us, our support team will offer you great discounts.
Yes! we do accept the fee in installments, depending on the mode of training you take.
We offer the best training on different modes like self-paced, one-one, batch as well as corporate training.
Yes! Our support team will take your resumes and forward to the firms for placement assistance
During the course, the trainer will provide the probable certification question to make you certified.
11 December
08:00 AM
21 December
21:00 PM

Click here to Login to add a review.

Very satisfied with the knowledge I gained from this training."
- Preetam Shinde
I enjoyed this training class. Had little knowledge about RDBMS, but Srini explained every step in his SQL Server DBA training materials and made sure every student understood the concept and real-world application.
- Kala Narenthirakumar
I have completed SQL server dba training at Kits Online Training. The trainer has good experience in providing various practical use cases
- Paul Peterson
KITS SQL Server DBA Online Training covered each topic with exciting lectures. The presentation of materials was excellent, making it easy to understand even for the beginners. The support team were very punctual in providing the recorded videos
- Jennifer Keller
SQL Server DBA Training by KITS introduces the administration of SQL Server DBA from basics to the advanced level. Thanks to the team for creating such useful content.
- Deepak Arora

100% Online Course

Flexible Schedule

Beginner Level To Advance Level

Real-Time Scenarios With Projects

LMS Access

Interview Questions & Resume Guidelines Access