## SQL

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

[Start Learning for Free](/content/sql/01-introduction/index.html)

Time to complete: 8h

+73.4K learners

1

## Queries

Write queries that the database understands using a shows table.

### Exercise 1
**Introduction**  
[Start](/content/sql/01-introduction/index.html)

### 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](/content/sql/09-music-playlist/index.html)

### 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](/content/sql/16-create-table/index.html)

### 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](/content/sql/22-joins/index.html)

### 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.