Professors
Learning Outcomes of this subject are:
R1. Understand the world of Databases
R2. Understand the Relational Model
R3. Learn the most popular query language for Databases (SQL)
R4. Practice with a real-world case project.
R5. Learn the basics of the most popular programming language for Data Analysis (Python)
First part of the semester:
- Introduction to Databases: understand the world of databases
- Relational Database Modeling: understand the relational database model
- Basic SQL: learn the basics commands of SQL
- Advanced SQL: learn the advanced commands of SQL
Project
- Data Analysis with a real world-case example (IMDB)
Second part of the semester:
- Introduction to Python: learn the basics of Python programming language
- Using SQL with Python: learn the use of SQL in Python
- Overview of NoSQL databases
The following table relates the learning outcomes to the content taught to achieve them:
R1: Understand the world of Databases - Introduction to Databases
R2: Understand the Relational Model - Relational Database Modeling
R3: Learn the most popular query language for Databases (SQL) - Basic and Advanced SQL
R4: Practice with a real-world case project - Project: Data Analysis using IMDB Database
R5: Learn the basics of the most popular programming language for Data Analysis (Python)
- Introduction to Python
- Introduction to SQL in Python
The evaluation system will be continuous combining several activities to facilitate the assimilation of knowledge by the student.
The following table shows the percentage of evaluation of each activity based on the final grade:
R1, R2, R3, R4, R5 Class Activity 15%
R3, R5 Homework 15%
R3 Mid-Term Exam 20%
R4 Project 30%
R5 Final Exam 20%
- Garcia Molina, Ullman and Widom, Database Systems - The Complete Book, Pearson (2009)
- Matthes, Eric - Python Crash Course (2016)
- Elder, John - Introduction to SQLite Databases for Python (2019)