USA LaoTu 高薪转行做数据第一平台
只要你有颗求变的心并愿意行动，到这里来，必使你得改变！成千聪明华人循此捷径高薪进入大公司！ => 注重实战的教学作风 新开课程 时间内容 => Topic started by: USA LaoTu Support Team on August 10, 2015, 09:10:55 AM
-
SQL Server 2012/14 DBA Term1 (100% English) 8:00 to 12:00 Sunday 09/13 to 10/25
7 x 4 hour sessions, total 28 hours.
Teacher Mr. Jon, Microsoft PMP / MCP:
Sixteen years of professional IT experience as a Database Administrator with large corporate databases. Strong experience with Hosting Solution on Healthcare industry. Over 4 years of DBA Engineering Team Lead managing multiple projects and mentoring team of DBAs both onshore and offshore.
Highly proficient in implementing SQL High Availability Solution using AlwaysOn/Replication/Log Shipping/Windows Clustering.
Expertise with VLDB (>10 TB) and complex database solution.
Expert level experience with capacity planning, DR, Database Servers infrastructure configuration and maintenance.
DB Migrations / upgrades and consolidations (including P2V) database server to SQL Server 2012.
Extensive experience with automate DBA tasks, proactive monitoring, virtualization, backup & restore.
Expert experience for analyzing/troubleshooting and problem solving database errors (Including deadlock errors, performance issues and connectivity errors).
Experienced working with business partners and users of different groups and departments.
Course Content:
Class 1: SQL Server DBA Basics / Install automation / Best Practices – 4hrs
(1) Introduction - 20min
(2) Start with some basic/interesting topics - 30min
- What do you expect in the DBA job interview?
- What are the role of a DBA? Do you wait for tickets to come and then start working?
- What is orphaned user, when do you see that, how to troubleshoot?
- Your transaction log is full - what do you do?
- Transaction log backup is not truncating the log file, what is going wrong?
(3) Break - 10 min
(4) SQL 2012/2014 a brief overview – 30min
(5) Start with some installation tips. (Assuming all students know how to install SQL 2012/2014) - 20min
- How do you automate installation?
- How do you automate Service Pack and Cumulative update installation?
(5) Break - 10 min
(6) Demo on installation automation – 30min
(7) Installation/upgrade on Failover Cluster/AlwaysOn Availability - 20min
(8) Break - 10 min
(9) Installation best practices – 30min
- Where to place "tempdb" database
- Storage allocation
(10) Question / Answer / Interview Tips - 20min
(11) Lab for Students - discussion and expectation - 10min
Class 2: backup and recovery/Database Maintenance - 4hrs
(1) Discussion on Lab exercise from previous class - 20min
(2) Database Backup - 30min
- Recovery Model
- Full/Differential/T-log backup
(3) Break - 10min
(4) Restoring Database - 40min
- Restoring Database
- Restoring to point-of-failure
(5) Question/Answer/DBA tips - 10min
(6) Break - 10min
(7) Backup History and maintenance plan - 50 min
- Designing Maintenance plan for Backup
- SQL Server Agent for scheduling backups
- Database Email notification
(8) Break - 10min
(9) Restoring System databases - 40min
(10) Question/Answer/DBA tips - 10min
(11) Lab for Students discussion and expectation - 10min
Class 3: Automation of SQL Server/Agent Jobs/SQL mail and SQL Server Security - 4hrs
(1) Discussion on Lab exercise from previous class - 20min
(2) How to configure SQL Agent - 20min
(3) Configure SQL Mail and automating Alerts – 10min
(3) Break - 10min
(4) Automating maintenance plan/backup/restore - 30min
(5) Introduction to Powershell scripting - 20 min
(6) Break - 10min
(7) Database Security - 50 min
(8) Break - 10min
(9) Configuring contained database - 40min
(10) Question/Answer/DBA tips - 10min
(11) Lab for Students discussion and expectation - 10min
Class 4: Performance Tuning/Database Maintenance/monitoring - 4hrs
(1) Discussion on Lab exercise from previous class - 10min
(2) Understanding Database Indexes - 15min
(3) Checking index fragmentation and defrag them - 25min
- Rebuild vs Reorganize index
(4) Break - 10min
(5) Database Statistics / Maintenance plan - 30 min
(6) SQL Server Maintenance Plan and Agent Jobs for regular maintenance - 20min
(7) Break - 10min
(8) SQL Server Profiler - 50 min
- Creating Traces and analyze them
- Extended Event basic for SQL 2014
(9) Break - 10min
(10) VLDBs, SAN, SSD and partitioning Strategies - 20
(11) How to troubleshoot database blocking with SQL DMV - 30
(12) Question/Answer/DBA tips - 10min
(13) Lab for Students discussion and expectation - 10min
Class 5: High availability - 4hrs
(1) Discussion on Lab exercise from previous class - 20min
(2) Log-shipping demo - 30min
(3) Break - 10min
(4) Mirroring - Pros-Cons – 20min
(5) Transactional Replication – 30min
(6) Break – 10min
(7) Achieving high availability with Failover Cluster Instances – 50min
(8) Break – 10min
(9) Overview of AlwaysOn HA – 40min
(10) Question/Answer/DBA tips - 10min
(11) Lab for Students discussion and expectation - 10min
Advanced DBA Topics
Class 6: Some Advanced SQL 2012/2014 Topics - 4Hrs
- SQL 2014 Change Data Capture
- SQL 2014 SSD Buffer pool extension
- SQL 2014 in memory OLTP Engine
- SSRS install and configure
- SQL 2014 Extended Event configuration
Class 7: How to configure AlwaysOn High Availability – 4hrs
More information later.
-
Great,Please fill me in, thanks!
-
Hi Laoshi,
I didn't see the price for this class. Can you please let me know: 1) where to find the price? 2) is this the same as SQL Server package listed in the class list on the registration page?
Thanks.
-
Thanks for your asking.
Will publish price information soon.
This is a different class with he previous classes.
-
请问laotu 老师，
这个SQL DBA 讲课老师 是这个视频里的同一位老师吗？
这个课之后， term 2是更高级课的吗？
另外， 请问 oracleDBA 是laotu 老师 讲吗？ 下一期 大概什么时候开课？
盼望解答
感谢
-
这个SQL DBA 讲课老师 是这个视频里的同一位老师吗？
----不是同一位老师， 是全部讲英语的老师
-
Registration Price:
SQL Server 2014 DBA (English) $1399 for general public
SQL Server 2014 DBA (English) $999 for student paid $2999 and up
SQL Server 2014 DBA (English) $799 for student paid $4999 and up (http://www.usalaotu.com/student/pay.php)
-
any pre requisition besides SQL Server 2012?
-
No, as long as you know SQL, you will be OK.
-
HI Laotu,
What's the timezone 8:00-12:00? AM or PM?
I live in Europe, so I have to re-calculate it.
thanks,
A.
-
timezone 8:00-12:00? AM ---是指加州时间早上，or called pacific time or PDT time (Pacific daytime savings time)
-
Yes, it is USA PST. Or Los Angeles Time.
It is afternoon if Europe time.
-
good timing, thanks
-
第一节课程（100% English) SQL Server 2012/14 DBA Term1 今天刚刚开始了，我的听后感觉非常的的强烈， 任课老师讲的是100% 的专业IT英语，我感觉就是在和真实工作里的同事打交道， 平时大家说的工作之中的常用IT 专业术语， 英语用语是一网打尽了，工作里面就是这么说话，听到和要说的就是这些英语了， 甚至比我会说的还要多，打交道最多的就是这样的DBA IT专业人士，同学们提问题也都是使用英语，0 距离和专业DBA交流， 又是另一个互相学习，切磋和练习工作之中professional talk 的机会。
这个课实在是太好的一个机会了， 极大的有助于提高英语communication 的能力, 老师虽然是外国人， 但是非常的有经验， 很耐心， 课程非常注重做DBA 工作的实用性和突出重点， 要点。 思路清晰，有逻辑，还有很多的交流技巧和经验可以让我们学习！
对正在做 DBA工作的同学来讲， （同学里面就有）， 经验立刻就可以用到工作里面去， 有工作中的问题也可以带到课堂里向专家请教。
对没有做DBA工作的同学在做其他工作的同学来讲，对自己平时天天大交到的DBA同事的工作范围， 系统环境等等就是一个透彻理解，增加IT经验基础的机会。
对没有在做DBA 工作，正在学习转行的新同学来讲， 真是有福了！这个课程是前无仅有的机会！工作之中同事是怎么说话的，会怎么说，通常是怎么样的人， 什么情况，工作的环境，系统的背景知识状况在这个课程里面是一个大爆光和聚焦！！！ 非常真实的一个和IT专业人士一起学习的交流的机会， 可以讲，有过和这位老师打交道的经验，同学们不用再去找专业的英语课了，修了这个课，会一举两得， 对同学们面试， 工作都将是一个很好很大的过渡点！会带来极大的帮助。
请同学们珍惜这次英语 IT课程的机会， 及早注册学习有用的专业IT知识， 把自己武装起来， 为早日掌握专业技术， 找到好工作奠定基础， 创造机会！
感谢老土老师和土校付出的努力， 为大家安排了这么好的一个学习机会！
-
We will have class6, 10/18.
Due to teacher's schedule, we will not have class on 10/25.
We will have class on 11/01.
-
USALaoTu SQL Server 2014 DBA class finished today.
In today's last class, class 7, teacher Jon covered details of High Availability topic Always On of SQL Server.
As a experienced SQL Server DBA, Jon showed student step by step of how to setup Always On with multi servers, details of what happened when failed over happens.
Students asked many interesting questions.
As same as other USA LaoTu high quality classes, student learned a lot from this SQL Server DBA class.
Some students suggests that since the content and DBA knowledge is so important for Database Analyst jobs, this DBA class should be included into USA LaoTu's Core Package course.
Many thanks to teacher Jon and to every students.
We looking forward this DBA class will open again in April of 2016 if teacher Jon have time.