Data Literacy : Essentials of Azure Data Studio

Focused View

Viktor Suha

33:18

112 View

1. Course Overview

1. Course Overview.mp4

01:38

02. Understanding Azure Data Studio

01. WideWorldImporters Developer Challenges.mp4

01:40

02. Overview.mp4

00:37

03. Defining Azure Data Studio.mp4

02:34

04. Database Connections.mp4

01:00

05. Comparing with SQL Server Management Studio.mp4

02:10

06. Main Components of Azure Data Studio.mp4

02:08

07. Other Components of Azure Data Studio.mp4

01:12

08. Versions and Getting Started.mp4

00:44

09. Demo - Downloading Azure Data Studio and Getting Started.mp4

01:57

10. References.mp4

00:28

11. Summary.mp4

01:21

3. Querying Data with Azure Data Studio

1. The SQL and T-SQL Languages.mp4

01:39

2. DML and DDL Statements.mp4

05:14

3. Demo - Running SQL Queries in Azure Data Studio.mp4

02:40

4. Demo - Managing Database Connections and Server Groups in Azure Data Studio.mp4

01:50

5. Demo - Working with SQL Notebooks and Extensions in Azure Data Studio.mp4

02:46

6. References.mp4

00:30

7. Module and Course Summary.mp4

01:10

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Microsoft Azure

Viktor Suha

Instructor's Courses

Viktor has been working with the Microsoft data platform, including the core SQL Server database engine, Reporting Services, and Integration Services for many years now. He has worked at Microsoft Premier Support for 10 years, supporting these technologies for large enterprise customers. He also gained some SharePoint infrastructure experience. Since his Microsoft years, he has been working both as a SQL Server database developer and a DBA, thus having experience in both worlds mainly in large enterprise environments. Viktor owns several MCP certifications, MCSA certification for SQL Server and he recently completed the Microsoft Professional Program for Data Science with a certificate to gain insights into machine learning and data science in general. He is keen to learn new technologies continuously and believes in ongoing personal development. His main professional interests are database technologies and trends including NoSQL platforms, but also BI solutions, MS Power BI, and MS Azure.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.