Back-To-School Deals - hours only!Up to 80% off on all courses and bundles.-Close
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!

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.
  • Certification. Complete all of the exercises successfully and you'll get a certificate. You can publish the certificate on your LinkedIn profile (here’s how.).
  • 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 exercises, or ask questions and share insights with other members of our community through the Discuss tab. You can also drop us a line at academy@vertabelo.com, and we'll be more than happy to answer! 😉

What Are the Requirements?

  • A web browser and an Internet connection.
  • Understanding of basic SQL concepts which we present in our SQL Basics 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 average values, maximum averages, and minimum averages.
  • Organize long queries in a clear way.
  • Put multiple metrics in a single report.
  • Calculate ratios and percentages.
  • Compare global and granular metrics.
  • Compare 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 meaningful 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.
    Start for free
    Gift this course

    Bundle deals

    87%
    off

    Reg. price
    $1551

    One to Rule 'Em All

    Includes 41 courses Python Basics. Part 1, Python Basics. Part 2, Python Basics. Part 3, Python Data Structures in Practice, Built-in Algorithms in Python, Working with Strings in Python, SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Creating Basic SQL Reports, Window Functions, Revenue Trend Analysis in SQL, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, Introduction to R, Tidyverse, Data Visualization 101, Statistics 101, SQL Basics in MS SQL Server, How to Insert, Update, or Delete Data in MS SQL Server, Common Functions in MS SQL Server, Revenue Trend Analysis in SQL Server, Creating Basic SQL Reports in SQL Server, Window Functions in MS SQL Server, Recursive Queries in MS SQL Server, GROUP BY Extensions in MS SQL Server, How to Read and Write CSV Files in Python, Introduction to Python for Data Science, How to Read and Write JSON Files in Python, Lists and Functions in R, Data Manipulation in R, Creating Basic SQL Reports in PostgreSQL, SQL Basics in PostgreSQL, PostgreSQL JOINs, SQL Practice Set in PostgreSQL, Window Functions in PostgreSQL, Recursive Queries in PostgreSQL, Writing User-Defined Functions in PostgreSQL, PostGIS

    Bundle price $199

    38 hours left at this price!

    Table of contents

    Progress: 0% completed 0 of 97 exercises done

    1. Introduction

    Get to know the data model and review some basic SQL concepts.

    More details Less
    Start now

    0% completed 0 of 8 exercises done

    2. Summarizing Data in SQL

    Learn how to create simple yet useful business metrics.

    More details Less
    Start now

    0% completed 0 of 18 exercises done

    3. Classifying Data with CASE WHEN and GROUP BY

    Discover how to get metrics based on custom classifications.

    More details Less
    Start now

    0% completed 0 of 19 exercises done

    4. Multi-level Aggregation

    Learn how to construct reports that aggregate data on multiple levels.

    More details Less
    Start now

    0% completed 0 of 19 exercises done

    5. Multiple Metrics in One Report

    Discover how to include multiple metrics in a single report.

    More details Less
    Start now

    0% completed 0 of 19 exercises done

    6. Comparing Groups in One Report

    Find out even more about how you can compare groups in single SQL reports.

    More details Less
    Start now

    0% completed 0 of 14 exercises done

    Reviews

    Average rating

    5/5100.0 (2)

    Details

    5 Stars 100%
    4 Stars 0%
    3 Stars 0%
    2 Stars 0%
    1 Stars 0%
      Load more reviews

      Comments

      0