Explore Azure Data Studio to revolutionize data interaction, discovery, and sharing for SQL developers, data analysts, and more, leveraging on-premise and cloud databases with open-source flexibility.

Hands on Azure Data Studio- Microsoft's Open Platform for Data Engineering and Analytics by James(Jim) Miller _Hands on Azure Data Studio- .jpg

ADS_180521.tar.gz

AzureDataStudio-CH-02-CMS-copy

AzureDataStudio-CH-03-copy

AzureDataStudio-CH-03-SQL-copy

AzureDataStudio-CH-04-BAK-copy

AzureDataStudio-CH-04-DB-copy

AzureDataStudio-CH-04-DB-SandDance-copy

AzureDataStudio-CH-05-copy

AzureDataStudio-CH-05-PWSH-copy

AzureDataStudio-CH-06-copy

AzureDataStudio-CH-07-copy

AzureDataStudio-CH-02-copy

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 course is designed for anyone who is involved in exploring and analyzing data. This includes SQL developers, data analysts, data scientists, and database administrators. It will also be helpful for professionals involved in data integration and data warehousing, as well as for Python and PowerShell developers looking for a data-centric platform for using their language of choice.

Azure Data Studio Masterclass

## Downloads
- You can download Azure Data Studio using this [link](https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio?view=sql-server-ver15).
- You can download SQL Server using this [link](https://www.microsoft.com/en-us/sql-server/sql-server-downloads).

## Grouping connections
This refers to the server grouping lesson [here](https://www.educative.io/courses/azure-data-studio-masterclass/grouping-and-the-central-management-servers-extension#grouping-and-color-coding-your-connections).
- [Creating Connections and Server Groups](https://youtu.be/lJRg4SzmEU8): 
For targeted viewing, the connections grouping starts at minute 03:35, and the color coding begins at 04:45.

## Code snippets in ADS
This refers to the code snippets lesson [here](https://www.educative.io/courses/azure-data-studio-masterclass/intellisense-and-snippets#code-snippets).
- [ADS Snippets](https://youtu.be/WSjKuqbvKjo)

## Jupyter notebooks
This refers to the Jupyter Notebooks lesson [here](https://www.educative.io/courses/azure-data-studio-masterclass/jupyter-notebooks#notebook-building-blocks).
- [Storytelling with Notebooks](https://www.youtube.com/watch?v=IKj66u6Lyd4)

This refers to the Git Repository lesson [here](https://www.educative.io/courses/azure-data-studio-masterclass/cloning-a-git-repository).
- [Notebook Organization](https://www.youtube.com/watch?v=Mv-5O8yGTvQ)

## Extensions
This refers to the Extensions lesson [here](https://www.educative.io/courses/azure-data-studio-masterclass/using-the-simple-dataflow-extension-for-ads).
- [Installing Extensions](https://www.youtube.com/watch?v=5zJe3DgK1AE)






# Downloads
- You can download Azure Data Studio using this [link](https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio?view=sql-server-ver15).
- You can download SQL Server using this [link](https://www.microsoft.com/en-us/sql-server/sql-server-downloads).

# Grouping connections
This refers to the server grouping lesson [here](https://www.educative.io/courses/azure-data-studio-masterclass/grouping-and-the-central-management-servers-extension#grouping-and-color-coding-your-connections).
- [Creating Connections and Server Groups](https://youtu.be/lJRg4SzmEU8): 
For targeted viewing, the connections grouping starts at minute 03:35, and the color coding begins at 04:45.

# Code snippets in ADS
This refers to the code snippets lesson [here](https://www.educative.io/courses/azure-data-studio-masterclass/intellisense-and-snippets#code-snippets).
- [ADS Snippets](https://youtu.be/WSjKuqbvKjo)

# Jupyter notebooks
This refers to the Jupyter Notebooks lesson [here](https://www.educative.io/courses/azure-data-studio-masterclass/jupyter-notebooks#notebook-building-blocks).
- [Storytelling with Notebooks](https://www.youtube.com/watch?v=IKj66u6Lyd4)

This refers to the Git Repository lesson [here](https://www.educative.io/courses/azure-data-studio-masterclass/cloning-a-git-repository).
- [Notebook Organization](https://www.youtube.com/watch?v=Mv-5O8yGTvQ)

# Extensions
This refers to the Extensions lesson [here](https://www.educative.io/courses/azure-data-studio-masterclass/using-the-simple-dataflow-extension-for-ads).
- [Installing Extensions](https://www.youtube.com/watch?v=5zJe3DgK1AE)






Here is some extra information in case you want to learn more.

Introduction

Open Source, Cross-Platform, Multi-Database

Everything Starts with a Connection

SQL Editing Reimagined

Visualizing and Exporting Your Queries

Getting Things Done with Notebooks

Reaching Beyond SQL

Source Control by Design

Free and Easy Extensions

Wrap Up

Appendixes

Appendix B

Downloads

Grouping connections

Code snippets in ADS

Jupyter notebooks

Extensions