Advanced Course
Creating Basic SQL Reports in SQL Server
Learn how to build basic SQL reports and make more informed, strategic decisions.
4.72
2,557 learners enrolled
Free trial Yes
Certificate of completion Yes
Time to complete 10 h
Coding challenges 97
Skills you will gain
- Use popular SQL aggregate functions such as COUNT() or SUM() to summarize data in SQL.
- Classify data: how you can create custom classifications of objects in SQL using the CASE WHEN syntax and how you can use classifications to group objects in the GROUP BY clause.
- Calculate averages and averages of averages.
- Organize long queries in a clear way.
- Put multiple metrics in a single report.
- Calculate ratios and percentages.
- Compare global and granular metrics.
- Comparing different business groups in a single report picking one of three methods presented in the course.
- Use common table expressions (CTEs).
Last reviews
Description
This course is ideal for people who know fundamental T-SQL concepts and would like to create meaningful SQL reports in MS SQL Server.
Welcome to our Creating Basic SQL Reports in MS SQL Server course! Over the course of several chapters, we'll teach you how to make practical use of your SQL knowledge. You'll learn the most common types of basic SQL reports and build them step by step.
Imagine that it's 2016—Pokémon Go briefly takes over everyone's social life, and you're running a comic book store. Somewhere between asking visitors to stop playing while inside and worrying about your book sales dropping, you're planning on moving your store online. But how will you know if it's the right thing to do or if it will lead to more revenue? You won't until you crunch the numbers!
Data is collected everywhere—from marketing software counting URL clicks to sales representatives creating customer profiles and Facebook recording its users, your digital footprint is making an impact on the future of shopping all over the world. Thanks to data, we're able to measure our performance and make more informed, strategic decisions. But first, you need to know how to collect and analyze that data.
The Creating Basic SQL Reports in MS SQL Server course is divided into six parts and consists of 97 practical exercises that you can access straight from a web browser and at your own leisure. At the end of each part, there's always a short summary quiz to check how much you remember.
As a warm up, we'll start with a quick introduction to the database model that we'll be working with in the course and review your basic SQL skills.
(Psst! If you don't feel confident with your basic SQL knowledge at this step, you can always brush up on it in our SQL Basics in MS SQL Server course.)
Then, we move on to show you how to use popular SQL aggregate functions such as COUNT() or SUM() to summarize data in SQL, like counting business objects based on selected criteria or calculating total amounts based on multiple objects.
After summarizing data in SQL, we move on to show you how to classify data: how you can create custom classifications of objects in SQL using the CASE WHEN syntax and how you can use classifications to group objects in the GROUP BY clause. This course explains the intricacies of the GROUP BY clause and reviews a few typical mistakes that beginners make.
Next, we'll tackle multi-level aggregation so you know how to calculate averages of averages and how to organize longer queries in a clear way. You'll learn how to put multiple metrics in a single report, calculate ratios and percentages, and compare global and specific metrics.
Finally, 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 best solution based on the result you want to achieve.
Once you finish the course, you'll be able to create a wide range of simple SQL reports, organize long queries, include multiple metrics in a single query, and operate on a database with several tables.
What's in It for Me?
- 97 interactive exercises. Learn at your own pace, from anywhere and anytime. Interact with hands-on exercises for improved retention.
- Lifetime access to the course. When you purchase the course, you’ll get instant personal access to all of its content.
- Certificate of completion. After you successfully finish all of the exercises, you'll get a downloadable PDF certificate to showcase your accomplishment.
- 30-day money-back guarantee. If you're not satisfied with the quality of the course, you can get a refund within 30 days of your purchase.
- Hints for the exercises. You can make use of ready-made hints for all exercises, or ask questions and share insights with other members of our community through the Discuss tab.
What Are the Requirements?
- A web browser and an Internet connection.
- Understanding of fundamental T-SQL concepts which we present in our SQL Basics in MS SQL Server course.
Learn How To:
- Use popular SQL aggregate functions such as COUNT() or SUM() to summarize data in SQL.
- Classify data: how you can create custom classifications of objects in SQL using the CASE WHEN syntax and how you can use classifications to group objects in the GROUP BY clause.
- Calculate averages and averages of averages.
- Organize long queries in a clear way.
- Put multiple metrics in a single report.
- Calculate ratios and percentages.
- Compare global and granular metrics.
- Comparing different business groups in a single report picking one of three methods presented in the course.
- Use common table expressions (CTEs).
Who Should Take This Course?
- Analysts with basic SQL skills who want to create business reports.
- Beginner data science enthusiasts with SQL knowledge.
- Business analysts with basic SQL knowledge who want to generate business metrics in SQL.
- Anyone interested in starting a career in SQL reporting.
Table of contents
Course progress 0%
Exercises completed 0/97
-
Introduction
0/8Get to know the data model and review some basic SQL concepts.
-
Summarizing Data in SQL
0/18Learn how to create simple yet useful business metrics.
-
Classifying Data with CASE WHEN and GROUP BY
0/19Discover how to get metrics based on custom classifications.
-
Multi-level Aggregation
0/19Learn how to construct reports that aggregate data on multiple levels.
-
Multiple Metrics in One Report
0/19Discover how to include multiple metrics in a single report.
-
Comparing Groups in One Report
0/14Find out even more about how you can compare groups in single SQL reports.
Get the Certificate of Competency in SQL
This certificate will confirm your practical SQL problem-solving skills
