Microsoft SQL Server 2005 Data Access MCITP 70-442 - Online Course

This series provides you with a study guide to prepare to become certified as a Microsoft Certified IT Professional: Database Developer. PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 (70-442), will cover your ability to build efficient, effective enterprise Microsoft SQL Server 2005 database solutions. Practice exams are also included, which will allow you to answer questions in the same format that the test will use on exam day, and will provide in-depth instructional feedback on each question to thoroughly cover every subject you'll need to master.

This series is for anyone who wants to achieve MCITP 70-442 certification. This online course contains 11 lessons and 3 practice exams and should take approximately 14 hours to complete.

Lesson 1: Designing Data Access (1.0) hour

Designing Data Access teaches you how to design appropriate data access technologies, design an appropriate data access object model, design a cursor strategy for a data access component, and design caching strategies. This course explains how to select technology for accessing data using SQL Server 2005.

Lesson 2: Designing Application Access (1.0) hour

Designing Application Access teaches you how to design client libraries to write applications that administer a SQL Server service, and design queries that use multiple active result sets. This course explains how client libraries are used to manage SQL Server 2005.

Lesson 3: Designing Queries (1.0) hour

Designing Queries teaches you how to write queries, modify queries to improve query performance, and design queries for retrieving data from XML sources. This course covers writing, analyzing, and modifying queries to improve their performance for the SQL Server 2005 database engine.

Lesson 4: Using Cursors (1.0) hour

Using Cursors teaches you how to design a cursor strategy. This course covers the appropriate use of cursors in SQL Server 2005.

Lesson 5: Planning Error Handling (1.0) hour

Planning Error Handling teaches you how to design code that validates input data and permissions, design code that detects and reacts to errors, and design user-defined messages to communicate application events. This course covers the improved SQL Server 2005 error-handling techniques.

Lesson 6: Planning a Transaction Strategy (1.0) hour

Planning a Transaction Strategy teaches you how to manage concurrency by selecting the appropriate transaction isolation levels, design the locking granularity level, design transaction scopes, and design code that uses transactions. This course explains how to maximize concurrency while maintaining data integrity by managing transactions and transaction scopes.

Lesson 7: Optimizing and Tuning Queries for Performance (1.0) hour

Optimizing and Tuning Queries for Performance teaches you how to optimize and tune queries for performance, evaluate query performance, detect locking problems, modify queries to optimize client and server performance, rewrite subqueries to joins, design queries that have search arguments, and convert single-row statements into set-based queries. This course covers improving query performance in SQL Server 2005.

Lesson 8: Optimizing Indexing Strategies (1.0) hour

Optimizing Indexing Strategies teaches you how to optimize indexing strategies. This course covers the types of indexes SQL Server 2005 supports, when you should use each type, index maintenance, and new features related to indexes.

Lesson 9: Scaling Out Applications (1.0) hour

Scaling Out Applications teaches you how to scale database applications. This course covers the requirements of designing applications so they can be scaled out to the enterprise level.

Lesson 10: Resolving Performance Problems (1.0) hour

Resolving Performance Problems teaches you how to resolve performance problems. This course covers tuning database application performance at the server level.

Lesson 11: Optimizing Data Storage (1.0) hour

Optimizing Data Storage teaches you how to optimize data storage. This course covers optimizing data storage for best performance by using proper design and selecting optimal data types.

3 Practice Exams

This course presents questions that will help you prepare for the MCITP 70-442: PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to look for in correct answers.