ECAM ENGINEERING PROGRAM
Combined Bachelor's / Master's Degree
General Data
Academic program ECAM ENGINEERING PROGRAM :
Type d'EC Classes
Lectures : 2h00
Tutorials : 2h00
Total duration : 8h00
Status :
Period :
Semester 3
Education language :
English
Learning Outcomes
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
Pre-requisites / co-requisites
None
Bibliography
ECAM Bibliography
Assessment(s)
Nature Coefficient Observable objectives
1Project1