SQL Joins
Combine data from several tables with inner, left and self joins.
What you'll learn
- Explain primary and foreign keys
- Write inner and left joins
- Join three or more tables
- Use self joins and subqueries
About this course
You practice joins on a sample school database with students, courses and enrollments. Each lesson adds a join type, and the exercises build toward multi-table reports.
Course curriculum
4 modules and 12 lessons over 3 weeks. Plan for about 9 learning hours.
01Keys and relationsWeek 1 · 3 lessons
- Primary keys
- Foreign keys
- One-to-many and many-to-many
02Join typesWeek 1 · 3 lessons
- INNER JOIN
- LEFT JOIN
- Finding missing rows
03Complex joinsWeek 2 · 3 lessons
- Joining many tables
- Self joins
- Subqueries versus joins
04ReportsWeek 3 · 3 lessons
- Enrollment report
- Course popularity report
- Checking results
Project
Multi-table reports. Five reports over a school database that each join three or more tables.
Who this course is for
Learners who can write basic SELECT queries and want to work with related tables.
Prerequisites
You write SELECT, WHERE and GROUP BY queries.
What's included
- 120-day course access
- Step-by-step lessons
- Practice files
- Reusable code templates
- A graded final exercise
- A digital completion certificate
Learning format
Self-paced practical course, part of our self-paced courses. Graded final exercise with written feedback.
Access and delivery
- Enrollment is activated within 15 minutes after payment.
- Final exercise feedback is delivered within 2 business days of submission, and the completion certificate is issued within 2 business days after passing the final exercise.
Certificate
You receive a digital completion certificate. Final exercise feedback is delivered within 2 business days of submission, and the completion certificate is issued within 2 business days after passing the final exercise.
Frequently asked questions
When does access start?
Enrollment is activated within 15 minutes after payment.
Is payment taken on this website?
No. After you submit your enrollment request, we reply by email with payment details and enrollment confirmation.
Does this course guarantee a job or income?
No. It is an education and training service and does not include employment, income or placement guarantees.
Can I cancel?
Our Refund and Cancellation Policy lists the terms for self-paced course programs.
