Microsoft SQL Server 2008 Implementation and Maintenance

Logo of SQL Server 2008

Certification exams specific to SQL Server 2005 were retired on June 30, 2011.

Don't be left behind! It is time to certify or recertify in the current technologies. Do you need to support or plan to support Microsoft SQL Server 2008? This course will teach you how to install and configure SQL Server 2008; create and implement database objects; implement high availability and diaster recovery solutions; secure instances, databases and database objects; monitor and troubleshoot SQL Server instances. You will be prepared for the Microsoft Certified Technology Specialist (MCTS) exam 70-432. Passing this exam validates your mastery of SQL Server 2008. Prerequisites: A solid foundation in Microsoft Windows Desktop O/S, Internet technologies, knowledge in reading and writing simple and complex SQL statements, and advanced data manipulation techniques.

In this MCTS course you will learn the following skills:

  • Installing and Configuring SQL Server 2008
  • Database Configuration and Maintenance
  • Creating tables and implementing constraints
  • Designing SQL Server indexes
  • Creating, populating, querying and managing full text indexes
  • Distributing and partitioning data
  • Importing and exporting data
  • Designing Policy based management
  • Backing up and restoring a database
  • Automating SQL Server
  • Designing SQL Server security
  • Monitoring SQL Server
  • Optimizing performance
  • Failover clustering
  • Database mirroring
  • Log shipping
  • Replication

Certification
The skills measured for the exam can be found at:
http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-432&locale=en-us#tab2
When you pass Exam 70-432 you complete the requirements for the following certification:
MCTS:Microsoft SQL Server 2008, Implementation and Maintenance

Achieving this certification will earn you credits toward:

  • MCITP: Database Administrator

Course Information:
Course # WITAC 2510
Hours 48
Tuition $765
Text: MCTS Self-Paced Training Kit (Exam 70-432): Microsoft® SQL Server® 2008 Implementation and Maintenance (Pro-Certification) by Mike Hotek (Hardcover - Feb 18, 2009) ISBN #978-0735626058.

Click here to register for this course.

For directions on how to register click here.

To request more info about any of our courses please contact us 215-968-8132 or itacademy@bucks.edu.