SQL Essentials
Ask precise questions of your data with SELECT, joins and aggregates.
At a glance
- Length24 minutes
- Lessons4
- Quiz3 questions
- Pass mark3 of 3 correct
- CertificateWhen you pass the quiz
- SubjectSoftware Engineering
- Offered byTech Academy, LearnerMap Academy
- PriceFree for members
What you’ll learn
The course has 4 lessons, from 5 to 7 minutes each, about 24 minutes in all. Lesson content opens once you sign in and start the course.
Querying
- SELECT, WHERE and ORDER BY6 min
- Joining tables7 min
Summarising
- GROUP BY and aggregates6 min
- Parameters, not string building5 min
Narrated lessons
Lesson 2, “Joining tables”, includes a narrated lesson, “Joining Tables, Narrated” (about 2 minutes, 8 scenes): a voice walks you through it with captions, a transcript you can click to jump around, and chapters. How a join stitches related rows back together, and when to reach for a left join.
How the course works
Start the course and it moves into your plan. Lessons open in order, and your progress is saved as you complete each one, so you can stop and come back at any time.
When you have finished the lessons, take the quiz. It has 3 questions, and you pass by answering every one correctly; passing completes the course and adds a certificate to your record. If you don’t pass, review the lessons and try again.
About Tech Academy
Hands-on engineering courses taught by Kestrel engineers.
Short, practical courses on the tools we use every day: version control, databases, containers, front-end and API design, and secure coding. Taught by the engineering team.
More from Tech Academy
Git FundamentalsCommit, branch and merge with confidence, and undo mistakes without panic.
Docker BasicsPackage an app with its dependencies so it runs the same everywhere.
React FoundationsThink in components, state and effects to build interfaces that stay predictable.
API DesignDesign HTTP APIs that are consistent, safe to retry and easy to evolve.
Secure CodingStop the common web vulnerabilities at the source: input, output, access and secrets.
Learning with LearnerMap Academy
LearnerMap Academy runs its learning on LearnerMap, a free platform for organisations. Every course here is free for members of LearnerMap Academy: sign in with the email address LearnerMap Academy knows you by, or with a passkey, and the course opens in your own plan.
Your plan holds at most 3 courses in progress at a time, so you finish what you start before pulling in the next one. Lessons open in order, your progress is saved as you complete each one, and every course ends with a quiz; passing it adds a certificate to your record.
Not a member yet? Ask LearnerMap Academy to invite you. Lesson content, quizzes and everyone’s progress stay private to members; these public pages show only what LearnerMap Academy chose to publish.