SQL Server Database Administrator: Learn SQL DBA Skills

Learn DBA skills for Azure SQL Databases, SQL Managed Instances and SQL Server on Azure Virtual Machines. Exam DP-300

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?

• Plan and implement data platform resources
• Implement a secure environment
• Monitor and optimize operational resources
• Optimize query performance
• Perform automation of tasks
• Plan and implement a High Availability and Disaster Recovery (HADR) environment
• Perform administration by using T-SQL

Requirements

• You will need to already be familiar with the 6 principal clauses of the SELECT statement - SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY
• It will also be good if you have had prior experience with Azure - but this is not essential.
• A lot of this course will use SQL Server Management Studio (SSMS). The latest version requires 64-bit Windows, but you could use SSMS 17.9.1 if you have 32-bit Windows.
• If you have a Mac, then you can use Azure Data Studio for querying, but that doesn't have all of the management capabilities of SSMS.
• For accessing the Azure portal, you will also need an internet browser (Edge or Chrome preferred).
• There is a 30-day refund guarantee of this Udemy course (see Udemy's refund policy).
• Why not have a look at the curriculum below and see what you can learn?

Target audience

• This course is for you if you want to implement or manage the operational aspects of cloud-native and hybrid data platform solutions built on Azure Data Services and SQL Server
• You could be a database administrator or data management specialist that manage on-premises and cloud relational databases built with Microsoft SQL Server and Microsoft Azure Data Services
• By the end of this course, after entering the official Practice Tests, you could enter (and hopefully pass) Microsoft's official DP-300 exam.
• Wouldn't the "Microsoft Certified: Azure Database Administrator Associate" certification look good on your CV or resume?