STAGE 2 OF THE DATA ANALYST PATH
SQL for reporting
Eight hours, thirty-four lessons, six downloads. Joins, groups, and the four query shapes that cover most of what anybody is actually asked for at work. No database administration, because you are not going to be doing any.
19
Included in the subscription
Or 39 to own this course alone
What you will be able to do
Written as tasks, because that is how you will be asked.
Thirty-four lessons
1. Getting a database in front of you
Four lessons, 38 minutes. No installation - the exercises run in the browser, and the download is there if you want it locally.
2. SELECT, WHERE and the first surprise
Six lessons, 1h 04m. Where NULL breaks your filter, demonstrated before it is explained.
3. Joins, drawn rather than described
Seven lessons, 1h 22m. Inner, left, and the one that silently multiplies your rows.
4. Grouping and aggregation
Six lessons, 1h 10m. GROUP BY, HAVING, and why your total is bigger than the sum of its parts.
5. The four query shapes
Five lessons, 58m. Ninety percent of real requests fit one of these.
6. Making it readable
Three lessons, 26m. Formatting, CTEs and naming things for the person who inherits it.
7. The final exercise
Three lessons, open-ended. A real question, a real dataset, and a human marks it.
Who teaches it
INSTRUCTOR
Marcus Bell
Eleven years writing reporting queries for people who did not want to learn SQL, which is the best possible training for teaching it to people who do. He answers every question in the course forum himself and the answers are usually longer than the question.
- 4,180 students on this course
- 4.9 from 1,204 reviews
- Still writes SQL four days a week
What people take next
Live from the catalogue.
The first four lessons are free
No card, no account. If chapter one does not suit you, nothing has been lost.