Help Icon

ETG8044

Course
ETG8044
Course Title
Microsoft Certified Solutions Associate (MCSA): SQL Server 2008

Description

This online training program will prepare you to use SQL Server 2008 product features and tools related to maintaining and implementation as well as to use SQL Server 2008 integration, reporting and analysis tools to access and process the data necessary to create business solutions. This program prepares students for two exams: Microsoft SQL Server 2008 Implementation and Maintenance exam (70-432) and Microsoft SQL Server 2008 Intelligence Development and Maintenance (70-448). Offered in partnership with ed2go.

Students should have one to two years of experience using SQL Server 2008 or two to three years of experience using a previous version of SQL Server.

Objectives

By the end of the program students will know how to implement, maintain, troubleshoot, and debug SQL Server 2008, as well as to use SQL Server 2008 integration, reporting, and analysis tools to access and process the data necessary to create business solutions. This online program will prepare students to take the Microsoft SQL Server 2008 Implementation and Maintenance (70-432) and the Microsoft SQL Server 2008 Intelligence Development and Maintenance (70-448) certification exams. Upon passing both exams, students will receive the MCSA SQL Server 2008 certification.

Content

  1. Microsoft SQL Server 2008 Implementation and Maintenance (SSMS432)
    1. Installation
    2. Instance and Database Configuration
    3. Security Management
    4. Database Management
    5. Data Management
    6. Database Monitoring and Performance
    7. Backups, Restores, and Database Snapshots
    8. High Availability and Disaster Recovery
  2. Microsoft SQL Server 2008: Business Intelligence Development and Maintenance (SSMS448)
    1. Implementing Integration Services
    2. Configuring Integration Services Packages
    3. Deploying Integration Services Packages
    4. Managing SSIS Packages
    5. Implementing Reporting Services Solutions
    6. Deploying and Delivering Reporting Services Reports
    7. Maintaining Reporting Services
    8. Implementing Analysis Services Solutions
    9. Querying Cubes and Working with Data Mining in SSAS
    10. Managing Analysis Services Solutions

Method of Instruction

Online

Evaluation

Class participation