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

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

Title: SQL Server 2012 T-SQL Programming
Post by: USA LaoTu Support Team on December 22, 2013, 10:26:55 AM

SQL Server 2012 T-SQL Programming

Teacher 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. (http://student.usalaotu.com/make_payment.php) 
Pre-request:  SQL Server 2012 SQL

T-sql 2012 course content outline


Class 1
Overview of T-SQL
Migration of database
Linked server
Linked file
Bulkcopy
Information schema view
Catalog view
Some useful system stored procedures
Project: A system conversion

Class 2
Temp table
Table var
Function
Stored procedure
Trigger
View
Error handling
Performance
Project: Supporting web application from back end

Class 3
Table 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

Title: Re: SQL Server 2012 T-SQL Programming
Post by: yundanfengqing on January 15, 2014, 08:55:19 PM

请问这门课可以用PAYPAL 付款吗?

Title: Re: SQL Server 2012 T-SQL Programming
Post by: USA LaoTu Support Team on January 15, 2014, 09:43:33 PM

Yes, you can.
Use the last Buy now button, Enter the payment amount for the course.