Data Analytics
580 learners
Learning SQL Joins
Explore the dynamic world of SQL Joins by analyzing data from an online shopping platform. This course will demonstrate how to connect different tables to reveal the in-depth narratives of orders, products, and customer interactions.
MySQL
4 lessons
20 practices
1 hour
Data Querying and Retrieval
Lessons and practices
Change to Find Delivered Orders
Fix Errors in SQL Joins
Adding Order Status Condition
Find Processed Orders
Joining Tables for Delivered Orders
Change to Find Orders with Extended Support
Fix Error in SQL Join
Adding Product Name Condition
Find Orders with Extended Support in Certain Category
Joining Tables for Category and Support
Exploring LEFT JOIN with Online Shop's Orders Data
Exploring RIGHT JOIN in SQL
Correcting the RIGHT JOIN Query
Linking Orders and OrderItems with LEFT JOIN
SQL Query Using LEFT JOIN to Connect Products and OrderItems
Merging Products and OrderItems Using SQL
Simulating FULL JOIN
Complete FULL JOIN
Simulating FULL JOIN with SQL UNION ALL
FULL JOIN with Category Condition in Online Shopping Data
Meet Cosmo:
The smartest AI guide in the universe
Our built-in AI guide and tutor, Cosmo, prompts you with challenges that are built just for you and unblocks you when you get stuck.
Join the 1M+ learners on CodeSignal
Be a part of our community of 1M+ users who develop and demonstrate their skills on CodeSignal
