Economics / Business EconomicsFinance

Guided Lab: Build a SQL Data Analysis Workflow with Azure and VS Code

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.

Learn More