LEARNING FORMAT

100% ONLINE

EUROPEAN CREDITS

3 ECTS

CERTIFICATION

ORACLE

DURATION

6 MONTHS

OVERVIEW

Managing data in the past, present, and future means mastering the SQL standard. SQL is versatile enough to encompass any type of data in Big Data systems: relational (SQL2) object-relational (SQL3, OQL) and non-relational (N.O.SQL, NEWSQL)

Job role: this GRADEO prepares you to become an advanced-SQL developer.

COURSES

This GRADEO includes 1 university course taught by a teacher from ESTIA engineering school and 1 industrial course in partnership with Oracle University. An academic course is generally divided into 6/7 modules, each one being delivered over a period of one week and 6/7 consecutive weeks. Each module represents 5 hours of student work per week.

  • Data and Codd Relational Model for structured databases
  • SQL2 for Relational Databases
  • Chris Date and Mike Stonebraker's Manifestations on the object relational model
  • OQL for object databases
  • SQL3 for hybrid (object-relational) databases
  • Data and NO SQL paradigms for unstructured databases (Datalakes and polystores)
  • Retrieve row and column data from tables with the SELECT statement
  • Create reports of sorted and restricted data
  • Employ SQL functions to generate and retrieve customized data
  • Run complex queries to retrieve data from multiple tables
  • Run data manipulation language (DML) statements to update data in a database
  • Run data definition language (DDL) statements to create and manage schema objects

PRE-REQUISITES

Learners must be proficient in basic mathematics (set theory) and computer science (undergraduate level).

FEES

Full Payment
720 € (VAT included)

KEY BENEFITS

  • Open to any computer scientist for continuous education (no academic prerequisites)
  • 6-month accelerated program
  • Providing double certification: an academic certificate from ESTIA corresponding to 3 ECTS & a professional certification from Oracle
  • Preparing for jobs

COMPANIES

If you are an organization wishing to register a group of employees for this training, we invite you to contact us in order to propose a partnership including benefits.

FAQ

Contrary to the MSc eBIHAR, the GRADEO courses are not eligible for payment in several instalments.
Simply click on the Apply Now button. You will then need to fill out a short form and pay the registration fee. You will receive your registration confirmation within 48 hours by email as well as your login details for the learning platforms. And the GRADEO adventure will begin for you! 
If you are interested in the concepts around SQL and want to be able to present in your resume a certificate that proves your skills in the field to claim a job in tension as Big Data architect, this program is for you. Whether you are an employee, a freelancer, a job seeker, or a student, you can organize your courses at your own pace within 6 months. The academic courses allow you to acquire the fundamental theoretical notions and concepts to have all the tools in hand to master the practice that the professional course brings you. 
This program will be very beneficial for you if you want to get your foot in the door of the IT world! If you are looking for a job, freelancing or studying and your goal is to acquire new skills that are in high demand on the market and that will allow you to have more career opportunities and projects! 
The academic course is to be taken on the France Université Numérique platform and the professional courses on the learning platform of the industrial company concerned. For example, for this GRADEO, the professional course will be available on the Oracle University platform.
You only need a computer and an internet connection.
At the end of this program, you will be able to master the theory and practice of the concepts discussed around SQL but also to become an expert! Recruiters are looking for skills today, and we'll teach them to you!
Not one, but two certifications are delivered at the end of the program if you pass your academic and professional exams. ESTIA will issue you a certificate of achievement corresponding to 3 ECTS for the whole program, and if you pass your Oracle exam, you will have in your pocket a professional certification that is highly prized by recruiters in the tech world: Oracle Database SQL Specialist (1Z0-914) . The certificate of achievement is therefore very valuable to you! 
ECTS is the acronym for European Credits Transfer System: these are the credits delivered by higher education institutions in Europe and allowing to validate a level of study.
It is totally possible to extend the duration of your program! Just keep in mind that your professional course and the corresponding exam session have a duration of 6 months and this duration is inflexible. Academic courses can be extended to a maximum of 12 months. To do so, you will have to contact our team so that we can help you in this process. After 12 months without a grade on your academic exam, we will be obliged to consider this as a program withdrawal. 
All year long !