It's Autumn! Prices fall like leaves! - hours only!Up to 80% off on all courses and bundles.-Close

This online course is intended for intermediate users and benefits beginner data analysts, IT students, business developers, and more. The prerequisite is understanding the basics of SQL presented in our SQL Basics course, followed by some practice.

Do you already know the basics of SQL? It’s time to learn some of its advanced features! In this online course, you’ll learn how to use ROLLUP, CUBE, and GROUPING SETS operations.

ROLLUP is an extension of the GROUP BY clause that allows you to attach additional lines which represent subtotals. They are often called super-aggregated rows. They can be presented together with the total sum line. Thanks to the useful ROLLUP extension, you can generate multiple grouping sets using just one SQL query.

Similar to ROLLUP, the CUBE extension allows you to generate subtotals. In addition, CUBE generates subtotals for all combinations of grouping columns specified in the GROUP BY clause.

GROUPING SETS is another step further because it allows for computing multiple GROUP BY clauses in a single SQL statement. GROUP BY GROUPING SETS is equivalent to the UNION of two or more GROUP BY operations in the same result set.

This online course consists of interactive exercises so that you can immediately gain practical experience. We designed it with the thought that it’s best to acquire knowledge through action. You can study at your own pace, and all you need is a computer, an internet connection, and a desire to learn and grow!

So what’s it going to be?

What's in It for Me?

  • 63 interactive exercises. Interact with hands-on exercises for improved retention. Learn at your own pace, from anywhere and at any time.
  • Lifetime access to the course. When you purchase the course, you'll get instant personal access to all of its content.
  • Online 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 the exercises or ask questions and share insights with other members of the Vertabelo Academy 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!

Learn How To:

  • Use ROLLUP with GROUP BY.
  • Display the order of columns with CUBE, and use CUBE with GROUPING() and COALESCE().
  • Use new functions and multiple groupings with UNION ALL.
  • Use multiple groupings with GROUPING SETS.

What Do You Need to Take This Course?

Who Should Take This Course?

  • Anyone who knows basic SQL but wants to go a step further.
  • Analysts who use SQL to create reports.
  • Database administrators.
  • Students taking SQL courses.
  • Programmers looking to improve their SQL skills.
    Start this course

    Table of contents

    Progress: 0% completed 0 of 63 exercises done

    1. ROLLUP

    Learn how to use ROLLUP with GROUP BY.

    More details Less
    Start now

    0% completed 0 of 21 exercises done

    2. CUBE

    Discover CUBE, another GROUP BY extension.

    More details Less
    Start now

    0% completed 0 of 17 exercises done

    3. GROUPING SETS

    Let's take a close look at GROUPING SETS, the last GROUP BY extension in our course.

    More details Less
    Start now

    0% completed 0 of 17 exercises done

    4. Final Quiz

    Verify how much you've learned with us in this course.

    More details Less
    Start now

    0% completed 0 of 8 exercises done

    Reviews

    Average rating

    5/5100.0 (1)

    Details

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

      Comments

      0