Designing Access to SQL Server Data

PrerequisitesThree 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

Target AudienceDevelopers 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

LessonsData Access Technologies Overview| - recognize the different types of database applications and data-access components, and determine how the components interact with one another.|SQL Server Data Access| - recognize how to access SQL Server data by using an appropriate access method.|Designing an Object Model for Data Access| - distinguish the object models that are used for managing data access.|SQL Server Caching Strategies| - recognize the different caching strategies in SQL Server 2005.|Designing Custom Caching| - recognize how to design a customized cache to achieve the desired caching solution for SQL Server 2005.|Designing a Cursor Strategy| - recognize how to use cursors to retrieve a particular set of rows from the entire result set.|Accessing and Managing a SQL Server Database| - utilize data access technologies appropriately to access and manage SQL Server data.|

Test Prep

Simulations