Quick Finds:

• Syllabus

Homeworks:

• HW 01 – SQL

Project Docs:

• Phase 1 Slides
• Phase 2 Slides
• Phase 4 Slides
• Project Template Repo and Slide Deck
• Wireframing 101
• Intro To Streamlit
• Generating Mock Data with Mockaroo

Lecture Notes and Handouts:

Week 1

Day 1 – May 13

• Morning
  • Introduction to Databases in DS (DS3000 + CS3200)
  • Intro to Python Tutorial (.zip file; download and unzip)
• Afternoon
  • Project Kickoff Slide Deck
  • NoteSet01 – CS 3200 – The Syllabus Stuff

Day 2 – May 14

• Moring
  • Presentation by Dr.  Franzsika Petri, KU Leuven
  • NoteSet03 – The Relational Model of Data
• Afternoon
  • NoteSet04 – Terminal, Docker, and MySQL
    • Northwind.Northeastern2025.zip
  • NoteSet05 – SQL Part 1

Day 3 – May 15

• Afternoon
  • NoteSet06 – SQL Part 2

Week 2

Tuesday – May 20

• How the Internet Works (3330+3200)
• Finish Note Set 06
• HuskyGram SQL Practice
• Note Set 07 – SQL Part 3

Wednesday – May 21

• Morning
  • Pierre DeWitte – Speaker
  • Project Repo – First Steps
• Afternoon
  • Project Repo Kickoff
  • HW Time

Thursday – May 22

• Morning
  • Finish Note Set 07 – SQL Part 3 (DDL)
  • Note Set 08 – SQL Advanced DDL
• Afternoon
  • Note Set 09 – Database Design Part 1

Friday – May 23

• Morning
  • Review Gym Database Model
  • Note Set 10 – Database Design Part 2
  • Note Set 11 – ER -> Relational DB
  • Gym ERD

Week 3

Monday

• Afternoon
  • Note Set 12 – Designing and Implementing a REST API

Week 4 & Week 5

• See Canvas for project course slides and handouts.