From the course: MySQL Data Analysis
Unlock this course with a free trial
Join today to access over 24,400 courses taught by industry experts.
Solution: Bridging tables - MySQL Tutorial
From the course: MySQL Data Analysis
Solution: Bridging tables
- [Instructor] This is the solution video for the bridging assignment. As a reminder, we're trying to pull the actor's first name, the actor's last name, and the titles that the actor appeared in. We're going to need to employ a bridge. Let's jump into workbench and walk through the answer. All right, so here you see I've actually started to stub out the solution without even talking about the tables that we're going to use yet. So sometimes I use this method, I use the alias for the columns that we're looking for. This can kind of just help frame the problem you're trying to solve, and then you go ahead and fill it in from here. So we know we need the actor first name and last name. We can start to take a look at the tables here. Probably has something to do with actor. We can start there. We look in the columns and we see first name, last name. It looks like that'll be a good place to start. So let's call these in here. We'll say from actor. And we'll say actor.first_name, and we'll…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
(Locked)
Introduction30s
-
(Locked)
Normalization and Cardinality3m 47s
-
(Locked)
Relationship diagrams1m 10s
-
(Locked)
Multi-table querying1m 4s
-
(Locked)
Reviewing the maven movies database1m 44s
-
(Locked)
Common JOIN types2m 25s
-
(Locked)
INNER JOIN1m 31s
-
(Locked)
INNER JOIN example5m 49s
-
(Locked)
Challenge: INNER JOIN42s
-
(Locked)
Solution: INNER JOIN4m 13s
-
(Locked)
LEFT JOIN1m 39s
-
(Locked)
LEFT JOIN example4m 43s
-
(Locked)
Challenge: LEFT JOIN42s
-
(Locked)
Solution: LEFT JOIN3m 57s
-
(Locked)
RIGHT JOIN1m 41s
-
(Locked)
LEFT vs. INNER vs. RIGHT JOIN3m 18s
-
(Locked)
FULL OUTER JOIN1m 27s
-
(Locked)
Pro tip: Bridging unrelated tables6m 51s
-
(Locked)
Challenge: Bridging tables57s
-
(Locked)
Solution: Bridging tables4m 25s
-
(Locked)
Multi-condition joins2m 40s
-
(Locked)
Challenge: Multi-condition joins44s
-
(Locked)
Solution: Multi-condition joins4m 42s
-
(Locked)
The UNION operator2m 15s
-
(Locked)
UNION example3m 51s
-
(Locked)
Challenge: The UNION operator32s
-
(Locked)
Solution: The UNION operator2m 41s
-
(Locked)
-