Azure Data Studio Essential Training

Course details

Azure Data Studio is a cross-platform database management front end that allows users to connect to a variety of server platforms, execute queries, and work with data. This course, from database expert Adam Wilbert, covers how to use the program efficiently to manage database servers, write queries, create notebooks, use extensions, and more. Adam goes over the basics of what Azure Data Studio is and how to install it, then dives into the details and options you need to know to manage database server connections. He explains the SQL query editor and the multitude of tasks you can accomplish with it. Adam also shows you ways to organize and document procedures using SQL Notebooks, as well as tools and techniques to extend the capabilities of Azure Data Studio. After going over how to customize your workspace and use the integrated terminal, Adam shares a few resources for keeping up with future development in Azure Data Studio.

Concepts

0. Introduction

01 - Manage relational databases with Azure Data Studio
02 - What you should know

1. Getting Started

03 - What is Azure Data Studio
04 - Install Azure Data Studio on Windows
05 - Install Azure Data Studio on macOS
06 - Install Azure Data Studio on Ubuntu Linux

2. Manage Database Server Connections

07 - Gather server details
08 - Start a database server on Docker
09 - Connect to a SQL Server instance
10 - Connect to PostgreSQL and Oracle servers
11 - Connect to Azure SQL Database in the cloud
12 - Tour the Azure Data Studio interface
13 - Work with editor tab groups
14 - Organize connections with server groups
15 - Backup a database
16 - Restore a backup
17 - Save the workspace

3. The SQL Query Editor

18 - Load and execute SQL scripts
19 - Write SQL queries
20 - Create tables with the visual editor
21 - Edit tabular data
22 - Generate scripts to create and drop tables
23 - Output results to external files
24 - View results as a chart
25 - Quick scripts with code snippets
26 - Create custom snippets

4. Organize and Document Procedures with Notebooks

27 - Execute queries with a notebook
28 - Format text cells with Markdown
29 - Add code cells to a notebook
30 - Add images to a text cell

5. Extend the Capabilities of Azure Data Studio

31 - Add functionality with extensions
32 - View query execution history
33 - Import data from CSV files
34 - Change the interface language
35 - View server performance reports
36 - Monitor user impact on the server

6. Customize the Workspace

37 - Choose a new color theme
38 - Adjust user and workspace settings
39 - Edit keyboard shortcuts
40 - Keyboard control with the command palette
41 - Focus on productivity in Zen mode

7. Use the Integrated Terminal

42 - Terminal basics
43 - Adjust display settings

Conclusion

44 - Next steps