SQL Server 2012 DBA Friday 6:00pm-9:00pm 08/30

[USA LaoTu Support Team]

SQL Server 2012 DBA  硅谷专家  多年 经验传授
Introduction to SQL 2012  DBA
6:00pm-9:00pm Friday  08/30 to 10/4   6 weeks

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.

[USA LaoTu Support Team]

Question:
Teacher laotu,
 
I am a SQL student of your.  I am planning to register  your new MS SQL DBA class.  I am taking an IT support position now.  Could you tell me which one has better job market and life style,  a SQL DBA or a data analyst?
 
Thanks!

Answer:

There are many job openings for Database Analyst.
Company prefer Database Analyst with some DBA skills.
That's the reason why this SQL Server 2012 DBA class is open.
It is opened with requests from Database Analyst students.
Both Database Analyst and DBA jobs offer very good lifestyle.

[Ding Ding]

who is the teacher of this class?

[USA LaoTu Support Team]

Teacher is Mr. Lin.
A Sr. SQL Server DBA with almost twenty years experience  large companies of Silicon Valley.
Read the content of the class he will teach, you will know they are all hot skills of SQL Server DBA job.

[Ding Ding]

请问老土老师 如果注册这门课后除了可以download Mr. Lin 的 video， 你还给一份以前讲过的video download 吗？

[jingzzsaccount]

Hi Lin Lao Shi and Laotu LaoShi,

Thank you very much for offering the sql DBA 2012 class! I think this class is an excellent complement to sql DBA 2008, and the two classes offer a great coverage and depth of sql DBA knowledge.

Mr. Lin is very good instructor. He is very clear in explaining concepts and why we have to do certain things as well as explaining detailed steps. He is very resourceful and helpful! 

Unfortunately, I didn't have time to do all the homework, but I will try to do some in my spare time.

Mr. Lin -- hope to "see you around" at Laotu's class!

Best regards
Jing

[USA LaoTu Support Team]

Strongly agree.  Thanks Mr. Lin!

[USA LaoTu Support Team]

SQL Server DBA Package Student will get 2008 and 2012 DBA course material.

[SolutionDBA]

Jing,

No worry for unfinished homework. I understand everyone is busy with their routine schedule.  If you want to catch up and ask questions, feel free to send me personal message from this forum, which will send to my mailbox promptly.  I couldn't feel more satisfied when I see my students learned and applied the knowledge from the class.

[ellie]

Can anyone tell me what is the requirement for computer to study SQL 2012 DBA class? Thanks!

[USA LaoTu Support Team]

做课堂练习和项目最好用Laptop, Windows 8 or 7:
    CPU: Intel i3, i5, i7
    Memory >= 8GB;
    Hard Drive >= 320 GB
    Brand name: Buy whatever brand name you like.    Many of us use Lenovo.
    Lenovo G580 : http://www.amazon.com/Lenovo-15-6-Inch-Laptop-Brown-Metal/dp/B00ATANTR2/ref=pd_sim_pc_4