This is the repository for the LinkedIn Learning course Guided Lab: Build a SQL Data Analysis Workflow with Azure and VS Code. The full course is available from LinkedIn Learning.
In this text article course, data visualization expert Adam Wilbert guides you though the process of setting up a database server, loading data, and executing queries against that data. Begin by deploying a free cloud hosted Azure SQL Database instance, then sets up the local management tools. Explore the process of making a connection to the remote server, creating a structure for their data, and loading in the initial set of records. Plus, learn how to create interactive "notebook" files that contain formatted instructions, text, and images along side interactive SQL code modules that can be used to perform a variety of statistical analyses on their imported data.
This repository includes a folder of Exercise Files that are referenced throughout the course. The Chapter 3 folder includes SQL scripts that will need to be executed on your server. You can either copy the raw text from the GitHub page and paste in VS Code, or download the individual files as needed. The Chapter 4 folder contains completed versions of the notebook files that are developed throughout the chapter and are provided for reference.
- To use these exercise files, you must have the following installed:
- Microsoft Visual Studio Code
- The SQL Server MSSQL extension for VS Code
- The Polyglot Notebook extension for VS Code
- Download individual files as needed, copy the raw text, or clone the full repository into your local machine using the terminal (Mac), CMD (Windows), or a GUI tool like SourceTree.
Adam Wilbert
Database consultant and educator
Check out my other courses on LinkedIn Learning.