USA LaoTu 高薪转行做数据第一平台
只要你有颗求变的心并愿意行动,到这里来,必使你得改变!成千聪明华人循此捷径高薪进入大公司! => 注重实战的教学作风 新开课程 时间内容 => Topic started by: USA LaoTu Support Team on September 09, 2014, 01:04:01 PM
-
SQL Server 2012 T-SQL Programming will start on 8:00 Sunday 10/19 to 12/07/14 5 x 4 hr class.
Teacher Chris is an SQL Server and Oracle Developer expert with more than 15 years Database developer experience in USA companies. He taught SQL server T-SQL and Oracle PL/SQL programming course in USA LaoTu school, students learned a lot.
Five 4 hour sessions, total 20 hours.
Class content:
1. Overal View
Migration of Database
Data type
Date
Strings
Numeric
SQL server built in functions
DDL, DML, Control Language
Project: Billing System Reconcilition
2. SQL server objects
Function
Procedure
Prigger
Views
Sequence
Index
Project: Web Application (password, table function)
3 SQL Server Objects (continued)
Cursor
Set operation
Analytic Function
Hirerachical query
Pivotal query
Peoject: A DW application(Type 2 Inert)
4. Error Handling and Debugging
Legacy Error Handling
The Raiseerror Statment
Try Catch
Debugging Tools
Danamic SQL
Project: a QA application(Dynamic SQL)
5. Performance
General Guide Line
Database Design Performance Tips
Index Performance Tips
Select Performance Tips
Insert Performance Tips
Cursor Performance Tips
Peoject: A cognos reporting application (DOC HIST)
Registration: http://student.usalaotu.com/make_payment.php
Price:
$1198 for general public
$898 for students paid $2999
$848 for students paid $3999
$798 for students paid $4999 and up
pre-requisition: SQL Server 2012 SQL
-
No class on 11/09.
Make up class will be 12/07.
No class in week end before and after Thanksgiving: 11/23, 11/30.