SQL

Learn database basics, queries, calculations, and more to start managing and analyzing data like a pro.

Start Learning for Free

Time to complete: 8h

+73.4K learners

1

Queries

Write queries that the database understands using a shows table.

Exercise 1

Introduction
Start

Exercise 2

Select
???

Exercise 3

Streaming Wars
???

Exercise 4

Rotten Tomatoes
???

Exercise 5

Like
???

Exercise 6

Golden Age
???

Exercise 7

ORDER BY
???

Exercise 8

NYC Restaurants
???

Bonus Article
Complete chapter to unlock
???

2

Aggregates

Perform math calculations using aggregate functions.

Exercise 9

Music Playlist
Start

Exercise 10

Counting Rows
???

Exercise 11

Old & New
???

Exercise 12

Total Playtime
???

Exercise 13

Billboard 100
???

Exercise 14

GROUP BY
???

Exercise 15

Video Games
???

3

New Table

Create a new table and add/update/delete data.

Exercise 16

Create Table
Start

Exercise 17

Insert Into
???

Exercise 18

Alter Table
???

Exercise 19

Update Set
???

Exercise 20

Delete From
???

Exercise 21

BFFs
???

Bonus Article
Complete chapter to unlock
???

4

Multiple Tables

Interacting with multiple tables using joins.

Exercise 22

Joins
Start

Exercise 23

Locked In
???

Exercise 24

Inner Join
???

Exercise 25

Left Join
???

Exercise 26

Students & Teachers
???

Exercise 27

Online Shop
???

Want to learn more about SQL?

Ask me anything

Your Name

Level 1

Course Progress

Exercises

0 / 27

XP Earned

0 / 405

Course Badges

0 / 4

Complete a chapter to earn a badge – collect 'em all!

Join the Club

Want to take your learning to the next level?

Get full access to all courses and more for as low as $9.99 / month.

Unlimited exercises and projects

Unlock our complete collection of courses and real-world projects.

Get help from Code Mentors

Have your project code reviewed by human experts in the field.

Earn a Certificate of Completion

Request official certificates for finishing courses.