Overview
-
Learn how to use Azure Data Studio to connect to a variety of server platforms, execute queries, and work with data.
Syllabus
-
Introduction
- Manage relational databases with Azure Data Studio
- What you should know
- What is Azure Data Studio?
- Install Azure Data Studio on Windows
- Install Azure Data Studio on macOS
- Install Azure Data Studio on Ubuntu Linux
- 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
- 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
- Execute queries with a notebook
- Format text cells with Markdown
- Add code cells to a notebook
- Add images to a text cell
- 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
- 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
- Terminal basics
- Adjust display settings
- Next steps
