0% completed

All LessonsFree Lessons (6)

Introduction

About the Course

Open Source, Cross-Platform, Multi-Database

Open Source Cross-Platform and Multi-Database

Everything Starts with a Connection

Getting Started With SQL Server Azure SQL and PostgreSQL Grouping and the Central Management Servers Extension Databases and Servers Quiz

SQL Editing Reimagined

IntelliSense and Snippets Object Definitions Saving Queries and Snippets Minimap SQL Queries via the Command Terminal Code Snippets Quiz

Visualizing and Exporting Your Queries

Loading Sample Data Running Queries and the Results Pane SandDance Queries Quiz

Getting Things Done with Notebooks

Jupyter Notebooks Setting up Our Code Cells Charting Our Results Kernel Options Python Kernel Notebooks Quiz

Reaching Beyond SQL

Setting up a Dataflow

Running Our Dataflow

Running in the Terminal

Using the Simple DataFlow Extension for ADS

PowerShell Quiz

Source Control by Design

Cloning a Git Repository Creating Your Own Repository Using Git to Manage File Changes Publishing Your ADS Repository to GitHub Source Control Quiz

Free and Easy Extensions

Getting Started With Extensions SQL Server Schema Compare Simple Data Scripter Extensions Quiz

Wrap Up

Appendixes

Appendix A Appendix B

Azure Data Studio Masterclass/

...

/

PowerShell Quiz

PowerShell Quiz

Here’s a short quiz on PowerShell to jog your memory.

We'll cover the following...

Technical Quiz

1.

Which PowerShell cmdlet runs a SQL command?

A.

Get-DbaDbTrigger

B.

Invoke-Sqlcmd

C.

Set-DbaDbState

D.

Enable-DbaStartupProcedure

1 / 3