The ShopStream DB Project is a beginner-friendly SQL Server project designed to practice SQL commands step by step using a real-world shopping database structure. It focuses on database design, data manipulation, reporting, and querying — covering DDL, DML, DQL, TCL, Joins, Aggregations, Filtering, Wildcards, Grouping, and Sets. In this project, I created a shop database that stores Customers, Products, and Orders, then ran 65 hands-on SQL exercises to master SQL Server fundamentals.
Topics Covered: I solved 65 SQL practice problems grouped into 5 categories:
Category 1 — DDL, DML, DQL, TCL (16 Questions) Create, alter, rename, and delete tables Insert, update, delete data Use transactions, commit, rollback, and savepoints
Category 2 — Basic Querying & Filtering (14 Questions) SELECT, WHERE, TOP, DISTINCT, IN, BETWEEN, ORDER BY Fetch data with conditions, sorting, and ranges
Category 3 — Null Handling, Aliases & Wildcards (14 Questions) IS NULL / IS NOT NULL Column/table aliases Wildcards: %, _, [AE]%, [^T]%
Category 4 — Aggregation, Grouping & Sets (14 Questions) SUM, AVG, COUNT, MIN, MAX, STDEV, VAR GROUP BY + HAVING UNION, UNION ALL, INTERSECT
Category 5 — Joins & Relationships (7 Questions) INNER JOIN, LEFT JOIN, FULL OUTER JOIN, CROSS JOIN Self-joins to compare products Combine rows vs. columns: JOIN vs UNION