SQL Server 2012 T-SQL Programming
Teacher has more than 15 years Database Analysis/Development experience in many large USA companies.
After SQL server 2012 SQL course, the purpose of this five sessions 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), Sunday
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