SQL Server 2012 T-SQL ProgrammingTeacher has more than ten years Database Analysis/Development experience in many large USA companies.
After SQL server 2012 SQL course, this purpose of this three session course is show you real world skills and cases of how to use T-SQL, bring your T-SQL skill to a new advanced level, make you ready for database analyst jobs need T-SQL skills.
8:00am to 12:00 noon (USA PST), Saturday
01/18/2014 4hr 01/25/2014 4hr 02/01/2014 4hr
Price $600 ($480 for Core Package 2013 Student)
Click here make payment with a Credit Card. Pre-request: SQL Server 2012 SQL
T-sql 2012 course content outlineClass 1Overview of T-SQL
Migration of database
Linked server
Linked file
Bulkcopy
Information schema view
Catalog view
Some useful system stored procedures
Project: A system conversionClass 2Temp table
Table var
Function
Stored procedure
Trigger
View
Error handling
Performance
Project: Supporting web application from back endClass 3Table expressions
Derived tables
Commom table expression
Recursive cte
Cursor
Set operators
Window functions
Pivoting data
Unpivoting data
Merge statement
Output clause
Project: Billing system reconciliation