ORSYS formation
CONTACT - +33 (0)1 49 07 73 73
CONTACT - 📞 +33 (0)1 49 07 73 73    drapeau francais   drapeau anglais

Consult our trainings :

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

Oracle SQL Training

Stage pratique
Best
Duration : 3 days
Ref : OSL
Price  2020 : 2040 € excl. taxes
Free breaks and lunches
  • Program
  • Participants / Prerequisite
  • Intra/Tailored
Program

Instructional goals

Learning objectives

  • 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.
Participants / Prerequisite

» Participants

Prerequisites

» Prerequisite

TRAINING PROGRAM
Intra/Tailored

Contact Informations

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
linkedin orsys
twitter orsys
it! orsys
instagram orsys
pinterest orsys
facebook orsys
youtube orsys