India: +91 406677 1418

WhatsApp no. : +919100386313

USA: +1 909 233 6006

Telegram : +15168586242

MS SQL SERVER 2012 DBA

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