MS Sql Server 2012 DBA Course Content
SQL Server Architecture
- Introduction to SQL Server 2012
- SQL Server 2012 Editions & Capacity Planning
- Pages & Extents
- Files and File groups
- Thread and Task Architecture
- Memory Architecture
- T-Log Architecture
Installing,Upgrading, Configuration,Managing services and Migration
- SQL server 2012 Installation
- Upgrading to SQL server 2008 R2/2012
- Managing services
- Configuring SQL Server 2012
- Migrating SQL server
Security,Automation & Monitoring
- Automating Administrative Tasks
- Monitoring SQL Server
- Security
Backup & Restore,High Availability & Replication
- Backup & Restore
- Log Shipping
- Database Mirroring
- AlwaysOn Availability Groups
- Replication
Windows & SQL Server Clustering
- Windows Server 2012 Clustering
- Installing SQL Server 2012 Fail-Over Clustering
- Administering a SQL Server 2012 Failover Cluster
- High Availability: Interoperability and Coexistence
Performance Tuning, Indexing & Optimizing SQL Server
- Optimizing SQL server
- Indexing
- Locking & Concurrency
- Performance Tuning