Microsoft SQL Server 2008: Programming with Transact-SQL

Course Overview

Transact-SQL (or SQL) is Microsoft's and Sybase's proprietary extension to SQL. This course will introduce you to the programming features of the language, using Micrsoft's SQL Server 2008. With prior knowledge of SQL assumed, this course looks at the procedural programming language functionalities of T-SQL, such as local variables, flow control constructs, error handling and built-in functions.

On completion of this Microsoft training course, delegates will be more proficient in SQL Server skills

Related Courses

• Microsoft SQL Server 2008: Business Intelligence End to End with SQL Server 2008 R2 and SharePoint 2010
• Microsoft SQL Server 2008: Audit & Security Course
• Microsoft SQL Server 2008: Implementing and Maintaining a Microsoft SQL Server 2008 Database
• Microsoft SQL Server 2008: Integration Services
• Microsoft SQL Server 2008 New Features: Hands-On
• Microsoft SQL Server 2008 Comprehensive Introduction: Hands-On
• Microsoft SQL Server 2008: Database Administration
• Microsoft SQL Server 2008: New Features for SQL Server 2005 Administrators and Developers
• Microsoft SQL Server 2008: Administration
• Microsoft SQL Server 2008: Integration Services

Prerequisites

A working level of SQL (SELECT, UPDATE and DELETE statements) is assumed. Delegates without this experience should consider the Introduction to SQL course.

Course Outline

• Stored procedures
• User defined functions (UDFs)
• Local variables
• Parameters
• Error handling
• Using cursors
• Transaction control
• Triggers