Introduction to Data Management
DSC 100 - UC San Diego - Prof. Kyle Shannon
Winter 2024
FAH 1301
TU & TH 5:00PM - 6:20PM
Welcome 👋
We are all very excited that you decided to join us on this whirlwind tour of data science. All relevant info, e.g. due dates, assignment links, etc. are found on this website. We look forward to teaching and working with all of you and hope to meet you in office hours. Read through the Assignments page and course Syllabus so you can hit the ground running when class starts!
Discussion Sections
| Day | Time | Location | Staff | Materials | |
|---|---|---|---|---|---|
| A01 | Fri | 5:00PM - 5:50PM | PCYNH 106 | TA: Kaveya Sivaprakasam IAs: | View |
Check out the assignments page for information on submitting HW, taking quizzes, and the exams!
Course Calendar
| Week 1 | ||
|---|---|---|
| Tue, Jan 09 | LECT | 01_welcome_welcome_welcome |
| Tue, Jan 09 | DEMO | 01_up_and_running_sqlite_instructor |
| Thu, Jan 11 | LECT | 02_relational_data_model |
| Thu, Jan 11 | DEMO | 02_relational_data_model_instructor |
| Fri, Jan 12 | DISC | Discussion |
| Week 2 | ||
|---|---|---|
| Tue, Jan 16 | LECT | 03_sql_basics |
| Tue, Jan 16 | DEMO | 03_sql_basics_instructor |
| Thu, Jan 18 | LECT | 04_join_me_for_joins |
| Thu, Jan 18 | DEMO | 04_simple_joins_student 04_simple_joins_instructor |
| Fri, Jan 19 | DISC | Discussion |
| Week 3 | ||
|---|---|---|
| Mon, Jan 22 | HMWK | Homework 1 is Due |
| Tue, Jan 23 | QUIZ | Quiz 1 is Due |
| Tue, Jan 23 | LECT | 05_join_me_for_joins_2 |
| Tue, Jan 23 | DEMO | 05_advanced_joins_student 05_advanced_joins_instructor |
| Thu, Jan 25 | LECT | 06_aggregation_and_grouping |
| Thu, Jan 25 | DEMO | 06_aggregation_and_grouping_student 06_aggregation_and_grouping_instructor |
| Fri, Jan 26 | DISC | Discussion |
| Week 4 | ||
|---|---|---|
| Tue, Jan 30 | QUIZ | Quiz 2 is Due |
| Tue, Jan 30 | LECT | 07_advanced_sql_queries |
| Tue, Jan 30 | DEMO | 07_subqueries_nested_queries_student 07_subqueries_nested_queries_instructor |
| Thu, Feb 01 | LECT | 08_advanced_sql_queries |
| Thu, Feb 01 | DEMO | 08_advanced_sql_queries_student 08_advanced_sql_queries_instructor |
| Thu, Feb 01 | HMWK | Homework 2 is Due |
| Fri, Feb 02 | DISC | Discussion |
| Week 5 | ||
|---|---|---|
| Tue, Feb 06 | QUIZ | Quiz 3 is Due |
| Tue, Feb 06 | LECT | 09_intro_relational_algebra |
| Tue, Feb 06 | DEMO | 09_set_ops_relax_ra_student 09_set_ops_relax_ra_instructor |
| Thu, Feb 08 | LECT | 10_relational_algebra |
| Thu, Feb 08 | DEMO | 10_relax_ra_queries_student 10_relax_ra_queries_instructor |
| Fri, Feb 09 | DISC | Discussion |
| Week 6 | ||
|---|---|---|
| Mon, Feb 12 | HMWK | Homework 3 is Due |
| Tue, Feb 13 | LECT | 11_class_interactive_sql_demo |
| Tue, Feb 13 | DEMO | 11_analysis_with_sql_student |
| Tue, Feb 13 | DEMO | 11_class_interactive_sql_demo_notebook |
| Thu, Feb 15 | EXAM | Midterm |
| Fri, Feb 16 | DISC | Discussion |
| Week 7 | ||
|---|---|---|
| Thu, Feb 22 | QUIZ | Quiz 4 is Due |
| Tue, Feb 20 | LECT | 12_data_storage_query_analysis |
| Tue, Feb 20 | DEMO | 12_sql_query_optimization |
| Thu, Feb 22 | LECT | 13_indexes_and_b_trees |
| Thu, Feb 22 | LECT | 13_btrees_notes |
| Thu, Feb 22 | DEMO | 13_indexes_and_b_trees |
| Fri, Feb 23 | DISC | Discussion |
| Week 8 | ||
|---|---|---|
| Mon, Feb 26 | HMWK | Homework 4 is Due |
| Tue, Feb 27 | LECT | 14_conceptual_design |
| Tue, Feb 27 | DEMO | 14_conceptual_design_student 14_conceptual_design |
| Thu, Feb 29 | QUIZ | Quiz 5 is Due |
| Thu, Feb 29 | LECT | 15_design_theory |
| Fri, Mar 01 | DISC | Discussion |
| Week 9 | ||
|---|---|---|
| Tue, Mar 05 | LECT | Guest Lecture - Brian from AWS |
| Thu, Mar 07 | LECT | 16_normalization |
| Thu, Mar 07 | DEMO | 16_normal_forms |
| Fri, Mar 08 | DISC | Discussion |
| Week 10 | ||
|---|---|---|
| Mon, Mar 11 | HMWK | Homework 5 is Due |
| Tue, Mar 12 | REVW | 17_final_review_normalization |
| Thu, Mar 14 | QUIZ | Quiz 6 is Due |
| Thu, Mar 14 | LECT | 18_data_quality_warehousing |
| Fri, Mar 15 | DISC | Discussion |