SQL DBA Training

Module Name Topic Details
Module  1 Starting with SQL Server
DBA Responsibilities
History of SQL Server -Versions
SQL Server 2005/2008/2008 R2/2012 Service Packs
Editions of SQL Server
Tools of SQL Server
Hardware/Software Requirements
Instances
CASE STUDIES
Module 2 Installing and Configurations
Installing SQL Server 2005/2008/2012
Pre -Installations steps
Post-Installations steps
Installing Service packs
Configuring Various Services
Startup Parameters
CASE STUDIES
Module 3 Working With Data Bases
Working With Data Bases
Database Architecture
Creating Databases
Adding Files and File groups
CASE STUDIES
Module 4 Implementing Security
Security In SQL Server 2008/2012
Types of Authentications
Understanding Server Roles/ Data Base Roles
Working with Users
Resolving Orphan users
CASE STUDIES
Module 5 Backup and Restoration
Backup Types
Why we need backups
Setting Recovery Model
Understandings T-log architecture
Truncating Log file
Backup System databases
Backup Devices
Performing Restoration
CASE STUDIES
Module 6 Automating  Administrative Tasks
Working With database mails
Configuring Linked Servers
Creating SQL Server Jobs
Maintenance Plans
CASE STUDIES
Module 7 High Availability
Working With Log shipping
Features of Log shipping
Configuring Log shipping
Monitoring Log shipping
Jobs
Log shipping Tables and Stored Procedures
Working With Replication
Configuring Replication
Types of replications
Replication agents
Managing Replication
Monitoring Replication
Working With Mirroring
Requirements of Mirroring
Configuring
Monitoring
Servers Involved in Mirroring
Types of Mirroring
Mirroring failover
Hands on
Module 8 Advanced administrations Concepts
Maintenance Plans
Monitoring Tools
Trouble Shooting
Monitoring and Tuning SQL Server
SQL Server Architecture
Managing Data bases
SQL Server Up gradations
Using DBCC Commands
Module 9 Clustering SQL Server
Introduction To Cluster Environment
Overview Of windows clustering
Requirements
Installing and configuring
Applying Service packs and Hot fixes
Patching clustered Instances
Module 10 SQL Server 2014 DBA Concepts
Introduction to SQL server 2014/2016
Always on (HA/DR) Features
Contained databases
New Updated DMVs