Schedule
Schedule for SDS 261, Data Science, the SQL, Interterm 2024, Smith College
Here’s your roadmap for the semester! Each day, follow the general process outlined below:
Enjoy the notes / text
Attend class, review the worksheet and solutions if you have any questions after working on it during class. Slides from class are linked below.
Complete the Lab assignment ( html linked below), submit the assignment to GitHub before 10am the following class period.
Discuss the reflection questions and ethics considerations (see the class notes) with your classmates and professor.
The textbooks are Modern Data Science with R (MDSR), 3rd edition by Baumer, Kaplan, and Horton and R for Data Science (R4DS), 2nd edition by Wickham, Çetinkaya-Rundel, and Grolemund.
| date | topic | in class | in lab | resources |
|---|---|---|---|---|
| Day 1 1.08.24 |
starting + R + RStudio + SQL + MySQL |
Introduction MDSR 15.1 R4DS 21.2 What is a DB? WS 1 |
Lab 1 | dbplyr package |
| Day 2 1.09.24 |
SQL clauses | SQL clauses MDSR 15.4 R4DS 21.5 SQL clauses WS 2 |
Lab 2 | |
| Day 3 1.10.24 |
Combining tables | SQL joins MDSR 15.4.7 R4DS 21.5.7 SQL joins WS 3 |
Lab 3 | |
| Day 4 1.11.24 |
Regular Expressions I | regex I MDSR 19 R4DS 15 regex I WS 4 |
Lab 4 | |
| Day 5 1.12.24 |
Regular Expressions II | regex II MDSR 19 R4DS 15 regex II WS 5 |
(no lab) | reg expr cheat sheet |
| Day 6 1.16.24 |
Creating a DB | creating databases MDSR 16.1.1 R4DS 21.4 creating databases WS 6 |
email prof with dataset idea for project Lab 5 |
|
| Day 7 1.17.24 |
Changing a DB | creating databases MDSR 16.1.1 R4DS 21.4 changing databases WS 7 |
Lab 6 | |
| Day 8 1.18.24 |
SQL extras | creating databases MDSR 16.1.1 R4DS 21.4 SQL extras WS 8 |
Project | |
| Day 9 1.19.24 |
Project | (no lab) |