Course Overview

The student will acquire the following skills:

- Implementing functionalities within database servers,
- Accessing database servers with any kind of programming language,
- Ensuring coherency when updating operations on a database as
regards transactions.

Learning Achievement

Competence

Course prerequisites

Basics for databases, SQL language.

Grading Philosophy

Assessment applicable at the end of the module, project-based in
collaboration with the Agile Methods course. 

Course schedule

Databases represent the powerful software that underlies contemporary
websites and applications. 2 DBMS (DataBase Management System) will be
considered in this class: ORACLE and SQL-Server.

A comparative study of these DBMS will be carried out for the
following:

- Database dictionary - Transactions, "all-or-nothing" proposition -
Internal languages (PL-SQL, TSQL) - Open Database Connectivity from
C# and JAVA - Object-Relational Mapping (Entity Framework and
Hibernate)

Course type

Lectures, seminars, exercises and projet. 

Online Course Requirement

Instructor

Other information

Duration: 36h
Study level: University Diploma in Technology
Language of instruction: English
Mode of delivery: In-class, face-to-face, project-based learning

Site for Inquiry