Collection 2784: Tuning and Optimizing Queries Using Microsoft® SQL Server 2005 2£119.99

Collection 2784: Tuning and Optimizing Queries Using Microsoft® SQL Server 2005 2

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: 12 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 2541: Core Data Access Development with Microsoft® Visual Studio® 2005£159.99

Collection 2541: Core Data Access Development with Microsoft® Visual Studio® 2005

Summary: This series of eight 2-hour workshops focus on designing data-driven Web applications with Visual Studio 2005. It is intended for developers who have application development experience working with Visual Studio 2005 and would like to start taking advantage of its rich data access and XML features.
While the skills in these workshops are common across Web and Windows®-based applications, the application used in the lab is a Web solution.

Course Details

Collection 2542: Advanced Data Access Development with Microsoft® Visual Studio® 2005£119.99

Collection 2542: Advanced Data Access Development with Microsoft® Visual Studio® 2005

Summary: This series of six 2-hour workshops focus on integrating advanced Data and XML techniques into your applications. It is intended for developers who have core Data and XML experience who would like to learn more advanced techniques and best practices using Visual Studio 2005.

Course Details

Collection 2782 : Designing Microsoft® SQL Server 2005 Databases 2£119.99

Collection 2782 : Designing Microsoft® SQL Server 2005 Databases 2

Summary: This collection of six 2-hour courses provides database developers working in enterprise environments with knowledge and skills to design a Microsoft® SQL Server 2005 database. These courses will also prepare you for exam 70-441 PRO: Designing Database Solutions by Using Microsoft® SQL Server 2005.

Course Details