USA LaoTu 高薪转行做数据第一平台
只要你有颗求变的心并愿意行动，到这里来，必使你得改变！成千聪明华人循此捷径高薪进入大公司！ => 坚定正确的转行方向 高薪捷径 视频试看 => Topic started by: USA LaoTu Support Team 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. (http://student.usalaotu.com/make_payment.php)