Skip to main content
HomeSQLReporting in SQL

Reporting in SQL

4.8+
13 reviews
Intermediate

Learn how to build your own SQL reports and dashboards, plus hone your data exploration, cleaning, and validation skills.

Start Course for Free
4 Hours15 Videos54 Exercises
29,122 LearnersTrophyStatement of Accomplishment

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Loved by learners at thousands of companies


Course Description

Master SQL Reporting

Build clear and valuable SQL reports and dashboards, and hone your skills in data cleaning and validation.

In this course, you will apply all the SQL concepts and functions you have learned in previous courses to build your very own dashboard. You will work on an Olympics database to learn about data exploration, data manipulation, data cleaning and validation, and performing complex calculations.

The first chapter aims to get you familiar with the dataset you’ll use, covering some of the essentials you'll need to explore the data properly. Here you will learn how to use ER diagrams and data exploration techniques to get a solid understanding of the data.

Practice Building SQL Reports Using Real Datasets

Next, you’ll learn to build more complex SQL queries to help you explore the data in more detail. The step-by-step approach helps you understand why complex queries require more thought and how they can help you build reports.

Once you get a hang of reporting in SQL, you will learn how to clean and validate SQL data, ensuring our reports are accurate and interpretable.

Develop Your SQL Database Skills

Learn to perform complex calculations using window functions and layered calculations in the final chapter. You will gain hands-on experience building two advanced calculations in particular: the percent of a total calculation and the performance index calculation.

This SQL course is perfect for anyone who will be commonly pulling data from databases and is a great complement for those who use R or Python for data science. This course is part of the SQL for Business Analysts Track and is essential for those who are planning to complete a Data Science or Data Analysis certification with DataCamp.
  1. 1

    Exploring the Olympics Dataset

    Free

    Before you can start building out reports to answer specific questions, you should get familiar with the data. In this chapter, you will learn how to use E:R diagrams and data exploration techniques to get a solid understanding of the data to better answer business-related questions.

    Play Chapter Now
    Case study
    50 xp
    Identifying the base report
    50 xp
    Building the base report
    100 xp
    Athletes vs events by sport
    100 xp
    The Olympics dataset
    50 xp
    Planning queries with an E:R diagram
    50 xp
    Age of oldest athlete by region
    100 xp
    Number of events in each sport
    100 xp
    Exploring our data
    50 xp
    Exploring summer_games
    100 xp
    Validating our query
    100 xp
    Report 1: Most decorated summer athletes
    100 xp
  2. 2

    Creating Reports

    Queries can get large, fast. It's important to take a logical approach when building more complicated queries. In this chapter, you will take a step-by-step approach to plan and build a complex query that requires you to combine tables in multiple ways and create different types of fields.

    Play Chapter Now
  3. 4

    Complex Calculations

    The value of reporting really shows when presenting not-so-obvious insights through complex calculations. In this chapter, you will learn how to build more complicated fields by leveraging window functions and layered calculations. You will gain hands-on experience building two advanced calculations in particular: the percent of a total calculation and the performance index calculation.

    Play Chapter Now

In the following tracks

SQL for Business Analysts

Collaborators

Collaborator's avatar
Mona Khalil
Collaborator's avatar
Sara Billen
Tyler Pernes HeadshotTyler Pernes

Learning & Development Consultant

As a learning & development consultant by day and a freelancer by night, Tyler has two clear passions in life: teaching and data. After receiving a bachelor's in biophysics at Johns Hopkins University, he moved into the world of data and began working in the ad-tech industry, leading two business intelligence teams in the process. He specializes in SQL, data visualization, data modeling, and data analysis.
See More

Don’t just take our word for it

*4.8
from 13 reviews
85%
15%
0%
0%
0%
Sort by
  • Jamil H.
    11 months

    This skill track is superior the career track. They both compliment each other...but the SQL skill track feels fresh and up to date.

  • Paolo G.
    over 1 year

    Out of the several courses I took on SQL this one is surely the best. I appreciated a lot the author's effort to provide comprehensive explanations about the logic of code scripts and to help the trainee to develop critical thinking while coding. Thanks Tyler.

  • Milan P.
    over 1 year

    Very useful!!

  • Jiraporn T.
    over 1 year

    I highly recommend this course for who has a basic knowledge of SQL and who want to acquire more skill about data preparation. All learner can apply example case studies with a real world working.

  • Anita B.
    over 1 year

    Great Hands on experience and concepts clarification

"This skill track is superior the career track. They both compliment each other...but the SQL skill track feels fresh and up to date."

Jamil H.

"Out of the several courses I took on SQL this one is surely the best. I appreciated a lot the author's effort to provide comprehensive explanations about the logic of code scripts and to help the trainee to develop critical thinking while coding. Thanks Tyler."

Paolo G.

"Very useful!!"

Milan P.

FAQs

Join over 13 million learners and start Reporting in SQL today!

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.