Byte-Sized-Chunks: SQL Joins in MySQL
Byte-Sized-Chunks: SQL Joins in MySQL
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!
Never fear joins again! Inner or outer, left or right, joins will be your best friends after this!
Url: View Details
What you will 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
Rating: 3.75
Level: Intermediate Level
Duration: 2.5 hours
Instructor: Loony Corn
Courses By: 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
About US
The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of course-link.com.
View Sitemap