Skip to content
learn@aiera

Databases · intermediate

SQL Intermediate: Joins, Subqueries and Design

Combine tables with joins, nest queries, use functions and CASE, and design tables with keys and constraints.

5 lessonsAbout 65 minFree
Start course

Not started

Finish every lesson, then sign in and pass the final assessment to earn a free certificate

Module 1: Combining tables

  1. Joining Tables with INNER JOIN13 min · Up next
  2. LEFT JOIN and Joining Many Tables13 min · Not started
  3. Subqueries: Queries Inside Queries12 min · Not started

Module 2: Better queries and better tables

  1. Functions, Dates and CASE13 min · Up next
  2. Designing Tables: Keys and Constraints14 min · Not started

Questions about SQL Intermediate: Joins, Subqueries and Design

What will I learn in SQL Intermediate: Joins, Subqueries and Design?

Combine tables with joins, nest queries, use functions and CASE, and design tables with keys and constraints. The course has 5 lessons, organised in 2 modules: Module 1: Combining tables; Module 2: Better queries and better tables.

How long does SQL Intermediate: Joins, Subqueries and Design take?

About 65 minutes in total, across 5 lessons. You can learn at your own pace and stop and continue any time.

Do I need experience to take SQL Intermediate: Joins, Subqueries and Design?

It helps to know the basics of the topic first. If you are new, start with the beginner course and come back.

Is SQL Intermediate: Joins, Subqueries and Design free?

Yes. The whole course is free and you do not need an account to learn. A free account is only needed for the final assessment and the certificate.

Do I get a certificate for SQL Intermediate: Joins, Subqueries and Design?

Yes, a free certificate of completion. Finish every lesson, sign in, and pass the 15-question final assessment with 80% or more. It is not an accredited qualification.

What should I learn after SQL Intermediate: Joins, Subqueries and Design?

The next step is SQL Advanced: CTEs, Windows and Performance.