DS3002 Data Science Systems

Jason Williamson email
School of Data Science
University of Virginia, Spring 2021

Course Schedule

# Date Topics(s)
Read / Watch / Labs
00
Student Survey
Take the Survey
01 01/29/2022 Course introduction: Data Engineering Basics
Netflix Data Analytics
Data Engineering - Parts I/II/III
Labs
Install MySQL (your choice) or
Install MySQL Workbench
Intro to Gitk
02 1/24/2022 Intro to Databases, Design of Relational Databases
Intro to SQL Slides
Handout txt files for class
MySQL Cheat Sheet
Additional Data Assets
03 1/31/2022 Introduction to SQL


04 2/7/2022 Hands on SQL with Python

Python Basics Intro
Python and Kaggle
Intro to Python Book
 
SQL Lite Python Code Examples
 

2/14/2022 Lab 2
Grab the lab

2/14/2022 Data Warehouse and OLAP
OLAP Reading






2/21/2022 Quiz 1 Released -> It is live in Collab Project One Live
Grap the project
07 2/28/2022 Consuming APIs
What is an API?
API Overview
Github API + Data Science
JSON Overview
GitHub API
08 3/14/2022 NoSQL & Unstructured Data

Intro to NoSQL
MongoDB in 30 Minutes
Hands-On MongoDB

3/16/2022 Project Due
Take the Quiz
10 3/21/2022 Catch up/Hands on NOSQL


3/23/2022 Quiz 2 Released(DELAYED. Working on AWS/Cloud S3)
AWS Labs /b>

4/4/2022 Data Lakes With Data Bricks & Delta Lakes

https://www.youtube.com/watch?v=y91r_DLMEq8
13 4/11/2022 Putting it all together | Project 2 Release (Due May 7th @ Noon)


4/13/2022
Take the Quiz(Optional)
14 4/18/2022 Wrapping Up


5/2/2022 Last Class
Want more labs?