Microsoft Certified Technology Specialist (MCTS): SQL Server 2008 Implementation and Maintenance

Scheduled Dates (sort by: location | date)

I'd like a different date/location

Please click above and we will take care of the rest.

I’d like an onsite/bespoke course

Please click above and we will be happy to discuss the benefits of onsite and bespoke courses with you.

If suitable dates or locations are not available, click this link and we will arrange one for you

Course Overview

This five-day accelerated track provides students with the knowledge and skills to implement and maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing and maintaining a database.

Audience

This course is intended for IT Professionals who need to implement, administer and maintain SQL Server databases

Examinations

• 70-432 Microsoft SQL Server 2008, Implementation and Maintenance

Course Outline

What will the track cover?

• Installing and Configuring SQL Server
• Managing Databases and Files
• Disaster Recovery
• Managing Security
• Transferring Data
• Automating Administrative Tasks
• Implementing Replication
• Maintaining High Availability
• Monitoring SQL Server
• Troubleshooting and Performance Tuning
• Creating Databases, Database Files, Data Types and Tables
• Implementing Data Integrity by Using Constraints and Triggers
• Using XML
• Implementing Views, Stored Procedures and Functions
• Implementing Managed Code in the Database
• Managing Transactions and Locks
• Using Service Broker

Microsoft Certified Technology Specialist (MCTS): SQL Server 2008 Implementation and Maintenance / MCTSSQIM