From the course: Complete Guide to SQL for Data Engineering: from Beginner to Advanced
Join today to access over 24,400 courses taught by industry experts.
Challenge: Joins - SQL Tutorial
From the course: Complete Guide to SQL for Data Engineering: from Beginner to Advanced
Challenge: Joins
- [Instructor] This time, the challenge is in front of you to find out all the product name with their IDs and the condition is they have to belong to a very specific category that is electronics and we are doing this exercise because a sale is about to come and we have a summer special offer we have to put for this electronic item. So help the team to find out all these product IDs along with their name.
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
-
-
-
-
(Locked)
Introduction to joins5m 2s
-
(Locked)
Inner join explained7m 9s
-
(Locked)
Left and right joins explained7m 18s
-
(Locked)
Full outer joins10m 41s
-
(Locked)
Using the UNION operator9m 2s
-
(Locked)
Using the CASE statement for conditional logic7m 12s
-
(Locked)
Using GROUP BY to aggregate data8m 52s
-
(Locked)
Common aggregation functions: SUM, AVG, COUNT, etc.6m 38s
-
(Locked)
Filtering GROUP BY results with the HAVING clause7m 52s
-
(Locked)
Challenge: Joins37s
-
(Locked)
Solution: Joins1m 49s
-
(Locked)
-
-
-
-
-
-
-
-
-