SQL Queries for Starters

Description

SQL is the standard language for asking questions of a database. These 7 PDF lessons teach it from the beginning, starting with what a database is and how SQL fits in.

You write your first SELECT queries, then filter rows with WHERE and sort results with ORDER BY. After that you combine data from several tables using JOINs and summarise it with GROUP BY. The final lesson gathers practical exercises with realistic examples. Exercises appear in most lessons, so you can try each query on paper or in any database tool you already use. Afterwards you should be able to read simple queries and write your own.

Who it is for: beginners with no programming background who want to pull and summarise data from databases.

What’s included
7 PDF lessons · 52 pages · about 14,000 words
One ZIP download that is yours to keep — read on any device, no subscription or app needed.

Course programme

1. Understanding Databases and SQL Basics
2. Writing Your First SELECT Queries
3. Filtering Data with WHERE Clause
4. Sorting Results with ORDER BY
5. Working with Multiple Tables Using JOINs
6. Aggregating Data with GROUP BY
7. Practical SQL Exercises and Real-World Examples