T- SQL Programming

Ø T-SQL Server Side Programming (20 hours)

- TSQL statements and building blocks

- Transactions

§ ACID Property

§ Transaction Isolation Levels

§ Transaction Control and Rollback

§ Locking & Blocking

§ Dirty Reads & Read Committed Snapshot

§ Snapshot Isolation Level

§ Nested Transactions

§ Transaction Save Points

- CURSOR (Record Based Data Processing)

- Stored Procedure (SP)

- User Defined Functions

§ Scalar Functions

§ Table-Valued Functions

- Triggers

§ DML Triggers

§ DDL Triggers

Ø T-SQL 2005 Enhancements for Developers (4 hours)

- CTE

- TOP <n>

- Random Data Sampling

- CROSS/OUTER APPLY

- PIVOT / UNPIVOT

- Ranking Functions

- OUTPUT

- Ranking Functions

- EXCEPT and INTERSECT

- Synonyms

- Exception Handling using TRY/CATCH

- .WRITE extension to the UPDATE command

- EXCECUTE AT LinkedServer

Ø T-SQL 2008 Enhancements for Developers (3 hours)

- Table Valued parameters in SP

- Row Constructors

- GROUPING SETS

- MERGE statement

- Managing Trees and Hierarchies using HierarchyID

Ø Integration Services (SSIS) (6 hours)