Home >> IT Training >> Microsoft Classes

SQL Server 2005 Tuning, Optimization, and Troubleshooting Training Classes

Our SQL Server 2005 Tuning, Optimization, and Troubleshooting training class is different from the rest because we hire only full-time, experienced consultants who also have a talent for teaching. Because our classes are taught by these IT professionals, you can ask your workplace questions and put those answers to work right away. Because our IT training classes are taught in 12 detailed labs over 5 concentrated days, you will leave the sessions confident that you can get the job done.

The goal of our classes is to teach you to evaluate and improve queries and understand the entire process of troubleshooting SQL Server 2005. We start our course by determining performance baselines and reviewing tables and scripts. You will optimize schemas, memberships and queries as well as learning to reduce blocking by indentifying code with locking and blocking issues. In the end, you will learn to troubleshoot SQL Servers connectivity and data issues. This course is designed for database developers and administrators with several years of experience with SQL Server database solutions in an enterprise environment. We use Official Microsoft Learning Products so that you are getting the best and most complete information available.

Our onsite SQL Server 2005 Tuning, Optimization, and Troubleshooting training classes are perfect for those companies with six or more employees needing this kind of training. By bringing the classroom to your facility, we can save your employees valuable commute time and save the company 30% off the cost of a course taught in a traditional classroom setting.

If you are ready to take the next step in IT, enroll in our SQL Server 2005 Tuning, Optimization, and Troubleshooting training class today. Just click on the blue button to get started and stay one step ahead of the pack.

Enrollment Fee: 2995 USD
Number of Class Days: 5

SQL Server 2005 Tuning, Optimization, and Troubleshooting schedule:
	Mar 16 - 20, 2009	Dallas, TX
	Mar 23 - 27, 2009	Chicago (Schaumburg), IL
	Mar 30 - Apr 3, 2009	Morristown, NJ
	Apr 13 - 17, 2009	Houston, TX
	Apr 20 - 24, 2009	Washington, DC
	Apr 27 - May 1, 2009	New York, NY
	May 11 - 15, 2009	San Jose, CA
	May 18 - 22, 2009	Los Angeles, CA
	Jun 15 - 19, 2009	Chicago (Schaumburg), IL
	Jun 22 - 26, 2009	Atlanta, GA
	Jul 20 - 24, 2009	Dallas, TX
	Jul 27 - 31, 2009	Washington, DC
	Aug 10 - 14, 2009	Raleigh, NC
	Aug 24 - 28, 2009	Orlando, FL
	Sep 21 - 25, 2009	San Jose, CA
	Sep 28 - Oct 2, 2009	Morristown, NJ

Training Class Outline:

1. Measuring Database Performance

*Importance of Benchmarking
*Key Measures for Query Performance: Sysmon
*Key Measures for Query Performance: Profiler
*Guidelines for Identifying Locking and Blocking

2. Optimizing Physical Database Design

*Performance Optimization Model
*Schema Optimization Strategy: Keys
*Schema Optimization Strategy: Responsible Denormalization
*Schema Optimization Strategy: Generalization

3. Optimizing Queries for Performance

*Performance Optimization Model: Queries
*What Is Query Logical Flow?
*Considerations for Using Subqueries
*Guidelines for Building Efficient Queries

4. Refactoring Cursors into Queries

*Performance Optimization Model: Query-Set-Based Solutions
*Five Steps to Building a Cursor
*Strategies for Refactoring Cursors

5. Optimizing an Indexing Strategy

*Performance Optimization Model: Indexes
*Considerations for Using Indexes
*Best Uses of the Clustered Index
*Best Practices for Non-Clustered Index Design
*How to Document an Indexing Strategy

6. Managing Concurrency

*Performance Optimization Model: Locking and Blocking
*Multimedia: "How to Use Efficient Queries to Reduce Locking and Blocking"
*Strategies to Reduce Locking and Blocking

7. Building a Monitoring Solution for SQL Server Performance Issues

*Narrowing Down a Performance Issue to an Environment Area
*Guidelines for Monitoring Database Servers and Instances by Using Profiler and Sysmon
*Guidelines for Auditing and Comparing Test Results

8. Troubleshooting Database and Database Server Performance Issues

*Narrowing Down a Performance Issue to a Database Object
*How Profiler Can Help Narrow a Search to a Specific Issue
*How the SQLdiag Tool Can Be Used to Analyze Outputs

9. Optimizing the Query Performance Environment

*The Methodology of Optimizing a Query Environment
*The Query Performance Troubleshooting Process

10. Troubleshooting SQL Server Connectivity Issues

*The Methodology of Troubleshooting SQL Server Connectivity Issues
*Areas to Troubleshoot for Common Connectivity Issues
*What Are SQL Server 2005 Endpoints?

11. Troubleshooting SQL Server Data Issues

*The Methodology of Troubleshooting SQL Server Data Issues
*The Process of Troubleshooting Data Integrity Issues
*How Torn Pages Can be Resolved Using a Single-Page Restore

12. Troubleshooting SQL Server Data Concurrency Issues

*The Methodology of Troubleshooting Concurrency Issues
*What Are SQL Server Latches?
*Activity: Choosing a Blocking Monitoring Solution