Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Administering Relational Databases on Microsoft Azure (DP-300) Cert Prep: 1 The Azure Data Platform

via LinkedIn Learning

Overview

Learn the skills to help you pass the first two components of the Microsoft DP-300 certification exam.

Syllabus

Introduction
  • Prepare for the DP-300 certification
  • What you should know
1. Azure's Database Offerings
  • An introduction to the Azure data platform
  • Virtual machines for SQL Server
  • Azure SQL Database
  • MySQL
  • MariaDB
  • PostgreSQL
2. Create a SQL Server Virtual Machine
  • SQL Server on Azure VM
  • SQL Server high availability and disaster recovery
  • Deploying a SQL Server VM from the Azure Marketplace
  • Connect to the SQL Server instance
  • Migrating a database to a SQL Server VM
3. The Azure Database Platform as a Service (PaaS)
  • Azure SQL Database PaaS
  • Backups, replication, and failover groups
  • Deploy Azure SQL Database
  • Connect to Azure SQL Database
  • Add a database to an elastic pool
  • What is a SQL Server Managed Instance?
  • Set up SQL Data Sync for Azure
4. Authentication and Authorization
  • Understanding Azure Active Directory
  • Principals and securables
  • Permissions and roles
  • Configure an Azure Active Directory admin
  • Control access with firewall rules
  • Add user accounts to a database
5. Data Security
  • Protect data at rest with Transparent Data Encryption (TDE)
  • Dynamic data masking
  • Encrypt data in transit
  • Configure Transport Layer Security (TLS)
  • Microsoft Defender for SQL
6. Compliance Controls
  • Classifying sensitive data
  • Enabling and viewing data classifications
  • Manage data with Microsoft Purview
  • Create tamper-evident databases with Ledger
Conclusion
  • Next steps

Taught by

Adam Wilbert

Reviews

4.7 rating at LinkedIn Learning based on 370 ratings

Start your review of Administering Relational Databases on Microsoft Azure (DP-300) Cert Prep: 1 The Azure Data Platform

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.