| Course label : | Databases |
|---|---|
| Teaching departement : | EEA / Electrotechnics - Electronics - Control Systems |
| Teaching manager : | Mister PIERRE-ANTOINE THOUVENIN / Mister PIERRE CHAINAIS |
| Education language : | |
| Potential ects : | 0 |
| Results grid : | |
| Code and label (hp) : | MR_DS_S1_DBA - Databases |
Education team
Teachers : Mister PIERRE-ANTOINE THOUVENIN / Mister PIERRE CHAINAIS
External contributors (business, research, secondary education): various temporary teachers
Summary
The course will cover the following topics: • Reminder about SQL, relational algebra and logic • Indexes and materialized views: advantages, drawbacks and when to use them • Using various kinds of indexes in the design of a database, • Physical plan of a query execution and the evaluation of its incurred cost, • Logical plan and optimization of a query and their cost models, • Query tuning.
Educational goals
At the end of the course, a successful student should be able to master the main techniques and algorithms that allow relational databases to handle efficiently large amount of data. These methods form the bases of systems that handle larger amounts of data. After attending this course the successful student will be able to: • Understand the relationship between relational algebra, logic, SQL, • Write complex queries, • Use methods to improve the performance of a database, • Know various structures of indexes and when to use them, • Understand how queries are compiled, optimized and executed, • Tune queries so as to make them more efficient.
Sustainable development goals
Knowledge control procedures
Continuous Assessment
Comments: Labs, grading scale: (min) 0 – 20 (max)
Exam, grading scale: (min) 0 – 20 (max)
Average passing grade = 10/20
Online resources
“Database systems, the complete book”, second edition, H. Garcia-Molina, J. D. Ullman, J. Widom “Database management systems”, third edition, R. Ramakrishnan, J. Gehrke “Database system concepts”, sixth edition, A. Silberschatz, H. Korth, and S. Sudarshan
Pedagogy
24 hours, 6 lectures 6 exercises Language of instruction is specified in the course offering information in the course and program directory. English is the default language.
Sequencing / learning methods
| Number of hours - Lectures : | 12 |
|---|---|
| Number of hours - Tutorial : | 12 |
| Number of hours - Practical work : | 0 |
| Number of hours - Seminar : | 0 |
| Number of hours - Half-group seminar : | 0 |
| Number of student hours in TEA (Autonomous learning) : | 0 |
| Number of student hours in TNE (Non-supervised activities) : | 0 |
| Number of hours in CB (Fixed exams) : | 0 |
| Number of student hours in PER (Personal work) : | 0 |
| Number of hours - Projects : | 0 |
Prerequisites
Introductory knowledge in SQL, programming and in algorithms.