MCTS: Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005

   

Microsoft Certified Technology Series: Database Administrator working in enterprise environments how to determine and troubleshoot performance issues using Microsoft SQL Server 2005. The primary focus of this workshop is to teach the overall process of troubleshooting. It includes establishing monitoring standards and baselines, determining performance thresholds, and focusing the investigation on specific issues.

         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.

         Prerequisites:

 

  • Working knowledge of the operating system and platform. Students should understand how the operating system integrates with the database, what the platform or operating system can do, and the interaction between the operating system and the database.
  • Basic understanding of server architecture such as CPU and memory utilization and disk input/output (I/O).
  • Basic knowledge of application architecture. Students should know how applications can be designed in three layers, what applications can do, the interaction between applications and the database, and the interaction between the database and the platform or operating system.
  • Understanding of Transact-SQL syntax and programming logic.
  • Basic knowledge of Microsoft Windows networking. Students should understand how Domain Name Service (DNS) operates and how servers communicate between domains.
 

                                                                                                                          Download Course detail PDF

100 % PSMB claimable            

  

 

 

 

 

 

 

 

 

 

 

 

       Registration Information

Venue :

 NexPro Training Centre, Penang
Starting Date:  Oct 2009

Duration:

 2 Days     

Fee:  RM2000  Per participant (Exam fee excluded)
Trainer  Mr. Daryl Soong, Microsoft Certified Trainer

Contact No:

 04-642 6779  Fax :  04-643 9155  Mr. Sean Chew (Pg)

 03-40244748  Mr. Ho (KL)

Offline Registration Form:

  Download PDF format
  ( File Size : 48KB, estimated 5 Seconds)

 

 

 

 We are the only HP training partner in Malaysia.

Our Instructors are trained and certified by HP and Microsoft.

      Payment Method : Crossed cheque payable to Nexus Professional Sdn. Bhd.

 << BACK

COPYRIGHT © 2002-2008, Nexus Professional SB. ALL RIGHTS RESERVED.