Cart Subtotal: $0.00

Welcome Student!

  • Contact Us
  • (888) 840-2378
  • Tech Support: (866) 830-9276
  • Click here to chat!

Microsoft 70-462: Administering SQL Server 2012 Databases

Click on image to zoom

Be the first to review this product

SKU# 174033

Availability: In stock

$199.00

$59.00

Secure shopping trustmarks

Quick Overview

Microsoft 70-462: Administering SQL Server 2012 Databases

QuickCert Exam Pass Guarantee

QuickCert’s online IT training programs are guaranteed to get you certified – or we will pay for your make-up exam. Our quality online IT courseware, packed with instruction, exercises, practice exams and test simulators will ensure you pass the exam. Learn more.

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

 

We create the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed. 

Syllabus

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

Instructor Bio

David Dye

Reviews
Write Your Own Review

You're reviewing: Microsoft 70-462: Administering SQL Server 2012 Databases

  •  
    1 star
    2 stars
    3 stars
    4 stars
    5 stars
    Quality
    Price
    Value

* Required Fields

Free Demo