Microsoft SQL Server 2008 Implementation and Maintenance (SSMS432) Courses

Microsoft SQL Server 2008 Implementation and Maintenance (SSMS432) Course Introduction

This course provides students with the knowledge and skills necessary to implement, maintain, troubleshoot, and debug SQL Server 2008. It focuses on teaching students how to use SQL Server 2008 product features and tools related to maintaining a database.

Course Prerequisites

Students should possess the knowledge and experience with implementing and administering a network operating system and experience using SQL Server.

Course Aim

This course prepares students to write the following Microsoft exam:
70-432: Microsoft SQL Server 2008, Implementation and Maintenance

Course Notes

A Student Textbook is provided for on-going reference. There is a final exam upon completion of the course. Participants who receive 75% or higher on their exam will receive a certificate.
Due to the dynamic nature of the IT industry, job success mandates that an individual not only learns the theory, but also obtains the skill to locate resources that provide answers and help to solve problems on the job. We encourage our students to develop research and study skills that will help them to make the transition from the classroom to the work environment. Independent thinking is required of anyone considering IT courses and a career in IT.

Program Classification

Information Technology

Training Path

This course covers the objectives for Microsoft exam 70-432: Microsoft SQL Server 2008, Implementation and Maintenance. Passing this exam completes the requirements for the MCTS: Microsoft SQL Server 2008, Implementation and Maintenance certification.

Industry Certification Preparation

This course prepares the student to write Microsoft Exam 70-432.

Method of Delivery

Online training supported by Academy of Learning College facilitators or Online instructors.

Microsoft SQL Server 2008 Implementation and Maintenance (SSMS432) Course Breakdown

Module 1:

SQL Server 2008 Introduction; SQL Server 2008 Requirements and Considerations; SQL Server 2008 Installation; Preparing to Upgrade to SQL Server 2008; Upgrading to SQL Server 2008; Performing a SQL Server 2008 Installation

Module 2:

SQL Server 2008 Configuration; SQL Server 2008 Feature Configuration; SQL Server 2008 Database Architecture; Database Creation in SQL Server 2008; Configuring SQL Server 2008

Module 3:

SQL Server 2008 Database Resource Security; SQL Server 2008 Login, Schema, and User Creation; Data Encryption in SQL Server 2008; Impersonation in SQL Server 2008; Audit Access to SQL Server 2008; Creating and Auditing Logins in SQL Server 2008

Module 4:

SQL Server 2008 Database Integrity and File Management; Moving Database Files in SQL Server 2008; Using Database Maintenance Plans in SQL Server 2008; Managing Database Integrity and Using Maintenance Plans; SQL Server Agent Security and Operator Configuration; Configuring SQL Server Agent Jobs and Alerts; Policy-Based Management in SQL Server 2008; Using SQL Server Agent and Policy-Based Management

Module 5:

Managing Table Partitions in SQL Server 2008; SQL Server 2008 Data Compression in a Database; Introduction to Indexes in SQL Server 2008; Index Creation in SQL Server 2008; Managing Indexes in SQL Server 2008; Transferring Bulk Data in SQL Server 2008; Importing and Exporting Data in SQL Server 2008; Managing Tables, Indexes, and Data in SQL Server 2008

Module 6:

Creating Trace Files in SQL Server 2008; Tuning a Database in SQL Server 2008; Monitoring Resources in SQL Server 2008; Creating Data Collectors in SQL Server 2008; Monitoring a SQL Server 2008 Instance; Locking in a SQL Server 2008 Database; Resolving Deadlocks and Blocks in SQL Server 2008; Monitoring and Tuning SQL Server 2008 Performance

Module 7:

Recovery Models and Backup Types in SQL Server 2008; Performing SQL Server 2008 Database Backups; Restoring SQL Server 2008 Backups; Working with Database Snapshots in SQL Server 2008; Backing Up and Restoring a SQL Server 2008 Database

Module 8:

Introduction to Database Mirroring in SQL Server 2008; Database Mirroring Configuration in SQL Server 2008; SQL Server 2008 Log Shipping Configuration; Replication Configuration in SQL Server 2008; Replication Management in SQL Server 2008; High-Availability Solutions in SQL Server 2008; Failover Clustering in SQL Server 2008