Microsoft SQL Server 2005 DBA Boot Camp
5 days Instructor-Led  Course  Microsoft Official SQL BI Training Classes from Solartech

Microsoft SQL Server 2005 BI Training from Solartech

This 5-days accelerated training boot camp will teach the following (please click the URL to view detail course content. Please make sure you meet all the pre-requisite or attend Course 2785: Implementing and Maintaining Microsoft SQL Server 2005.  Training will be conducted by Solartech expert and Microsoft SQL Server 2005 certified instructor and use only genuine Microsoft Official Curriculum content. This training also helps you to prepare for Microsoft Certified IT Professional: Database Administrator Certification.
 

Designing a Microsoft SQL Server 2005 Infrastructure

This course provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL ServerT 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 tradeoffs that need to be made during design.
 
1 day
Designing Security for Microsoft SQL Server 2005

This two-day instructor-led course enables database administrators who work with enterprise environments to design security for database systems using Microsoft SQL ServerT 2005. The course emphasizes that students should think about the whole environment, which includes business needs, regulatory requirements, network systems, and database considerations during design. Students will also learn how to monitor security and respond to threats.
 
1 day
Designing High Availability Database Solutions Using Microsoft SQL Server 2005

This instructor-led course provides students with the knowledge and skills to design high availability database solutions using Microsoft® SQL ServerT 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.
1.5 days
Administering and Automating Microsoft SQL Server 2005 Databases and Servers

This course provides 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.
 
0.5 day
Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005

The purpose of this workshop is to 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 establishing monitoring standards and baselines, determining performance thresholds, and focusing the investigation on specific issues.
 
1 day

| Home | About Us | Contact Us | Find a Course |