| 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
Get More:http://akirait.com/sql-dba-training/ |
