Database systems are used for storing and maintaining any sort of data, providing convenient access to them through efficient query processing.
This course aims to give fundamental knowledge about databases, with particular attention to relational models. Students will learn how to design a relational database, using established methods such as E/R diagrams, and implement them. In addition, this course will offer an extensive presentation of SQL query languages.
Teaching and Learning Methods: Lectures (with in-class exercises) and individual practical labs.
Course Policies: Mandatory attendance at practical sessions.
During the course, we will cover several chapters in the textbook:
- Book: RAMAKRISHNAN R., GEHRKE J. Database Management Systems. 3rd edition, McGraw-Hill, 2002, 1104p.
When needed, suggested books and/or research articles will be reported in class.
Basic knowledge of maths, computer science and coding.
The course will cover the following topics:
- Introduction to database systems
- Database Design Principles
- E/R Diagrams
- SQL language: instructions for querying the database
- SQL language: instructions for creating and manipulating tables
- Relational Design
- Introduction to NoSQL databases
Learning outcomes:
- Learn the fundamental aspects of database management systems
- Obtain competencies in designing relational databases
- Learn and practice SQL for querying databases
Nb Hours: 21,00
Evaluation:
- Exercises during the lesson (25 % of the final grade)
- Final written exam (75 % of the final grade).
