MySQL: Understanding & Implementing Joins

MySQL 8:0
  • 10 Videos | 1h 3m 40s
  • Includes Assessment
  • Earns a Badge
Likes 22 Likes 22
This 10-video course explores how to use joins to combine data from different relations in meaningful ways. Learners will examine why joins are such a powerful and ubiquitous concept in data analysis. Begin by observing how SQL features several types of joins, and how these can be understood, and will examine each type of join in depth. You will examine the cross join, which is the simplest kind of join, and is also known as a Cartesian join. Then examine inner joins, which can be expressed as a combination of the cross join operator along with a filter. This course continues by examining the three types of outer joins, the left, the full, and the right outer join. You will explore natural joins, which could be an inner or an outer join where two additional conditions are satisfied. You will examine several features of the join keyword. Finally, this course demonstrates how to use MySQL platform to support several varieties of different joins types.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    identify the use cases of joins
    compute the cross-join of two relations
    compute the inner join of two relations
    compute the left outer join of two relations
  • compute the right outer join of two relations
    define the natural join operator
    implement a cross product in MySQL
    perform join operations in MySQL
    Course Summary

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 8 Likes 8  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 25 Likes 25  
Likes 22 Likes 22  
Likes 18 Likes 18