We move! Starting September 1st, our QUEBEC CITY training center will be located at 5400, des Galeries Blvd, Suite 500, 5th Floor, Québec (Quebec) G2K 2B4
OR101

Fundamental Concepts of Oracle 11g/12c

93%

overall satisfaction for this course

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

Objectives

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

Targeted audience

Developers, Web specialists and those in network positions.

Prerequisite

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

Training Details

Content

  • 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.

Customer Testimonials

Great teacher. The content is really satisfying.

Paul C. / Conseiller Technologique, Emergex Subventions Inc.

Select the training date*

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

    March 16 to March 17 2020

Trainer(s) assigned(s)

Other course(s) in this category