Students Free Training

Oracle Database 12c Bootcamp

Oracle Database 12c Bootcamp is a hands-on bootcamp training course.

English

Description

Oracle Database 12c Bootcamp is a hands-on bootcamp training course.

Outline

5 modules 15 Days total
  • Oracle Database Architecture Overview
  • Oracle Database Instance Configurations
  • Oracle Database Memory Structures
  • Process Structures
  • Database Storage Architecture
  • Logical and Physical Database Structures
  • Container and Pluggable Database Overview
  • Install Oracle Grid Infrastructure for a Standalone Server
  • Install Oracle Database 12c software
  • Create an Oracle Database
  • Using the SRVCTL Utility
  • Configuring the Oracle Network
  • Administering User Security
  • Creating and Managing Tablespaces
  • Managing Storage Space
  • Managing UNDO Data
  • Moving Data
  • Configuring for Recoverability
  • Using the RMAN Recovery Catalog
  • Backup Strategies and Terminology
  • Performing Backups
  • Using RMAN-Encrypted Backups
  • Performing Recovery, Part 1
  • Performing Recovery, Part 2
  • Using Flashback Technologies
  • Duplicate database
  • Basic Tuning Diagnostics
  • Using Automatic Workload Repository
  • Monitoring Applications
  • Identifying Problem SQL Statements
  • Influencing the Optimizer
  • Reducing the Cost of SQL Operations
  • Tuning PGA and Temporary Space
  • Automatic Memory
  • Introduction to Oracle Data Guard
  • Networking for Oracle Data Guard
  • Creating a Physical Standby Database by Using SQL and RMAN Commands
  • Oracle Data Guard Broker: Overview
  • Creating a Data Guard Broker Configuration
  • Using Oracle Active Data Guard
  • Configuring Data Protection Modes
  • Performing Role Transitions