Designing an Application Solution for SQL Server 2005

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


recognize how to design and build a database model and a physical database, and how to secure it

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

175 min.

Course Objectives

Designing an Application Solution for SQL Server 2005

  • recognize the conceptual, logical, and implementation phases of building a logical database model.
  • recognize how to employ conceptual modeling techniques and implement an Entity Relationship Model in the SQL Server 2005 database.
  • recognize the guidelines for normalizing data in a database model.
  • recognize how to create and modify a database, based on user requirements, and the procedures defined by SQL Server 2005 for storing data.
  • recognize the types of data supported by an RDBMS, and the different data types and their sizes.
  • recognize how to implement security in SQL Server 2005 by using roles, login accounts, and encryption keys.
  • recognize how to work with schemas and implement synonyms in a database application.
  • recognize how to implement execution context in accordance with Object Ownership Chaining in SQL Server 2005.
  • determine the design of a SQL Server 2005 database.