ISS8AC | 6ICI284B | Duration : 21 hoursDatabase 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 : | ||||||||
|
|
|
|
|
Historique de la page
Vue d'ensemble
Gestion des contenus
Activité