70-462: SQL Server Database Administration (DBA)

Beginner-Intermediate practical experience in Database Administration (DBA) SQL Server. Was for Microsoft exam 70-462.

Created by: Phillip Burton • 880000+ students so far
Best Selling Instructor - over 880,000 students so far

Created by: I Do Data Limited
Improve your skills in SQL, Office, Tableau, Power BI + more

What Will I Learn?

• Create Backups and Restore Databases, understanding the different recovery models
• Manage logins and server roles, and import and export data
• Implement and maintain indexes, and manage and configure databases, including compression and concurrency problems
• Manage SQL Server Agent and audit SQL Server instances
• Collect and analyse troubleshooting data
• Plan and install SQL Server and related services, including implementing a migration strategy

Requirements

• You don't need any prior DBA knowledge prior to taking this course.
• It would be helpful if you knew how to create simple T-SQL statements (SELECT, FROM, WHERE, GROUP BY) for some parts of the course, but not essential
• You don't need any form of SQL Server to already be installed on your computer; I will show you have to download it and install it - for free.
• You need to have a Windows computer, or use a Mac computer which can dual-boot into Windows or using Parallel Desktop with Windows. (However, it will not work under Windows ARM - for example, a Mac M1 or M3.)
• Most of the DBA functionality is not available on Azure Data Studio, and therefore you will not be able to do the DBA operations using a Mac.

Target audience

• This course is for you if you want practice experience in SQL Server Database Administration
• No prior experience with T-SQL is required, although the more knowledge you have it, the better.
• In this course we will cover several aspects which used to be tested in Microsoft's 70-462 exam "Administering Microsoft SQL Server"
• Although the exam specifically says "SQL Server 2012/2014", all parts of this course are applicable for the 2016 and 2017 versions, and most in the 2008 and 2008R2 versions.
• This course is not for you if you want advanced training on Database Administration.