Topic outline
-
The course will be entirely in the lab
Exam
A written exam on the DB part (33% of the final grade), and a small group (max 3 students) project (67% of the final grade). The project will be published just after the last lecture.
Some older written exams are 2020-01 2020-02 2020-03
Written Exam during the pandemics
During the pandemics, the written exam will be via Zoom (or another suitable conference tool). You will receive the link for the connection the day before the exam. Each student will (1) have an ID card ready, (2) leave the microphone and the webcam on for the entire duration of the exam. The professor and the helpers might ask any student to show the surroundings.
You have to use your real name inside Zoom.
You will write the SQL query in a form. The exam will be taken via moodle and you will have an hour to complete the exam, starting from the time you read the exam.
Teaching material
- Pensare in Python o Python for Everybody
- Python Data Science Handbook
- Think stats
- Python for everybody
- Basi di dati, Modelli e Linguaggi di interrogazione”, Atzeni, Ceri, Paraboschi, Torlone, McGraw-Hill. Course on Data Base Modeling
Other resources
Software download: Python (Anaconda), SQLite, SQLite browser
Lectures
The lectures will by via zoom, following the link to lectures.
-
URL
Chat used for all discussions that are relevant to the course (lecture hours, lecture topics, exam, etc.)
-
[30/09] Introduction to the Jupyter Notebook, Array, lists, loops, dictionaries. Reading files, functions, and libraries.
-
-
[02/10] Separator-based files. Relational model DBMS. Schemas and instances. Exploring a DB. Constraints, Keys, Indices. Null values.
-
URLLists: solution URL
-
URLDictionaries URL
-
URLFiles URL
-
-
URLBooks URL
-
URLSolution URL
-
-
Kaltura Video Resource
-
-
URLSolution: German elections URL
-
-
URLSolution: German elections (pandas) URL
-
-
-
URLSolution: Join URL
-
URLSolution: Set operations URL
-
-
URLSolution: Saturday Night Live 1 URL
-
URLSolution: Saturday Night Live 2 URL
-
-
URLSolution: Apache URL
-
-
URLSolution: Nested queries URL
-
FeedbackFeedback: Nested queries
-
URLSolution: Employees URL
-
FeedbackFeedback: Employees
-
-
FeedbackFeedback: unittest 2
-
-
URLSolution: Formula 1 URL
-
FeedbackFeedback: F1
-
-
URLSolution: FIFA 18 URL
-
-
URLSolution: Happyness URL
-
FeedbackFeedback: Happyness
-
-
URLSolution: TED URL
-
FeedbackFeedback: TED