Microsoft 70-462: Administering SQL Server 2012 Databases

£495.00

Description

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 unauthorized access is also a candidate for this training course on SQL 2012.

Below is a partial list of job functions associated to this training course:

Audit SQL Server instances
Back up databases
Configure additional SQL Server components, Instances and Services
Deploying a SQL Server
Implementing strategies, column stores and High-Availability and Disaster Recovery solutions
Importing/exporting
Install SQL Server and related services.
Maintenance
Management, configuration, permissions, alerts, logins and roles.
Optimization
Installation Planning
Restoring
Troubleshooting

The SQL 2012 Administering Databases course prepares you for the Microsoft Exam 70-462 – As the participant in the SQL 2012 Administering course will learn:

Installation Planning
Installing SQL Server and related services
Implementation of a migration strategy
How to configure additional SQL Server components
Managing the SQL Server Agent
Database management and configuration
How to configure SQL Server instances
Implementing a SQL Server clustered instance
SQL Server instances management
How to properly Identify and resolve concurrency problems
The collection of and how to analyze troubleshooting data
Auditing SQL Server instances
Configure and maintain a back up strategy
Database restoration
Implementing and maintaining indexes
Importing and exporting data
Managing logins and server roles
Managing database permissions
Managing users and database roles
Troubleshooting security
Implementing AlwaysOn, database mirroring and replication

Syllabus:

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 Dem0
Exam Scenarios
Module Review

Module 4

Tracing Access to SQL Server
Auditing Option
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

Course Delivery: Online