Azure Data Studio Masterclass

Course Overview

Azure Data Studio revolutionizes how we interact, discover, process, and share data and analytics. It is stand-alone open-source software that works with on-premise databases and databases living in the cloud. You do not need to be on Azure to get the most of Azure Data Studio! This c... See More

How You'll Learn

Faster than videos

Videos are holding you back. The average video tutorial is spoken at 150 words per minute, while you can read at 250. That‘s why our courses are text-based.

Progress you can show

Built in assessments let you test your skills. Completion certificates let you show them off.

Faster than videos

Videos are holding you back. The average video tutorial is spoken at 150 words per minute, while you can read at 250. That‘s why our courses are text-based.

Progress you can show

Built in assessments let you test your skills. Completion certificates let you show them off.

Course Contents

Hide All

Hide All Lessons

1. Introduction

About the Course

2. Open Source, Cross-Platform, Multi-Database

Open Source

Cross-Platform and Multi-Database

3. Everything Starts with a Connection

Getting Started With SQL Server

Azure SQL and PostgreSQL

Grouping and the Central Management Servers Extension

Databases and Servers Quiz

4. SQL Editing Reimagined

IntelliSense and Snippets

Object Definitions

Saving Queries and Snippets

Minimap

SQL Queries via the Command Terminal

Code Snippets Quiz

5. Visualizing and Exporting Your Queries

Loading Sample Data

Running Queries and the Results Pane

SandDance

Queries Quiz

6. Getting Things Done with Notebooks

Jupyter Notebooks

Setting up Our Code Cells

Charting Our Results

Kernel Options

Python Kernel

Notebooks Quiz

7. Reaching Beyond SQL

Setting up a Dataflow

Running Our Dataflow

Running in the Terminal

Using the Simple DataFlow Extension for ADS

PowerShell Quiz

8. Source Control by Design

Cloning a Git Repository

Creating Your Own Repository

Using Git to Manage File Changes

Publishing Your ADS Repository to GitHub

Source Control Quiz

9. Free and Easy Extensions

Getting Started With Extensions

SQL Server Schema Compare

Simple Data Scripter

Extensions Quiz

10. Wrap Up

Conclusion

11. Appendixes

Appendix A

Appendix B