Module Artifacts — 7 items
Outlines the module's learning topics covering complex SQL queries, including JOIN types (INNER, LEFT, and others), and WHERE clause filtering with comparison and logical operators, serving as a roadmap for learners and instructors to understand what concepts will be taught and in what order.
This reading introduces why simple SELECT statements are insufficient for real-world database work and previews the complex SQL concepts — JOINs, filtering, aggregation, and subqueries — that learners will study throughout the module.
This reading explains all major SQL JOIN types (INNER, LEFT, RIGHT, FULL, CROSS) and how to combine data from multiple related tables, serving as a reference and study resource for learners writing multi-table queries.
This reading covers the SQL WHERE clause in depth — including comparison operators, logical operators (AND, OR, NOT), pattern matching with LIKE, IN, BETWEEN, and NULL handling — so learners can precisely filter query results to only the rows they need.
This reading explains how the ORDER BY clause controls the sequence of query results, covering ascending and descending sorts, multi-column sort keys, and sorting by expressions, so learners can return data in a predictable, meaningful order.
This reading covers the GROUP BY clause and aggregate functions (COUNT, SUM, AVG, MIN, MAX) along with the HAVING clause for filtering grouped results, enabling learners to write queries that produce summary statistics across categories of data.
This reading introduces subqueries — SELECT statements nested inside other SQL statements — explaining how to write and place them in WHERE, FROM, and SELECT clauses so learners can decompose complex data retrieval problems into manageable logical steps.
This reading is a duplicate of artifact 6 and covers the same subquery concepts — nested SELECT statements, inner/outer query terminology, and practical placement strategies — providing learners with the same reference material on writing and using subqueries.