Learn about GROUP BY Extensions in SQL Server - CUBE, ROLLUP, and GROUPING SETS | Online Course | Vertabelo Academy

Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Great job! Now you know both ROLLUP and CUBE operators.

In just a moment, you'll learn how to use GROUPING SETS!

19/19 Congratulations

1. Introduction

2. Get to know the tables – VaccineAdministration

3. Get to know the tables – WildfireIncident

4. Introduction to CUBE

5. Introduction to CUBE – exercise

6. Order of Columns in CUBE

7. CUBE with GROUPING_ID()

8. CUBE with GROUPING_ID() – exercise

9. CUBE with GROUPING() – exercise

10. Columns outside CUBE

11. Columns outside CUBE – exercise

12. CUBE with multiple pairs of parentheses

13. CUBE with multiple pairs of parentheses – exercise

14. CUBE with COALESCE()

15. CUBE with COALESCE() – exercise

19. Congratulations

Congratulations! You’ve answered all of the questions in this part.

We’ll be looking at GROUPING SETS in the next part. See you there!

Click Next exercise to finish this part.

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings.You can modify your browser settings on your own. For more information see our Privacy Policy.