Computer systems

Database systems (mySQL)

ER Model

Data warehousing

Data governance

Case studies

Data Definition Language

Data Modification Language

SQL in MySQL

SQL in Python

Covers content from the first half of the course

Take home (due in 12 hours) and open book/notes/web/ChatGPT

Class time will be used as an extended office hour

Coding basics

Python basics I (IDE, variables, data types, console I/O)

Python basics II (conditions, loops, lists, strings, dictionaries, files - csv, json, excel)

Error handling and debugging

Data Frames

Import/Export

Functions

Aggregation Functions

Data Slicing

Missing Data

Combining Data

Python code geenration (e.g.,  ChatGPT)

Generative AI (e.g., OpenAI) API

Generative AI applications

Intro to RPA

RPA using Python

RPA using UIPath

10-15 minute group presentation of insights extracted from data using SQL and/or Python

Datasets from Kaggle or an online channel will be selected and provided