Coursera Plus Annual is 40% Off — Ends July 13.

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

LinkedIn Learning

Practice It: SQL Joins

via LinkedIn Learning

Write review
DataCamp Ad

AI Engineer - Learn how to integrate AI into software applications

Learn More → University of the People Ad

Earn Your CS Degree, Tuition-Free, 100% Online!

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate 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 186 ratings

Start your review of Practice It: SQL Joins

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.