Bases de Dados / Databases 🧮

2nd Year - 1st Semester

Course completion:

Course Program:

1. General Database Concepts

1.1. Data and Information Systems

1.2. Technologies and Applications

1.3. Database Management Systems

2. Data Modeling

2.1. Data modeling process

2.2. Relational Data Model

2.3. Functional dependencies and normalization

2.4. Data integrity

3. Definition and manipulation of data

3.1. Structured Query Language (SQL)

3.2. DDL - Data Definition Language

3.3. DML - Data Manipulation Language

3.4. DCL - Data Control Language

4. Transactions

4.1. Database transaction concept and desirable properties

4.2. Concurrent access to data

5. Constituent objects and database programming

5.1. Structural: table, index, sequence, view

5.2. Behavioral: trigger, stored procedure, function

5.3. Oracle Data Dictionary