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

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

Title: T-SQL Programming 第五期 8:00am Sunday 8/28 to 10/02
Post by: USA LaoTu Support Team on June 15, 2016, 09:13:38 PM

USALaoTu 美国老土 T-SQL Programming 课，具有丰富经验的业界专家把他们工具箱里的好工具和绝招教给你，把你的SQL Server T-SQL编程带到高级水平，让你面试时脱颖而出，成为大公司高薪高级数据分析人才。

Dr. Shin 讲授 Transact SQL Programming 第五期
8:00am-12:00pm  Sunday 8/28 to 10/02
After register, student will get previous class material, access previous class video, and join this new online live class.

Chapter 01 Introduction to T-SQL
    Brief History
    SQL 3VL
    T-SQL Control-Folw-Language
    SQL Server 2014 Environment and Tools for T-SQL(SSMS)
    Logical Query Processing
    Cases Demo

Chapter 02 -  Transact-SQL Programming Constructs
    Basic T-SQL Programming Constructs
      Database and Main Objects for T-SQL querying
      Data Types -- All Data Type Demo
      Control-Flow-Statement
      Cursor
   Composite T-SQL Constructs
      Batches, Scripts, and Transactions

Chapter 03 - Importing and Exporting File Data Sources
    BCP, Bulk Insert, xp_cmdshell, etc
    Rowset Functions (Openquery, OpenRowset, OpenDatasource) vs. Linked Server
    Project: Load/Query Excel files

Chapter 04 - Querying Tables with SELECT and Multiple Tables With Joins
        Information_Schema.Columns/Tables
        TOP and OFFSET-FETCH
        GO N
        Objects_Find
        TABLE Joins vs Set Operators

Chapter 05 - Using Functions and Aggregating Data
Chapter 06 - Using Subqueries and APPLY
Chapter 07 - Grouping, Pivoting and Windowing
Chapter 08 - Data Modification
Chapter 09 - Programming with Transact-SQL
Chapter 10 - Error Handling and Transactions
Chapter 11 - Query Tuning
Chapter 12 - T-SQL for BI
Chapter 14 - Graphs and Recursive Queries
Chapter 14 - Programmable Objects
Chapter 15 - Project -- Migrate SQL Server Database Data

Registration: http://www.usalaotu.com/student/register.php
Price:
  $1198  for general public
  $998    for students paid $2999
  $899    for students paid $3999
  $848    for students paid $4999 and up

Title: Re: T-SQL Programming 第五期 8:00am Sunday 8/28 to 10/02
Post by: USA LaoTu Support Team on August 13, 2016, 10:48:05 AM

Class web page is ready:  tsql_term4.php (http://www.usalaotu.com/student/tsql_term4.php)

T-SQL Term4 class schedule:

Sun, Aug 28, 2016 8:00 AM - 12:00 PM PDT<br>
Sun, Sep 04, 2016 ********* US Labor day weekend, No Class ***************
Sun, Sep 11, 2016 8:00 AM - 12:00 PM PDT<br>
Sun, Sep 18, 2016 8:00 AM - 12:00 PM PDT<br>
Sun, Sep 25, 2016 8:00 AM - 12:00 PM PDT<br>
Sun, Oct 2, 2016 8:00 AM - 12:00 PM PDT  <br>