This course repeats the course on databases seen in the second year of CIR. It starts with some reminders on the SQL language, presents new operators (WITH, hierarchical SQL queries),
shows how to model a database using the Merise method, and how to normalize a relational schema. The course ends with the presentation of the principles of concurrency.
The practical course is conducted under Linux. Each student uses a client-side software, and connects to his own database on a centralized server. To illustrate concurrency, a specific database is used, to which all students are connected simultaneously.