Course : Oracle SQL

Practical course - 3d - 21h00 - Ref. OSL
Price : 1640 € E.T.

Oracle SQL



Required course



INTER
IN-HOUSE
CUSTOM

Practical course in person or remote class
Disponible en anglais, à la demande

Ref. OSL
  3d - 21h00
1640 € E.T.






Teaching objectives
At the end of the training, the participant will be able to:
Understand the relational model
Identify the objects of an Oracle database.
Query and classify data in a table
Work with data in database tables.
Know how to return data

Course schedule

1
Introduction

  • The relational model
  • Basic concepts: relationship (table), attributes (columns), integrity constraints.
  • Integrity constraints.

2
Tools

  • Overview of SQL*Plus.
  • Overview of SQL Developer.

3
Introduction to SQL.

  • Oracle data types.
  • - Creating tables.
  • Introduction to update instructions.
  • Using sequences.
  • Introduction to querying (SELECT).

4
Data querying

  • Sorting and deleting duplicates. Aliases and prefixes. Using Fetch and Offset.
  • Handling the NULL value. Using SQL functions.
  • Using pseudo-columns: ROWID and ROWNUM. Using aggregates: COUNT, SUM, AVG, etc.
  • Set operations: union, intersection, difference.
  • Nested queries: IN, EXISTS operators.
  • Use of joins.
  • External joins.
  • Grouping: GROUP BY and HAVING.

5
Objects of an Oracle database

  • Creating and deleting tables.
  • Integrity constraint management: primary key, uniqueness, non-nullity, CHECK, referential constraints.
  • Use of views.
  • Use of synonyms.
  • Data dictionary.

6
Complex SQL statements

  • Configuring SQL*Plus scripts.
  • Division and complex queries.
  • Update statements with nested queries.
  • Hierarchical queries.
  • Using regular expressions.


Customer reviews
4,5 / 5
Customer reviews are based on end-of-course evaluations. The score is calculated from all evaluations within the past year. Only reviews with a textual comment are displayed.
JESSICA E.
24/08/26
4 / 5

Bonjour,Le nombre de jours de la formation était insuffisant par rapport au contenu. Certains sujets ont dû être survolés et nous n’avons pas assez pratiqué. Nous aurions eu peut être besoin de 6 jours ou d’espacer les 3 jours pour nous permettre de nous exercer entre 2 cours et de pouvoir poser des questions pertinentes. Heureusement que le formateur nous a fourni des exercices pour pouvoir pratiquer après la formation. Le contenu de la formation était très complet et structuré.Cdt,
CHARLOTTE J.
24/08/26
4 / 5

dans l’ensemble très bien, mais on passe trop de temps sur des choses peu utiles / peu importantes / "faciles" et parfois trop rapide sur des notions complexes / plus utiles
ADRIEN P.
24/08/26
4 / 5

beaucoup de contenu pour peu de temps de formation, mais tres interessant



Publication date : 08/02/2024



This programme is an original creation, developed by the teaching teams at ORSYS Formation. Any reproduction, representation, adaptation or use, in whole or in part, without the prior written authorisation of ORSYS, is strictly prohibited. ORSYS reserves the right to take any action necessary to protect its intellectual property rights.

Dates and locations
Select your location or opt for the remote class then choose your date.
Remote class

Dernières places
Date garantie en présentiel ou à distance
Session garantie

REMOTE CLASS
2026 : 23 Sep., 7 Dec., 7 Dec.

2027 : 27 Jan., 27 Jan., 19 Apr., 19 Apr., 20 Sep., 20 Sep., 3 Nov., 3 Nov.

PARIS LA DÉFENSE
2026 : 7 Dec.

2027 : 27 Jan., 19 Apr., 20 Sep., 3 Nov.



This programme is an original creation, developed by the teaching teams at ORSYS Formation. Any reproduction, representation, adaptation or use, in whole or in part, without the prior written authorisation of ORSYS, is strictly prohibited. ORSYS reserves the right to take any action necessary to protect its intellectual property rights.