DP-300: Azure Relational Database Administrator Exam Prep

Explore relational technologies covered by exam, including Azure SQL Database, SQL Server managed instance, SQL Server in a VM, and SQL Edge, with hands-on demos in the portal and SSMS.

Students learn to create an Azure virtual machine, enable RDP, and manually install SQL Server with a specific admin user, then connect using SQL Server Management Studio.

Set a maintenance window for automated SQL Server patching within a VM portal, choosing a Sunday 2 a.m. window to install patches.

Learn to install Azure SQL Database, a cloud native relational service with server and database components, offering region options, and v-core or D2 pricing with endpoints secured by firewall whitelisting.

Create an Azure SQL database using the Microsoft Azure sample database to start with data for testing; configure firewall and explore sample tables like sales and customer.

Explore SQL managed instance, the most compatible SQL server in the cloud. Learn setup essentials: admin login with a 16-character password, virtual network, security, and hourly billing.

Evaluate how patching, security features, and licensing shape choosing between SQL server on a vm, sql managed instance, and azure sql database.

Evaluate the scaling requirements for your solution by comparing scaling up and scaling down, read scale-out, and global scale-out in Azure SQL Database.

Explore high availability options for Azure SQL Database and SQL Managed Instance, including standard and premium tiers, always on availability groups, and zone redundant deployments.

Learn how to scale Azure SQL database by adjusting compute settings and tier, selecting more DTUs and storage in the standard tier, with seamless redeploy and pay-for-what-you-need pricing.

Learn how to vertically scale a sql server in a vm by resizing the virtual machine, adjust disk space for data and logs, and compare with Azure sql database scaling.

Create regional data replicas to improve performance by routing reads to a secondary (read-only) while writes stay on the primary, and explore sharding to distribute data across servers.

Demonstrates using SQL Data Sync to synchronize data between two databases on the same server, configuring a hub database, bidirectional sync, hub-win conflicts, and automatic updates every minute.

Design an upgrade strategy to move from SQL Server to SQL Server 2019 in Azure using the data migration assistant, with backup to blob storage, log shipping, and bulk copy.

Use Data Migration Assistant within an Azure Migrate project to move data from SQL Server to Azure SQL Database, including setting up source and destination and generating a migration report.

Deploy the database migration service in a region, create a server, connect a virtual network, and migrate the Get Cloud Skills Customer table to Azure SQL Database.

Upgrade a SQL database without downtime by using active geo replication to a secondary replica, test on staging, swap to production, and terminate replication if needed.

Create an Azure AD admin user to replace the SQL Server administrator, enabling login via Azure AD authentication and centralizing admin management across databases.

Add an Azure AD user to SQL Server, create a database user, and grant the db data reader role for read-only access; login requires selecting database in the connection string.

Explore dynamic data masking to protect personal identifiable information on reports by anonymizing sensitive fields like email addresses, while granting non-admin read-only access through controlled logins.

Create an Azure Key Vault in the portal to securely store keys and secrets with access policies, then encrypt a column using a vault key via deterministic encryption.

Explore how Azure SQL uses firewall rules and virtual networks to control access, including IP-based firewall entry and service endpoints for private network access.