OFF
IT & SoftwareDatabase Management Systems (DBMS)
70-462: SQL Server Database Administration (DBA)
★4.6
(33,848 students)10h
>_ What You'll 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.
/ Course Details & Curriculum
Please note: Microsoft has withdrawn the 70-462 exam. However, the information in this course is still relevant to DBA.
Do you want to gain practical experience in Database Administration in SQL Server? 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.
Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.
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 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 2022, 2019, 2016, 2014 and 2012, and mostly in 2008R2 and 2008.
Author and Instructor
P
Phillip Burton, I Do Data Limited
Expert at Udemy
With years of hands-on experience in IT & Software, Phillip Burton, I Do Data Limited has dedicated thousands of hours to teaching and mentorship. This course is the culmination of industry best practices and a proven curriculum that has helped thousands of students transition into professional roles.
Community Feedback
★★★★★
M
Michael Chen
Verified Enrollment
"This 70-462: SQL Server Database Administration (DBA) course was exactly what I needed. The instructor explains complex IT & Software concepts clearly. Highly recommended!"
S
Sarah Johnson
Verified Enrollment
"I've taken many Udemy courses on IT & Software, but this one stands out. The practical examples helped me land a job."
D
David Smith
Verified Enrollment
"Great value for money. The section on Database Management Systems (DBMS) was particularly helpful."
E
Emily Davis
Verified Enrollment
"Excellent structure and pacing. I went from zero to hero in IT & Software thanks to this course. Lifetime access is a huge plus."
Common Questions
Is the "70-462: SQL Server Database Administration (DBA)" course truly discounted?
Yes. By utilizing our verified 95% coupon, you can enroll in "70-462: SQL Server Database Administration (DBA)" at a massive discount. This grants you lifetime access to all course materials and updates.
Do I qualify for a certificate upon completion?
Yes. When you enroll with a 95% coupon provided by CoursesWyn, you follow the same path as a paid student and are eligible for the official completion certificate from Udemy.
What happens if the coupon code expires?
Udemy coupons have strict enrollment limits and time windows. If this code expires, we recommend bookmarking this page and checking back daily, as we refresh our deals constantly to find the latest active discounts.
$199.99Save 95%
$10.99
Verified Discount Code
✨Lifetime Access
🏆Official Certificate
📱Access on Mobile/TV
🔄Latest Updated Course
Claim Your Discount Code
XXXXXXXX
CLICK TO SHOW
REVEAL & COPY
$199.99
$10.9995%