ECAM LaSalle Mechanical and Electrical Engineering Programme
General Data
Academic program ECAM LaSalle Mechanical and Electrical Engineering Programme Module Manager(s) :
BITAR Diala
EC Type : Lectures Databases (LIIEEng03EDatabases)
Tutorials : 2h00
Lab Work : 4h00
Lectures : 2h00
Individual work : 4h00
Total duration: 8
Status
Period
Semester 3
Teaching language :
English
General objectives
Databases are designed and filled with limits set by their designers. This database initiation training will allow you to understand what a database really is and how it differs from a simple file containing information.
The goal of this course is to become a generalist interlocutor able to discuss with all profiles (MOA, MOE, developers, DBA, users) while being operational on the essential SQL language.
Content
Introduction to Relational database
Models of database systems
Theory of database systems
Implementation of database systems
Introduction to SQL language
• Reminder on the relational model
• Characteristics of SQL

Query data
• Data selection
• Restrictions or conditions
• Sorts
• Joins
Corequis
None
Bibliographie
ECAM Bibliography
Assessment(s)
Nature Coefficient Observable objectives
1 1 Project