5910 Breckenridge Pkwy Suite B, Tampa, FL. 33610
(800) 272-0707

SkillSoft Explore Course

IT Professional Curricula     Internet and Network Technologies Solution Area     Cloud Computing     DP-900: Azure Data Fundamentals
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.

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