Intermediate SQL
INTERMEDIATE
#SQL
Author: Alina Myronets
Course description
This course is for you if you already have a basic knowledge of SQL, but want to learn more advanced things in order to create more powerful queries. In the course, you will get acquainted with grouping of data, filtering of grouped data. Also learn to work with several tables from the database at the same time, combining them. Learn about different types of table joins, learn how to use them in practice.
Complete all chapters to get certificate
0%
Grouping
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
In this section, you will learn what nested subqueries are, how to create them, and how to work with them.
Nested Queries
Joining Tables
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
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