70-462: SQL Server Database Administration (DBA)

Learn some of the skills that Microsoft wants you to know in this course, add another tool to your CV or resume, and even pursue official Microsoft certification. SQL Server is one of the most commonly demanded database technologies in the job market, and being able to do DBA for SQL Server could be quite valuable for your current employment and your next job search. They will download and install SQL Server Developer for free, which provides you with all of the functionality of the full-priced Enterprise edition (though without being able to use it for commercial purposes). Let's begin by downloading a demonstration database and learning how to backup and restore it, as well as what recovery models are applicable for other databases, so that you can provide Point in Time recovery.

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. They will manage logins and server roles, allowing you to regulate who has access to what data, as well as design and maintain indexes to speed up searches and import and export data. They'll look at SQL Server Agent management so you can automate normal operations and be alerted to problems, they'll look at database management and configuration, and they'll look at compression, both of which help with managing large databases. And a lot more.

The course gradually rises in difficulty, so you'll manually backup a database before using SQL Server Agent to automate it. They will only conduct things in this course that require a single computer, rather than numerous servers or virtualization. The course is fairly relaxed - there will be a few "wrong turns" to show you what problems could develop, but each session works towards an end goal at a relatively modest speed, so you can easily follow along on your own computer. They'll assuming you know how to operate a computer, including how to install programs, but the actual DBA will be basic, and they'll present each component as they go.

There is no need for T-SQL experience because they will demonstrate everything they can using the GUI (Graphical User Interface) as well as T-SQL. However, if you intend to take the official Microsoft test, you must have the equivalent understanding as described in my first two courses on 70-461 T-SQL. You can download a certificate of completion at the end of the course to show off your new skills and continue your preparations for official Microsoft certifications. The course was recorded on SQL Server 2017, but it will also work in 2022, 2019, 2016, 2014, and 2012, as well as a portion of 2008R2 and 2008.

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

Udemy rating: 4.5/5.0
Enroll here: udemy.com/course/70-462-sql-server-database-administration-dba/