DP-900 Azure Data Fundamentals: Relational Data Management


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description
Relational data management ensures cloud database systems are versatile and functionable. In this course, you'll explore how to work with relational data on Azure, including basic management tasks for relational data such as SQL database and the security features within. You'll then learn about Azure Data Studio, Azure SQL Server Management Studio, SQL Server, and the sqlcmd utility. Finally, you'll learn about SQL Managed Instance, Azure Synapse Analytics, as well as different connectivity issues such as authentication or firewall. This course is one in a series that prepares learners for the Microsoft Azure Data Fundamentals (DP-900) exam.

Expected Duration (hours)
1.7

Lesson Objectives

DP-900 Azure Data Fundamentals: Relational Data Management

  • discover the key concepts covered in this course
  • use different methods for deploying relational data
  • describe Azure SQL Database uses and features
  • recognize Azure SQL Database security features
  • use Azure AD authentication for security
  • use Azure Data Studio as a query tool
  • use SQL Server Management Studio as a query tool
  • use the sqlcmd utility as a query tool
  • describe SQL Server on Azure Virtual Machine
  • describe Azure Managed Instance features
  • describe Azure Synapse Analytics components and features
  • identify different Azure SQL connectivity errors
  • identify different Azure SQL connectivity issues
  • summarize the key concepts covered in this course

    • Course Number:
    it_clazdataf_04_enus

    Expertise Level
    Intermediate