Fundamental Concepts of Oracle 11g/12c


overall satisfaction for this course

?Average calculated from scores obtained from 261 participants who took this course.
  • Duration 2 days
  • Regular fee 1 275
  • Preferential fee 1 150?
  • Locations
    • Montreal
  • Laboratory


To provide the knowledge and skills required to effectively use Oracle 11g/12c.

Targeted audience

Developers, Web specialists and those in network positions.


Conceptual data modeling (Course BD101) and knowledge of a programming language.

Customer Testimonials

Great teacher. The content is really satisfying.

Paul C. / Conseiller Technologique, Emergex Subventions Inc.


  • Introduction to the Oracle database (physical structure, memory structures)
  • Essential elements of data modeling
  • Overview of Oracle relational objects (tables, views, sequences)
  • Introduction to the SQLDEVELOPER environment
  • Differences between SQL and SQL*Plus commands
  • Queries, display and formatting of data in a table
  • Basic formatting functions (e.g.: TO_CHAR, TO_DATE, SUM, AVG, etc.)
  • Introduction to complex queries
  • Using simple and complex joins
  • Nested queries using the IN and EXISTS operators
  • Inserting, updating and deleting data in a table (DML)
  • Creating, modifying and deleting Oracle tables
  • Managing integrity constraints (PRIMARY KEY, UNIQUE KEY, NOT NULL)
  • Controlling user access to tables
  • Granting, confirming and revoking privileges on standard tables

General Note

Note: Even though the course is presented using Oracle Express 11g Edition, the concepts and techniques covered apply equally well to the Standard and Business Editions.


*Unless stated otherwise, all sessions are in French.
  • Montreal

    September 5 to September 6 2019

Trainer(s) assigned(s)

Other course(s) in this category