1. Microsoft SQL Server 2005 Data Access MCITP 70-442:1 Designing Data Access
Time: 1 hours
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
2. Microsoft SQL Server 2005 Data Access MCITP 70-442:2 Designing Application Access
Time: 1 hours
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
3. Microsoft SQL Server 2005 Data Access MCITP 70-442:3 Designing Queries
Time: 1 hours
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
4. Microsoft SQL Server 2005 Data Access MCITP 70-442:4 Using Cursors
Time: 1 hours
This course covers the appropriate use of cursors in SQL Server 2005.
5. Microsoft SQL Server 2005 Data Access MCITP 70-442:5 Planning Error Handling
Time: 1 hours
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
6. Microsoft SQL Server 2005 Data Access MCITP 70-442:6 Planning a Transaction Strategy
Time: 1 hours
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
7. Microsoft SQL Server 2005 Data Access MCITP 70-442:7 Optimizing and Tuning Queries for Performance
Time: 1 hours
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
8. Microsoft SQL Server 2005 Data Access MCITP 70-442:8 Optimizing Indexing Strategies
Time: 1 hours
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
9. Microsoft SQL Server 2005 Data Access MCITP 70-442:9 Scaling Out Applications
Time: 1 hours
This course covers the requirements of designing applications so they can be scaled out to the enterprise level.
Objectives
- Scale database applications
10. Microsoft SQL Server 2005 Data Access MCITP 70-442:10 Resolving Performance Problems
Time: 1 hours
This course covers tuning database application performance at the server level.
Objectives
- Resolve performance problems
11. Microsoft SQL Server 2005 Data Access MCITP 70-442:11 Optimizing Data Storage
Time: 1 hours
This course covers optimizing data storage for best performance by using proper design and selecting optimal data types.
12. Microsoft SQL Server 2005 Data Access MCITP 70-442:12 Practice Exam 1
Time: 1 hours
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
13. Microsoft SQL Server 2005 Data Access MCITP 70-442:13 Practice Exam 2
Time: 1 hours
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
14. Microsoft SQL Server 2005 Data Access MCITP 70-442:14 Practice Exam 3
Time: 1 hours
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