Skip to main content

Microsoft 70-462: Administering SQL Server Databases

Intermediate8 Hours 24 Minutes62 Course Videos45 Test Questions

$99.00

Microsoft 70-462: Administering SQL Server Databases is an online course for DBAs and IT staff who install, secure and maintain SQL Server 2012. It runs for 8 hours 24 minutes over 62 videos.

  • Login details sent straight after payment
  • Self-paced. Study on any device
  • StemBoss Certificate of Completion
  • 14-day refund promise

Secure checkout. Pay by card, Apple Pay or Google Pay.

Download the course outline (PDF)

Microsoft 70-462: Administering SQL Server Databases is an online course for database administrators and IT staff who install, secure and maintain SQL Server 2012. It follows the Microsoft 70-462 exam, part of the MCSA: SQL Server certification. The course lasts 8 hours 24 minutes over 62 videos, with 45 test questions.

The 13 lessons follow the daily jobs of a SQL Server DBA. You start with the platform and the install, then set up databases and security. Later lessons cover encryption, indexes, backups, high availability, performance and recovery, so you know what to do when something goes wrong.

What you will learn

  • Describe the SQL Server platform and how it stores data
  • Install SQL Server and change key settings, such as memory and email alerts
  • Create and manage user databases
  • Control access with logins, server roles and permissions
  • Apply encryption and compression to protect and shrink data
  • Work with indexes and log files
  • Plan and run backups and restores
  • Set up high availability, tune performance and recover damaged databases

Course outline

  1. Identifying the SQL Server platform: an overview of SQL Server and data storage
  2. Deploying SQL Server: installing the database engine
  3. Configuring SQL Server: core settings, memory and email
  4. Managing databases in SQL Server 2012: creating and looking after user databases
  5. Managing SQL Server security: logins, server roles and permissions
  6. Implementing advanced security settings: tighter control over data access
  7. Applying encryption and compression: protecting and shrinking stored data
  8. Working with indexes and log files: keeping queries fast and logs healthy
  9. Working with backup and restore: planning and running backups
  10. Implementing high availability: keeping databases online
  11. Optimising server performance: finding and fixing slow spots
  12. Troubleshooting issues and recovering databases: fixing faults and bringing data back
  13. Performing advanced database management tasks: managing the wider database estate

Who this course is for

  • Database administrators who look after SQL Server
  • IT staff who have SQL Server added to their duties
  • Developers who want to understand the admin side
  • Beginner to intermediate SQL Server users
  • Learners preparing for the Microsoft 70-462 exam

Before you start

No formal prerequisites are listed, and the course suits beginner to intermediate users. Basic Windows Server knowledge and some practice writing T-SQL queries will help. Microsoft 70-461: Querying SQL Server is a good partner course.

About the 70-462 exam

Microsoft 70-462 checked your ability to install, configure, secure, back up and maintain SQL Server 2012 and 2014 databases. Microsoft issued it as one of the exams for the MCSA: SQL Server 2012/2014 certification.

Microsoft retired it on 31 January 2021 along with the other MCSA exams, so it can no longer be booked. The admin tasks taught here are still the daily work of a SQL Server DBA.

Jobs this course supports

  • SQL Server Database Administrator
  • Database Engineer
  • Database Analyst
  • Data Engineer
  • IT Consultant
  • Application Support Analyst

Skill level

Intermediate
Duration

8 Hours 24 Minutes
Videos

62 Course Videos
Questions

45 Test Questions
Certification

MCSA: SQL Server 2012/2014 (retired)
Exam code

70-462
Certification body

Microsoft
Prerequisites

None set; basic Windows Server and T-SQL knowledge helps.
Best for

Database administrators, database engineers, data engineers, application support analysts
Topics covered

SQL Server install and setup, database management, security and permissions, encryption and compression, indexes and logs, backup and restore, high availability, performance tuning
Format

Online video lessons, self-paced
Language

English
Closed captions

Yes
Certificate

StemBoss Certificate of Completion

What is inside this course

13 modules and 62 lessons. Here is the full outline.

Module 13 lessons
  1. Overview
  2. DataStorage-Part 1
  3. DataStorage-Part 2
Module 22 lessons
  1. Install-Part 1
  2. Install-Part 2
Module 36 lessons
  1. Configuring-Part 1
  2. Configuring-Part 2
  3. Changing Memory-Part 1
  4. Changing Memory-Part 2
  5. Email-Part 1
  6. Email-Part 2
Module 45 lessons
  1. User Databases-Part 1
  2. User Databases-Part 2
  3. User Databases-Part 3
  4. User Databases-Part 4
  5. User Databases-Part 5
Module 56 lessons
  1. Setting Security-Part 1
  2. Setting Security-Part 2
  3. Server Roles-Part 1
  4. Server Roles-Part 2
  5. Setting Permissions-Part 1
  6. Setting Permissions-Part 2
Module 65 lessons
  1. Querying Data From Multiple Tables-Part 1
  2. Querying Data From Multiple Tables-Part 2
  3. Querying Data From Multiple Tables-Part 3
  4. Querying Data From Multiple Tables-Part 4
  5. Querying Data From Multiple Tables-Part 5
Module 73 lessons
  1. Encrypting And Compressing-Part 1
  2. Encrypting And Compressing-Part 2
  3. Encrypting And Compressing-Part 3
Module 86 lessons
  1. Functions-Part 1
  2. Functions-Part 2
  3. Functions-Part 3
  4. Functions-Part 4
  5. Functions-Part 5
  6. Functions-Part 6
Module 97 lessons
  1. Managing Backups-Part 1
  2. Managing Backups-Part 2
  3. Managing Backups-Part 3
  4. Managing Backups-Part 4
  5. Managing Backups-Part 5
  6. Managing Backups-Part 6
  7. Managing Backups-Part 7
Module 104 lessons
  1. Stored Procedures-Part 1
  2. Stored Procedures-Part 2
  3. Stored Procedures-Part 3
  4. Stored Procedures-Part 4
Module 117 lessons
  1. Managing SQL Performance-Part 1
  2. Managing SQL Performance-Part 2
  3. Managing SQL Performance-Part 3
  4. Managing SQL Performance-Part 4
  5. Managing SQL Performance-Part 5
  6. Managing SQL Performance-Part 6
  7. Managing SQL Performance-Part 7
Module 125 lessons
  1. Set Operators-Part 1
  2. Set Operators-Part 2
  3. Set Operators-Part 3
  4. Set Operators-Part 4
  5. Set Operators-Part 5
Module 133 lessons
  1. Managing Database Infrastructures-Part 1
  2. Managing Database Infrastructures-Part 2
  3. Managing Database Infrastructures-Part 3

Your learning path

Where Microsoft 70-462: Administering SQL Server Databases fits. Build your skills one step at a time.

You are hereMicrosoft 70-462: Administering SQL Server Databases
Next stepMicrosoft 70-465: Designing Database Solutions for Microsoft SQL Server

Frequently asked questions

Can I still take the Microsoft 70-462 exam?

No. Microsoft retired 70-462 on 31 January 2021 with the other MCSA exams. The course is still useful for learning hands-on SQL Server administration.

Which version of SQL Server does the course use?

The course is built around SQL Server 2012. Most of the admin tasks, such as security, backups and indexes, work in a similar way in later versions.

Does the course cover backup and restore?

Yes. A full lesson covers planning and running backups, and another covers fixing faults and recovering damaged databases.

Is this course suitable for beginners?

It suits beginner to intermediate users. It helps to know some T-SQL first, so you may want to take 70-461 before or alongside it.

Does it cover high availability?

Yes. One lesson looks at high availability options to keep databases online when something fails.

Do I get a certificate?

Yes. You get a StemBoss Certificate of Completion when you finish the course.

Can I get a refund?

Yes, within 14 days if you have completed less than 20% of the course. See our refund policy for details. Read the refund policy.

Related courses

$99.00
Buy course