Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Practice It: SQL Joins

via LinkedIn Learning

Write review

Details

Provider

LinkedIn Learning
Pricing

Free Trial Available
Languages

English
Certificate

Certificate Available
Effort

57 minutes
Sessions

Self-Paced
Level

Intermediate

Found in

SQL Courses

Part of

SQL Hands-On Practice

Coursera

Learn AI, Data Science & Business — Earn Certificates That Get You Hired

Boot.dev

The Most Addictive Python and SQL Courses

Overview

Google, IBM & Meta Certificates – 40% Off

One Coursera Plus subscription covers most Professional Certificates on Coursera.

Unlock All Certificates

Learn about four different types of SQL joins and get hands-on practice creating the joins in GitHub Codespaces.

Syllabus

Introduction

Welcome to the course
Prerequisites and preassessment
Getting started with GitHub Codespaces
Installing the database in GitHub Codespaces

1. SQL JOIN and Descriptions

SQL commands for determining relationships
Try it: Schema description SQL commands
Check it: Schema description SQL commands
Try it: Table and column description SQL commands
Check it: Table and column description SQL commands

2. Inner Join

Understanding inner joins
Try it: Inner join
Check it: Inner join
Understanding self joins
Try it: Self join
Check it: Self join

3. Left Join

Understanding left joins
Try it: Left join
Check it: Left join
Try it: Multiple complex joins
Check it: Multiple complex joins

4. Right Join

Understanding right joins
Try it: Right join
Check it: Right join
Try it: Full outer join
Check it: Full outer join

5. Cross Join

Understanding cross joins
Try it: Cross joins and Cartesian joins
Check it: Cross joins and Cartesian joins

Conclusion

Continuing on with SQL

Taught by

Nikiya Simpson

Reviews

4.1 rating at LinkedIn Learning based on 240 ratings

Start your review of Practice It: SQL Joins