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) | |||
---|---|---|---|
N° | Nature | Coefficient | Observable objectives |
1 | 1 | Project |