Relational Databases

Objectives

Know the different ways of storing data, the types of databases ; Know the principles of relational databases ; Know how to use the SQL language ; Know how to model and build a clean database that respects normal forms

Course outline

Table, records, attributes, types, primary key, foreign key ; Database Management System ; CRUD (Create Read Update Delete) ; Joins, association types ; Aggregations ; Relational algebra ; Views, Indexes, Transactions, Trigger, Rights management ; UML modeling, logical model, physical model

Prerequisites

None