Azure Data Studio Essential Training

Learn how to use Azure Data Studio to connect to a variety of server platforms, execute queries, and work with data.

Introduction

• Manage relational databases with Azure Data Studio
• What you should know

1. Getting Started

• What is Azure Data Studio?
• Install Azure Data Studio on Windows
• Install Azure Data Studio on macOS
• Install Azure Data Studio on Ubuntu Linux

2. Manage Database Server Connections

• Gather server details
• Start a database server on Docker
• Connect to a SQL Server instance
• Connect to PostgreSQL and Oracle servers
• Connect to Azure SQL Database in the cloud
• Tour the Azure Data Studio interface
• Work with editor tab groups
• Organize connections with server groups
• Backup a database
• Restore a backup
• Save the workspace

3. The SQL Query Editor

• Load and execute SQL scripts
• Write SQL queries
• Create tables with the visual editor
• Edit tabular data
• Generate scripts to create and drop tables
• Output results to external files
• View results as a chart
• Quick scripts with code snippets
• Create custom snippets

4. Organize and Document Procedures with Notebooks

• Execute queries with a notebook
• Format text cells with Markdown
• Add code cells to a notebook
• Add images to a text cell

5. Extend the Capabilities of Azure Data Studio

• Add functionality with extensions
• View query execution history
• Import data from CSV files
• Change the interface language
• View server performance reports
• Monitor user impact on the server

6. Customize the Workspace

• Choose a new color theme
• Adjust user and workspace settings
• Edit keyboard shortcuts
• Keyboard control with the command palette
• Focus on productivity in Zen mode

7. Use the Integrated Terminal

• Terminal basics
• Adjust display settings

Conclusion

• Next steps