BootSelf
Check my readiness
sql · postgresql-dba

Types of JOINs

10 roles need it, 9 as coreUsually level 3: WorkingLesson available

Where it sits

Learn first

Relational Data ModelResults orderingThe NULL value

This skill

Types of JOINs

Leads to

Many-to-many relationshipsCohort analysis: churn and retention by cohortsRetrieving DataViews

Jobs that need it

What level 3 (Working) means

Uses it independently on the job. Level 4 (Strong): handles hard cases, reviews others.

Start learning

Understanding JOINs

Introducing INNER JOINs

16 parts

Open the lesson

Find out where you stand

A free check, then a route that starts at your level.

Check my readiness

Learned alongside it

ABSAggregate functionsAlter tableBasic data typesBasic DELETE statementBasic SELECT statementBasic UPDATE statementBasics SQL

Types of JOINs: common questions

What is Types of JOINs?

Types of JOINs is a skill in sql and postgresql-dba, needed by 10 roles on BootSelf.

Which jobs need Types of JOINs?

Backend Developer (ASP.NET Core), Backend Developer (Go), Backend Developer (Java, Spring Boot), Backend Developer (Node.js), Backend Developer (Python), and 5 more. Most ask for level 3 (Working): uses it independently on the job.

What should I learn before Types of JOINs?

Relational Data Model, Results ordering, The NULL value.

How do I practise Types of JOINs?

Check your readiness for free, then BootSelf builds a route and short daily learning loops: a little theory, checks on what you get wrong, then a small program.