Azure Data Studio Essential Training
Offered By: LinkedIn Learning
Course Description
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
Taught by
Adam Wilbert
Related Courses
Excel 2010Miríadax Intro to Data Science
Udacity Data Manipulation at Scale: Systems and Algorithms
University of Washington via Coursera Statistical Computing with R - a gentle introduction
University College London via Independent Introducción a Data Science: Programación Estadística con R
Universidad Nacional Autónoma de México via Coursera