Microsoft Certification Training

Microsoft SQL Server Database

Courses 2779 & 2780 Implementing a Microsoft SQL Server 2005 Database & Maintaining a Microsoft SQL Server 2005 Database (5-Day)

SQL Server 2005 represents Microsoft’s first major technology upgrade for some time. Microsoft officially launched on 7 November 2005.  These combined courses provide students with product knowledge and skills needed to implement a MS SQL Server 2005 database as well as knowledge on how to use SQL Server 2005 product features and tools related to maintaining a database. This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for implementing and maintaining a database.

Courses 2786 & 2788 Designing a Microsoft SQL Server 2005 Infrastructure & Designing High Availability Database Solutions Using Microsoft SQL Server 2005  (5-Day)

SQL Server 2005 represents Microsoft’s first major technology upgrade for some time. Microsoft officially launched on 7 November 2005. The first two of the five day instructor-led course provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL Server 2005 database infrastructure. The course focuses on the development of strategies for data archiving, consolidation, distribution, and recovery. The course also stresses the importance of capacity analysis and emphasizes the trade-offs that need to be made during design. The last three days provides students with the knowledge and skills to design high availability database solutions using Microsoft SQL Server 2005. The course focuses on teaching experienced database administrators working in enterprise environments to design database solutions that meet the availability needs of their organization. It emphasizes that students should think broadly about high availability, which includes thinking about the database itself and about their entire environment, including business needs; regulatory requirements; and network, systems, and database considerations during design. Students will also learn how to document and test the high availability database solution. 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.

Courses 2787 &2789 & 2790 Designing Security for Microsoft SQL Server 2005 & Administering and Automating Microsoft SQL Server 2005 & Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 (5-Day)

SQL Server 2005 represents Microsoft’s first major technology upgrade for some time. Microsoft officially launched on 7 November 2005. The first two of the five day instructor-led course enables database administrators who work with enterprise environments to design security for database systems using Microsoft SQL Server 2005. The course emphasizes that students should think about the whole environment, which includes business needs, regulatory requirements and network systems, and database considerations during design. Students will also learn how to monitor security and  respond to threats. During course 2789 teaches students with the knowledge and skills to administer and automate Microsoft SQL Server 2005 databases and servers. This course focuses on the need to maintain administration and automation information. The last two days of this workshop will teach database administrators 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 learning how to establish monitoring standards and baselines, determining performance thresholds, and focusing the investigation on specific issues. This course is intended for current professional database administrators who have on-the-job experience administering SQL Server database solutions in an enterprise environment.

Check the IT Certification Training Schedule for current training dates.

Print this Page