Gain competitive skills in SQL by learning how to create SQL reports in the PostgreSQL database! This online course consists of 97 interactive exercises; after you complete them all, you'll be able to track and analyze the performance of your metrics. The skills you acquire here can be applied to any industry.
This online course will be of interest to analysts, junior programmers, software developers, and more. It is perfect for people who have basic knowledge of writing SQL queries in PostgreSQL and would like to analyze their work using meaningful reports. Scroll down for details!
Nowadays, data is collected everywhere and on everything. Knowing how to understand and interpret data you've collected lets you make more informed decisions in business (but not limited to business). In this online course, you'll learn how to make use of your SQL toolkit to build insightful SQL reports from scratch. Furthermore, because of that, you will be able to control the key indicators and metrics of your data. These skills benefit anyone who wants to be successful in data analysis, from sales to accounting to dog walking to personal finance.
Imagine you're working in the sales department of a large e-commerce company, and you recently reported a significant sales drop. To better understand what happened, you have decided to find out more about your customers' journeys and what step they decide to leave your website. How can you accomplish this task? How would you spot any trends? Certainly, you could ask the IT department to verify this information, but they are usually very busy and creating such a report could take them days. However, with the knowledge provided in our online course, you can create SQL reports by yourself on the fly!
In this online course, you will learn how to build SQL reports from scratch using PostgreSQL GROUP BY and aggregate functions. You will gain the knowledge to manage long queries, include multiple metrics in one SQL query, and operate on the PostgreSQL database using several tables.
As a warmup, you'll refresh your skills by writing basic queries with a short quiz we have prepared. You will also get to know the database model we'll be working on through the course. Next, you'll use popular aggregate PostgreSQL functions to count business objects based on your criteria or calculate total amounts based on many objects.
Each online course part ends with a summary quiz which you can use to track how much you've learned so far and what you still need to focus on.
The next step for successful data analysis is data classification with CASE WHEN and GROUP BY. In this online course, you will learn what the most common beginner mistakes are and how to avoid them.
At the end of each part, you'll be challenged with a short summary quiz.Last but not least, you'll teach yourself how to compare different business groups in just one SQL report. You'll find out how to do it in three ways and learn why it's good to know them all.
Click "Start for free" to learn more!
Get to know the data model and review some basic SQL concepts.
Learn how to create simple yet useful business metrics.
Providing detailed information and counting objects
Calculating metrics for multiple business objects
Understanding the difference between various count metrics
Discover how to get metrics based on custom classifications.
Custom classifications of business objects
Custom counting of business objects
Learn how to construct reports that aggregate data on multiple levels.
Basic multi-level aggregation
Multi-level aggregation in groups
Multi-level aggregation with custom classification
Three or more aggregation levels
Discover how to include multiple metrics in a single report.
Multiple metrics for a single object
Ratios and percentages
Global vs. specific metrics
Find out even more about how you can compare groups in single SQL reports.