70-462: SQL Server Database Administration (DBA) (Udemy.com)

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

Created by: Phillip Burton

Produced in 2020

icon
What you will 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

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 88 / 100

icon
Course Description

Do you want to gain practical experience in Database Administration in SQL Server? Are you wanting to prepare for the official Microsoft exam 70-462 "Administering Microsoft SQL Server"? Either way, welcome.
In this course, learn some of the skills that Microsoft want you to know, and add another tool to your CV or resume, and even go for the official Microsoft certification.
SQL Server is one of the main database tools that is requested in the job market, and the ability to being able to do DBA for SQL Server could be very useful for your current work, and your next job hunt.
We'll download and install for free SQL Server Developer, which gives you all of the capabilities of the full-cost Enterprise edition (though without being able to use it for commercial purposes). We'll start by downloading a demonstration database, and learning how to backup and restore this database, and what recovery models are appropriate for other databases, to enable you to offer Point in Time recovery.
We'll manage logins and server roles, so you can control who gets access to what data, implement and maintain indexes, so you can speed up searches, and import and export data. We'll look at managing SQL Server Agent, so you can automate routine tasks, and also be alerted to problems, we'll manage and configure databases, and look at compression, both of which aids with administrating big databases. And much more.
The course will take around 10 hours to complete, but completing this will enable you to versed in Database Administration tasks, giving you hands-on experience.
The course increases in difficulty slowly, so you'll manually backup a database, but then later we'll use SQL Server Agent to automate this. In this Part 1 course, we will only do activities that require one computer, instead of multiple servers or virtualization.
The course is fairly relaxed - there will be a few "wrong turns", so you can see what problems might arise, but every lesson works towards an end goal at a relatively slow pace, so you can follow on your own computer easily. I assume that you know how to use a computer, including installing programs, but the actual DBA will be at a basic level, and I'll introduce every component as we go on.
No knowledge of T-SQL is required, as I'll demonstrate everything I can through the GUI (Graphical User Interface) as well as T-SQL. However, if you are going to go for the official Microsoft exam, the equivalent knowledge as per my first two courses in 70-461 T-SQL is essential.
At the end of the course, you can download a certificate of completion, so you can show everyone your new-found skills, and continue your preparations for the official Microsoft certifications.
The course is recorded on SQL Server 2017, but will also work fully in 2016, 2014 and 2012, and mostly in 2008R2 and 2008.Who this course is for:
  • 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 are 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.

*Some courses are excluded from this sale. Coupon not working? If the link above doesn't drop prices, clear the cookies in your browser and then click this link here.
Also, you may need to apply the coupon code directly on the cart page to get the discount.

Coupon Code

icon
Instructor Details

Phillip Burton

Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.
He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.
He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015.
His interests are working with data, including Microsoft Excel, Access and SQL Server.

icon
Reviews

4.4

50 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

It's a good course. Looks simple but all the discussed topics are deep drive into the concept of Why and what, which is very good. It's difficult to just read the book and the material by own. This course helped me to easily navigate through the topics covered in Microsoft SQL server prep book. Although the HA and mirroring are not covered in here, we can understand the concepts by reading the prep material after finishing the course.

Could have covered more! but whatever he taught was good! being a beginner this course helped alot to explore other things as well

Enjoyed the lectures a great deal, solid content, lecturer make the material interesting for those preparing for MSSQL Cert. Exam.

The Instructor is good and have a lot of knowledge but the course misses a lot of material you must know for the exam.

Trainer Voice is too low, which makes student dis-engaged.Examples could have been more generic in nature.I expect Trainer to talk about what kind of questions can come in Certification and how to address them.

I needed to fill in some gaps in my knowledge which I discovered during an Azure course. I went through this course in a relaxed way in about a week and never found myself bored or struggling. I used a VMware workstation player to build a temporary machine, install SQL server and duplicate the demonstrations. I wish I had done this ages ago as it has clarified a lot of things.

Awesome stuff. Took your 70-461 course and learned a lot. Didn't know much about SQL Server Administration and wanted to learn and this is the way to learn it. All of your courses have been great!

Very well-structured course with clear explanations for novices. Would be even better if the Word file contains all of the relevant code for each lecture, sometimes it was missing. Overall, excellent course!

Reasonably informative. Certain features described in the course are not available in SQL Server Express, at least not by default. This should be noted either at the beginning, or when discussing these features.

Great content, very informative and professionally made. My Director of IT recommended this course to me to get me up to speed on SQL due to a promotion I recently received. Thanks for making a great course.

I am an oracle DBA and since we have sql server databases in my environment I decided to take this course such that I can help my sql server dba's when I can. I must tell you this course is great, I have learn a lot and will begin implementing in my environment. The only reason I am giving 4.5 star is because the course doesn't have enough practicals. The trainer is so knowledgeable about the course.

Without having a lot of SQL Server understanding, this course was very helpful and gave me the understanding I needed to be able to get moving with SQL Server and the apps associated with it. Thanks