/sql-for-data-analysis-3271025

This is a repository for the LinkedIn Learning course SQL for Data Analysis

Primary LanguageJupyter NotebookOtherNOASSERTION

SQL for Data Analysis

This is the repository for the LinkedIn Learning course SQL for Data Analysis. The full course is available from LinkedIn Learning.

SQL for Data Analysis

If you’re looking to get Structured Query Language into your application development, but your story is more prequel than SQL, you need to build a solid foundational knowledge of SQL analysis. In this course, instructor Nikiya Simpson starts with a quick review of SQL basics, then focuses on fundamental SQL queries used in beginning data analysis. Nikiya explains the importance of asking the right questions of your data, as well as how those questions translate into SQL. She also shows how these concepts can be used to derive quick insights from your data to help drive effective decision-making. Nikiya finishes the course by demonstrating how to incorporate queries into tools like Microsoft Power BI to help bring your data to life.

This course is integrated with GitHub Codespaces, an instant cloud developer environment that offers all the functionality of your favorite IDE without the need for any local machine setup. With GitHub Codespaces, you can get hands-on practice from any machine, at any time—all while using a tool that you’ll likely encounter in the workplace. Check out both Codespaces videos to learn how to get started.

See the readme file in the main branch for updated instructions and information.

Instructions

This repository has folders for each of the videos in the course. Each folder corresponds to a chapter and the sample file mentioned in the videos.

Installing

To use these exercise files, you must have the following installed:

  1. In Chapter 5, install suggested extensions for Python and Jupyter when prompted. In Select Kernel (Type to Choose Kernel Source), Choose Python Environments -> Python 3.11.4 (Recommended).
  2. PDF Viewer for viewing ERD.
  3. Install the HTML Preview or Open in Default Browser extensions in VS Code to open html files to view.
  4. Before starting this exercise, Create V_Orders View for Chapter 5 Dashboard by running the "Create View V_Orders.sql" file.

Tips

  1. For Chapter 5, restart the kernel to stop the dashboard from running on port 8050.

Instructor

Nikiya Simpson

Check out my other courses on LinkedIn Learning.