Byte-Sized-Chunks: SQL Joins in MySQL
4.5 (10 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,560 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Byte-Sized-Chunks: SQL Joins in MySQL to your Wishlist.

Add to Wishlist

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.5 (10 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,560 students enrolled
Created by Loony Corn
Last updated 3/2016
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 2.5 hours on-demand video
  • 23 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
  • We will write join queries in MySQL, and the course will explain how MySQL ought to be installed and set up

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!

Using discussion forums

Please use the discussion forums on this course to engage with other students and to help each other out. Unfortunately, much as we would like to, it is not possible for us at Loonycorn to respond to individual questions from students:-(

We're super small and self-funded with only 2 people developing technical video content. Our mission is to make high-quality courses available at super low prices.

The only way to keep our prices this low is to *NOT offer additional technical support over email or in-person*. The truth is, direct support is hugely expensive and just does not scale.

We understand that this is not ideal and that a lot of students might benefit from this additional support. Hiring resources for additional support would make our offering much more expensive, thus defeating our original purpose.

It is a hard trade-off.

Thank you for your patience and understanding!

Who is the target audience?
  • Yep! Data analysts who write queries, but never really understood the different types of joins
  • Nope! Please don't enroll for this class if you have already enrolled for our 13-hour course 'From 0 to 1: Databases and SQL'
Compare to Other MySQL Courses
Curriculum For This Course
12 Lectures
Joins: Connecting the Dots!
12 Lectures 02:28:37

The full power of databases emerges when we link tables - and Joins are the way to accomplish this
Preview 09:54

Cross Joins are conceptually simple, which is great, because they are the underpinning of Inner Joins
Cross Joins aka Cartesian Joins

Inner Joins are your best friend. Understand them for what they are: cross joins with a filter condition.
Inner Joins

Outer Joins are really useful if used right. They are a little tricky though - understand how they work, and why you should not be surprised to see NULLs in the result of an outer join.

Left Outer Joins

Once we've understand Inner and Outer joins, Natural Joins are easy-peasey
Right, Full Outer Joins, Natural Joins, Self Joins

MySQL is an open-source RDBMS, the most popular in the world by some measures. Acquired by Oracle, it still has a very powerful free Community Edition
Preview 07:03

Setting up MySQL and the MySQL workbench can be a little daunting - never fear! We'll walk through it.
Setting up MySQL and the Workbench

Let's get our feet wet - create a database, use that database, create a simple table, and bulk load a file into that table
Preview 17:25

That first table was a bit simplistic - no constraints. Now let's do a more involved example, and harness the full power of the Bulk Uploader.
Preview 14:14

Let's create a new table, this time using the Inner Join operator to seed it.

Use A Subquery To Populate A Table

Let's create a table twice - once using Inner Join, and once using Outer Join. Guess what the difference is?
Outer Join And Inner Join: A Little Test
About the Instructor
Loony Corn
4.3 Average rating
5,491 Reviews
42,720 Students
75 Courses
An ex-Google, Stanford and Flipkart team

Loonycorn is us, Janani Ravi and Vitthal Srinivasan. Between us, we have studied at Stanford, been admitted to IIM Ahmedabad and have spent years  working in tech, in the Bay Area, New York, Singapore and Bangalore.

Janani: 7 years at Google (New York, Singapore); Studied at Stanford; also worked at Flipkart and Microsoft

Vitthal: Also Google (Singapore) and studied at Stanford; Flipkart, Credit Suisse and INSEAD too

We think we might have hit upon a neat way of teaching complicated tech courses in a funny, practical, engaging way, which is why we are so excited to be here on Udemy!

We hope you will try our offerings, and think you'll like them :-)