This Companion covers relational and object databases, with the SQL language as its through-line, from SQL2 to SQL3 and on to NoSQL systems.

The first course, "Relational and Object SQL Programming", taught by Professor Serge Miranda, covers Codd's relational model, normalisation, ACID properties, SQL level 2 and PL/SQL, then introduces SQL3 and the object-relational model through the manifestos of Date and Stonebraker and the ODMG.

The second course, "Big Data SQL", taught by Professor Serge Miranda, extends those foundations towards Big Data paradigms, NoSQL and NewSQL systems, and vector databases.

On the Oracle side, "Oracle AI Database SQL Associate" goes deeper into SQL on Oracle Database 23ai: the SELECT statement in detail, data types and functions, DML and DDL statements, set operators, object management and user access control.

"Become an Oracle AI Database Foundations Associate" explores the Oracle Autonomous AI Database: converged data management, vector search, JSON and graph data, Oracle Data Studio and APEX development.

✅ On completing the Companion, you validate 6 ECTS corresponding to credits from the BIHAR Master of Science, and you may sit the Oracle AI Database SQL Associate (1Z0-171) and Oracle AI Database Foundations Associate (1Z0-1195-26) certifications. The second exam is free.

All academic courses are offered as MOOC videos, giving you complete flexibility in your learning journey.

The courses "Relational and Object SQL Programming" and "Big Data SQL" are delivered on the Moodle platform, managed by Datum Academy. You will find instructional videos, downloadable course materials and detailed case studies. Academic exams are taken online, remotely proctored by ProctorExam.

The Oracle learning paths are accessible on the Oracle MyLearn platform. Official path and certification titles are in English; the courses are generally multilingual.

Relational and Object SQL Programming (⌛ 30 hours):

Module 1: Database concepts and Codd's relational model (ACID, TIPS)
Module 2: Design, access methods, OLAP
Module 3: Introduction to SQL2 (views, transactions, data warehouse)
Module 4: The third manifesto of Chris Date and Mike Stonebraker — the hybrid object-relational model
Module 5: Introduction to ODMG and OQL
Module 6: Introduction to SQL3
Module 7: Towards NoSQL and vector databases

Big Data SQL (⌛ 30 hours):

Module 1: Big Data paradigms and Codd's relational model
Module 2: Introduction to SQL2
Module 3: Chris Date and Mike Stonebraker's manifestos on the object-relational model
Module 4: Introduction to ODMG and OQL
Module 5: Introduction to SQL3
Module 6: NoSQL and NewSQL
Module 7: SQL and vector databases

Oracle AI Database SQL Associate (⌛ 29 hours) — free course access:

Write SQL queries (SELECT, joins, grouping, subqueries), manipulate data with DML statements, use string, date, numeric and conversion functions, create and manage objects with DDL statements and control access.

Certification: Oracle AI Database SQL Associate (1Z0-171) — 245 USD exam

Become an Oracle AI Database Foundations Associate (⌛ 5 hours) — free course and exam:

Understand the fundamentals of the Autonomous AI Database and its autonomous operations, manage multi-model data (JSON, graph, vectors), use Oracle AI Vector Search and Data Studio, discover Oracle Machine Learning and APEX.

Certification: Oracle AI Database Foundations Associate (1Z0-1195-26)

1. Relational and Object SQL Programming (ESTIA):

✔️ Identify and manage different data types: structured, semi-structured and unstructured.
✔️ Understand the fundamental concepts of Codd's relational model and their application in SQL.
✔️ Master SQL2 as a wrapper for relational algebra while recognising its limitations.
✔️ Explore the integration of object concepts in SQL3 and analyse the two main approaches (the Date and Stonebraker manifestos).
✔️ Manipulate objects in SQL3 using CREATE TYPE, REF and dereferencing joins.
✔️ Write PL/SQL and understand normalisation and ACID properties.

2. Big Data SQL (ESTIA):

✔️ Understand and compare NoSQL and NewSQL systems for unstructured data.
✔️ Master SQL extensions up to vector databases.
✔️ Position data systems by paradigm.

3. Oracle AI Database SQL Associate (Oracle):

✔️ Retrieve data from tables with the SELECT command.
✔️ Build reports with sorted and filtered data.
✔️ Use SQL functions to generate custom data.
✔️ Write complex queries across multiple tables.
✔️ Run DML statements to update data in a database.
✔️ Create and manage schema objects with DDL statements.

4. Become an Oracle AI Database Foundations Associate (Oracle):

✔️ Understand the fundamentals of the Autonomous AI Database.
✔️ Manage multi-model data: JSON, graph and vectors.
✔️ Use Oracle AI Vector Search and Data Studio.
✔️ Discover Oracle Machine Learning and APEX development.