SQL: Asking Your Database the Right Questions
SELECT, WHERE, JOIN, GROUP BY. The four things you will write every working day. Built around a real orders-and-customers database, including the JOIN mistake that silently loses rows and how to spot it.
PHP
5 lessons
Plus plan
From $4/month, unlocks this and the rest of the library
Start free preview
Create free account
Already a member? Sign in
- This course AND every other Plus course
- Playground Pro, private projects, Monaco editor
- Certificates on every course you finish
- Cancel any time. Access runs to the end of the period
- Pay in your currency, card or M-Pesa
- 1 lesson free to preview now
Step 5 of 17 on Back End Developer
Next after this: Database Design: Tables That Age Well
See the path
Course Curriculum
5 lessons · 1 free preview · ~1.4h total
2
WHERE: Asking for Rows
3
JOIN: Pulling Two Tables Together
4
LEFT JOIN: The Rows You Were Silently Losing
5
Project: A Sales Report Worth Reading
Student Reviews
No reviews yet. Be the first after completing!
Course Includes
- 5 structured lessons
- Live coding playground
- Hints when you're stuck
- Automatic code checking
- Completion certificate
- Included with Plus
- Mobile friendly