Course Website:
http://www.certifiednetworks.com/classes/SQLProgrammingClass/default.aspx
Visit the site for updates, scheduling information, course description, setup guide, labs, & scripts

Description:
Transact-SQL extends SQL by adding the constructs found in other procedural languages, such as variables and control structures, thus allowing for a flexible procedural extension to SQL. Intended for anyone working with or evaluating Microsoft SQL Server, this course covers the basic syntax and statements used to create functioning Transact-SQL modules with an emphasis on reporting techniques and performance tuning. Students write different types of Transact-SQL modules, including batches, transactions, stored procedures, user defined functions, and triggers. Prerequisite: Although familiarity with SQL or Oracle is not required, some programming experience is helpful.

Audience:
Anyone developing a software system based on Microsoft SQL Server 2005.

Required Pre-Requesits:
A working knowledge of basic SQL
Knowledge of database concepts

Helpful Additional Pre-Requesits:
Some experience with any programming language such as Visual Basic, Java, C or C++

Format:
50% lecture & demonstration, 50% lab
40 hours class time
5 days or 12 evenings

Course Materials:
Lab and lecture materials by David Henson
Outside 3rd party reading material will be reviewed and recommended during class