Byte-Sized-Chunks: SQL Joins in MySQL

Never fear joins again! Inner or outer, left or right, joins will be your best friends after this!

4.05 (35 reviews)

Udemy

platform

English

language

Data & Analytics

What you will learn

Master the different types of joins - inner joins, outer joins, natural joins and cross joins

Understand how these joins are used in MySQL queries

Why take this course?

Note: This course is a subset of our much longer course 'From 0 to 1: SQL and Databases' so please don't sign up for both:-)

All too often, we write queries by copy-pasting from other queries that some friend or colleague copy-pasted from somewhere. We often don't appreciate the nitty-gritty, and are left with vaguely uncomfortable each time we try to change our query - and clueless when our queries don't run, or when they return unexpected results.

Joins are probably the most useful type of queries out there. They are the glue that bind together tables in a database, that connect the dots.

Once we understand - really understand - joins, even very complex queries start to make sense. And that's why this course is all about joins, with examples in MySQL to drive home the theory.

Inner joins
Outer joins
Cross joins
Natural joins
Left and right joins
Wrap up all of this with examples in MySQL!

Content

Joins: Connecting the Dots!

You, This Course, and Us!

Introduction To SQL Joins

Cross Joins aka Cartesian Joins

Inner Joins

Left Outer Joins

Right, Full Outer Joins, Natural Joins, Self Joins

MySQL - Installed and Introduced

Setting up MySQL and the Workbench

Creating a Database and Using It

An Involved Bulk Loading Example

Use A Subquery To Populate A Table

Outer Join And Inner Join: A Little Test

Screenshots

Byte-Sized-Chunks: SQL Joins in MySQL - Screenshot_01

Byte-Sized-Chunks: SQL Joins in MySQL - Screenshot_02

Byte-Sized-Chunks: SQL Joins in MySQL - Screenshot_03

Byte-Sized-Chunks: SQL Joins in MySQL - Screenshot_04

Reviews

Ulday

January 8, 2020

Didn't match course vibe. My mistake - read the description; but not listened to actual course; If you hate indian accent, don't take it. Also, this course is very basic info, no homeworks whatsoever; I could've have got the same info from youtube tutorials.

Ithar

December 13, 2019

It explained table joins very clearly and good visualizations. It was a little bit slow at times, but it covered the topic very well.

Ana

October 5, 2018

Excellent, as all the courses of this instructor I have taken so far. Everything is very well explained. The videos are lengthy, but after watching them with attention just once it is impossible to forget the content. The only caveat is the Indian accent of the instructor, which in the beginning can sound very unfamiliar, but after two or three videos it was no problem anymore. I highly recommend this course.

Ildar

June 8, 2017

so far it's good. But some example could be mysql version specific since they're not working on my end. Example in "Lecture 4" You inner join sql statements are >>> SELECT col_name, col_name2 <<< without specifying the tables, it throws an error "col_name" in field list is ambiguous... When changing the query to SELECT tbl1.col_name, tbl2.col_name2 and using aliases like in Lecture 4 it also throws an error. Without aliases it works, I fail to see the need to use aliases so early on in the course.. My work around to keep the aliases was to change the query multiple times and write it as SELECT alias_name1.col_name, alias_name2.col_name2 in order to make it work. Otherwise it kept throwing an error "#1054 - Unknown column 'tbl1.col_name' in 'field list'"... Aliases may be needed but not so early on in the course... Explanations are very good though and so are the visuals so it's definitely at least a 4 star course. UPDATE: You do fix this in Lecture 5 and supply fully working example

Charts

Price

Rating

Enrollment distribution

Byte-Sized-Chunks: SQL Joins in MySQL - Distribution chart