Intro to Data Management
DSC 100, Fall 2025 at UC San Diego 👋
Fall 2025
MANDE B-202
TUE & THUR 6:30PM - 7:20PM
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
-
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
-
QUIZ Quiz 2 Released
- 🧑🏫 Thu Oct 16
-
LECT 07_advanced_sql_queries slides
-
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
-
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
- 🧑🏫 Thu Oct 30
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
-
DEMO 12_sql_query_optimization template
-
HW 4 Homework 4 Released
-
QUIZ Quiz 4 Released
Week 8 - Coneptual Design & Design Theory
- 🧑🏫 Mon Nov 17
-
DISC Discussion Section walkthrough
- 🧑🏫 Tue Nov 18
-
LECT 15_design_theory slides
-
HW 5 Homework 5 Released
- 🧑🏫 Thu Nov 20
-
LECT 16_normal_forms
-
QUIZ Quiz 5 Released
Week 9 - Functional Dependancies
- 🧑🏫 Mon Nov 24
-
DISC Discussion Section
- 🧑🏫 Tue Nov 25
-
LECT 17_normal_forms_2
- 🏠 Thu Nov 27
-
RELX Thanksgiving Break
- 🏠 Fri Nov 28
-
RELX Thanksgiving Break
-
QUIZ Quiz 6 Released