Consult our trainings :

Digital
Technologies

Management
Personal Development

Business
Administration

> formation Technologies numériques > formation SGBD > formation Oracle > formation Oracle SQL

Oracle SQL Training

Name: Formation Oracle SQL
SKU: OSL

Stage pratique

Best

Duration : 3 days

Ref : OSL

Price 2021 : 2070 € excl. taxes

Free breaks and lunches

Program
Participants / Prerequisite
Intra/Tailored

Program

Instructional goals

Learning objectives

À l’issue de la formation, le participant sera en mesure de :

Know how to identify the objects of an Oracle database.
Query and sort data in a table
Work with data in database tables.
Know how to retrieve data
Participants

PROGRAM

» Introduction

The relational model.
The basic notions: Relation (table), attributes (columns), integrity constraints.
Integrity constraints.

» Tools

Overview of SQL*Plus.
Overview of SQL Developer.

» Introduction to SQL

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

» Querying data

Sorting and deleting duplicates. Using aliases and prefixes.
Handling the value NULL. Using SQL functions.
Using pseudo-columns: ROWID and ROWNUM. Using aggregates: COUNT, SUM, AVG...
Set clauses: Union, intersect, except
Embedded queries: IN, EXISTS operators.
Using joins.
Outer joins.
Grouping: GROUP BY and HAVING.

» Objects of an Oracle database

Creating and deleting tables.
Managing integrity constraints: Primary key, uniqueness, no null values, CHECK, referential constraints.
Using views.
Using synonyms.
Data dictionary.

» Complex SQL instructions

Configuring SQL*Plus scripts.
Complex divisions and queries.
Update instructions with embedded queries.
Hierarchical queries.
Using regular expressions.

PDF

Send

Participants / Prerequisite

» Participants

Prerequisites

» Prerequisite

TRAINING PROGRAM

Intra/Tailored

For how many persons*

Preferred Cities*

Preferred Dates*

Comments

Contact Informations

Gender*

Name*

Surname*

Company*

Establishment

Department*

Address*

City*

Zip code*

Country*

Phone*

Professional email*

By checking this box, I certify that I have read and accepted the conditions for the use of my data regarding the General Data Protection Regulation (GDPR).

You can at any time modify the use of your data and exercise your rights by sending an email to rgpd@orsys.fr

By checking this box, I agree to receive commercial and promotional communications from ORSYS Training*. You can unsubscribe at any time by using the link included in our communications.

CLASSE A DISTANCE

En inter et en intra-entreprise
Inscrivez-vous ou contactez-nous !

Book your place

Click on a session for reserving.

Time schedule

Generally, courses take place from 9:00 to 12:30 and from 14:00 to 17:30.

However, on the first day attendees are welcomed from 8:45, and there is a presentation of the session between 9:15 and 9:30.

The course itself begins at 9:30. For the 4- or 5-day hands-on courses, the sessions finish at 15:30 on the last day