Quick Finds:
Lecture Notes and Handouts:
Week 1
Day 1 – May 11
- Welcome to Belgium!
Day 2- May 12
- Morning
- Introduction to Databases in DS (DS3000 + CS3200)
- Intro to Python Tutorial Coming Soon (.zip file; download and unzip)
- Afternoon
- Project Kickoff
- Launching CS 3200
- The Relational Model
Day 3 – May 13
- Maria Martins Talk on the EU Structure and Functioning
- Visit to EU Parliament
Day 4 – May 14
- Setting Up Docker and MySQL
- Setting Up DataGrip (download installer > here <)
- Setting up Northwind Database (download > here <)
- Introduction to SQL DQL
- SQL DQL Part 2
- Topics:
- MySQL
- Docker
- DataGrip
- SQL SELECT Statements
Day 5 – May 15
- SQL SELECT Practice – HuskyGram
- Advanced Select Statements
- SQL DQL Part 3
Week 2:
May 18
- European Commission
- EEAS
May 19
- Wrap Up SQL SELECT Statements
- DDL Crash Course
May 20
- Brussels
May 21
May 22
Week 3
May 28
Project Docs:
Slide Decks
- How the Internet Works
- Jumping Into the Project Template Code Base
- Presenting to Seamus and the Profs
- Jupyter -> Streamlit + Data Viz
- Generating Mock Data