Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings. You can modify your browser settings on your own. For more information see our Privacy Policy.
Interactive Course
Start here if you’re new to SQL. Learn the basics of SQL, retrieve data from an SQL database and build simple reports.
Databases are part of our everyday life, and being able to communicate with them is essential. This course will teach you the basics of SQL, a powerful query language that lets you work with many types of data.
The SQL Basics course starts with simple queries performed on a single table. These exercises will show you how to retrieve exactly what you need. Next, you’ll start working with multiple tables. You will find out about the subtle differences between various joining methods, including INNER JOIN, LEFT JOIN, RIGHT JOIN, and OUTER JOIN.
As you go deeper into the course, you’ll master using the GROUP BY function to create simple reports. You’ll also start investigating subqueries. Finally, you can test your knowledge (and earn your certificate!) in a comprehensive quiz.
Looking to get started in SQL? Give this course a try – the fascinating world of SQL queries is only a click away!
Just a web browser and an Internet connection
Plus, you’ll get to practice your skills on over 129 interactive exercises.
Course progress
Exercises completed
Find out what relational databases are and get to know SQL – a language to talk to databases.
Exercises completed
Introduction
Discover how to select data from a single table.
Exercises completed
See the whole table
Select some columns
Filtering rows
Logic
Text patterns
To be or NULL to be
A little bit of mathematics
Let's practice
Learn how to select data from multiple tables.
Exercises completed
How to query more than one table
Creating JOINs
Referencing columns
Let's practice
Computations in SQL? Why not? You will learn how to group rows and compute statistics with aggregate functions.
Exercises completed
Ordering
Eliminating duplicate results
Aggregation
Grouping
HAVING: filtering and ordering groups
Let's practice
Learn about various kinds of JOINs to best suit your needs.
Exercises completed
Get to know the data
JOIN revisited
LEFT JOIN
RIGHT JOIN
FULL JOIN
OUTER JOINS
NATURAL JOIN
Aliases for tables
Queries within queries? That's right! Discover how to build and use subqueries.
Exercises completed
Introduction
Very simple subqueries
Subqueries with multiple results
Correlated subqueries
Combine query results using set operations like UNION, INTERSECT or MINUS.
Exercises completed
Introduction
INTERSECT
Check your SQL skills.
Exercises completed