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

Author Topic: T-SQL Programming 第五期 8:00am Sunday 8/28 to 10/02  (Read 8116 times)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
T-SQL Programming 第五期 8:00am Sunday 8/28 to 10/02
« 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

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Re: T-SQL Programming 第五期 8:00am Sunday 8/28 to 10/02
« Reply #1 on: August 13, 2016, 10:48:05 AM »
Class web page is ready:  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>