This training course is no longer available.

Please return to Oracle 11g category or contact our customer service for more details.

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

Trainer(s) assigned(s)

Other course(s) in this category