USA LaoTu 高薪转行做数据第一平台

只要你有颗求变的心并愿意行动,到这里来,必使你得改变!成千聪明华人循此捷径高薪进入大公司! => 注重实战的教学作风 新开课程 时间内容 => Topic started by: USA LaoTu Support Team on July 08, 2018, 08:36:36 PM

Title: 业界专家经验传给你: 微软 T-SQL 第6期 8:00am to 12:00 noon Sunday 08/05-09/02
Post by: USA LaoTu Support Team on July 08, 2018, 08:36:36 PM
USA LaoTu 同学受益多多的好课: 微软 T-SQL Database Programming

业界专家经验传给你: 微软 T-SQL  第6期  8:00am to 12:00 noon Sunday 08/05-09/02

把多年业界 微软 T-SQL Database Programming 专家经验传给你。
把你很快带到高级水平,使你的面试脱颖而出,使你在工作中如虎添翼。

Course Content. (http://www.usalaotu.com/forum/index.php?topic=3384.0)
Title: Re: 业界专家经验传给你: 微软 T-SQL 第6期 8:00am to 12:00 noon Sunday 08/05-09/02
Post by: USA LaoTu Support Team on July 29, 2018, 11:56:14 AM
This only gives the outline of what will the course cover, more contents will be added before it starts and the order may change.

1. Introduction to TSQL (class 1~2)
   SELECT
   Aggregations and Grouping
   Working with Strings
   Working with Dates and Times
   Working with Numbers
   Views
   Stored Procedures
   UDF
   Indexes
   Triggers
   
2. Advanced TSQL (class 2~4)
   Elementary Programming
   Working with Nulls
   Querying from Multiple Tables
   Advanced Select Techniques
   Windowing Functions
   Inserting, Updating and Deleting
   Transactions, Locking, Blocking and Deadlocking
   Managing large tables and Database
   Managing indexes
   In-Memory OLTP


3. Query tuning (class 4)
   TO BE ADDED

4. Basic Defensive Database Programming (class 5)
   Code Vulnerabilities
   Defensive Error handling
   Defensive Data Modificatin
   Reusing T-SQL Code
   
Reference:
[1]. Inside Microsoft SQL Server 2012: T-SQL Querying. Steve Kass, Lubor Kollar, Itzik Ben-Gan, Dejan Sarka
[2]. SQL Server T-SQL Recipes, Forth Edition. Jason Brimhall; Jonathan Gennick; Wayne Sheffield
[3]. T-SQL Querying. Itzik Ben-Gan; Adam Machanic; Dejan Sarka; Kevin Farlee.
[4]. Defensive Database Programming with SQL Server. Alex Kuznetsov
Title: Re: 业界专家经验传给你: 微软 T-SQL 第6期 8:00am to 12:00 noon Sunday 08/05-09/02
Post by: USA LaoTu Support Team on August 01, 2018, 10:58:11 AM
This class meets 5 times.

Sun, Aug 5, 2018 8:00 AM - 12:00 PM PDT

Sun, Aug 12, 2018 8:00 AM - 12:00 PM PDT

Sun, Aug 19, 2018 8:00 AM - 12:00 PM PDT

Sun, Aug 26, 2018 8:00 AM - 12:00 PM PDT

Sun, Sep 16, 2018 8:00 AM - 12:00 PM PDT
Title: Re: 业界专家经验传给你: 微软 T-SQL 第6期 8:00am to 12:00 noon Sunday 08/05-09/02
Post by: USA LaoTu Support Team on August 01, 2018, 07:09:37 PM
Class web page is ready. Student can access the class:  tsql_term6.php (http://www.usalaotu.com/student/tsql_term6.php)

The benefit for Old Core Package students: After register this T-SQL class,
-- You will get a free listen of Core Package course (SQL 2017, Oracle 18c, Microsoft Power BI ).
-- You will get one year access of Wednesday Job & Career Counselling webinar.