LEARNING FORMAT

100% ONLINE

EUROPEAN CREDITS

6 ECTS

CERTIFICATION

ORACLE & ESTIA

DURATION

3 MONTHS

OVERVIEW

🚦 Enrollments will open on Monday, March 3rd, for the first learning session 🚦

This advanced program offers comprehensive training on relational and object-oriented databases, with a focus on the SQL language and its evolution towards SQL3. You will also learn how to use SQL in an Oracle Cloud environment for modern applications.

The first course, "Relational and Object SQL Programming", covers the fundamentals of relational and object databases. You will explore key concepts from Codd's relational model, the limitations of SQL2, and the innovations introduced by SQL3 to integrate object-oriented concepts. This course also introduces the basics of NoSQL systems for unstructured data and the functional principles of Hadoop/MapReduce.

The second course, "SQL on Oracle Cloud", introduces you to using SQL in an Oracle Cloud environment. You will learn how to retrieve, manipulate, and manage relational data with Oracle Autonomous Database while developing skills to write complex queries and manage schema objects.

✅ Learners who successfully complete the exams for these courses will obtain the Oracle Database SQL Specialist certification and earn 6 ECTS credits corresponding to credits from the Master of Science BIHAR.

PRE-REQUISITES

Entry Requirements:

  • A Master's degree in Computer Science or equivalent.
  • Basic knowledge of relational databases and programming languages.
  • Have a good level of computer English
⚠️ Please ensure that you meet the required level before enrolling in this program. This will ensure you can fully benefit from this enriching experience. 

COURSES

All courses are offered as MOOC videos, providing you with complete flexibility in your learning experience.

The course "Relational and Object SQL Programming" is delivered on the Moodle platform, managed by Datum Academy. It includes instructional videos, downloadable course materials, and detailed practical exercises. This format is designed to help you easily grasp concepts and apply them to real-world projects.

The Oracle course "SQL on Oracle Cloud" is accessible directly on the Oracle platform. It features interactive videos and resources specifically designed to prepare you for the official certification.

Relational and Object SQL Programming (⌛ 30 hours) :

  • Module 1: Data Paradigms & Codd's Relational Model for Structured Databases
  • 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
SQL on Oracle Cloud (⌛ 16 hours) :

Module 1 : Reporting Aggregated Data Using the Group Functions
Module 2 : Using Set Operators
Module 3 : Introduction to Data Dictionary Views
Module 4 : Creating Views
Module 5 : Manipulating Data by Using Subqueries
Module 6 : Managing Data in Different Time Zones

SKILLS TO MASTER

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 the relational algebra language while recognizing its limitations.
✔️ Explore the integration of object concepts in SQL3 and analyze the two main approaches (Date and Stonebraker's manifesto).
✔️ Manipulate objects in SQL3 using CREATE TYPE, REF, and dereferencing joins.
✔️ Understand and compare NoSQL systems for managing unstructured data.
✔️ Explore the functional principles of Hadoop and MapReduce for processing large volumes of data.

2. SQL on Oracle Cloud (Oracle):

✔️ Retrieve data from tables using the SELECT command.
✔️ Create reports with sorted and filtered data.
✔️ Use SQL functions to generate custom data.
✔️ Write complex queries to manipulate multiple tables simultaneously.
✔️ Execute DML (Data Manipulation Language) statements to update data in a database.
✔️ Create and manage schema objects using DDL (Data Definition Language) statements.

FEES

Price with Certification
600 € (VAT included)

FAQ

This program is designed for individuals who already hold a Master’s degree in Computer Science or an equivalent qualification. It requires basic knowledge of relational database, programming languages, and a good level of technical English.
The program is certified. If you successfully pass all the course exams, you will earn the Oracle Database SQL Specialist certification and validate 6 ECTS credits, which count towards the Master of Science BIHAR.
The program is designed to be completed in its entirety.
The estimated duration for completing the program is three months. However, the academic courses are fully flexible, so you can take longer if needed. If you require more than three months, we recommend starting with the Oracle courses first, as they have a fixed access duration, and then progressing at your own pace with the academic courses.
Both academic and Oracle exams are in the form of multiple-choice questions (MCQs) with online proctoring.
If you have not received your access credentials by the day before the session starts, please contact our support team at contact@datum.academy.
No refunds are granted after the 14-day withdrawal period has expired. However, free access to upcoming undergraduate-level courses (Bachelor’s level) will be available in 2026 (without certification exams). If interested, please reach out to be added to the interest list.
There are no financing options available. However, if an employer wishes to pay for the training fees outside of our website’s Paybox system, they can contact contact@datum.academy, and an invoice will be issued for payment processing.
A forum is available within the Moodle space for each academic course, where learners can ask questions and collaborate. Peer support is strongly encouraged. For Oracle courses, a chat feature is available for inquiries.
There is no personalized support currently. However, a digital chatbot tutor is being developed and will soon be available to assist learners.
The ECTS (European Credit Transfer and Accumulation System) allows students to accumulate academic credits. Successfully completing the academic courses in this program enables you to waive these courses if you choose to pursue the Master BIHAR or eBIHAR (distance learning format). Additionally, the credits earned can be accumulated to ultimately obtain the Master's degree by validating the required competency blocks.