Microsoft 70-462: Administering SQL Server 2012 Databases

299 USD 18.99 USD 94%
Test scorm

This training course was created specifically for those individuals (Database Professionals) who install, maintain and configure as their primary job function. Any participants setting up database systems and/or responsible for efficient system operation, regular database back ups stored effectively, and securing data from unauthorised access is also a candidate for this training course on SQL 2012.

read more

Module 1

  • Introduction to SQL Server 2012
  • SQL Server
  • SQL Server Tools
  • Management Studio Demo
  • Data Tools
  • Exam Scenarios
  • Module Review

Module 2

  • Installing SQL Server
  • SQL Architecture
  • Hardware Requirements
  • Software Requirements
  • Installation Process
  • Troubleshooting Installation
  • Upgrading and Unattended Installations
  • Configuration Demo
  • Exam Scenarios
  • Module Review

Module 3

  • Backup and Restore a Database
  • Database Architecture
  • Database Backup
  • Restoration Process
  • Restoring System Database
  • Backup and Recovery Demo
  • Exam Scenarios
  • Module Review

Module 4

  • Tracing Access to SQL Server
  • Auditing Options
  • Introduction to SQL Audit
  • Audit Objects and Implementation
  • Extended Events
  • Tracing Activity Demo
  • Exam Scenarios
  • Module Review

Module 5

  • Importing and Exporting Data
  • Introduction to Data Transfer
  • ETL Tools
  • Improving Data Transfer
  • Copying Database Methods
  • Transferring Data Demo
  • Exam Scenarios
  • Module Review

Module 6

  • SQL Server Security
  • Security and Authentication
  • Server and Database Roles
  • Permissions
  • Securing SQL Server Demo
  • Exam Scenarios
  • Module Review

Module 7

  • Automating SQL Server
  • SQL Server Agent
  • Database Mail
  • Operators, Alerts and Jobs
  • Database Configuration Demo
  • Exam Scenarios
  • Module Review

Module 8

  • Monitoring SQL Server
  • Dynamic Management Views and Functions
  • Profiler Trace
  • Database Tuning Advisor
  • Activity and Performance Monitor
  • Data Collection
  • Monitoring Demo
  • Exam Scenarios
  • Module Review

Module 9

  • Maintaining SQL Server
  • Checking Database Integrity
  • Indexing
  • Ongoing Maintenance
  • Managing and Maintaining Demo
  • Exam Scenarios
  • Module Review

Module 10

  • Troubleshooting SQL Server
  • Service Issues
  • Connectivity Issues
  • Locking Issues
  • Troubleshooting Demo
  • Exam Scenarios
  • Module Review
  • Program Review
  1. Module 1
5
Start
SQL Server
5
Start
SQL Server
6
Start
SQL Server Tools
6
Start
SQL Server Tools
6
Start
SQL Server Tools
7
Start
Management Studio Demo
7
Start
Management Studio Demo
7
Start
Management Studio Demo
8
Start
Data Tools
8
Start
Data Tools
9
Start
Exam Scenarios
10
Start
Module Review
  1. Module 2
11
Start
Installing SQL Server
12
Start
SQL Architecture
13
Start
Hardware Requirements
13
Start
Hardware Requirements
14
Start
Software Requirements
14
Start
Software Requirements
15
Start
Installation Process
16
Start
Troubleshooting Installation
17
Start
Upgrading and Unattended Installations
17
Start
Upgrading and Unattended Installations
18
Start
Configuration Demo
18
Start
Configuration Demo
19
Start
Exam Scenarios
20
Start
Module Review
  1. Module 3
21
Start
Backup and Restore a Database
22
Start
Database Architecture
22
Start
Database Architecture
22
Start
Database Architecture

No reviews for this course !

Add New Discussion

How do you rate this product?

Select currency