Skip to main content

Ctrl+K

ADSC 3610 - Database Systems in Applied Data Science II - Syllabus

Part 1 - MongoDB

Lecture 1: Introduction to Non-Relational Databases
Lecture 2: Introduction to MongoDB and the document model
Lecture 3: MongoDB Atlas and connecting to MongoDB database
Lecture 4: Data modelling in MongoDB
Lecture 5: Schema design patterns in MongoDB
Lecture 6: CRUD operations in MongoDB
Lecture 7: Aggregation operations in MongoDB
Lecture 8: ACID transactions in MongoDB
Course recap MongoDB

Part 2 - PySpark

Lecture 9: Introduction to PySpark
Lecture 10: Resilient Distributed Datasets (RDDs) in Spark
Lecture 11: Spark Dataframes
Lecture 12: Spark DataFrame transformations
Lecture 13: Spark Structured Streaming
Lecture 14: Spark Structured Streaming (continued)
Lecture 15: Monitoring ML experiements with mlflow
Lecture 16: Model deployment with mlflow and streamlit

Part 3 - Data privacy, security, and ethics

Lecture 17: Data privacy laws
Lecture 18: Failures in data privacy
Lecture 19: Bias and fairness in ML
Lecture 20: Research in Bias and fairness in ML

Midterms Information

Midterm 1 instruction

Installation Guide

Installation instruction for macOS
Installation instruction for Windows

Worksheet solution

Worksheet 1: Introduction to noSQL databases and document model with MongoDB
Worksheet 2: Data modelling with MongoDB
Worksheet 3: CRUD operations in MongoDB

Index

By Quan Nguyen

© Copyright 2023.