MySQL: Understanding & Implementing Joins

MySQL    |    Intermediate
  • 10 videos | 59m 40s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 124 users Rating 4.6 of 124 users (124)
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

  • 1m 44s
  • 5m 17s
    In this video, you will learn how to identify the use cases for joins. FREE ACCESS
  • Locked
    3.  Cross Joins
    7m 26s
    In this video, you will learn how to compute the cross-join of two relations. FREE ACCESS
  • Locked
    4.  Inner Joins
    10m 47s
    During this video, you will learn how to compute the inner join of two relations. FREE ACCESS
  • Locked
    5.  Left Outer Joins
    7m 49s
    To find out how to compute the left outer join of two relations, consult a database management textbook or search for it on the internet. FREE ACCESS
  • Locked
    6.  Right Outer Joins
    6m 14s
    To find out how to compute the right outer join of two relations, look up the definition of a right outer join. FREE ACCESS
  • Locked
    7.  Natural Join
    4m 23s
    In this video, you will learn about the natural join operator. FREE ACCESS
  • Locked
    8.  Cross Products in MySQL
    7m 24s
    During this video, you will learn how to implement a cross join in MySQL. FREE ACCESS
  • Locked
    9.  Joins in MySQL
    7m 44s
    In this video, you will learn how to perform join operations in MySQL. FREE ACCESS
  • Locked
    10.  Course Summary
    52s
    Upon completion of this video, you will be able to see the Course Summary. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course MySQL: Creating & Updating Tables
Rating 4.7 of 171 users Rating 4.7 of 171 users (171)
Course MySQL: Views, Indices, & Normal Forms
Rating 4.8 of 85 users Rating 4.8 of 85 users (85)
Course Querying SQL Databases: Using Generative AI Tools to Filter & Group Data
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course MySQL: Transactions, Savepoints, & Locks
Rating 4.5 of 44 users Rating 4.5 of 44 users (44)
Course Java SE 11 Programmer II: Lambda Operations & Streams
Rating 4.7 of 64 users Rating 4.7 of 64 users (64)
Course MySQL: Views, Indices, & Normal Forms
Rating 4.8 of 85 users Rating 4.8 of 85 users (85)