Formation Oracle SQL Language

Code formation



14 heures (généralement 2 jours pauses comprises)

Pré requis

  • Computer skills
  • Knowledge of any operating system


The course answers questions

How to build a query?

What possibilities have SQL?

What is a relational database?

What is the structure and SQL commands

Plan du cours

Relational database models

  • The structure of a relational database
  • Connection types of tables
  • The normalization and denormalization database
  • Database Management System (RDBMS)

Relational Operators

Characteristics of declarative SQL language SQL Syntax Division language DQL, DML, DDL, DCL Language DQL (Data Query Language)

  • SELECT queries
  • Aliases columns, tables
  • Service date (DATE types, display functions, formatting)
  • Group Features
  • Combining internal and external tables
  • UNION operator
  • Nested Subqueries (the WHERE clause, the table name, column name)
  • Correlated subqueries

Data Modification Language

  • Inserting rows (INSERT clause)
  • Inserting via query
  • Updating rows (UPDATE)
  • Removing rows (DELETE)

Data Definition Language

  • Create, change of ownership, remove tables (CREATE, ALTER, DROP) Creating tables by asking (CREATE TABLE .... AS SELECT ...)


  • Options NULL and NOT NULL
  • CONSTRAINT clause
  • Condition PRIMARY KEY
  • Condition UNIQUE
  • Condition FOREIGN KEY
  • DEFAULT clause



Language DCL

  • Granting and revoking permissions (GRANT, REVOKE)
  • Roles
  • Creating Users
  • sequences
  • Synonyms
  • The views (perspective)

Nos Clients témoignent


Catégories Similaires

Cours Similaires

Réduction spéciale

Newsletter offres spéciales

Nous respectons le caractère privé de votre adresse mail. Nous ne divulguerons ni ne vendrons votre adresse email à quiconque
Vous pouvez toujours modifier vos préférences ou vous désinscrire complètement.

Nos clients

is growing fast!

We are looking to expand our presence in Belgium!

As a Business Development Manager you will:

  • expand business in Belgium
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!