YoVDO

Data Literacy : Essentials of Azure Data Studio

Offered By: Pluralsight

Tags

Microsoft Azure Courses Database Management Courses Data Literacy Courses Cloud Databases Courses Azure Data Studio Courses

Course Description

Overview

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.


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.

Syllabus

  • Course Overview 1min
  • Understanding Azure Data Studio 15mins
  • Querying Data with Azure Data Studio 15mins

Taught by

Viktor Suha

Related Courses

Making Sense of Data in the Media
The University of Sheffield via FutureLearn
Analytics for the Classroom Teacher
Curtin University via edX
Computational Thinking and Design
Friday Institute via MOOC-ED
Problem Solving in the Digital Age: Getting Started with Computational Thinking and Design
Friday Institute via MOOC-ED
What is Data Science?
IBM via Coursera