Everything you need to know about SQL JOINs in a single tutorial. Download a SQL practice sheet with a test dataset and 12 ready-to-use SQL query examples: http://l.rw.rw/joins-practice-sheet

In this video, you will learn SQL JOIN command in its variations: INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN. We will connect 3-4 tables and combine JOINs with WHERE, GROUP BY, ORDER BY, HAVING clauses. We will also use COUNT and LIKE.

We will use PostgreSQL as our RDBMS. Set it up for SQL training use Railsware Academy tutorial: https://youtu.be/DMl5fsc8PSk

What you will need to download:
postgreSQL for Mac: https://postgresapp.com/
postgreSQL for Windows: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
Graphical user interface client pgAdmin: https://www.pgadmin.org/download/

Timestamps:
1:20 - Test dataset structure review
2:40 - Database setup in postgreSQL
3:07 - The logic of SQL JOIN clause
5:47 - SQL INNER JOIN
7:27 - SQL LEFT JOIN
8:40 - SQL RIGHT JOIN
9:17 - SQL FULL JOIN
10:25 - Join 3 tables using INNER JOIN
13:15 - SQL GROUP BY and ORDER BY descending
14:31 - SQL HAVING vs WHERE
16:30 - Join 4 tables using SQL FULL JOIN and INNER JOIN

Learn SQL with Railsware Academy. Subscribe to our channel and follow the SQL YouTube course.
Contact Railsware to build your software product http://bit.ly/contactrailsware
Join Railsware team http://bit.ly/railswarecareers
Subscribe to Railsware and learn the most efficient data analytics tools with us!
Try Coupler.io - a tool for safe data imports from various tools to GSheets: bit.ly/sqljoins-couplerws
Download Coupler.io in GSuite marketplace: bit.ly/sqljoins-couplermp

Design: Vlad Shagov
Video editor: Oleg Gorovoi
Cases: Elvira Nassirova, Alexey Vasiliev, Anastasiia Avramenko
Speaker: Anastasiia Avramenko