SQL Projects: AdventureWorks Sales Project

AdventureWorks Sales Project is a hands-on project focused on transforming structured data with SQL via SQLite in Google Colab. Students will develop a complete project for professional portfolio using a real-world scenario and dataset. Students will improve technical skillset in SELECT, ORDER BY, WHERE, Aggregate Functions, GROUP BY, Joins, and Subqueries as well as conceptional understanding of querying data, sorting and filtering queries, aggregating data, combining tables, and nesting queries.

Benefits

• Complete project for professional portfolio

• Technical skillset in SELECT, ORDER BY, WHERE, Aggregate Functions, GROUP BY, Joins, and Subqueries

• Conceptual understanding of querying data, sorting and filtering queries, aggregating data, combining tables, and nesting queries

Topics

1. Querying data using SELECT, DISTINCT, and CAST

2. Sorting and filtering queries using ORDER BY and WHERE

3. Aggregating data using COUNT, SUM, AVG, MAX/MIN, and GROUP BY

4. Combining tables using INNER JOIN, LEFT/RIGHT JOIN, and FULL JOIN

5. Nesting queries using Subqueries

Downloadables

• Download to 1 file (ZIP) containing 1 Scenario (PDF), 1 Dataset (MS Excel), and 1 Database (SQLite)

• Access to 1 file (Google Colab) containing 1 Demo (Google Colab)

Requirements

• Google Colab