IT Professional Curricula     Internet and Network Technologies Solution Area     Cloud Computing     DP-900: Azure Data Fundamentals

---

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.

---

---

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