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

Go to class Write review
OpenLearning Ad

Future-Proof Your Career: AI Manager Masterclass

Learn More → Boot.dev Ad

Learn Backend Development Part-Time, Online

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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

Go to class

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.