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 70-450: Designing Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008

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

Overview

The 70-450 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 SQL server instances and database solutions, database server security solutions, database solutions for high availability, backup and recovery solutions, monitoring Strategies and data distribution. These same tasks will help you understand the objectives and competencies required by the PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008 certification exam. Exam retired July 31, 2015.

Vendor:   Microsoft
Vendor Id:   70-450
Version:   1
Level:   Intermediate
Learning Time:   360  Minutes

Exercises

  1. Designing a SQL Server Instance and a Database Solution
  2. Total Learning Time is 60  Minutes and module version is 10

    Exercises:
    • Introduction
    • Designing for CPU Memory and Storage Capacity Requirements
    • Designing SQL Server Instances
    • Designing a Physical Database and Placing Objects
    • Upgrading SQL Server Instances
    • Summary
  3. Designing a Database Server Security Solution
  4. Total Learning Time is 70  Minutes and module version is 1

    Exercises:
    • Introduction
    • Designing Instance Authentication
    • Designing Instance Level Security Configurations
    • Designing Database Schema and Object Security Parameters
    • Designing a Security Policy and an Audit Plan
    • Designing an Encryption Strategy
    • Summary
  5. Designing SQL Server Instances
  6. Total Learning Time is 70  Minutes and module version is 1

    Exercises:
    • Introduction
    • Design a Failover Clustering Solution
    • Design Database Mirroring
    • Design a High-Availability Solution Based on Replication
    • Design a High-Availability Solution Based on Log Shipping
    • Select High-Availability Technologies Based on Business Requirements
    • Summary
  7. Designing a migration strategy
  8. Total Learning Time is 50  Minutes and module version is 1

    Exercises:
    • Introduction
    • Design a Backup Strategy
    • Design a Recovery Strategy
    • Design a Recovery Test Plan
    • Summary
  9. Designing a Monitoring Strategy
  10. Total Learning Time is 50  Minutes and module version is 1

    Exercises:
    • Introduction
    • Design a monitoring solution at the operating system level
    • Design a monitoring solution at the instance level
    • Backup and recovery
    • Summary
  11. Designing a Strategy to Maintain and Manage Databases
  12. Total Learning Time is 30  Minutes and module version is 1

    Exercises:
    • Introduction
    • Designing a Strategy to Maintain and Manage Databases
    • Summary
  13. Designing a Strategy for Data Distribution
  14. Total Learning Time is 30  Minutes and module version is 1

    Exercises:
    • Introduction
    • Design security for accessing packages
    • Summary
LIVE LAB Access to real hardware and software in real time and with full administrator privileges to gain real-world practical experience.
  • 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