MySQL: Understanding & Implementing Joins
MySQL 8:0
| Intermediate
- 10 Videos | 59m 40s
- Includes Assessment
- Earns a Badge
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 courseidentify the use cases of joinscompute the cross-join of two relationscompute the inner join of two relationscompute the left outer join of two relations
-
compute the right outer join of two relationsdefine the natural join operatorimplement a cross product in MySQLperform join operations in MySQLCourse Summary
IN THIS COURSE
-
1.Course Overview1m 44sUP NEXT
-
2.Introducing Joins5m 17s
-
3.Cross Joins7m 26s
-
4.Inner Joins10m 47s
-
5.Left Outer Joins7m 49s
-
6.Right Outer Joins6m 14s
-
7.Natural Join4m 23s
-
8.Cross Products in MySQL7m 24s
-
9.Joins in MySQL7m 44s
-
10.Course Summary52s
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.