Intro to Data Management

DSC 100, Fall 2024 at UC San Diego 👋

Fall 2024

CNTR 105

TUE & THUR 5:00PM - 6:20PM

Kyle Shannon (Data Soothsayer)

kshannon@ucsd.edu

Week 0 - Welcome, Welcome, Welcome

🧑‍🏫 Thu Sep 26: MISC Sign Up for EdStem (class discussion board); LECT 01_welcome_welcome_welcome slides; DEMO 01_up_and_running_sqlite template

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.

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

Week 2 - SQL Joins

🧑‍🏫 Tue Oct 8: LECT 04_join_me_for_joins slides; DEMO 04_simple_joins template solutions; QUIZ Quiz 1 Released
🧑‍🏫 Wed Oct 9: DISC Discussion Section walkthrough
🧑‍🏫 Thu Oct 10: 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

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

Week 4 - Advanced SQL Queries

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

Week 5 - Formal Query Languages and Relational Algebra

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

Week 6 - Midterm & Data Analysis Workflow

🏠 Mon Nov 4: EXAM Midterm Released (takehome)
🏠 Tue Nov 5: EXAM No Class (work on midterm)
🏠 Wed Nov 6: DISC No Discussion Section (work on midterm); EXAM Midterm Due (End of Day)
🧑‍🏫 Thu Nov 7: 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

🧑‍🏫 Tue Nov 12: LECT 13_index_and_b_trees slides; DEMO 13_index_and_b_trees template
🧑‍🏫 Wed Nov 13: DISC Discussion Section walkthrough
🧑‍🏫 Thu Nov 14: LECT 14_conceptual_design slides; DEMO 14_conceptual_design template solutions

Week 8 - Coneptual Design & Design Theory

🧑‍🏫 Tue Nov 19: LECT 15_design_theory slides; HW 5 Homework 5 Released
🧑‍🏫 Wed Nov 20: DISC Discussion Section
🧑‍🏫 Thu Nov 21: LECT 16_normal_forms; QUIZ Quiz 5 Released

Week 9 - Functional Dependancies

🧑‍🏫 Tue Nov 26: LECT 17_normal_forms_2
🧑‍🏫 Wed Nov 27: DISC Discussion Section
🏠 Thu Nov 28: RELX Thanksgiving Break
🏠 Fri Nov 29: RELX Thanksgiving Break; QUIZ Quiz 6 Released

Week 10 - Normalization & Final Exam

🧑‍🏫 Tue Dec 3: LECT 18_normalization
🧑‍🏫 Wed Dec 4: DISC Discussion Section
🧑‍🏫 Thu Dec 5: LECT 19_data_warehouses_lakes