Azure Database Administrator Associate (DP-300) Cert Prep: 1 The Azure Data Platform
2h 12mIntermediate2021-10-06
Authors
Adam Wilbert
Data Visualization Expert
Course details
Passing the Microsoft DP-300 certification exam allows job seekers to demonstrate proficiency with next-gen, cloud-based database technologies, and in this Administering Relational Databases on Microsoft Azure (DP-300) Cert Prep series of courses, Adam Wilbert takes you through the key aspects of the exam that you need to know. This first course focuses on the first two components of the exam: Understanding the full breadth of the Azure offerings, and creating and securing those resources. Even if you don’t plan on taking the exam, studying these aspects is still a great way to gain the knowledge and proficiency needed to modernize your organization's database resources.
Skills covered
SQLDatabase AdministrationDatabase ManagementAzureNetwork AdministrationCloud PlatformsCert PrepNetwork and System AdministrationCloud ComputingOpen SourceMicrosoft
Concepts
0. Introduction
- 01 - Prepare for the DP-300 certification
- 02 - What you should know
1. Azure's Database Offerings
- 03 - An introduction to the Azure data platform
- 04 - Virtual machines for SQL Server
- 05 - Azure SQL Database
- 06 - MySQL
- 07 - MariaDB
- 08 - PostgreSQL
2. Create a SQL Server Virtual Machine
- 09 - SQL Server on Azure VM
- 10 - SQL Server high availability and disaster recovery
- 11 - Deploying a SQL Server VM from the Azure Marketplace
- 12 - Connect to the SQL Server instance
- 13 - Migrating a database to a SQL Server VM
3. The Azure Database Platform as a Service (PaaS)
- 14 - Azure SQL Database PaaS
- 15 - Backups, replication, and failover groups
- 16 - Deploy Azure SQL Database
- 17 - Connect to Azure SQL Database
- 18 - Add a database to an elastic pool
- 19 - What is a SQL Server Managed Instance
4. Authentication and Authorization
- 20 - Understanding Azure Active Directory
- 21 - Principals and securables
- 22 - Permissions and roles
- 23 - Configure an Azure Active Directory admin
- 24 - Control access with firewall rules
- 25 - Add user accounts to a database
5. Data Security
- 26 - Protect data at rest with Transparent Data Encryption (TDE)
- 27 - Dynamic data masking
- 28 - Encrypt data in transit
6. Compliance Controls
- 29 - Classifying sensitive data
- 30 - Enabling and viewing data classifications
Conclusion
- 31 - Next steps