BADM 554 — Data Foundations

Fall 2026 · 8 weeks · MSBAi · Canvas 56880

186

Concepts

169 core + 17 studio

9

Outcomes

3 L / 4 C / 2 E

8

Modules

8 weeks

23

Resources

chapters, videos, labs

Concept Distribution by Taxonomy

Relational Foundations
19 (18c + 1s)
SQL
47 (44c + 3s)
Data Modeling
22 (20c + 2s)
Python & Pandas
21 (19c + 2s)
ETL Pipelines
21 (19c + 2s)
NoSQL & APIs
24 (21c + 3s)
Cloud & Optimization
18 (16c + 2s)
Quality & Governance
14 (12c + 2s)

8-Week Course Timeline

1
Relational Databases + SQL SELECTP1

Project kickoff: database design walkthrough + SQLFiddle setup

7 items
2
JOINs, Subqueries, AggregationP1

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

6 items
3
Data Modeling + ER Diagrams + NormalizationP1

ER diagram workshop in DrawIO + normalization decision-making

5 items
4
Python Fundamentals + pandasP2

pandas fundamentals + AI for debugging DataFrames

7 items
5
ETL Pipelines (pandas + sqlalchemy)P2

ETL pipeline workshop: error handling + logging best practices

6 items
6
NoSQL (MongoDB) + API Data IngestionP2

MongoDB Compass + real API integration (Yelp/weather)

6 items
7
Cloud Databases + Query OptimizationP3

AWS RDS setup walkthrough + EXPLAIN plan analysis

5 items
8
Data Quality, Governance + SynthesisP3

Final presentations + portfolio feedback

6 items