好用的手机公司, 新年大促销: 3 month FREE! $15/Month 5GB data and text

Author Topic: SQL Server 2012/14 DBA Term1 (100% English) 8:00 to 12:00 Sunday 09/13 to 11/01  (Read 22819 times)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
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.


John

  • Core Package
  • Sr. Member
  • *
  • Posts: 262
  • Karma: +0/-2
Great,Please fill me in, thanks!

Lilyqsr

  • Core Package
  • Jr. Member
  • *
  • Posts: 88
  • Karma: +0/-0
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.

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Thanks for your asking.
Will publish price information soon.
This is a different class with he previous classes.

emilystudy

  • Core Package
  • Sr. Member
  • *
  • Posts: 458
  • Karma: +2/-3
请问laotu 老师,

这个SQL DBA 讲课老师 是这个视频里的同一位老师吗? 


这个课之后, term 2是更高级课的吗?

另外, 请问 oracleDBA 是laotu 老师 讲吗? 下一期 大概什么时候开课?

盼望解答

感谢

如月

  • Core Package
  • Hero Member
  • *
  • Posts: 1742
  • Karma: +17/-2
这个SQL DBA 讲课老师 是这个视频里的同一位老师吗? 
 

----不是同一位老师, 是全部讲英语的老师




shofeller

  • Core Package
  • Full Member
  • *
  • Posts: 216
  • Karma: +0/-0
any pre requisition besides SQL Server 2012?

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
No, as long as you know SQL, you will be OK.

Almeerder

  • MSBI2008 ETL&SSIS
  • Newbie
  • *
  • Posts: 15
  • Karma: +0/-0
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.

如月

  • Core Package
  • Hero Member
  • *
  • Posts: 1742
  • Karma: +17/-2
 timezone 8:00-12:00? AM  ---是指加州时间早上,or called  pacific time or PDT time  (Pacific daytime savings time)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Yes, it is USA PST. Or Los Angeles Time.
It is afternoon if Europe time.

Almeerder

  • MSBI2008 ETL&SSIS
  • Newbie
  • *
  • Posts: 15
  • Karma: +0/-0
good timing, thanks

如月

  • Core Package
  • Hero Member
  • *
  • Posts: 1742
  • Karma: +17/-2
第一节课程(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知识, 把自己武装起来, 为早日掌握专业技术, 找到好工作奠定基础, 创造机会!

感谢老土老师和土校付出的努力, 为大家安排了这么好的一个学习机会!

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
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.