Azure Data Fundamentals: Azure SQL Querying Techniques
Azure 2020
| Intermediate
- 12 Videos | 1h 6m 1s
- Includes Assessment
- Earns a Badge
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.
WHAT YOU WILL LEARN
-
discover the key concepts covered in this coursedescribe 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 Databaseuse SQL Server Management Studio (SSMS) to query Azure SQL Database
-
use Data Studio to query Azure SQL Databaseuse the sqlcmd utility to query Azure SQL Databaseuse PostgreSQL to query relational datause MySQL to query relational datause MariaDB to query relational datasummarize the key concepts covered in this course
IN THIS COURSE
-
1.Course Overview1m 49sUP NEXT
-
2.Structured Query Language6m 36s
-
3.Using Data Definition Language5m 47s
-
4.Using Data Manipulation Language7m 50s
-
5.Querying Azure SQL Database Using Azure Portal3m 34s
-
6.Querying Azure SQL Database Using SSMS3m 56s
-
7.Querying Azure SQL Database Using Data Studio6m 23s
-
8.Querying Azure SQL Database Using sqlcmd Utility4m 30s
-
9.Querying Relational Data in PostgreSQL8m 37s
-
10.Querying Relational Data in MySQL7m 46s
-
11.Querying Relational Data in MariaDB8m 23s
-
12.Course Summary50s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.