![](https://ccweb.imgix.net/https%3A%2F%2Fwww.classcentral.com%2Fimages%2Ficon-black-friday.png?auto=format&ixlib=php-4.1.0&s=fe56b83c82babb2f8fce47a2aed2f85d)
SQL PowerShell 2019 - The Lingua Franca for the Data Platform
PASS Data Community Summit via YouTube
Overview
![](https://ccweb.imgix.net/https%3A%2F%2Fwww.classcentral.com%2Fimages%2Ficon-black-friday.png?auto=format&ixlib=php-4.1.0&s=fe56b83c82babb2f8fce47a2aed2f85d)
This course teaches learners how to use PowerShell as a versatile tool to interact with various Microsoft data products such as Azure Data Studio, SQL Server, Azure SQL Database, and Excel. By the end of the course, students will be able to seamlessly move data between these platforms, work with data objects using PowerShell's native language, and document and share PowerShell code using PowerShell Notebooks. The course covers importing data from Excel, utilizing Azure Data Studio, working with SQL Server modules, and integrating with Power BI assets. The intended audience for this course includes data professionals, database administrators, and individuals working with Microsoft data products.
Syllabus
Intro
About me
Agenda
GitHub repo
Azure Data Studio
Get Azure Data Studio
Import SQL Server Module
Import Data from Excel
Get Excel Sheet Info
Import Excel Worksheets
Save Notebooks
Jupyter Books
SQL Server Module
Central Management Servers
Power BI Assets
Taught by
PASS Data Community Summit