Data Literacy : Essentials of Azure Data Studio
Azure Data Studio is a lightweight, open source, cross-platform client tool that enables you to connect to a database and work with the data. This course will teach you how to use Azure Data Studio to get the data you want.
What you'll learn
Getting data and working with data from an ever increasing number of data sources have become paramount for the developer. In this course, Data Literacy: Essentials of Azure Data Studio, you’ll learn how to connect to different databases, both on-premises and in the cloud, then run your SQL queries from a lightweight, cross-platform and open source client tool called Azure Data Studio. First, you’ll explore what Azure Data Studio is, what capabilities it has, what you can use it for, and how it compares to SQL Server Management Studio. Next, you’ll discover how to download and install this tool to start working with your data. Finally, you’ll learn what the differences between Data Manipulation Language and Data Definition Language SQL statements are, how to run your SQL queries, how to manage database connections to SQL Server, Azure SQL Database or PostgreSQL, and what notebooks are. When you’re finished with this course, you’ll have the skills and knowledge of using Azure Data Studio to query and work with your data from different data sources.
Table of contents
- WideWorldImporters Developer Challenges 2m
- Overview 1m
- Defining Azure Data Studio 3m
- Database Connections 1m
- Comparing with SQL Server Management Studio 2m
- Main Components of Azure Data Studio 2m
- Other Components of Azure Data Studio 1m
- Versions and Getting Started 1m
- Demo: Downloading Azure Data Studio and Getting Started 2m
- References 0m
- Summary 1m