Skip to main content Link Menu Expand (external link) Document Search Copy Copied

Intro to Data Management

DSC 100, Fall 2025 at UC San Diego 👋

Fall 2025

MANDE B-202

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

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

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

LECT 13_index_and_b_trees    slides

DEMO 13_index_and_b_trees    template

🧑‍🏫  Thu Nov 13

LECT 14_conceptual_design    slides

DEMO 14_conceptual_design    template   solutions

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

Week 10 - Normalization & Final Exam

🧑‍🏫  Mon Dec 1

DISC Discussion Section (final review)

🧑‍🏫  Tue Dec 2

LECT 18_normalization

🧑‍🏫  Thu Dec 4

LECT 19_data_warehouses_lakes

🏠  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)