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

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