Time: 
2015-04-26 15:00-2015-04-26 16:00
Room: 
CC-235

Experience level

Learner

Session Track

Development & Databases

Exploring MySQL Join Types – INNER, OUTER, and much more.

Joining tables is one of the fundamental aspects of any relational database, but the different ways of joining tables are often misunderstood.

Learn about INNER JOINS, OUTER JOINS (LEFT, RIGHT and FULL), OUTER JOIN with exclusions, CROSS JOIN. Also find out how multiple INNER JOINS impact your result set versus multiple OUTER JOINS.

By the end of this presentation you will at a minimum you will be able to answer that common interview of “explain the difference between an INNER JOIN and an OUTER JOIN”.