Designing Queries in SQL 2005

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


recognize how to design and execute queries in SQL Server 2005, utilizing XQuery and the XML Data Modification Language

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-442 PRO: Designing and Optimizing Data Access 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, implementing databases at the physical level, and gathering business requirements

Expected Duration

135 min.

Course Objectives

Designing Queries in SQL 2005

  • recognize how to write the SELECT queries and use the operators and functions to aggregate and modify data.
  • recognize how to create a partition and generate an ordered array or table within the result set.
  • recognize how SQL codes are compiled and create objects that can reuse the query plans.
  • recognize how to improve the performance of SQL queries.
  • recognize how to create and execute XML data queries by using XQuery in SQL Server 2005.
  • recognize how to use the XML Data Modification Language.
  • create and execute queries in SQL Server 2005, XQuery and utilize the XML Data Modification Language.