| 1/24 |
1 |
Welcome |
Course intro |
Syllabus |
|
|
| 1/26 |
2 |
Python |
- Discord for Education
- Python |
Videos:
- Python crash course
- Set up Visual Studio Code for Python programming
Python for Everyone (py4e):
- Variables
- Conditionals
- Functions
- Iterations
- Strings
- Lists
- Dictionaries
- Tuples |
Intake |
- Complete consent form
- Join Discord
- Create GitHub account |
| 1/31 |
3 |
Plain text data formats |
Plain text data formats |
- Video: Plain-text data formats
- py4e: - Files
- Text files code examples |
Python |
- Set up Python
- Contemporary issues exercise |
| 2/2 |
4 |
Data munging |
- Text files in Python
- Example Python code |
Accessing O’Reilly Safari e-books
Big Data Handbook (bdh):
- Does This Data Smell Funny?
- Data Lurking in Plain Sight |
Text files |
|
| 2/7 |
5 |
Workshop - raw data munging |
Workshop - raw data munging |
|
Data munging |
|
| 2/9 |
6 |
Spreadsheets |
Spreadsheets |
|
|
|
| 2/14 |
7 |
Workshop - spreadsheets |
Workshop - spreadsheets |
Vicky Rampin’s slides |
|
Workshop - raw data munging |
| 2/16 |
8 |
SQL CRUD |
SQLite intro |
Using SQLite:
- What is SQLite?
- Uses of SQLite
- Building and Installing SQLite (only Precompiled Distributions and An sqlite3 Primer)
- The SQL Language
- The SELECT Command |
Spreadsheets |
|
| 2/21 |
9 |
SQL joins |
- SQL joins
- SQL inner joins
- SQL left, right, and reflexive joins |
SQL joins example code |
SQL CRUD |
Workshop - spreadsheets |
| 2/23 |
10 |
Workshop - SQL |
Workshop - SQL |
|
SQL joins |
|
| 2/28 |
11 |
Normalization |
Normalization |
- A Simple Guide to Five Normal Forms in Relational Database Theory
- Database Design, Chapter 12 |
|
|
| 3/2 |
12 |
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 |
Normalization |
Workshop - SQL |
| 3/7 |
n/a |
no class |
|
|
|
|
| 3/9 |
13 |
Workshop - database design |
Workshop - database design |
|
Entity-Relationship Diagrams |
|
| 3/14 |
n/a |
no class |
|
|
|
|
| 3/16 |
n/a |
no class |
|
|
|
|
| 3/21 |
14 |
Review |
Exam 1 review |
Exam Practice:
- Quiz
- GitHub Repository |
|
|
| 3/23 |
15 |
Exam 1 |
|
|
|
Workshop - database design |
| 3/28 |
16 |
MongoDB CRUD |
- MongoDB setup
- MongoDB CRUD |
Video: MongoDB setup
NYU CIMS documentation:
- MongoDB Database Management on CIMS
- Accessing MongoDB on CIMS
MongoDB documentation:
- MongoDB CRUD Operations
- MongoDB db.collection.find() |
|
|
| 3/30 |
17 |
MongoDB CRUD |
MongoDB aggregation |
MongoDB documentation:
- MongoDB Data Model Design
- MongoDB Data Model Examples and Patterns |
|
|
| 4/4 |
n/a |
no class |
|
|
|
|
| 4/6 |
18 |
Workshop - MongoDB |
Workshop - MongoDB |
|
MongoDB CRUD |
|
| 4/11 |
19 |
Web apps |
- The Web
- Intro to HTML |
|
|
|
| 4/13 |
20 |
Web apps |
Pymongo & flask |
Flask & pymongo documentation:
- Flask Quickstart
- Pymongo tutorial |
|
Workshop - MongoDB |
| 4/18 |
21 |
Workshop - web apps |
Workshop - Web app |
|
Web apps |
|
| 4/20 |
22 |
Jupyter notebooks |
Jupyter Notebooks |
|
|
|
| 4/25 |
23 |
Pandas |
- Pandas
|
- 10 minutes to Pandas
- Example Jupyter notebooks |
|
|
| 4/27 |
24 |
Data visualization |
|
|
|
Workshop - web app |
| 5/2 |
25 |
Workshop - pandas |
Workshop - pandas |
|
Pandas |
|
| 5/4 |
26 |
Review |
Exam 2 review |
|
|
Workshop - pandas
(No late work accepted beyond this date.) |
| 5/10 @2-3:50PM |
27 |
Exam 2 |
|
|
|
|