SQL Server 2012 T-SQL Programming 8:00 Sunday 10/19/14 to 12/07/14

[USA LaoTu Support Team]

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

[USA LaoTu Support Team]

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.