ISS8AC Database Essentials
| ECTS Credits : 2 Duration : 21 hours | Semester : S8 | ||
Person(s) in charge : Bart LAMIROY, Associate Professor, bart.lamiroy@mines-nancy.univ-lorraine.fr | ||||
Keywords : Relational databases, SQL, normalized forms, PL/SQL, NoSQL | ||||
Prerequisite : Elementary algorithms, Imperative programming, some SQL notions are a plus | ||||
Objective: Acquiring the databases systems modelling fundamentals.
| ||||
1. introduction, issues, entity-association 2. Relational, transition entity-association 3. Normalized forms and coherent databases 4. Transactional model, ACID 5. Stocked procedures, triggers et PL/SQL 6. Distributed models 7. NoSQL
| ||||
Abilities: | ||||
Levels | Description and operationnal verbs | |||
Know | The underlying modelling mechanism, management, stocking and using big data, client relations | |||
Understand | the differences and complementarity between the data oriented modelling and the process oriented modelling (or algorithms) | |||
Apply | Scenarios and utilization modelling on concrete cases, with constraints of real situations | |||
Analyse | modelling problems related to database relational model | |||
Summarise |
| |||
Assess | The adequate modelling solutions, their qualities, their limits, their performances, and the relevancy of its usage | |||
Evaluations : | ||||
|
|
|
|
|