Database Design Schedule

From Knowledge Kitchen
Jump to navigation Jump to search
Lecture Date Topic Slides Notes Reading due Quiz due Assignment due
1 9/2 Course details Course intro
2 9/7* Python Python blast

Python for Everyone (py4e):

Intake Questionnaire
3 9/9 Text files Plain text data formats

py4e:

Python
4 9/14 Data munging Text files in Python

Big Data Handbook:

Text files
5 9/23 Workshop - raw data munging Data munging
6 9/28* Spreadsheets Spreadsheets
7 9/30 Guest lecture: Vicky Rampin of NYU Libraries


Workshop - spreadsheets

Spreadsheets Workshop - raw data munging
8 10/5 SQL CRUD SQLite intro

Using SQLite

9 10/7 SQL joins SQL joins SQL CRUD Workshop - spreadsheets
10 10/14 Workshop - SQL SQL joins
11 10/19 Normalization Normalization

Database Design

12 10/21 Entity-Relationship Diagrams Entity-Relationship Diagrams

Relational Database Design and Implementation

  • Chapter 3 - Why Good Design Matters
  • Chapter 4 - Entities and Relationships
  • Chapter 5 - The Relational Data Model
Workshop - SQL
13 10/26 Workshop - Normalization & Entity-Relationship Diagramming Normalization
14 10/28 Review Exam 1 review Entity-Relationship Diagrams
15 11/2 Exam #1 Workshop - Normalization & Entity-Relationship Diagramming
16 11/4 MongoDB CRUD
17 11/9 MongoDB CRUD

MongoDB aggregation

18 11/11 Workshop - MongoDB MongoDB CRUD
19 11/16 Web apps
20 11/18 Web apps Pymongo & flask Workshop - MongoDB
21 11/23 Workshop - Web app Web apps
22 11/30 Jupyter Notebooks Jupyter Notebooks
23 12/2 Pandas Pandas slides
24 12/7 Data visualization Pandas Workshop - Web app
25 12/9 Workshop - pandas
26 12/14 Review

Workshop - pandas
No late assignments accepted beyond this date.

27 12/21/2021 12pm until 12/22/2021 12PM Exam #2


Extras

Optional additional material that might be of interest to some.

Lecture Date Topic Slides Notes Reading Quiz Assignment
N/A N/A Blockchain Blockchain slides Blockchain