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.
10 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 12
  • Length 2.5 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2016 English

Course 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!

Mail us about anything - anything! - and we will always reply :-)

What are the requirements?

  • We will write join queries in MySQL, and the course will explain how MySQL ought to be installed and set up

What am I going to get from this course?

  • Master the different types of joins - inner joins, outer joins, natural joins and cross joins
  • Understand how these joins are used in MySQL queries

What 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'

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Joins: Connecting the Dots!
You, This Course, and Us!
Preview
01:14
09:54
The full power of databases emerges when we link tables - and Joins are the way to accomplish this
17:02
Cross Joins are conceptually simple, which is great, because they are the underpinning of Inner Joins
19:52
Inner Joins are your best friend. Understand them for what they are: cross joins with a filter condition.
15:31

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.

16:08
Once we've understand Inner and Outer joins, Natural Joins are easy-peasey
07:03
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
14:26
Setting up MySQL and the MySQL workbench can be a little daunting - never fear! We'll walk through it.
17:25
Let's get our feet wet - create a database, use that database, create a simple table, and bulk load a file into that table
14:14
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.
06:49

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

08:59
Let's create a table twice - once using Inner Join, and once using Outer Join. Guess what the difference is?

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Loony Corn, 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 :-)

Ready to start learning?
Take This Course