SQL Tutorial

Learn database queries step by step

Lesson 1: SELECT Basics

Retrieve data from the database using SELECT statements.

Try this query:
SELECT * FROM consoles LIMIT 5;
Challenge

Find all consoles released after 2000

SQL Query Editor

Write and execute your own queries

1
Query Results

Data Visualizations

Explore gaming data through interactive charts

Database Schema

Explore the data structure

consoles

  • id INTEGER PRIMARY KEY
  • name TEXT
  • company_id INTEGER
  • year INTEGER
  • generation INTEGER
  • units_sold REAL (millions)
  • price REAL (USD)

companies

  • id INTEGER PRIMARY KEY
  • name TEXT
  • founded INTEGER
  • country TEXT

games

  • id INTEGER PRIMARY KEY
  • title TEXT
  • console_id INTEGER
  • year INTEGER
  • copies_sold REAL (millions)

Console History

Discover fascinating gaming facts

Run queries to explore the fascinating history of gaming consoles!

Achievements

Unlock badges as you learn SQL

Share Your Favorites

Tell us about your gaming memories

Your Saved Favorites

No favorites saved yet. Share yours above!