JOINS Examples

Course:
SQL

A SQL JOIN lets you retrieve data from 2 or more tables in your database. In this video we give examples of 4 kinds of joins: INNER Joins, LEFT Joins, RIGHT Joins, and FULL Joins (also known as FULL OUTER Joins).

A SQL JOIN lets you retrieve data from 2 or more tables in your database. In this video we give examples of 4 kinds of joins: INNER Joins, LEFT Joins, RIGHT Joins, and FULL Joins (also known as FULL OUTER Joins).

Lessons
Course Info
SQL - A Quick Overview
Choosing a Relational Database
PostgreSQL - Installation and Overview
SELECT Queries - Part 1
SQL Queries - Part 2
INSERT Queries
UPDATE Queries
DELETE Queries
JOINS Explained
JOINS Examples
VIEWS - Complex Queries, Cross Joins, Unions, and more
Indexes
Course Page
SQL
Course Description
In this Introduction to SQL Course, you will learn the essential queries needed to work with a relational database: How to create data (INSERT), change existing data (UPDATE), and find data (SELECT and JOINs). You will also learn how to choose a database, install PostgreSQL, speed up queries with indexes, and more.