Overview
This course introduces Azure Data Studio, a lightweight, cross-platform tool from Microsoft designed to assist Data Professionals in managing and maintaining their Data Platform fleet. The course covers the origins of Azure Data Studio, its features, and its versatility beyond SQL Server. Through demo-heavy sessions, learners will explore various functionalities such as creating charts, running profiler, using PowerShell, and working with Big Data Clusters. The intended audience for this course includes Data Professionals looking to enhance their skills in data management using Azure Data Studio.
Syllabus
Introduction
SQL Server
Azure Data Studio
When should we use Management Studio
When should we use Azure Data Studio
Session overview
Dashboard
User Snippets
Change Database
Run Profiler
Create Charts
Create a Script
Sanddance
Backup and Restore
Schema Compare
Powershell
Plan Explorer
Trusted Notebook
Docker
Demo
Big Data Cluster
Big Data Cluster Demo
Source Control Demo
Taught by
PASS Data Community Summit