General Information
Lecturers: Daniele Apiletti, Diego Monti
Teaching staff: Alessandro Fiori, Simone Monaco
SSD: ING-INF/05 – CFU: 8 – course details from the official student guide
Q&A teaching assistance on Piazza: piazza.com/polito.it/fall2023/01txasm
đź“° News
- We are using Piazza for class discussion. We invite all students to join the course Piazza. Piazza is highly suggested to get help fast and efficiently from classmates and teachers. Rather than emailing questions to the teaching staff, students are invited to post their questions on Piazza.
đź“’ Teaching material
Course introduction (slides)
- Non-relational databases for data management – introduction (slides)
- Introduction to MongoDB, collections, create, delete, GUI (slides)
- MongoDB, querying data, find operator, aggregation pipeline (slides)
- MongoDB aggregation examples, indexes (slides)
- Distributed Data Management, replication, and the CAP theorem (slides)
- MongoDB replica set (slides, updated Nov 18)
- Distributed transactions (slides)
- Distributed data processing and Map Reduce (slides)
- NoSQL design recipe (slides)
- MongoDB design patterns part 1 (slide)
- MongoDB design patterns part 2 (slide)
🗒️ Exercises
- Exercise extended SQL, customers (text, solution)
- Exercise extended SQL, rentals (text, solution)
- Exercise DW design, hotels (text, solution)
- Exercise DW design, storehouses (text, solution)
- Exercise DW design, rentals (text, solution)
- Exercise DW design, parcels (text, solution)
- Exercise DW design, computer (text, solution)
- Exercise DW design, vehicle rental (text, solution)
- Exercise DW design, versioning services (text, solution)
- Exercise DW design, craft beer (text, solution)
- Exercise DW design, tickets (text, solution)
- Exercise DW design, food delivery (text, solution)
- MongoDB query exercises (slides)
- MongoDB query exercises IMDB (slides, IMDB database)
- MongoDB design pattern exercises 1 (slide)
- MongoDB design pattern exercises 2 (slide)
đź’» Laboratory material
The first lab is scheduled for Thursday, October 19
Students group | Time | Room |
TEAM A (FROM A TO K) | Thursday, 16:00 – 17:30 | LAIB2B |
TEAM B (FROM L TO Z) | Thursday, 17:30 – 19:00 | LAIB2B |
For Labs 1 and 2, you need to run Extended SQL on Oracle databases. SQL Developer is already available on the devices. If you want to practise at home (or on PoliTO devices as well), we suggest you configure its online version on Oracle Live SQL, in particular:
- You can add tables using SQL scripts
- A short guide on how to import SQL scripts and query the DB in Oracle Live SQL is available (pdf)
Lab 1: Extended SQL
- Text (pdf)
- Data warehouse tables (zip (CSV), zip (SQL))
- Solution (star schema, queries)
Lab 2: Extended SQL
Lab 3: Looker Studio
- Text (pdf)
Lab 4: MongoDB Compass
Lab 5: MongoDB replica set
Lab 6: Visualization analysis
- Solution (xlsx)
Lab 7: Redesign with Tableau
- Text (pdf)
- Solution (zip)
Lab 8: Visualization of a dataset
đź“„ Exam
- February 22th, 2023
- February 7th, 2023
- February 17th, 2022
- Feb 1st, 2021
- Feb 15th, 2021
- June 17th, 2021
- September 1st, 2021
- January 28th, 2022
- February 17th, 2022
- February 7th, 2023
- February 22th, 2023