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

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

SQL Basics

Ordering
1. The scope of the course part
Eliminating duplicate results
Aggregation
Grouping
HAVING: filtering and ordering groups
Let's practice

Instruction

Welcome to the third part of our SQL Basics course.

In the previous two parts, you've learned how to select data from single and multiple tables. You know how to filter rows and join columns from different tables. Now it's time to move on.

In this part, you'll learn how to compute statistics, group rows, and filter such groups. Such operations are extremely important for preparing reports and always come in handy in big tables.

Are you ready?

Exercise

Click Next exercise to proceed.