DP-900 Azure Data Fundamentals: Azure SQL Querying Techniques


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
Azure SQL is used for extracting and organizing data that is stored in a relational database. In this course, you'll learn how to recognize and apply data querying techniques using SQL, Data Definition Language, and Data Manipulation Language. You’ll start by learning about Structured Query Language including its uses, features, and limitations. You’ll examine how to work with the Data Definition Language and Data Manipulation Language. Next, you'll learn how to query Azure SQL Database using the Azure portal, SSMS, Data Studio, and the sqlcmd utility. Finally, you'll discover how to query relational data in PostgreSQL, MySQL, and MariaDB. This course is one in a series that prepares learners for the Microsoft Azure Data Fundamentals (DP-900) exam.

Expected Duration (hours)
1.1

Lesson Objectives

DP-900 Azure Data Fundamentals: Azure SQL Querying Techniques

  • discover the key concepts covered in this course
  • describe the uses, features, and limitations of Structured Query Language (SQL)
  • use Data Definition Language (DDL) in Microsoft SQL Server Management Studio (SSMS)
  • use Data Manipulation Language (DML) in Microsoft SQL Server Management Studio (SSMS)
  • use the Azure portal to query Azure SQL Database
  • use SQL Server Management Studio (SSMS) to query Azure SQL Database
  • use Data Studio to query Azure SQL Database
  • use the sqlcmd utility to query Azure SQL Database
  • use PostgreSQL to query relational data
  • use MySQL to query relational data
  • use MariaDB to query relational data
  • summarize the key concepts covered in this course
  • Course Number:
    it_clazdataf_06_enus

    Expertise Level
    Intermediate