Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Azure Data Studio Essential Training

via LinkedIn Learning

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
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

Taught by

Adam Wilbert

Reviews

4.7 rating at LinkedIn Learning based on 133 ratings

Start your review of Azure Data Studio Essential Training

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.