Microsoft 70-462: Administering SQL Server 2012 Databases Training Course

Current Status
Not Enrolled
Price
11.99
Get Started

Table of Contents

This course is intended for IT professionals and database administrators who want to upskill their methods in storing and managing data in the SQL server, handle performance and troubleshooting problems, connect and organize SQL servers and create a base for all other SQL server related disciplines.

Key Features

  • 1-year e-learning access

Overview

The Microsoft 70-462 exam is for those working as SQL Server Database administrators, System engineers, and experienced developers. In this course, learn how to administer and manage SQL Server 2012 – from planning, installing, troubleshooting, recovering, and securing instances and databases. This course helps prepare you for the 70-462 exam.

Outline

  • Introduction to the course
    1. Course Introduction
    2. Course Modules
  • Module 1
    1. Introduction to SQL Server 2012
    2. SQL Server Part1
    3. SQL Server Part2
    4. SQL Server Part3
    5. SQL Server Part4
    6. SQL Server Tools Part1
    7. SQL Server Tools Part2
    8. SQL Server Tools Part3
    9. Management Studio Demo Part1
    10. Management Studio Demo Part2
    11. Management Studio Demo Part3
    12. Data Tools Part1
    13. Data Tools Part2
    14. Exam Scenarios
    15. Module Review
  • Module 2
    1. Installing SQL Server
    2. SQL Architecture
    3. Hardware Requirements Part1
    4. Hardware Requirements Part2
    5. Software Requirements Part1
    6. Software Requirements Part2
    7. Installation Process
    8. Troubleshooting Installation
    9. Upgrading & Unattended Installations Part1
    10. Upgrading & Unattended Installations Part2
    11. Configuration Demo Part1
    12. Configuration Demo Part2
    13. Exam Scenarios
    14. Module Review
  • Module 3
    1. Backup and Restore a Database
    2. Database Architecture Part1
    3. Database Architecture Part2
    4. Database Architecture Part3
    5. Database Backup Part1
    6. Database Backup Part2
    7. Database Backup Part3
    8. Restoration Process Part1
    9. Restoration Process Part2
    10. Restoring System Database Part1
    11. Restoring System Database Part2
    12. Backup and Recovery Demo Part1
    13. Backup and Recovery Demo Part2
    14. Exam Scenarios
    15. Module Review
  • Module 4
    1. Tracing Access to SQL Server
    2. Auditing Options Part1
    3. Auditing Options Part2
    4. Introduction to SQL Audit Part1
    5. Introduction to SQL Audit Part2
    6. Audit Objects and Implementation
    7. Extended Events Part1
    8. Extended Events Part2
    9. Tracing Activity Demo Part1
    10. Tracing Activity Demo Part2
    11. Tracing Activity Demo Part3
    12. Tracing Activity Demo Part4
    13. Exam Scenarios
    14. Module Review
  • Module 5
    1. Importing and Exporting Data
    2. Introduction to Data Transfer Part1
    3. Introduction to Data Transfer Part2
    4. ETL Tools
    5. Improving Data Transfer Part1
    6. Improving Data Transfer Part2
    7. Improving Data Transfer Part3
    8. Improving Data Transfer Part4
    9. Copying Database Methods Part1
    10. Copying Database Methods Part2
    11. Transferring Data Demo Part1
    12. Transferring Data Demo Part2
    13. Exam Scenarios
    14. Module Review
  • Module 6
    1. SQL Server Security
    2. Security and Authentication
    3. Server and Database Roles
    4. Permissions Part1
    5. Permissions Part2
    6. Securing SQL Server Demo Part1
    7. Securing SQL Server Demo Part2
    8. Exam Scenarios
    9. Module Review
  • Module 7
    1. Automating SQL Server
    2. SQL Server Agent
    3. Database Mail
    4. Operators, Alerts and Jobs
    5. Database Configuration Demo Part1
    6. Database Configuration Demo Part2
    7. Database Configuration Demo Part4
    8. Database Configuration Demo Part3
    9. Exam Scenarios
    10. Module Review
  • Module 8
    1. Monitoring SQL Server
    2. Dynamic Management Views and Functions
    3. Profiler Trace
    4. Database Tuning Advisor
    5. Activity and Performance Monitor
    6. Data Collection
    7. Monitoring Demo Part1
    8. Monitoring Demo Part2
    9. Monitoring Demo Part3
    10. Monitoring Demo Part4
    11. Monitoring Demo Part5
    12. Monitoring Demo Part6
    13. Monitoring Demo Part7
    14. Exam Scenarios
    15. Module Review
  • Module 9
    1. Maintaining SQL Server
    2. Checking Database Integrity
    3. Indexing Part1
    4. Indexing Part2
    5. Indexing Part3
    6. Ongoing Maintenance
    7. Managing and Maintaining Demo Part1
    8. Managing and Maintaining Demo Part2
    9. Managing and Maintaining Demo Part3
    10. Exam Scenarios
    11. Module Review
  • Module 10
    1. Troubleshooting SQL Server
    2. Service Issues
    3. Connectivity Issues
    4. Locking Issues
    5. Troubleshooting Demo Part1
    6. Troubleshooting Demo Part2
    7. Exam Scenarios
    8. Module Review
    9. Program Review

stay informed!

Subscribe to receive exclusive content and notifications

small_c_popup.png

Share this course

[geturl]
Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

Keep in touch

Fill in your details and we’ll get back to you in no time.