DBMS project

School / Prep
ENSEIRB-MATMECA

Internal code

EIN7-PROJ2

Description

The practical sessions take place on the Oracle system. These sessions enable students to better understand the course and the Tds, and to test SQL queries. At the end of the practical sessions, a project allows students to simulate a database application, from design to implementation.
Plan

Presentation of ORACLE
Presentation of MySQL
Architecture
SQL, SQLPLUS
SQL-host language interface
PL/SQL
Oracle project

Competencies
C2. Level 2C3. Level 2C4. Level 2C7. Level 2C8. Level 2C12. Level 2

TDTutorial20h
TIIndividual work30h

Mandatory prerequisites

Algorithms I1A, I2A

Syllabus

- ORACLE overview
- MySQL overview
- Architecture
- SQL, SQLPLUS
- SQL-host language interface
- PL/SQL
- Oracle project

Bibliography

Oracle documentation available, copy of slides.

Initial assessment / Main session - Tests

Type of assessment	Type of test	Duration (in minutes)	Number of tests	Test coefficient	Eliminatory mark in the test	Remarks
Project	Minutes			1