Interactive Course
Learn how to use ROLLUP, CUBE, and GROUPING SETS—three extremely useful GROUP BY extensions that will help you create sophisticated queries in no time.
Ultimate money saver
With our Forever plan this course will cost you only
$ 4.33
83% OFF
38 hours left
ROLLUP, CUBE, and GROUPING SETS are GROUP BY extensions available in SQL Server, a relational database developed by Microsoft. SQL Server is among the three most widely used databases in the world. The NASDAQ stock exchange alone stores over one petabyte (a million gigabytes) of data in SQL Server. Other prominent companies that use SQL Server include Dell, Yahoo and, obviously, Microsoft!
If you already know SQL but would like to learn some advanced features available in SQL Server, this is the right course for you. Find out how to use ROLLUP, CUBE, and GROUPING SETS to create advanced reports with SQL Server or facilitate ETL processes if you work with data warehouses.
You’ll also benefit from this course if you’re planning to pass the 70-761 Querying Data with Transact SQL Microsoft certification. The exam requires demonstrated knowledge of GROUP BY extensions, so you’re in the right place to acquire and hone this skill.
We believe in learning by doing. Our courses include interactive exercises so you can get hands-on experience immediately. You can also learn comfortably at your own pace—we offer lifetime access to all course content!
Course progress
Exercises completed
Learn how to use ROLLUP with GROUP BY.
Exercises completed
Discover CUBE, another GROUP BY extension.
Exercises completed
Let's take a close look at GROUPING SETS, the last GROUP BY extension in our course.
Exercises completed
Verify how much you've learned with us in this course.
Exercises completed