Search This Blog

Tuesday, March 12, 2024

PL_Azure Data Studio_BI Tracks

 Table of Contents

1 Overview

2 Lessons

2.1 #Top 5 Time-Saving Extensions in Azure Data Studio

2.1.1 SQL Server Schema Compare

2.1.2 Simple Data Scripter

2.1.3 Simple DataFlow

2.1.4 Query History

2.1.5 Sandance for Azure Data Studio

2.2 # The Basics - Notebooks in Azure Data Studio Webinar

2.3 Features Review - Azure Data Studio

2.3.1 Snippet

2.3.1.1 Use existing Snippets

2.3.1.2 Create our own Snippets

2.4 Notebook Capabilities - Azure Data Studio

2.5 Sharing Notebooks - Azure Data Studio Webinar

2.6 Build & Run Azure Data Studio Native ELT Packages

2.7 Getting Started with GitHub - Azure Data Studio

2.8 How to Install Extensions - Hands On Azure Data Studio Book

2.9 How to Make SandDance Visualizations - Azure Data Studio Tutorial

2.10 Why I Love Notebooks - Azure Data Studio Tutorial

2.11 Storytelling with Notebooks - Hands On Azure Data Studio Book Video

2.12 Notebook Organization - Azure Data Studio

2.13 Revolutionize Your Data Integration Practices with Azure Data Studio - Webinar

2.14 How to Integrate Your Applications - Azure Data Studio Tutorial

2.15 How to Create Connections - Azure Data Studio Tutorial

2.16 Database Connections - Azure Data Studio

2.17 How to Use Integrated Terminal - Azure Data Studio Tutorial

2.18 SQL Snippets - Hands On Azure Data Studio Book Video

2.19 How to Use Python Snippets - Azure Data Studio Tutorial

2.20 How to Create Custom Snippets - Azure Data Studio Tutorial

2.21 Extension for SQL Query Repository - Azure Data Studio

2.22 Workspaces, Files, Folders | VS Code | GitHub Noteboks - Azure Data Studio Webinar

2.23 ELT or ETL Data Integration in Azure Data Studio Notebooks



  1. Overview

https://www.youtube.com/watch?v=MBlbLQKiD6g&list=PLO3tt7mPBC9zERFsZEQEZJHsczSqObXaa


  1. Lessons

    1. #Top 5 Time-Saving Extensions in Azure Data Studio 

https://www.youtube.com/watch?v=MBlbLQKiD6g&list=PLO3tt7mPBC9zERFsZEQEZJHsczSqObXaa

  • Data Studio > View > Extensions

  1. SQL Server Schema Compare

  • Compare .dacpac files and databases

  • Apply changes from source to target

  • Useful when we migrating or deploying databases 

  • Press F1 to Use Command Pallete to find any functionality


  1. Simple Data Scripter

  • Migrating data from tables by generating insert scripts

  1. Simple DataFlow

  • Copy a table from one server to another server easily


  1. Query History

  • View > Terminal – we can see Query History Tab also


  1. Sandance for Azure Data Studio

  • Generates quick visualizations of your data

  1. # The Basics - Notebooks in Azure Data Studio Webinar

https://www.youtube.com/watch?v=ngpyluniD6U&list=PLO3tt7mPBC9zERFsZEQEZJHsczSqObXaa&index=2

  • Open Azure Data Studio – Connect Database – then execute any query – now we can see “New Note Book” button – click then choose the Kernal


A screenshot of a computer Description automatically generated

  • Kernal Options

    • SQL

    • Python

    • Powershell

    • PySpark, Spark, Scala, R etc

A screenshot of a computer Description automatically generated

  • Note book is a json file – any JSON editer can use to open the Notebook

    • Cmd window > Tree . /f

  • https://jupyterbook.org/intro.html

  • https://github.com/Jim-BITracks/Webinar-02



  1. Features Review - Azure Data Studio 

https://www.youtube.com/watch?v=6xE3YYjmU-Y&list=PLO3tt7mPBC9zERFsZEQEZJHsczSqObXaa&index=3

  1. Snippet 

    1. Use existing Snippets

  • Open any database –  then type sql – it will shows a lot of available snippets – we can  choose to get templates

  1. Create our own Snippets

  • View – Command Palattes > type snippet 


  1. Notebook Capabilities - Azure Data Studio

  2. Sharing Notebooks - Azure Data Studio Webinar

  3. Build & Run Azure Data Studio Native ELT Packages

  4. Getting Started with GitHub - Azure Data Studio

  5. How to Install Extensions - Hands On Azure Data Studio Book

  6. How to Make SandDance Visualizations - Azure Data Studio Tutorial

  7. Why I Love Notebooks - Azure Data Studio Tutorial

  8. Storytelling with Notebooks - Hands On Azure Data Studio Book Video

  9. Notebook Organization - Azure Data Studio

  10. Revolutionize Your Data Integration Practices with Azure Data Studio - Webinar

  11. How to Integrate Your Applications - Azure Data Studio Tutorial

  12. How to Create Connections - Azure Data Studio Tutorial

  13. Database Connections - Azure Data Studio

  14. How to Use Integrated Terminal - Azure Data Studio Tutorial

  15. SQL Snippets - Hands On Azure Data Studio Book Video

  16. How to Use Python Snippets - Azure Data Studio Tutorial

  17. How to Create Custom Snippets - Azure Data Studio Tutorial

  18. Extension for SQL Query Repository - Azure Data Studio

  19. Workspaces, Files, Folders | VS Code | GitHub Noteboks - Azure Data Studio Webinar

  20. ELT or ETL Data Integration in Azure Data Studio Notebooks
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)