Designing Database Objects

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


recognize how to design database objects according to your requirements

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

155 min.

Course Objectives

Designing Database Objects

  • recognize the guidelines laid down by SQL Server 2005 to name objects and select identifiers, and how to create, modify, and decide the constraints that are applicable on tables.
  • recognize how to design efficient indexes in SQL Server 2005.
  • recognize how to design and delete T-SQL user-defined data types.
  • recognize how to design and implement different types of views, based on your requirements.
  • recognize how to design, execute, and delete stored procedures in SQL Server 2005.
  • recognize how to design scalar and table-valued user-defined functions.
  • recognize how to design DDL, DML, and Logon triggers in SQL Server 2005.
  • design objects for a SQL Server 2005 database.