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
Phone: +27 10 020 2067

Physical Address:

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

You are here

Microsoft 70-462 Administering Microsoft SQL Server 2012 Databases

LIVE LAB:

Microsoft 70-462 Administering Microsoft SQL Server 2012 Databases

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

Overview

The 70-462 Practice-Lab will provide you with the necessary platform to gain hands on skills in Microsoft SQL Server 2012 Databases. By completing the lab tasks you will improve your practical skills Configuring SQL Server components, Manage SQL Server Agent, Manage and configure databases, Configure and Manage SQL Server instances, Collect and analyze troubleshooting data, Configure and maintain a backup strategy and Manage database permissions. These same tasks will help you understand the objectives and competencies required by the Administering Microsoft SQL Server 2012 Databases certification exam. Update: Lab now includes a SQL 2014 device.

Vendor:   Microsoft
Vendor Id:   70-462
Version:   1
Level:   Intermediate
Learning Time:   780  Minutes

Exercises

  1. Install SQL Server and Related Services
  2. Total Learning Time is 50  Minutes and module version is 4

    Exercises:
    • Introduction
    • Planning SQL Server 2012 Installation
    • Install SQL Server and Related Services
    • Plan for capacity
    • Summary
  3. Implement a Migration Strategy
  4. Total Learning Time is 40  Minutes and module version is 5

    Exercises:
    • Introduction
    • Restore vs. Detach / Attach
    • Upgrade from a Previous Version
    • Summary
  5. Configure Additional SQL Server Components
  6. Total Learning Time is 50  Minutes and module version is 3

    Exercises:
    • Introduction
    • Configure Full-Text Indexing
    • Configure SSIS Security
    • Configure FILESTREAM
    • Summary
  7. Manage SQL Server Agent
  8. Total Learning Time is 40  Minutes and module version is 5

    Exercises:
    • Introduction
    • Create, Maintain, and Monitor Jobs
    • Automate (Setup, Maintenance, Monitoring) Across Multiple Databases and Multiple Instances
    • Summary
  9. Manage and Configure Databases
  10. Total Learning Time is 50  Minutes and module version is 2

    Exercises:
    • Introduction
    • Designing Multiple Filegroups
    • Configuring and Standardizing Databases
    • Implementing and Configuring Contained Databases
    • Summary
  11. Configure SQL Server Instances
  12. Total Learning Time is 40  Minutes and module version is 2

    Exercises:
    • Introduction
    • Configuring Server Level Settings
    • Configuring Database Mail
    • Summary
  13. Manage SQL Server Instances
  14. Total Learning Time is 40  Minutes and module version is 8

    Exercises:
    • Introduction
    • Interaction of Instances
    • Managing Resource Utilization by Using Resource Governor
    • Summary
  15. Identify and Resolve Concurrency Problems
  16. Total Learning Time is 60  Minutes and module version is 3

    Exercises:
    • Introduction
    • Examining Deadlock Issues
    • Creating Alerts on Critical Server Condition
    • Monitoring data and server access
    • Monitoring via DMV
    • Summary
  17. Collect and Analyze Troubleshooting Data
  18. Total Learning Time is 30  Minutes and module version is 2

    Exercises:
    • Introduction
    • Tools for Troubleshooting Data
    • Summary
  19. Audit SQL Server Instances
  20. Total Learning Time is 50  Minutes and module version is 2

    Exercises:
    • Introduction
    • Configuring Server Audits
    • Configuring Policy-Based Management
    • Monitoring Unsolicited Attempts to Connect
    • Summary
  21. Configure and Maintain a Backup Strategy
  22. Total Learning Time is 40  Minutes and module version is 2

    Exercises:
    • Introduction
    • Managing Backups
    • Restoring Databases
    • Summary
  23. Implement and Maintain Indexes
  24. Total Learning Time is 40  Minutes and module version is 2

    Exercises:
    • Introduction
    • Managing Indexes
    • Full Text Indexes
    • Summary
  25. Import and Export Data
  26. Total Learning Time is 30  Minutes and module version is 2

    Exercises:
    • Introduction
    • Data Import and Export
    • Summary
  27. Manage Logins and Server Roles
  28. Total Learning Time is 40  Minutes and module version is 4

    Exercises:
    • Introduction
    • Configuring Server Security
    • Managing Access to the Server, SQL Server Instance and Databases
    • Summary
  29. Manage Database Permissions
  30. Total Learning Time is 40  Minutes and module version is 2

    Exercises:
    • Introduction
    • Configuring Database Security
    • Managing Certificates and Keys
    • Summary
  31. Manage Users and Database Roles
  32. Total Learning Time is 50  Minutes and module version is 3

    Exercises:
    • Introduction
    • Managing Security Roles
    • Creating Database User Accounts
    • Creating Contained Logins
    • Summary
  33. Implement Database Mirroring and Replication
  34. Total Learning Time is 40  Minutes and module version is 8

    Exercises:
    • Introduction
    • Implement Database Mirroring
    • Implementing Replication
    • Summary
  35. Failover Clustering
  36. Total Learning Time is 50  Minutes and module version is 9

    Exercises:
    • Introduction
    • Configuring Windows Clustering
    • Installing a SQL Server Failover Cluster
    • Implementing the AlwaysOn Feature
    • Summary
LIVE LAB Access to real hardware and software in real time and with full administrator privileges to gain real-world practical experience.
USD 295 USD 120 59% OFF
  • No of hours: 
    780
    + 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 (Unless indicated otherwise)
  • 10-Day money-back guarantee
Back to Top