/The-Applied-SQL-Data-Analytics-Workshop

A Quick, Interactive Approach to Learning Analytics with SQL

Primary LanguageJupyter NotebookMIT LicenseMIT

The Applied SQL Data Analytics Workshop

GitHub issues GitHub forks GitHub stars PRs Welcome versions

This is the repository for The Applied SQL Data Analytics Workshop, published by Packt, published by Packt. It contains all the supporting project files necessary to work through the course from start to finish.

Requirements and Setup

The Applied SQL Data Analytics Workshop

To get started with the project files, you'll need to:

  1. Install PostgreSQL 12 on Windows, Mac, Linux
  2. Install Anaconda on Windows, Mac, Linux

About The Applied SQL Data Analytics Workshop

You already know that you want to learn data analysis with SQL, and a smarter way to learn is to learn by doing. The Applied SQL Data Analytics Workshop focuses on building up your practical skills so that you can navigate and compose custom reports like an expert data analyst. You'll learn from real examples that lead to real results. 

What you will learn

  • Experiment with data analytics using basic and advanced queries
  • Learn data interpretation through descriptive statistics and aggregate functions
  • Export data from outside sources using powerful SQL queries
  • Discover how to work with and manipulate data using SQL joins and constraints
  • Speed up your data analysis workflow by automating tasks and optimizing queries
  • Discover different advanced analytics techniques, including geospatial and text analysis

Related Workshops

If you've found this repository useful, you might want to check out some of our other workshop titles: