Intro to Data Management

DSC 100, Fall 2025 at UC San Diego 👋

Fall 2025

MANDE B-202

TUE & THUR 6:30PM - 7:20PM

Kyle Shannon (Data Soothsayer)

kshannon@ucsd.edu

Week 0 - Welcome, Welcome, Welcome

🧑‍🏫 Thu Sep 25: MISC Ensure gradescope and piazza access (no canvas); LECT 01_welcome_welcome_welcome slides; DEMO 01_up_and_running_sqlite template solutions

Week 1 - Relational Data Model & SQL Basics
📘 Read The Relational Data Model.
🍿 Watch IBM's What is SQL video.
🍿 Watch IBM's SQL vs. NOSQL video.
🍿 Watch IBM's Relational vs. NR Database video.

🧑‍🏫 Mon Sep 29: DISC Discussion Section walkthrough
🧑‍🏫 Tue Sep 30: LECT 02_relational_data_model slides; DEMO 02_relational_data_model template
🧑‍🏫 Thu Oct 2: LECT 03_sql_basics slides; DEMO 03_sql_basics template; HW 1 Homework 1 Released

Week 2 - SQL Joins

🧑‍🏫 Mon Oct 6: DISC Discussion Section walkthrough
🧑‍🏫 Tue Oct 7: LECT 04_join_me_for_joins slides; DEMO 04_simple_joins template solutions; QUIZ Quiz 1 Released
🧑‍🏫 Thu Oct 9: LECT 05_join_me_for_joins_2 slides; DEMO 05_advanced_joins template walkthrough solutions; HW 2 Homework 2 Released

Week 3 - Aggregations, Groupings, & Subqueries

🧑‍🏫 Mon Oct 13: DISC Discussion Section walkthrough
🧑‍🏫 Tue Oct 14: LECT 06_aggregation_and_grouping slides; DEMO 06_aggregation_and_grouping template solutions; QUIZ Quiz 2 Released
🧑‍🏫 Thu Oct 16: LECT 07_advanced_sql_queries slides; DEMO 07_subqueries_nested_queries template solutions; HW 3 Homework 3 Released

Week 4 - Advanced SQL Queries

🧑‍🏫 Mon Oct 20: DISC Discussion Section walkthrough
🧑‍🏫 Tue Oct 21: LECT 08_advanced_sql_queries_2 slides; DEMO 08_advanced_sql_queries template solutions; QUIZ Quiz 3 Released
🧑‍🏫 Thu Oct 23: LECT 09_sql_dbs_real_world

Week 5 - Formal Query Languages and Relational Algebra

🧑‍🏫 Mon Oct 27: DISC Discussion Section walkthrough
🧑‍🏫 Tue Oct 28: LECT 10_intro_relational_algebra slides ta_slides recording; DEMO 09_relax_relational_algebra_pt1 template solutions
🧑‍🏫 Thu Oct 30: LECT 11_relational_algebra slides ta_slides recording; DEMO 10_relax_relational_algebra_pt2 template solutions

Week 6 - Midterm & Data Analysis Workflow

🏠 Mon Nov 3: DISC Midterm Review Session; EXAM Midterm Reelased (at End of Day)
🏠 Tue Nov 4: EXAM No Class (work on midterm)
🏠 Wed Nov 5: EXAM Exam Due at End of Day
🧑‍🏫 Thu Nov 6: LECT 12_data_storage_query_analysis slides recording demo; DEMO 12_sql_query_optimization template; HW 4 Homework 4 Released; QUIZ Quiz 4 Released

Week 7 - Query Analysis, Indexing, & B-Trees

🧑‍🏫 Mon Nov 10: DISC Discussion Section (go over midterm) walkthrough
🧑‍🏫 Tue Nov 11: RELX 🇺🇸 Veteran's Day Holiday
🧑‍🏫 Thu Nov 13: LECT 13_index_and_b_trees slides; DEMO 13_index_and_b_trees template

Week 8 - Coneptual Design & Design Theory

🧑‍🏫 Mon Nov 17: DISC Discussion Section walkthrough
🧑‍🏫 Tue Nov 18: LECT 14_conceptual_design slides; DEMO 14_conceptual_design template solutions; HW 5 Homework 5 Released
🧑‍🏫 Thu Nov 20: LECT 15_design_theory slides; QUIZ Quiz 5 Released

Week 9 - Functional Dependancies

🧑‍🏫 Mon Nov 24: DISC Discussion Section walkthrough
🧑‍🏫 Tue Nov 25: LECT 16_normal_forms
🏠 Thu Nov 27: RELX 🦃 🔥 🍽️ 🍗 Thanksgiving Break
🏠 Fri Nov 28: RELX 🦃Thanksgiving Break; QUIZ Quiz 6 Released

Week 10 - Normalization & Final Exam

🧑‍🏫 Mon Dec 1: DISC Discussion Section (final review)
🧑‍🏫 Tue Dec 2: LECT 17_normal_forms_2
🧑‍🏫 Thu Dec 4: LECT 18_normalization
🏠 Fri Dec 5: EXAM Final Exam Released (11:59 AM)

Week 11 - Final Exam

🏠 Mon Dec 8: EXAM Final Exam Submission Cutoff (11:59 AM)