This Companion is designed for IT professionals looking to specialise in the design and administration of large-scale data architectures.

"Big Data SQL", taught by Professor Serge Miranda, starts from Codd's relational model and goes through SQL2, SQL3, OQL, NoSQL and NewSQL to vector databases.

"NoSQL and Data Lakes", taught by Professor Gabriel Mopolo, covers NoSQL databases — Oracle NoSQL, MongoDB — and the construction of data lakes with Big Data SQL.

"Distributed Big Data Management", taught by Professors Serge Miranda and Sergio Simonian, covers Big Data paradigms, graph and vector query languages, and distributed processing with Map/Reduce, Hadoop and Spark.

On the Oracle side, "Become an OCI Architect Associate" covers the design of architectures on Oracle Cloud Infrastructure: identity and access management, networking, compute and storage. "Become an Oracle Autonomous AI Database Professional" covers the operation of Oracle Autonomous Databases: provisioning, monitoring, tuning, security, backup and recovery. "Become an OCI Data Science Professional" covers the full machine learning lifecycle on OCI.

✅ On completing the Companion, you validate 12 ECTS corresponding to credits from the BIHAR Master of Science, and you may sit the Oracle Cloud Infrastructure Architect Associate (1Z0-1072-26), Oracle Autonomous AI Database Professional (1Z0-931-26) and OCI Data Science Professional (1Z0-1110-26) certifications. The OCI Architect Associate exam is free.

⚠️ Please make sure you meet the required level before enrolling in this programme. This will ensure you can fully benefit from the experience.  

🛑 This program is only available in French for French speakers 🛑

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

Academic courses 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.

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

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

NoSQL and Data Lakes (⌛ 30 hours):

Module 1: Recap of Big Data concepts and NoSQL databases
Module 2: Introduction to Oracle NoSQL
Module 3: Oracle NoSQL and the key/document model
Module 4: Introduction to MongoDB and MongoShell
Module 5: Introduction to MongoDB and its Java API
Module 6: Big Data architectures and building data lakes with Big Data SQL

Distributed Big Data Management (⌛ 30 hours):

Module 1: Big Data and AI concepts
Module 2: Disruptive concepts in the data economy
Module 3: NoSQL and vector databases
Module 4: Map/Reduce
Module 5: Hadoop
Module 6: Advanced Hadoop and Spark

Become an OCI Architect Associate (⌛ 27 hours) — free course and exam:

Design a secure OCI network and identity management, implement OCI compute services, deploy and manage block, object and file storage, apply architecture principles to secure and scalable environments.

Certification: Oracle Cloud Infrastructure Architect Associate (1Z0-1072-26)

Become an Oracle Autonomous AI Database Professional (⌛ 11 hours) — Oracle Learning Subscription required:

Provision and configure Autonomous Databases, manage operations, monitoring and maintenance, optimise and size databases for performance, implement security, automation and backup/recovery.

Certification: Oracle Autonomous AI Database Professional (1Z0-931-26) — 245 USD exam

Become an OCI Data Science Professional (⌛ 17 hours) — Oracle Learning Subscription required:

Identify the OCI services needed for an ML solution, use OCI Data Science end to end, register, deploy and monitor models, automate pipelines and apply MLOps practices.

Certification: OCI Data Science Professional (1Z0-1110-26) — 245 USD exam

1. Big Data SQL:

✔️ Master SQL extensions from Codd's relational model to SQL3 and vector databases.
✔️ Understand the NoSQL and NewSQL paradigms and their use cases.
✔️ Position data systems by paradigm (ACID, BASE, CAP theorem).

2. NoSQL and Data Lakes:

✔️ Understand the characteristics of Big Data and the limits of relational databases.
✔️ Master NoSQL databases such as Oracle NoSQL and MongoDB.
✔️ Build and manage virtual and physical data lakes with Big Data SQL and ETL/ELT tools.
✔️ Prepare data for analysis using statistical and AI tools.

3. Distributed Big Data Management:

✔️ Master SQL extensions for structured, semi-structured and unstructured data.
✔️ Understand graph query languages (GQL) and polystores.
✔️ Implement distributed processing frameworks such as Hadoop and Spark.

4. Become an OCI Architect Associate:

✔️ Design a secure OCI network and identity management.
✔️ Implement OCI compute services.
✔️ Deploy and manage block, object and file storage.
✔️ Apply architecture principles to secure and scalable environments.

5. Become an Oracle Autonomous AI Database Professional:

✔️ Provision and configure Oracle Autonomous Databases.
✔️ Manage operations, monitoring and maintenance.
✔️ Optimise and size databases for performance.
✔️ Implement security, automation and backup/recovery.

6. Become an OCI Data Science Professional:

✔️ Use OCI Data Science across the full machine learning lifecycle.
✔️ Register, deploy and monitor models.
✔️ Automate pipelines and apply MLOps practices.