Existing User Login

New User? Create An Account

Request new password

We Are All About You

XpertSkills - the parent company under which iCollege operates - was established in South Africa in 2003 and since then, we have grown globally in leaps and bounds with customers and partners in more than 120 countries. With employees on 3 continents and as a next-generation, virtual organization we are unconstrained by the limits that are usually associated with traditional “brick & mortar” companies.

This allows us to focus, without distraction, on reaching our ultimate goal – ensuring your ongoing success – by providing affordable, reliable, high quality and relevant learning products whilst remaining innovative and agile.

Contact Details:

Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com

Physical Address:

Head Office - South Africa
16 Monte Carlo Crescent
Kyalami business Park
Johannesburg
South Africa 1684

You are here

courses popup callback

LIVE LAB:

Microsoft SQL Server 2008 Implementation and Maintenance

Practical exercises in a live environment to help you get real-world, hands-on experience.

Overview

The 70-432 Practice-Lab will provide you with the necessary platform to gain hands on skills in SQL Server 2008. By completing the lab tasks you will improve your practical skills in installing SQL Server 2008 and related services, Maintaining a SQL Server Databases, Managing SQL Server Security, Data Management Tasks, Troubleshooting and Optimising SQL Server and High Availability. These same tasks will help you understand the objectives and competencies required by the MCTS: Microsoft SQL Server 2008, Implementation and Maintenance certification exam.

Vendor:   Microsoft
Vendor Id:   70-432
Version:   1
Level:   Intermediate
Learning Time:   530  Minutes

Exercises

  1. Installing SQL Server 2008
  2. Total Learning Time is 30  Minutes and module version is 6

    Exercises:
    • Introduction
    • Install SQL Server 2008 and Related Services
    • Summary
  3. Configure Additional SQL Server Components
  4. Total Learning Time is 50  Minutes and module version is 1

    Exercises:
    • Introduction
    • Installing Shared Features
    • Managing SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)
    • Master Data Services (MDS)
    • Summary
  5. Configure SQL Server Instances and Services
  6. Total Learning Time is 60  Minutes and module version is 1

    Exercises:
    • Introduction
    • Configure SQL Server Instances
    • Configure SQL Server Services
    • Implement Database Mail
    • Configure Full-Text Indexing
    • Summary
  7. Maintaining SQL Server Instances
  8. Total Learning Time is 50  Minutes and module version is 1

    Exercises:
    • Introduction
    • Manage SQL Server Agent Jobs
    • Manage SQL Server Agent Alerts
    • Implement the Declarative Management Framework (DMF)
    • Summary
  9. Managing SQL Server Security
  10. Total Learning Time is 70  Minutes and module version is 1

    Exercises:
    • Introduction
    • Managing Logins and Server Roles
    • Manage Users and Database Roles
    • Manage SQL Server Instance Permissions
    • Manage Database, Schema and Object Permissions
    • Auditing SQL Server Instances
    • Summary
  11. Maintaining SQL Server Databases
  12. Total Learning Time is 60  Minutes and module version is 1

    Exercises:
    • Introduction
    • Backup an SQL Server Database
    • Managing Database Snapshots
    • Maintaining Database Integrity
    • Maintaining Databases Using Maintenance Plans
    • Summary
  13. Performing Data Management Tasks
  14. Total Learning Time is 70  Minutes and module version is 1

    Exercises:
    • Introduction
    • Import and Export Data
    • Manage Data Partitions
    • Implement Data Compression
    • Maintain Indexes
    • Manage Collations
    • Summary
  15. Monitoring Troubleshooting and Optimising SQL Server
  16. Total Learning Time is 90  Minutes and module version is 1

    Exercises:
    • Introduction
    • Identifying SQL Server Service Problems
    • Identify SQL Agent Job Execution Problems
    • Implement Resource Governor
    • Collect Trace Data by Using SQL Server Profiler
    • Use the Database Engine Tuning Advisor
    • Collect Performance Data by Using Dynamic Management Views (DMVs)
    • Collecting Performance Data by Using System Monitor
    • Summary
  17. Implementing High Availability
  18. Total Learning Time is 50  Minutes and module version is 1

    Exercises:
    • Introduction
    • Implementing Database Mirroring
    • Implementing Replication
    • Configuring Log Shipping
    • Summary
LIVE LAB Access to real hardware and software in real time and with full administrator privileges to gain real-world practical experience.
  • 530+ Minutes of practical exercises
  • Gain practical experience with real-world scenarios
  • Access to real hardware & software in real time
  • Experiment & put theory to practice
  • Includes exercises designed to prepare for exams.
  • 12 Months access
  • 10-Day money-back guarantee
Back to Top