GET IN THE LEAD - get certified today! Experience the benefits of classroom learning - anytime, anywhere! QuickCert's expert instruction and multi-media courses are to get you certified - or your money back! Read why successful professionals choose QuickCert >

 

This QuickCert trainig 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 QuickCert training course on SQL 2012.

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

Audit SQL Server instances

Back up databases

Configure additional SQL Server components, Instances and Services

Deploying a SQL Server

Implementing strategies, columnstores 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 QuickCert SQL 2012 Administering Databases course prepares you for the Microsoft Exam 70-462 - As the participant in the QuickCert SQL 2012 Adminstering 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

QuickCert creates the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed.  QuickCert is so certain this course meets and exceeds the exam objectives, we guarantee you will pass your exam!

Not sure what course is right for you?
Contact one of our Career Advisors at 888.840.2378 for assistance.

Your QuickCert Microsoft Exam 70-462: Administering Microsoft SQL Server 2012 Databases Certification
Training Package Includes:

Delivery Format	Instructor Led Modules	Hardbook Supplement	Practice Exam Simulator	Exam Pass Guarantee
DVDs or online

Exam Pass Guarantee - Learn More

Free Product Upgrades

Toll Free Educational Support

Compatibility with:
98 | 2000 | ME | XP | 2003| Vista | Windows 7 | Windows 8

 

Hear What Our Customers Are Saying...

“I’m 100% satisfied with QuickCert’s training program. I love that it’s broken into manageable sections.   This is an all-inclusive training solution… they give you the manuals, the lectures broken into short segments, and practice tests that really mirror the actual tests I’ve taken. I plan to renew my membership!!”

— Karen S., Network Administrator, Calabasas, California

Questions?  Contact one of our Career Advisors at 888.840.2378 for assistance or email sales@quickcert.com.

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

Instructor Introduction
Course Outline

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

Questions?  Contact one of our Career Advisors at 888.840.2378 for assistance or email sales@quickcert.com.

Free Demo