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.phpPrice:
$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