Interactive Course

Reporting in SQL

Learn to apply all the SQL concepts and functions you have learned in previous courses to build out your very own dashboard

  • 4 hours
  • 15 Videos
  • 54 Exercises
  • 4,874 Participants
  • 4,450 XP

Loved by learners at thousands of top companies:

3m-grey.svg
whole-foods-grey.svg
uber-grey.svg
siemens-grey.svg
lego-grey.svg
ea-grey.svg

Course Description

Become a master at building complex reports! In this course, you will apply all the SQL concepts and functions you have learned in previous courses to build out your very own dashboard. By navigating through an Olympics database, you will become an expert data explorer and learn how to understand novel database quickly and effectively. Since data is never perfect, you will gain valuable strategies to deal with real-world issues commonly found with SQL, including how to remove data duplication and how to turn messy data into clean, organized reports. Lastly, you’ll conquer complex calculations using window functions and layered calculations, all within the same report. This is a perfect class 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.

  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.

  2. Cleaning & Validation

    Although it would be nice, data in the real-world is rarely stored in an ideal way. Simply put: data can get messy. In chapter 3, you will learn how to deal with this messy data by fixing data type issues, cleaning messy strings, handling nulls, and removing duplication.

  3. 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.

  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.

  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.

  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.

  3. Cleaning & Validation

    Although it would be nice, data in the real-world is rarely stored in an ideal way. Simply put: data can get messy. In chapter 3, you will learn how to deal with this messy data by fixing data type issues, cleaning messy strings, handling nulls, and removing duplication.

  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.

What do other learners have to say?

Devon

“I've used other sites, but DataCamp's been the one that I've stuck with.”

Devon Edwards Joseph

Lloyd's Banking Group

Louis

“DataCamp is the top resource I recommend for learning data science.”

Louis Maiden

Harvard Business School

Ronbowers

“DataCamp is by far my favorite website to learn from.”

Ronald Bowers

Decision Science Analytics @ USAA

Tyler Pernes
Tyler 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
Icon Icon Icon professional info