Collection 2784: Tuning and Optimizing Queries Using Microsoft® SQL Server 2005£119.99
Description
Summary: This collection of six 2-hour workshops provides database developers working in enterprise environments with the knowledge and skills to analyze and address performance bottlenecks that occur within their Microsoft® SQL ServerTM 2005 database solutions. These courses will also prepare you for exam 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft® SQL ServerTM 2005.
Audience: Developer
Available Offline: Yes
Subscription: 18 months
These six workshops will teach database developers working in enterprise environments how to analyze and address performance bottlenecks that occur within their Microsoft® SQL ServerTM 2005 database solutions.
Topics covered within the collection include:
• Measuring database performance
• Optimization through physical design
• Query optimization
• Refactoring cursors in queries
• Index optimization
• Managing concurrency and locking
These courses will also prepare you for exam 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft® SQL ServerTM 2005.
This offer includes the following:
E-Learning
Workshop 4370: Measuring Database Performance Using Microsoft® SQL ServerTM 2005
Workshop 4371: Optimizing Physical Database Design Using Microsoft® SQL ServerTM 2005
Workshop 4372: Optimizing Queries for Performance Using Microsoft® SQL ServerTM 2005
Workshop 4373: Refactoring Cursors into Queries Using Microsoft® SQL ServerTM 2005
Workshop 4374: Optimizing an Indexing Strategy Using Microsoft® SQL ServerTM 2005
Workshop 4375: Managing Concurrency Using Microsoft® SQL ServerTM 2005
Course Objectives
Summary: This collection of six 2-hour workshops provides database developers working in enterprise environments with the knowledge and skills to analyze and address performance bottlenecks that occur within their Microsoft® SQL ServerTM 2005 database solutions. These courses will also prepare you for exam 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft® SQL ServerTM 2005.
Audience: Developer
Available Offline: Yes
Subscription: 18 months
These six workshops will teach database developers working in enterprise environments how to analyze and address performance bottlenecks that occur within their Microsoft® SQL ServerTM 2005 database solutions.
Topics covered within the collection include:
• Measuring database performance
• Optimization through physical design
• Query optimization
• Refactoring cursors in queries
• Index optimization
• Managing concurrency and locking
These courses will also prepare you for exam 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft® SQL ServerTM 2005.
This offer includes the following:
E-Learning
Workshop 4370: Measuring Database Performance Using Microsoft® SQL ServerTM 2005
Workshop 4371: Optimizing Physical Database Design Using Microsoft® SQL ServerTM 2005
Workshop 4372: Optimizing Queries for Performance Using Microsoft® SQL ServerTM 2005
Workshop 4373: Refactoring Cursors into Queries Using Microsoft® SQL ServerTM 2005
Workshop 4374: Optimizing an Indexing Strategy Using Microsoft® SQL ServerTM 2005
Workshop 4375: Managing Concurrency Using Microsoft® SQL ServerTM 2005
Technical Requirements
Summary: This collection of six 2-hour workshops provides database developers working in enterprise environments with the knowledge and skills to analyze and address performance bottlenecks that occur within their Microsoft® SQL ServerTM 2005 database solutions. These courses will also prepare you for exam 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft® SQL ServerTM 2005.
Audience: Developer
Available Offline: Yes
Subscription: 18 months
These six workshops will teach database developers working in enterprise environments how to analyze and address performance bottlenecks that occur within their Microsoft® SQL ServerTM 2005 database solutions.
Topics covered within the collection include:
• Measuring database performance
• Optimization through physical design
• Query optimization
• Refactoring cursors in queries
• Index optimization
• Managing concurrency and locking
These courses will also prepare you for exam 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft® SQL ServerTM 2005.
This offer includes the following:
E-Learning
Workshop 4370: Measuring Database Performance Using Microsoft® SQL ServerTM 2005
Workshop 4371: Optimizing Physical Database Design Using Microsoft® SQL ServerTM 2005
Workshop 4372: Optimizing Queries for Performance Using Microsoft® SQL ServerTM 2005
Workshop 4373: Refactoring Cursors into Queries Using Microsoft® SQL ServerTM 2005
Workshop 4374: Optimizing an Indexing Strategy Using Microsoft® SQL ServerTM 2005
Workshop 4375: Managing Concurrency Using Microsoft® SQL ServerTM 2005
Accessibility Requirements
Summary: This collection of six 2-hour workshops provides database developers working in enterprise environments with the knowledge and skills to analyze and address performance bottlenecks that occur within their Microsoft® SQL ServerTM 2005 database solutions. These courses will also prepare you for exam 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft® SQL ServerTM 2005.
Audience: Developer
Available Offline: Yes
Subscription: 18 months
These six workshops will teach database developers working in enterprise environments how to analyze and address performance bottlenecks that occur within their Microsoft® SQL ServerTM 2005 database solutions.
Topics covered within the collection include:
• Measuring database performance
• Optimization through physical design
• Query optimization
• Refactoring cursors in queries
• Index optimization
• Managing concurrency and locking
These courses will also prepare you for exam 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft® SQL ServerTM 2005.
This offer includes the following:
E-Learning
Workshop 4370: Measuring Database Performance Using Microsoft® SQL ServerTM 2005
Workshop 4371: Optimizing Physical Database Design Using Microsoft® SQL ServerTM 2005
Workshop 4372: Optimizing Queries for Performance Using Microsoft® SQL ServerTM 2005
Workshop 4373: Refactoring Cursors into Queries Using Microsoft® SQL ServerTM 2005
Workshop 4374: Optimizing an Indexing Strategy Using Microsoft® SQL ServerTM 2005
Workshop 4375: Managing Concurrency Using Microsoft® SQL ServerTM 2005
You may also be interested in...
Collection 2781: Designing Microsoft® SQL Server 2005 Server-Side Solutions£159.99
Collection 2782 : Designing Microsoft® SQL Server 2005 Databases£119.99
Collection 2783: Designing the Data Tier for Microsoft® SQL Server 2005£119.99
