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
OR201

Oracle 11g/12c: Database Administration

93%

overall satisfaction for this course

?Average calculated from scores obtained from 197 participants who took this course.
See the training dates
  • Duration 3 days
  • Regular fee 1 935
  • Preferential fee 1 740?
  • Locations
    • Montreal
  • Laboratory
    course

Objectives

To provide the knowledge and skills required to install, configure and manage an Oracle 12c database.

Targeted audience

Developers (other than supervisors) and network specialists (other than those who work in security).

Prerequisite

Knowledge of Oracle 11g (Course OR101) and system administration (Windows Server 2008 or UNIX)

Training Details

Content

  • Overview of the Oracle 12c database architecture (non-CDB, CDB and PDB)
  • Preparing and installing a database based on OFA standards
  • Managing the database instance and network configuration
  • Memory structures (SGA and PGA) and parameters
  • Managing logical (TABLESPACES) and physical (DATAFILES) memory
  • Managing the undo tablespace (UNDO and RETENTION)
  • Different types of tables: standard, partitioned, external, temporary
  • Different index types: B*tree, bitmap, function based, reverse key, partitioned
  • Managing security (users, privileges and roles)
  • Setting up auditing (UNIFIED AUDIT TRAIL)
  • Introduction to FLASHBACK concepts (query, table, drop table and database)
  • Backup and restore using RMAN
  • Introduction to the DATAPUMP tool

Customer Testimonials

Effective and covers the entire subject in just a few days.

Alain R. / Conseiller(ère) Mise en expl. des appl., Hydro-Québec

Select the training date*

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

    October 23 to October 25 2019

  • Montreal

    June 8 to June 10 2020

Trainer(s) assigned(s)

Other course(s) in this category