You are here: Home > GRADEO 1

GRADEO DATA BASE FUNDAMENTALS AND SQL PROGRAMMING

GRADEO DATA BASE FUNDAMENTALS
AND SQL PROGRAMMING - 499€ TTC

Databases contain a big part of the world's data. SQL (Structured Query Language) is a must to communicate with & extract data from databases. Build your skills now if you want to become a data scientist.

 Duration : 17 weeks        Effort : 6 hours/week

What skills will you learn ?

By the end of this GRADEO, you will:


 
Master the concepts of the relational data model underlyingSQL standard, SQL2 and SQL3 (Codd's theorem on relational algebra; Gray's theorem on transactions, OLAP, ).

 Master SQL2 for relational data bases (definition, manipulation and control).


 Master SQL3 for object-relational data models (Date's manifesto) with the integration of pointers within tables of values.


Dates

2 Nov 2020 - 8 Mar 2021

Registration

14 Oct 2020 - 9 Nov 2020

Language

English

Price

499 €

Syllabus

This GRADEO is composed of 2 courses:


 1 academic course from ESTIA: OBJECT-RELATIONAL DATA BASES
AND SQL STANDARD 


 1 course from ORACLE University: ORACLE SQL EXPERT


2 Nov 2020 - 8 Mar 2021

Registration

14 Oct 2020 - 9 Nov 2020

Language

English

Price

499 €

Dates

OBJECT-RELATIONAL DATA BASES AND SQL STANDARD 

This SQL programming course includes three major parts :
I- the relational data base model (with Codd's theorem, the relational algebra supporting SQL , data normalization, OLAP , B-tree implementation of relations).

II- the SQL2 presentation (definition, manipulation and control).

III - the SQL3 (and OQL) presentation corresponding to object-oriented data stores (with the thirsd manifesto from Chris Date).

Dates: 2 Nov 2020 - 11 Dec 2020


ORACLE SQL EXPERT

SQL is the language you use to interact with a database, which is an incredibly valuable and highly sought after skill in today's digital world. As organizations seek to do more with their data, they need more professionals who can access and analyze that data.

SQL is the skill that enables you to do just that. With this Oracle SQL expert course, you'll have everything you need to start down the path of becoming a SQL developer.

With this course you'll learn the fundamentals about the SQL language, and how to use SQL to query, retrieve, and modify data within a database.

Also included are practice exercises and valuable information to help you to prepare for the Oracle SQL Certified Associate exam.

Self-paced: 2 Nov 2020 - 8 Mar 2021


Prerequisites

Learners should master basic mathematics (set theory) and computer science (bachelor level).

Assessment and certification

The learner will take an exam at the end of each course. Upon successful completion of these exams, he will get a GRADEO certificate delivered by  ESTIA (recognised by 3 ECTS) along with the Oracle certification.

Course team

Serge Miranda

Serge Miranda Professor at University Cote d'Azur (UCA). Founder of MBDS Master at UCA and BIHAR Master at ESTIA.

License

License for the ESTIA course content

License Creative Commons BY NC ND : the user must mention the author's name, he may exploit the work except in a commercial context, he can not create a work derived from the original work.

License for the ORACLE course content

Restrictive license  Copyright © 2020 Oracle University. All rights reserved.

License for the course content created by the learners

Restrictive license : your production is your intellectual property and can not be reused.