Canvas Manager

Course 56880 · 8 weekly modules · Canvas MCP integration

Approved In Review Pending
1

Relational Databases + SQL SELECT

Project 1AIAS 0

Ch 1 + Ch 2 (partial) · 38 concepts

Not pushed
OWeek 1: Welcome to Data Foundationsoverview
RChapter 1: The Database Environmentreading
VRelational Model in 30 Minutesvideo
VSQL SELECT Deep Divevideo
VDDL + DML Fundamentalsvideo
SStudio: Project Kickoff + SQLFiddle Setupstudio
QQuiz 1: Relational Foundations (L1, L2)quiz

Studio: Project kickoff: database design walkthrough + SQLFiddle setup

2

JOINs, Subqueries, Aggregation

Project 1AIAS 0

Ch 2 (continued) + Ch 3 · 28 concepts

Not pushed
OWeek 2: Power SQLoverview
VAggregate Functions & GROUP BYvideo
VJOINs and Subqueriesvideo
VCTEs and Window Functionsvideo
SStudio: JOIN Patterns + AI Debuggingstudio
QQuiz 2: SQL Competency (C1)quiz

Studio: SQL deep-dive: JOIN patterns + common mistakes, AI for SQL debugging

3

Data Modeling + ER Diagrams + Normalization

Project 1AIAS 2

Ch 4 · 22 concepts

Not pushed
OWeek 3: Designing Databasesoverview
VER Diagrams Step-by-Stepvideo
RChapter 4: Data Modeling & Normalizationreading
SStudio: ERD Workshop in DrawIOstudio
PPROJECT 1 DUE: Relational Database Designproject

Studio: ER diagram workshop in DrawIO + normalization decision-making

4

Python Fundamentals + pandas

Project 2AIAS 2

Ch 5 · 21 concepts

Not pushed
OWeek 4: Python for Dataoverview
VPython Fundamentals for Data Workvideo
Vpandas: The Data Swiss Army Knifevideo
VPandas vs SQL: When to Use Eachvideo
LJupyter Notebook: pandas Fundamentalslab
SStudio: pandas + AI Debuggingstudio
QDataCamp: Data Cleaning Assignmentquiz

Studio: pandas fundamentals + AI for debugging DataFrames

5

ETL Pipelines (pandas + sqlalchemy)

Project 2AIAS 2

Ch 6 · 21 concepts

Not pushed
OWeek 5: Building Data Pipelinesoverview
VETL Pipeline Architecturevideo
VSQLAlchemy: Python Meets Databasesvideo
VError Handling & Loggingvideo
SStudio: ETL Build + Pair Debuggingstudio
DPeer Code Reviewdiscussion

Studio: ETL pipeline workshop: error handling + logging best practices

6

NoSQL (MongoDB) + API Data Ingestion

Project 2AIAS 2

Ch 7 · 24 concepts

Not pushed
OWeek 6: Beyond Relationaloverview
VNoSQL Fundamentalsvideo
VMongoDB + REST APIsvideo
SStudio: MongoDB Compass + API Hands-onstudio
QMid-Course Checkpointquiz
PPROJECT 2 DUE: ETL Pipeline in Pythonproject

Studio: MongoDB Compass + real API integration (Yelp/weather)

7

Cloud Databases + Query Optimization

Project 3AIAS 3

Ch 8 · 18 concepts

Not pushed
OWeek 7: Cloud + Performanceoverview
VCloud Databases & AWS RDSvideo
VQuery Optimization & Indexingvideo
SStudio: AWS RDS Setup + EXPLAIN Hands-onstudio
QQuiz: AWS Setup + Connectivity (C4)quiz

Studio: AWS RDS setup walkthrough + EXPLAIN plan analysis

8

Data Quality, Governance + Synthesis

Project 3AIAS 3

Ch 9 (review) · 14 concepts

Not pushed
OWeek 8: Quality, Governance + What's Nextoverview
VData Quality & Governancevideo
VACID Properties & Transactionsvideo
SStudio: Presentations + Portfoliostudio
PPROJECT 3 DUE: Cloud Database + Optimizationproject
POral Defense (Team)project

Studio: Final presentations + portfolio feedback