性能价格比最好的手机服务 3 months of 5GB 4G LTE a month and unlimited talk and text for only $20 bucks.
您还在为孩子留学美国而烦恼吗?快找德美留学!不用考托福和SAT,成绩优异者保证进美国名校;英语不达标的,进优质大学。1对1,精准投,超常规,不录取不收费! 网址:www.demei.info

Author Topic: Content of SQL Server 2012 DBA High Availability course  (Read 7365 times)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4063
  • Karma: +35/-11
Content of SQL Server 2012 DBA High Availability course
« on: December 01, 2013, 06:41:13 PM »
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.