Programming with SQL Server 2005

This course is included in our On-demand training solution.


recognize how to implement SQL Server 2005 programming features to work with database data

Target Audience

Developers who use Microsoft Office SQL Server 2005 and consultants providing consulting services for SQL Server 2005; individuals looking to pass the 70-441 PRO: Designing Database Solutions by Using Microsoft SQL Server 2005 certification exam and those individuals targeting toward the Microsoft certification: Microsoft Certified IT Professional (MCITP): Database Developer certification path.


Three or more years database programming experience including expertise in troubleshooting triggers, queries, stored procedures, user-defined functions, and user-defined types, writing Transact-SQL queries, performing database performance optimization, designing and troubleshooting the data access layer of the application, designing databases, iImplementing databases at the physical level, and gathering business requirements.

Expected Duration

135 min.

Course Objectives

Programming with SQL Server 2005

  • recognize how to implement the different levels of isolation and snapshot isolation while working with databases.
  • recognize how to access local and external data from SQL Server 2005 by configuring the linked server.
  • recognize how to implement exception handling to overcome the errors that arise during execution.
  • recognize how to implement Common Table Expressions in SQL Server 2005.
  • recognize how to build a crosstab query using the Pivot operator and work with the UnPivot operator.
  • recognize how to create a partition and generate an ordered array or table within the result set.
  • determine how snapshot isolation works, a solution for linked servers, and how to implement T-SQL statements.