The Applied SQL Data Analytics Workshop

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

Requirements and Setup

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

The Applied SQL Data Analytics Workshop is the ideal companion on your journey to extracting information from raw business data. Whether it's importing data, analyzing complex data types, or optimizing your queries, this book equips you with the skills you need to build your knowledge in data analysis with SQL.

What you will learn

• Understand what data analytics is and why it is important
• Experiment with data analytics using basic and advanced queries
• Interpret data through descriptive statistics and aggregate functions
• Export data from external sources using powerful SQL queries
• Work with and manipulate data using SQL joins and constraints
• Speed up your data analysis workflow by automating tasks and optimizing queries

Related Workshops

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

• The Data Analysis Workshop
• The SQL Workshop
• The Applied Aritificial Intelligence Workshop