برای استفاده کامل از سایت، جاوااسکریپت را فعال کنید.

JavaScript is required for the full experience. You can still browse these pages:

Practice It: SQL Joins

57mIntermediate2022-11-09

Authors

Nikiya Simpson

MBA, Developer, Expert in Data-Driven Web Applications

Course details

In this course, instructor Nikiya Simpson guides you through four main types of SQL joins, with plenty of opportunities to try what you’re learning. Nikiya starts with schema description SQL commands, plus table and column description SQL commands. She goes over inner joins, then dives into left joins, self joins, and multiple complex joins. Nikiya also covers right joins, full outer joins, and cross joins.

Skills covered

SQLDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentDeep Dive (X:Y)

Concepts

0. Introduction

01 - Welcome to the course
02 - Prerequisites and preassessment
03 - Getting started with GitHub Codespaces
04 - Installing the database in GitHub Codespaces

1. SQL JOIN and Descriptions

05 - SQL commands for determining relationships
06 - Try it - Schema description SQL commands
07 - Check it - Schema description SQL commands
08 - Try it - Table and column description SQL commands
09 - Check it - Table and column description SQL commands

2. Inner Join

10 - Understanding inner joins
11 - Try it - Inner join
12 - Check it - Inner join
13 - Understanding self joins
14 - Try it - Self join
15 - Check it - Self join

3. Left Join

16 - Understanding left joins
17 - Try it - Left join
18 - Check it - Left join
19 - Try it - Multiple complex joins
20 - Check it - Multiple complex joins

4. Right Join

21 - Understanding right joins
22 - Try it - Right join
23 - Check it - Right join
24 - Try it - Full outer join
25 - Check it - Full outer join