Microsoft SQL Server 2005 Data Access MCITP 70-442 Training Online Course
Microsoft SQL Server 2005 Data Access MCITP 70-442 Training Online Course Total Time: 14 hour(s)
This series provides you with a study guide to prepare to become certified as a Microsoft Certified IT Professional: Database Developer. PRO: Designing and Optimising 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.
| |
Try A Free Demo
|
Live Labs Available
|
24/7 Tutor Available
|
Need help? Click Here
|
| |
 |
 |
 |
 |
 |
Microsoft SQL Server 2005 Data Access MCITP 70-442 Training Online Course Lessons:
1 Designing Data Access
- Design appropriate data access technologies
- Design an appropriate data access object model
- Design a cursor strategy for a data access component
- Design caching strategies
|
Duration 1 hour |
2 Designing Application Access
- Design client libraries to write applications that administer a SQL Server service
- Design queries that use multiple active result sets
|
Duration 1 hour |
3 Designing Queries
- Write queries
- Modify queries to improve query performance
- Design queries for retrieving data from XML sources
|
Duration 1 hour |
4 Using Cursors
This course covers the appropriate use of cursors in SQL Server 2005.
|
Duration 1 hour |
5 Planning Error Handling
- Design code that validates input data and permissions
- Design code that detects and reacts to errors
- Design user-defined messages to communicate application events
|
Duration 1 hour |
6 Planning a Transaction Strategy
- Manage concurrency by selecting the appropriate transaction isolation levels
- Design the locking granularity level
- Design transaction scopes
- Design code that uses transactions
|
Duration 1 hour |
7 Optimising and Tuning Queries for Performance
- Optimise and tune queries for performance
- Evaluate query performance
- Detect locking problems
- Modify queries to Optimise client and server performance
- Rewrite subqueries to joins
- Design queries that have search arguments
- Convert single-row statements into set-based queries
|
Duration 1 hour |
8 Optimising Indexing Strategies
This course covers optimising data storage for best performance by using proper design and selecting optimal data types.
|
Duration 1 hour |
9 Scaling Out Applications
This course covers the requirements of designing applications so they can be scaled out to the enterprise level.
|
Duration 1 hour |
10 Resolving Performance Problems
This course covers tuning database application performance at the server level.
|
Duration 1 hour |
|
Duration 1 hour |
|
Duration 1 hour |
|
Duration 1 hour |
|
Telephone: 0871 222 8790
Alternate Number: 01279 814 876
Fax: 01279 816 093
E-Mail: info@e-careers.co.uk
Address:
10 Riverside Business Park,
Stony Common Road,
Stansted Mountfitchet,
Essex,
CM24 8PL

|
|