Teach yourself how to build basic SQL reports to track and analyze the performance of your metrics.
This online course will be of interest to junior programmers and software developers.
This course is perfect for people who know SQL basics and would like to analyze their work using meaningful SQL reports. This knowledge can be used with database engines: PostgreSQL, MySQL (8.0 and higher), Oracle, SQL Server, SQLite.
Welcome to our Creating Basic SQL Reports course! In this course, we'll teach you how to make use of your knowledge to build basic SQL reports. Thanks to this learning, you'll nail tracking and analyzing key metrics of your company. Whether you're a marketer, accountant or working in sales, this course helps you become more productive. Not convinced?
Imagine you're working at a digital marketing agency. Your client wants to know more about their target audience so you've conducted a survey, which was sent out to 15,000 users. Congrats! The survey went very well, and over 85% of users responded! Real fun was about to start, but you realized the data was collected in a company database. Sure, you could ask your IT department for help but they're super busy at this point. How will you know how the users responded? How can you count objects based on your criteria or find trends? Thanks to data, we're able to measure company activities and make more informed decisions. But you need to know how to analyze that data to make it meaningful.
Once you complete the Creating Basic SQL Reports course, you'll be able to do all of the above: you'll create simple SQL reports, organize long queries, include multiple metrics in a single query, and operate on a database with several tables.
As a warm up, we'll review your basic SQL skills and introduce you to the database model we designed for the course.
Then, we move on to show you how to use popular SQL aggregate functions like COUNT() or SUM() to summarize data in SQL. You'll count business objects based on your criteria and calculate total amounts based on multiple objects like a real SQL data analyst!
At the end of each part, you'll be challenged with a short summary quiz.
Next, we move on to present how you can classify your data using the CASE WHEN as well as the GROUP BY clause. While explaining the intricacies of the GROUP BY clause, we'll together review a few typical mistakes that beginners make.
In the last part, we'll talk about comparing different business groups in a single report, and we'll show you three methods of doing this so you can always pick the one that best matches your needs.
Each of the sections comes with extensive practice material, which means you'll write lots of SQL code on your own.
Click the "Start for free" button 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.