Byte-Sized-Chunks: SQL Joins in MySQL
3.5 (2 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.
87 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!
3.5 (2 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.
87 students enrolled
Created by Loony Corn
Last updated 3/2016
English
Price: $20
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 23 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
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
Requirements
  • We will write join queries in MySQL, and the course will explain how MySQL ought to be installed and set up
Description

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-3 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'
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 12 Lectures Collapse All 12 Lectures 02:28:37
+
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
17:02

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

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
15:31

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

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
14:26

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
06:49

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
08:59
About the Instructor
Loony Corn
4.3 Average rating
3,293 Reviews
26,226 Students
65 Courses
A 4-person team;ex-Google; Stanford, IIM Ahmedabad, IIT

Loonycorn is us, Janani Ravi, Vitthal Srinivasan, Swetha Kolalapudi and Navdeep Singh. Between the four of us, we have studied at Stanford, IIM Ahmedabad, the IITs and have spent years (decades, actually) 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

Swetha: Early Flipkart employee, IIM Ahmedabad and IIT Madras alum

Navdeep: longtime Flipkart employee too, and IIT Guwahati alum

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 :-)