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

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!

What's in It for Me?

  • 68 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.
  • Certificate of completion. After you successfully finish all of the exercises, you’ll get a downloadable PDF certificate to showcase your accomplishment.
  • 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 ask questions and share insights with other members of our community through the Disqus tab.

Who Should Take This Course?

  • Anyone who knows basic SQL but wants to go one step further.
  • Analysts who use SQL Server to create reports.
  • SQL Server database administrators and system engineers.
  • Students taking SQL Server courses.
  • Professionals engaged in ETL processes.
  • Anyone who wants to pass the 70-761 Querying Data with Transact SQL certification.
  • Programmers looking to improve their SQL skills.
    Start for free
    Gift this course

    Bundle deals

    86%
    off

    Reg. price
    $1512

    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, Introduction to Python for Data Science, How to Read and Write CSV Files in Python, How to Read and Write JSON Files in Python, Lists and Functions in R, Data Manipulation in R, 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, How to Read and Write Excel Files in Python

    Bundle price $199

    40 hours left at this price!

    60%
    off

    Reg. price
    $240

    MS SQL Server Kit

    Includes 6 courses SQL Basics in MS SQL Server, How to Insert, Update, or Delete Data in MS SQL Server, Common Functions in MS SQL Server, Window Functions in MS SQL Server, Recursive Queries in MS SQL Server, GROUP BY Extensions in MS SQL Server

    Bundle price $95

    40 hours left at this price!

    Table of contents

    Progress: 0% completed 0 of 68 exercises done

    1. ROLLUP

    Learn how to use ROLLUP with GROUP BY.

    More details Less
    Start now

    0% completed 0 of 23 exercises done

    2. CUBE

    Discover CUBE, another GROUP BY extension.

    More details Less
    Start now

    0% completed 0 of 19 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 18 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 (3)

    Details

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

      Comments

      0