JOINS Explained

Course:
SQL

SQL Joins let you fetch data from 2 or more tables in your database. We will cover the more common types of Joins: Inner Joins, Left Joins, Right Joins, and Full Joins (also called ‘Full Outer Joins’). We will introduce these 4 kinds of Joins and prepare you for our next video where we will cover many examples.

SQL Joins let you fetch data from 2 or more tables in your database. We will cover the more common types of Joins: Inner Joins, Left Joins, Right Joins, and Full Joins (also called ‘Full Outer Joins’). We will introduce these 4 kinds of Joins and prepare you for our next video where we will cover many examples.

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.