Troubleshooting and Optimizing Database Servers using Microsoft SQL Server 2005 (Certificate)

New Horizons Learning Center Philippines
Alabang, Makati City, Marikina City, Philippines

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This workshop teaches database administrators working in enterprise environments how to determine and troubleshoot performance issues using Microsoft SQL ServerT 2005. The primary focus of this workshop is to teach the overall process of troubleshooting.

Who Should Attend:
This course is intended for current professional database administrators who have three or more years of on-the-job experience administering SQL Server database solutions in an enterprise environment.

Prerequisite(s) or equivalent knowledge:
2780 Maintaining a Microsoft SQL Server 2005 Database
2779 Implementing a Microsoft SQL Server 2005 Database
2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

Prerequisite Comments:
Have a Microsoft Certified Technology Specialist: Microsoft SQL Server 2005 credential or equivalent experience


Outline: Top
Lesson 1: 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.

Top
Lesson 2: Troubleshooting Database and Database Server Performance Issues
Narrowing Down a Performance Issue to a Database Object.
How the SQLdiag Tool Can Be Used to Analyze Outputs.


Lesson 3: Optimizing the Query Performance Environment
The Methodology of Optimizing a Query Environment.
The Query Performance Troubleshooting Process.
Use of Database Tuning Advisor to Troubleshoot the Query Environment.


Lesson 4: 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?


Lesson 5: 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.

Top
Lesson 6: Troubleshooting SQL Server Data Concurrency Issues
The Methodology of Troubleshooting Concurrency Issues.
What Are SQL Server Latches?

...''

Elements of this syllabus are subject to change.

Phone:(63)2-859-2801

School Address:

CEO Suite, Level 37
LKG Tower
Ayala Avenue, Makati 1226
Philippines


Jobs & Resumes: Alabang, Makati City, Marikina City
Houses & Roommates: Alabang, Makati City, Marikina City
Travel Agencies:

Search other schools for Troubleshooting and Optimizing Database Servers using Microsoft SQL Server 2005 training resources.

Maintaining a Microsoft SQL Server 2005 Database
Implementing a Microsoft SQL Server 2005 Database
Designing Microsoft SQL Server 2005 Server-Side Solutions
Designing Microsoft SQL Server 2005 Databases
designing the data tier for microsoft sql server 2005
tuning and optimizing queries using microsoft sql server 2005
Designing Microsoft SQL Server 2005 Infrastructure and Services
Designing Security for Microsoft SQL Server 2005
Designing a High Availability Database Solutions Using Microsoft SQL Server 2005
Administering and Automating Microsoft SQL Server 2005 Databases and Servers
SQL Server 2008
Maintaining a Microsoft SQL Server 2008 Database
Implementing a Microsoft SQL Server 2008 Database
Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
implementing and maintaining microsoft sql server 2008 reporting services
SQL Server Business Intelligence
oracle database 10g - introduction to sql
Oracle Database 10g: Program With PL/SQL
Oracle10g SQL and SQL Plus

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Our combined search function does not only provide you with the training courses and students, but also talent resumes and jobs, or shared apartments nearby for rent.