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
Babbel Ad

Start speaking a new language. It’s just 3 weeks away.

Learn More → DataCamp Ad

PowerBI Data Analyst - Create visualizations and dashboards from scratch

Learn More →

Overview

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.