Byte-Sized-Chunks: SQL Joins in MySQL

About Course

•  

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

Topics covered in this course

• Section 1: Joins: Connecting the Dots!
  	Lecture 1	You, This Course, and Us!	01:14
  	Lecture 2	Introduction To SQL Joins	09:54
  	Lecture 3	Cross Joins aka Cartesian Joins	17:02
  	Lecture 4	Inner Joins	19:52
  	Lecture 5	Left Outer Joins	15:31
  	Lecture 6	Right, Full Outer Joins, Natural Joins, Self Joins	16:08
  	Lecture 7	MySQL - Installed and Introduced	07:03
  	Lecture 8	Setting up MySQL and the Workbench	14:26
  	Lecture 9	Creating a Database and Using It	17:25
  	Lecture 10	An Involved Bulk Loading Example	14:14
  	Lecture 11	Use A Subquery To Populate A Table	06:49
  	Lecture 12	Outer Join And Inner Join: A Little Test	08:59

What is included in 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

Who should buy this course?

• • Data analysts who write queries, but never really understood the different types of joins
  • Please don't enroll for this class if you have already enrolled for our 13-hour course 'From 0 to 1: Databases and SQL'
  • We will write join queries in MySQL, and the course will explain how MySQL ought to be installed and set up