Skip to content

Microsoft 70-462: Administering SQL Server 2012 Databases

CM


eTrain

Summary

Price
£99 inc VAT
Or £33.00/mo. for 3 months...
Study method
Online, self-paced
Duration
7 hours
Access to content
1 year
Certification
MCSA: SQL 2016 Database Administration
Professional certification What's this?
Additional info
  • Exam(s) / assessment(s) is included in price
  • Tutor is available to students

Add to basket or enquire

Overview

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.


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

Certification

MCSA: SQL 2016 Database Administration

Awarded by Microsoft

Description

Course Curriculum

Introduction to the course

Course Introduction (0:55)

Course Modules (1:00)

Module 1

Introduction to SQL Server 2012 (0:18)

SQL Server Part1 (1:50)

SQL Server Part2 (5:19)

SQL Server Part3 (5:50)

SQL Server Part4 (5:19)

SQL Server Tools Part1 (1:02)

SQL Server Tools Part2 (5:32)

SQL Server Tools Part3 (3:05)

Management Studio Demo Part1 (5:35)

Management Studio Demo Part2 (3:56)

Management Studio Demo Part3 (5:49)

Data Tools Part1 (5:27)

Data Tools Part2 (3:42)

Exam Scenarios (2:43)

Module Review (1:49)

Module 2

Installing SQL Server (0:17)

SQL Architecture (1:03)

Hardware Requirements Part1 (7:14)

Hardware Requirements Part2 (3:23)

Software Requirements Part1 (3:16)

Software Requirements Part2 (1:07)

Installation Process (1:33)

Troubleshooting Installation (2:17)

Upgrading & Unattended Installations Part1 (0:07)

Upgrading & Unattended Installations Part2 (5:01)

Configuration Demo Part1 (7:12)

Configuration Demo Part2 (2:05)

Exam Scenarios (2:55)

Module Review (1:04)

Module 3

Backup and Restore a Database (0:14)

Database Architecture Part1 (0:11)

Database Architecture Part2 (7:18)

Database Architecture Part3 (1:15)

Database Backup Part1 (0:16)

Database Backup Part2 (6:44)

Database Backup Part3 (3:50)

Restoration Process Part1 (0:17)

Restoration Process Part2 (6:41)

Restoring System Database Part1 (0:05)

Restoring System Database Part2 (2:10)

Backup and Recovery Demo Part1 (7:35)

Backup and Recovery Demo Part2 (5:12)

Exam Scenarios (4:32)

Module Review (2:04)

Module 4

Tracing Access to SQL Server (0:20)

Auditing Options Part1 (0:15)

Auditing Options Part2 (7:36)

Introduction to SQL Audit Part1 (0:09)

Introduction to SQL Audit Part2 (2:01)

Audit Objects and Implementation (4:42)

Extended Events Part1 (0:05)

Extended Events Part2 (0:38)

Tracing Activity Demo Part1 (8:16)

Tracing Activity Demo Part2 (6:53)

Tracing Activity Demo Part3 (4:09)

Tracing Activity Demo Part4 (4:54)

Exam Scenarios (3:02)

Module Review (1:03)

Module 5

Importing and Exporting Data (0:15)

Introduction to Data Transfer Part1 (0:08)

Introduction to Data Transfer Part2 (1:14)

ETL Tools (6:05)

Improving Data Transfer Part1 (1:45)

Improving Data Transfer Part2 (0:46)

Improving Data Transfer Part3 (0:57)

Improving Data Transfer Part4 (3:50)

Copying Database Methods Part1 (3:03)

Copying Database Methods Part2 (0:42)

Transferring Data Demo Part1 (4:36)

Transferring Data Demo Part2 (4:24)

Exam Scenarios (2:18)

Module Review (1:06)

Module 6

SQL Server Security (0:08)

Security and Authentication (8:05)

Server and Database Roles (4:04)

Permissions Part1 (3:35)

Permissions Part2 (7:47)

Securing SQL Server Demo Part1 (7:53)

Securing SQL Server Demo Part2 (5:49)

Exam Scenarios (2:32)

Module Review (1:25)

Module 7

Automating SQL Server (0:09)

SQL Server Agent (4:03)

Database Mail (4:16)

Operators, Alerts and Jobs (8:18)

Database Configuration Demo Part1 (3:08)

Database Configuration Demo Part2 (7:20)

Database Configuration Demo Part3 (6:20)

Database Configuration Demo Part4 (3:04)

Exam Scenarios (2:42)

Module Review (1:28)

Module 8

Monitoring SQL Server (0:23)

Dynamic Management Views and Functions (1:12)

Profiler Trace (1:13)

Database Tuning Advisor (1:27)

Activity and Performance Monitor (2:30)

Data Collection (3:52)

Monitoring Demo Part1 (3:59)

Monitoring Demo Part2 (6:03)

Monitoring Demo Part3 (4:38)

Monitoring Demo Part4 (4:16)

Monitoring Demo Part5 (4:51)

Monitoring Demo Part6 (3:56)

Monitoring Demo Part7 (2:58)

Exam Scenarios (3:52)

Module Review (1:42)

Module 9

Maintaining SQL Server (0:12)

Checking Database Integrity (4:14)

Indexing Part1 (6:10)

Indexing Part2 (5:28)

Indexing Part3 (1:47)

Ongoing Maintenance (3:41)

Managing and Maintaining Demo Part1 (5:50)

Managing and Maintaining Demo Part2 (7:18)

Managing and Maintaining Demo Part3 (6:09)

Exam Scenarios (1:51)

Module Review (0:57)

Module 10

Troubleshooting SQL Server (0:10)

Service Issues (0:59)

Connectivity Issues (1:08)

Locking Issues (4:53)

Troubleshooting Demo Part1 (3:09)

Troubleshooting Demo Part2 (7:37)

Exam Scenarios (2:32)

Module Review (0:52)

Program Review (1:50)

Frequently Asked Questions

Does this course prepare me to take the Microsoft 70-462 exam?

Yes. This course is designed to teach you exactly what you need to know to pass exam 70-462.

Is there a practice exam included with this course?

This course does not come with a practice exam.

Is the exam fee included in my purchase price?

No. You'll need to purchase access to exam 70-462 separately from this course.

Who is the Instructor for this course?

All of our instructors are highly certified in their field, and have earned this specific certification. We require a minimum of 15 years real world experience in any field our instructors teach.

Do you offer course completion certificates?

Upon successful completion of this course you will be awarded a personalized certificate of completion.

What if I am unhappy with the course?

We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

How long do I have access to the course?

After enrolling, you will have unlimited course access for 12 months.

When does the course start and finish?

This is a completely self-paced online course - you decide when you start and when you finish.

Who is this course for?

Requirements

Career path

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

What does study method mean?

Study method describes the format in which the course will be delivered. At reed.co.uk courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

What are CPD hours/points?

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on reed.co.uk, many of which can be completed online.

What is a ‘regulated qualification’?

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

What is an ‘endorsed’ course?

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body’s logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.