Description

The course is structured into several sections, covering:

1. Defining a Database Management System
2. The relational model and relational database querying
3. Database design and implementation
4. Developing web-based applications that interact with databases

Practical exercises accompany each section of the course, providing hands-on experience that reinforces theoretical concepts.

The course also introduces basic database administration concepts such as backup/restore, views, replication, indexing, and the role of a DBA (Database Administrator).

Finalité

The goal of this course is to design, implement, and utilize relational databases. In particular, students will learn to define a relational schema from a conceptual data model and use SQL. Topics include the installation, design, querying, and SQL programming for a Relational Database Management System (RDBMS).

Compétences visées

• Knowledge of relational database management systems (RDBMS)
• Proficiency in SQL and data-driven application development

Description des modalités d'évaluation

• Written exam
• Project