Description

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

Tags

Syllabus

Syllabus IntroductionPrepare for the DP-300 certificationWhat you should know1. Azure's Database OfferingsAn introduction to the Azure data platformVirtual machines for SQL ServerAzure SQL DatabaseMySQLMariaDBPostgreSQL2. Create a SQL Server Virtual MachineSQL Server on Azure VMSQL Server high availability and disaster recoveryDeploying a SQL Server VM from the Azure MarketplaceConnect to the SQL Server instanceMigrating a database to a SQL Server VM3. The Azure Database Platform as a Service (PaaS)Azure SQL Database PaaSBackups, replication, and failover groupsDeploy Azure SQL DatabaseConnect to Azure SQL DatabaseAdd a database to an elastic poolWhat is a SQL Server Managed Instance?4. Authentication and AuthorizationUnderstanding Azure Active DirectoryPrincipals and securablesPermissions and rolesConfigure an Azure Active Directory adminControl access with firewall rulesAdd user accounts to a database5. Data SecurityProtect data at rest with Transparent Data Encryption (TDE)Dynamic data maskingEncrypt data in transit6. Compliance ControlsClassifying sensitive dataEnabling and viewing data classificationsConclusionNext steps Read more