This class will use SQL 2012 as platform and will focus on new features of SQL 2012, although the first half of the lecture will review concept of SQL server DBA in general.
Week1 – SQL 2012 New features overview, SQL editions and licensing, Installation, Upgrade, and Migration Strategies. Main responsibility of SQL DBA – backup/restore, HA/DR, performance tuning, architecture design, new instance deployment.
Week2 – SQL Agent – setup and automate SQL Agent jobs, backup and restore databases. SSIS – Transfer data from different data source, linked server, querying remote data source. PerfMon, SQL Profiler. Optional* SSAS – Business Intelligence.
Week3 – High-Availability and Disaster-Recovery. Database Mirroring, Log Shipping
Week4 - Traditional Windows and SQL clustering. Installation and setup.
Case study - Monitor SQL instance balance in a stacked SQL cluster environment using PowerShell.
Week5 - SQL server AlwaysOn Availability Group – architecture, setup, configuration, listener, primary & secondary replica. Combine different HA technologies such as clustering and AlwaysOn. Demo of AG failover.
Week6 – SQL server AlwaysOn Availability Group continued - Backup and restore of AlwaysOn AG.
SQL Server 2008/2012 DBA Package $1398 (include 2008/2012 both DBA courses)
SQL Server 2012 DBA $998
SQL Server 2008 DBA $899
Click here: Register course use Credit Card.
Topic: Content of SQL Server 2012 DBA High Availability course (Read 9938 times)