Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

CodeSignal

Learning SQL Joins

via CodeSignal

Go to class Write review

Overview

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.

Syllabus

  • Unit 1: Learning SQL Joins with Online Shopping
    • Change to Find Delivered Orders
    • Fix Errors in SQL Joins
    • Adding Order Status Condition
    • Find Processed Orders
    • Joining Tables for Delivered Orders
  • Unit 2: Exploring INNER JOIN with Online Shop's Product Data
    • 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
  • Unit 3: Understanding Advanced SQL Joins with Online Shop's Orders Data
    • 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
  • Unit 4: SQL FULL JOIN Mastery with Shop's Products
    • 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

Reviews

Start your review of Learning SQL Joins

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.