Databases

About this course

This course is an introduction to relational databases. Aimed at students who are comfortable with programming, it reviews database design, SQL queries, and even more advanced aspects: triggers, elements of no-SQL databases. It is part of the Master of science “Internet of things”.

Expected learning outcomes

At the end of this course, engineering students will be able to:
· Understand how a processor architecture works
· Choose a hardware architecture
· Understand the advantages of integration: consumption, dimensions, reliability, …
· Realize the acquisition of a sensor data
· Manage asynchronous events, Implement a serial communication

Indicative Syllabus

Syllabus:
Relational databases (entity-relationship model)
SQL (structured query language), illustrated through MySQL
– data definition: create/modify the structure the database structure
– data manipulation: add/delete/update the content of the database
– data query: extract information
Triggers
Towards big data: an introduction to Map Reduce

Teaching / Learning Methodology

In-person teaching: 13hrs (6 lectures + 7 lab sessions)
Free labs: 7hrs, plus a short project

Recommended Reading

TBA