OR101

Fundamental Concepts of Oracle 11g/12c

92%

overall satisfaction for this course

?Average calculated from scores obtained from 259 participants who took this course.
  • Duration 2 days
  • Regular fee 1 265
  • Preferential fee 1 075?
  • Locations
    • Montreal
  • Laboratory
    course
Parcours

Formation path :

Databases Training Paths

View path
SUMMARY
DETAILS

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.

Customer Testimonials

Good basis for Oracle and its general understanding.

Alexandre A. / Analyste Exploitation TI, Hydro-Québec

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.

DATES*

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

    March 22 to March 23 2018

Trainer(s) assigned(s)

Other course(s) in this category