Azure DP-900 Course 2

Microsoft Azure SQL

Explore the characteristics of relational data

Define

• tables
• indexes
• views

  Explore relational data workload offerings

  Explore the characteristics of non-relational data

  Define types of non-relational data

  Describe types of non-relational and NoSQL databases

  Learn about data ingestion and processing

  Explore data visualization

  Explore data analytics

  Module 1:  Relational Data Services in Microsoft Azure

• Describe and compare PaaS, IaaS, and SaaS solutions.

• Describe Azure SQL database services including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machine.
• Describe Azure Synapse Analytics and Azure Database for PostgreSQL, Azure Database for MariaDB, and Azure Database for MySQL.

  Module 2:  Explore provisioning, deploying, and querying relational data in Azure

• The provisioning, deploying, and querying of relational data in Microsoft Azure.

• Main methods for deployment including the Azure portal, Azure Resource Manager templates, Azure PowerShell, and the Azure command-line interface (CLI).

• Identify data security components such as firewalls, authentication and explore basic connectivity issues such as accessing from on-premises, access with Azure VNets, access from the Internet, authentication, firewalls.
• Data Definition Language (DDL) versus Data Manipulation Language (DML), and query relational data in Azure SQL Database, Azure Database for PostgreSQL, and Azure Database for MySQL.