Query a Database with SQL

TechBeginnerHome

90 minutes

5 steps

·Beginner

After 90 min: Ability to extract, filter, and analyze data from a real database

What you need

LaptopSQLite or MySQLDatabase tool like DBeaver

The 90-Minute Plan

Understand Tables & Rows0–15 min

Learn that databases store data in tables with columns and rows. Explore a sample database.

Write SELECT Queries15–35 min

Use SELECT * FROM table_name to retrieve all data. Filter with WHERE clauses.

Join Tables35–55 min

Connect two tables using INNER JOIN to find related data.

Aggregate & Group55–75 min

Use COUNT, SUM, AVG with GROUP BY to analyze patterns in your data.

Ship & next steps75–90 min

Write 5 complex queries and save them. Next: learn INSERT, UPDATE, DELETE.

Pro Tip

Write queries step by step. Start simple and add complexity. Use comments to document your logic.

90 min·5 steps

TechIntermediate

After 90 min: A properly structured database for a real application or business problem

6,912

see the plan

90 min·5 steps

TechAdvanced

After 90 min: Dramatically faster query execution and reduced database load

8,765

see the plan

90 min·5 steps

TechBeginner

After 90 min: A working Python program that solves a real problem

8,743

see the plan

90 min·5 steps

TechBeginner

After 90 min: A live webpage about your interests visible in a browser

11,205

see the plan