Azure Data Fundamentals: Azure SQL Querying Techniques

Azure 2020    |    Intermediate
  • 12 videos | 1h 6m 1s
  • Includes Assessment
  • Earns a Badge
Likes 30 Likes 30
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 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

IN THIS COURSE

  • 1m 49s
  • 6m 36s
    Learn how to describe the uses, features, and limitations of SQL. FREE ACCESS
  • Locked
    3.  Using Data Definition Language
    5m 47s
    In this video, you will learn how to use Data Definition Language (DDL) in Microsoft SQL Server Management Studio (SSMS). FREE ACCESS
  • Locked
    4.  Using Data Manipulation Language
    7m 50s
    During this video, you will discover how to use Data Manipulation Language (DML) in Microsoft SQL Server Management Studio (SSMS). FREE ACCESS
  • Locked
    5.  Querying Azure SQL Database Using Azure Portal
    3m 34s
    In this video, you will learn how to use the Azure portal to query Azure SQL Database. FREE ACCESS
  • Locked
    6.  Querying Azure SQL Database Using SSMS
    3m 56s
    Discover how to use SQL Server Management Studio (SSMS) to query data in Azure SQL Database. FREE ACCESS
  • Locked
    7.  Querying Azure SQL Database Using Data Studio
    6m 23s
    In this video, you will use Data Studio to query an Azure SQL Database. FREE ACCESS
  • Locked
    8.  Querying Azure SQL Database Using sqlcmd Utility
    4m 30s
    After completing this video, you will be able to use the sqlcmd utility to query Azure SQL Database. FREE ACCESS
  • Locked
    9.  Querying Relational Data in PostgreSQL
    8m 37s
    In this video, you will learn how to use PostgreSQL to query relational data. FREE ACCESS
  • Locked
    10.  Querying Relational Data in MySQL
    7m 46s
    Upon completion of this video, you will be able to query relational data using MySQL. FREE ACCESS
  • Locked
    11.  Querying Relational Data in MariaDB
    8m 23s
    During this video, you will learn how to query relational data using MariaDB. FREE ACCESS
  • Locked
    12.  Course Summary
    50s
    In this video, we will summarize the key concepts covered in this course. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Azure Data Fundamentals: Relational Data Workloads
Likes 34 Likes 34  
Course Azure Data Fundamentals: Azure Data Ingestion & Processing
Likes 42 Likes 42  
Course Microsoft Azure Fundamentals: Managing Azure Costs

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Microsoft Azure Fundamentals: Databases & Data Analytics
Likes 229 Likes 229  
Course Azure Data Fundamentals: Non-relational Data Services
Likes 22 Likes 22  
Course Azure Data Fundamentals: Relational Data Management
Likes 38 Likes 38