 | Study programme 2019-2020 | Français | |
| Databases I (part A) | |||
Learning Activity |
| Code | Lecturer(s) | Associate Lecturer(s) | Subsitute Lecturer(s) et other(s) | Establishment |
|---|---|---|---|---|
| S-INFO-100 |
|
|
| Language of instruction | Language of assessment | HT(*) | HTPE(*) | HTPS(*) | HR(*) | HD(*) | Term |
|---|---|---|---|---|---|---|---|
| Français | Français | 0 | 15 | 0 | 0 | 0 | Q1 |
| Organisational online arrangements for the end of Q3 2019-2020 assessments (Covid-19) |
|---|
|
| Description of the modifications to the Q3 2019-2020 online assessment procedures (Covid-19) |
| Quiz in Moodle |
Content of Learning Activity
Relational databases.
Basic SQL instructions.
MySQL environment.
Data selection and sorting, junction tables, functions, groups.
Subqueries (simple, complex, correlated)
Data manipulation language, transactions, constraints.
Views.
Security basics.
Required Reading
Travaux Pratiques - Travaux pratiques de Bases de données I (SQL) - Alain Buys
Required Learning Resources/Tools
Not applicable
Recommended Learning Resources/Tools
www.mysql.org
Other Recommended Reading
Not applicable
Mode of delivery
- Face to face
Type of Teaching Activity/Activities
- Travaux pratiques
- Travaux de laboratoire
- Exercices de création et recherche en atelier
- Projet sur ordinateur
- Etudes de cas
Evaluations
The assessment methods of the Learning Activity (AA) are specified in the course description of the corresponding Educational Component (UE)
(*) HT : Hours of theory - HTPE : Hours of in-class exercices - HTPS : hours of practical work - HD : HMiscellaneous time - HR : Hours of remedial classes. - Per. (Period), Y=Year, Q1=1st term et Q2=2nd term