LEARNING FORMAT

100% ONLINE

EUROPEAN CREDITS

6 ECTS

CERTIFICATION

ORACLE & ESTIA

DURATION

3 MONTHS

OVERVIEW

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.
⚠️ Please ensure that you meet the required level before enrolling in this program. This will ensure you can fully benefit from this enriching experience. Note that, for administrative reasons, no refunds will be issued once the registration is confirmed.

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.