Ratings & reviews

4.7226 ratings

Mandy S.

14 days ago

This course was fantastic. You can go at own pace and get assistance if you get stuck.

Suzi G.

16 days ago

THE TASK WAS EASY

Stacy B.

18 days ago

It was a good practice aspect somewhat, with mediocre explanations but I think you shouldn't have fill-in the blank for the code writing. We need to be given the view of the table... Show more

77%
15%
8%
0%
0%
info

Complete all chapters to get certificate

0%

Grouping

chevron

In this section, you will learn how to group and work with such data. For this, we will get acquainted with such an operator as GROUP BY. You will also learn how to filter grouped data using the operator HAVING.

GROUP BY

Challenge: Number of Stations

Challenge: Total Ride Time for Each Subway Line

Challenge: Average Ride Time for Each Subway Line

Challenge: The Shortest Ride of Each Subway Line

HAVING

Challenge

More Complex Filtering

Nested Subqueries

chevron

In this section, you will learn what nested subqueries are, how to create them, and how to work with them.

Nested Queries

Joining Tables

chevron

In this section, you will learn how you can combine several tables, thus working with one common table, which will simplify the creation of queries.

JOIN 2 Tables

Challenge: All Flights Information

Challenge: Information about Passenger Flight Departure

Challenge: Find the Number of Passenger

JOIN 3 Tables

Challenge 1

Challenge 2

UNION clause

Left, Right, and Inner Joins

chevron

In this section, you will learn how to combine several tables in different ways, in particular: INNER JOIN, LEFT JOIN, RIGHT JOIN.

INNER JOIN

Challenge

LEFT JOIN

RIGHT JOIN