This course provides a comprehensive introduction to database systems, emphasizing both theoretical foundations and practical applications. Topics include logical models of databases, relational algebra, and database design principles such as functional dependencies. Students will gain proficiency in Structured Query Language (SQL), covering both basic commands and advanced queries. Additional topics include views, triggers, functions, and stored procedures within database management systems. The course also explores indexing structures for physical database design. Students will develop skills to translate relational algebra into SQL and design efficient database solutions.

Temps présentiel : 30 heures

Charge de travail étudiant : 70 heures

Méthode(s) d'évaluation : Examen final, Examen partiel, Travail personnel