Microsoft SQL Server 2005 Data Access MCITP 70-442: 1 Designing Data Access
Description
This course explains how to select technology for accessing data using SQL Server 2005.
Objectives
- Design appropriate data access technologies
- Design an appropriate data access object model
- Design a cursor strategy for a data access component
- Design caching strategies
Microsoft SQL Server 2005 Data Access MCITP 70-442: 2 Designing Application Access
Description
This course explains how client libraries are used to manage SQL Server 2005.
Objectives
- Design client libraries to write applications that administer a SQL Server service
- Design queries that use multiple active result sets
Microsoft SQL Server 2005 Data Access MCITP 70-442: 3 Designing Queries
Description
This course covers writing, analyzing, and modifying queries to improve their performance for the SQL Server 2005 database engine.
Objectives
- Write queries
- Modify queries to improve query performance
- Design queries for retrieving data from XML sources
Microsoft SQL Server 2005 Data Access MCITP 70-442: 4 Using Cursors
Description
This course covers the appropriate use of cursors in SQL Server 2005.
Objectives
Microsoft SQL Server 2005 Data Access MCITP 70-442: 5 Planning Error Handling
Description
This course covers the improved SQL Server 2005 error-handling techniques.
Objectives
- Design code that validates input data and permissions
- Design code that detects and reacts to errors
- Design user-defined messages to communicate application events
Microsoft SQL Server 2005 Data Access MCITP 70-442: 6 Planning a Transaction Strategy
Description
This course explains how to maximize concurrency while maintaining data integrity by managing transactions and transaction scopes.
Objectives
- Manage concurrency by selecting the appropriate transaction isolation levels
- Design the locking granularity level
- Design transaction scopes
- Design code that uses transactions
Microsoft SQL Server 2005 Data Access MCITP 70-442: 7 Optimizing and Tuning Queries for Performance
Description
This course covers improving query performance in SQL Server 2005.
Objectives
- 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
- Convert single-row statements into set-based queries
Microsoft SQL Server 2005 Data Access MCITP 70-442: 8 Optimizing Indexing Strategies
Description
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.
Objectives
- Optimize indexing strategies
Microsoft SQL Server 2005 Data Access MCITP 70-442: 9 Scaling Out Applications
Description
This course covers the requirements of designing applications so they can be scaled out to the enterprise level.
Objectives
- Scale database applications
Microsoft SQL Server 2005 Data Access MCITP 70-442:10 Resolving Performance Problems
Description
This course covers tuning database application performance at the server level.
Objectives
- Resolve performance problems
Microsoft SQL Server 2005 Data Access MCITP 70-442:11 Optimizing Data Storage
Description
This course covers optimizing data storage for best performance by using proper design and selecting optimal data types.
Objectives
Microsoft SQL Server 2005 Data Access MCITP 70-442:12 Practice Exam 1
Description
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.
Objectives
- Complete the practice exam questions
Microsoft SQL Server 2005 Data Access MCITP 70-442:13 Practice Exam 2
Description
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.
Objectives
- Complete the practice exam questions
Microsoft SQL Server 2005 Data Access MCITP 70-442:14 Practice Exam 3
Description
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.
Objectives
- Complete the practice exam questions