SQL JOINS with Examples - LEFT, INNER, FULL, CROSS JOIN & UNION - Download the data and practice!
Skip all the nonsense. Download SQL and start practising SQL JOINS. It’s the only way to learn. Step by step tutorial for beginners in SQL. Set your SQL Environment up, learn how to create a database, how to import data in the database, how to interact with the database, how to run queries in the database, how to manipulate the data and many more! The focus of this tutorial is on JOINS and UNIONS with Examples
Data Analytics Course Link:
http://ipidata.teachable.com/
Download the raw data:
https://github.com/Pitsillides91/SQL-...
Part 1:
• SQL Tutorial for Data Scientist and D...
Part 2:
• How to Learn SQL as a Beginner – Spec...
Table of contents:
• SQL JOINS theory and examples
• SQL Left join with examples
• SQL Inner join with examples
• SQL Full join with examples
• SQL Cross join with examples
• SQL UNION all join with examples
Yiannis Pitsillides on Social Media:
/ pitsillides91
https://www.instagram.com/ypexists/?h...
https://www.pinterest.co.uk/pitsillid...
/ 1500092413449073
Chapters
00:00 - Intro
01:42 - LEFT JOIN Theory
06:28 - INNER JOIN Theory
07:29 - FULL JOIN Theory
08:54 - CROSS JOIN Theory
10:03 - UNION ALL Theory
11:00 - LEFT JOIN Application
20:37 - FULL JOIN Application
26:46 - INNER JOIN Application
28:52 - CROSS JOIN Application
31:27 - UNION ALL Application
EXCEL:
Excel top 5 Interview Questions: • Top 5 Excel Interview Questions for ...
Excel top 7 Most Used Formulas: • Top 7 Most-Used Excel Formulas for Da...
Excel Interview Test – Junior: • Excel Test for Job Interview 2025 - ...
Excel Interview Test – Intermediate: • Data Analyst Excel Test Example for I...
Excel Interview Test – Difficult: • EXCEL Interview Test Questions and An...
Excel Interview Test – Average Part 1: • Data Analyst EXCEL Interview Test Exa...
Excel Interview Test – Average Part 2: • Excel Test for Job Interview - Downlo...
SQL:
SQL Tutorial from scratch part 1: • SQL Tutorial for Data Scientist and D...
SQL Tutorial from scratch part 2: • How to Learn SQL as a Beginner – Spec...
SQL Tutorial JOINs: • SQL JOINS with Examples - LEFT, INNER...
SQL Top 5 Interview Questions: • Top 5 SQL Interview Questions & Answe...
SQL Interview Test – Beginner: • Data Analyst SQL Test Example for Int...
SQL Interview Test – Junior: • Easy SQL Test example for Data Analys...
SQL Interview Test – Intermediate: • SQL Test for Data Analyst Job Intervi...
SQL Interview Test – Difficult: • SQL Test Example for Interviews | Que...
PYTHON:
Python Tutorial from Scratch Part 1 – • How to learn Python? – Specific for D...
Python Tutorial from Scratch Part 2 - • Complete PYTHON Tutorial for Data Sci...
Python Tutorial from Scratch Part 3 JOINS - • How to Merge DataFrames in Python? Th...
Python Tutorial from Scratch Part 4 Visuals - • How to create Data Visualizations in ...
Python Tutorial from Scratch Part 5 Visuals - • Complete Seaborn Tutorial on Python –...
Python top 5 Interview Questions: • Python Interview Test Questions and A...
Python Interview Test – Beginner: • Python Interview Test for Data Analys...
Python Interview Test – Junior: • Junior Data Analyst Python Coding Tes...
Python Interview Test – Intermediate: • Python Interview Test Example for Dat...
Python Interview Test – Difficult: • Python Interview Test Example for Dat...
