SQL Server 2012/14 T-SQL Programming, 8:00 Sunday 11/08 to 12/06

[USA LaoTu Support Team]

SQL Server 2012/14 T-SQL Programming, 8:00 Sunday 11/08 to 12/06

8:00am to 12:00 noon, USA PST (Los Angeles Time), Sunday 11/08 to 12/06

11/08, 11/15, 11/22, 11/29, 12/06

T-SQL skill will bring your SQL Server database analysis skill to a Senor level.

After register, you can access previous T-SQL class material, and join online live class on 11/08.

Dr.Shin 是成功转行生物博士, 曾在微软, 大公司, 大银行 做Sr. MSBI 专家

Dr. Shin is one of our teachers at MSBI2012 SSIS ETL class. He gave students many high level C# .net scripts used in MSBI.

In this class, Dr. Shin Will deliver to students many very useful T-SQL scripts he used in his industry work.

Registration link: http://www.usalaotu.com/student/register.php

More information later.

[USA LaoTu Support Team]

Dr. Shin 讲授 Transact SQL Programming
8:00 Sunday 11/08 to 12/06
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]

The start date of this T-QSL class postponed to 11/08 due to the change of previous SQL Server 2014 DBA class's schedule change.

[PurpleSeas]

Thanks, looking forward to this class,

 hope there are some Stored Procedure, index view and dynamic T-SQL examples and demos.

 

[USA LaoTu Support Team]

We got answer from Dr. Shin:

"Thanks for your messages.
All mentioned will be covered and will focus on SP, Index and view and dynamic T-SQL as well."

[USA LaoTu Support Team]

如果你想把自己的SQL 编程技术提高到高级水平,
如果你想在工作中让你的老板和同事们对你刮目相看,
如果你想在面试中脱颖而出,
你应该立刻注册我们今天开始的T-SQL 课.

USA LaoTu 高质量课程, 一线在职博士数据分析专家把在北美诸多大公司多年积累的大量高招, 实例, 讲给你, 别处都没有, 别处听不到. 很多已经工作的老同学们都在上这期课, 上课同学们都说好! 这么好的课, 不听你太亏!

Well designed Demo and Labs documents are available for student to practice and reference in their work.

任何时候注册都不晚. 每课都有视频.

[USA LaoTu Support Team]

以找工作为中心, 这是我们所有课的宗旨.  T-SQL的课, 两位业界专家先后两期课教学, 累计40小时视频. 就是要把学生从初级提升到高级, 在面试中脱颖而出,拿到高薪工作.
看看这位上课短短一个月同学的体会分享和考试结果吧!

Hi,

I got 78% out of proveit2.com T-SQL test, due to attending your course T-SQL for 5 classes.
The average is 69%
Our TSQL course really helps a lot.

Thank you.

W