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)

:::