Databases

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: 12h00	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.

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