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 DataRegistration:
http://www.usalaotu.com/student/register.phpPrice:
$1198 for general public
$998 for students paid $2999
$899 for students paid $3999
$848 for students paid $4999 and up