Module 1: Introduction to Oracle Database

Topics

• Oracle Database server architecture overview
• Oracle Multitenant Container Database introduction and architecture
• Oracle Database instance configurations
• Introduction to Database Sharding

Module 2: Accessing an Oracle Database

Topics

• Connecting to an Oracle Database instance
• Database tool choices: SQL*Plus, SQL Developer, and DBCA
• Oracle Enterprise Manager Database Express and Cloud Control
• Oracle Enterprise Manager component overview

Module 3: Creating an Oracle Database by Using DBCA

Topics

• Planning the database and choosing a database template
• Choosing and understanding character sets
• Using the Database Configuration Assistant, including silent mode

Labs / Practice

• Create an Oracle database using DBCA

Module 4: Creating an Oracle Database by Using a SQL Command

Topics

• Creating a Container Database (CDB) with a SQL command
• Using the SEED FILE_NAME_CONVERT clause
• Using the ENABLE PLUGGABLE DATABASE clause

Labs / Practice

• Create a CDB manually using the CREATE DATABASE statement

Module 5: Starting Up and Shutting Down a Database Instance

Topics

• Starting an Oracle Database instance
• Shutdown modes: NORMAL, TRANSACTIONAL, IMMEDIATE, and ABORT
• Opening and closing PDBs, and configuring PDBs to auto-open

Labs / Practice

• Practice starting up, shutting down, and managing PDB availability

Module 6: Managing Database Instances

Topics

• Working with and modifying initialization parameters
• Automatic Diagnostic Repository, alert log, and trace files
• Administering the DDL log file
• Querying dynamic performance views and the data dictionary

Labs / Practice

• Manage initialization parameters and query the data dictionary

Module 7: Oracle Net Services: Overview

Topics

• Connecting to the database instance over the network
• Oracle Net Services components and configuration tools
• Oracle Net Listener overview and the default listener
• Dedicated vs. shared server architecture

Module 8: Configuring Naming Methods

Topics

• Establishing Oracle network connections and name resolution
• Naming methods: Easy Connect, Local Naming, and Directory Naming
• Using database services to manage workloads

Labs / Practice

• Configure naming methods and database services

Module 9: Configuring and Administering the Listener

Topics

• Oracle Net Listener overview and the default listener
• Configuring dynamic service registration
• Configuring static service registration

Labs / Practice

• Configure and administer the Oracle Net Listener

Module 10: Configuring a Shared Server Architecture

Topics

• Shared server architecture overview
• Enabling and controlling shared server operations
• SGA and PGA usage under shared server
• Shared server configuration considerations

Labs / Practice

• Configure and test a shared server architecture

Module 11: Configuring Oracle Connection Manager for Multiplexing and Access Control

Topics

• Oracle Connection Manager architecture and processes
• Filtering rules for intranet and internet access control
• Session multiplexing
• Configuring cman.ora, clients, and the database server

Labs / Practice

• Configure Oracle Connection Manager for access control and multiplexing

Module 12: Creating PDBs from Seed

Topics

• Provisioning new pluggable databases and available tools
• Creating a new PDB from PDB\$SEED
• Using FILE_NAME_CONVERT, OMF, and PDB_FILE_NAME_CONVERT

Labs / Practice

• Create a new PDB from PDB\$SEED

Module 13: Using Other Techniques to Create PDBs

Topics

• Cloning regular PDBs and migrating non-CDB data into a CDB
• Plugging a non-CDB into a CDB using DBMS_PDB
• Cloning and relocating remote PDBs, including near-zero downtime relocation
• Proxy PDBs for cross-CDB queries

Labs / Practice

• Create PDBs using cloning, plugging, and relocation techniques

Module 14: Managing PDBs

Topics

• Changing PDB mode and modifying PDB settings
• Impact of changing initialization parameters at the PDB level
• Using ALTER SYSTEM within a PDB
• Configuring host name/port per PDB and dropping PDBs

Labs / Practice

• Manage PDB settings, parameters, and lifecycle

Module 15: Database Storage Overview

Topics

• Database storage architecture and logical/physical structures
• Segments, extents, and blocks
• Tablespaces, data files, and default CDB tablespaces
• Deferred segment creation and monitoring tablespace usage

Module 16: Creating and Managing Tablespaces

Topics

• Creating permanent and temporary tablespaces in a CDB
• Defining default permanent tablespaces
• Altering, dropping, and viewing tablespace information
• Implementing Oracle Managed Files (OMF)
• Moving or renaming online data files

Labs / Practice

• Create and manage tablespaces and data files

Module 17: Improving Space Usage

Topics

• Block space management, row chaining, and migration
• Using unusable indexes and temporary (global/private) tables
• Table compression concepts and the compression advisor
• Reclaiming space by shrinking segments
• Managing resumable space allocation

Labs / Practice

• Resolve space usage issues and shrink segments

Module 18: Managing Undo Data

Topics

• Undo data concepts and the transaction relationship
• SHARED vs. LOCAL undo mode
• Configuring and guaranteeing undo retention
• Temporary undo: benefits, enabling, and monitoring

Labs / Practice

• Configure and monitor undo tablespaces

Module 19: Creating and Managing User Accounts

Topics

• Database user accounts and Oracle-supplied administrator accounts
• Creating common and schema-only users in a multitenant environment
• Password, password file, and OS authentication
• Assigning quotas

Labs / Practice

• Create and manage database user accounts

Module 20: Configuring Privilege and Role Authorization

Topics

• System and object privileges
• Granting privileges in a multitenant environment
• Using roles to manage privileges and Oracle-supplied roles
• Granting and revoking privileges and roles

Labs / Practice

• Configure privilege and role-based authorization

Module 21: Configuring User Resource Limits

Topics

• Profiles and their relationship to users
• Creating profiles in a multitenant architecture
• Resource, locking, and password profile parameters
• Oracle-supplied password verification functions

Labs / Practice

• Create and assign resource profiles

Module 22: Implementing Oracle Database Auditing

Topics

• Database security and monitoring for compliance
• Unified audit policies: system-wide, object-specific, and conditional
• Auditing in the CDB and PDBs
• Value-based and fine-grained auditing (FGA)
• Archiving and purging the audit trail

Labs / Practice

• Configure and test unified and fine-grained audit policies

Module 23: Introduction to Loading and Transporting Data

Topics

• General architecture for moving data
• Oracle Data Pump overview and benefits
• SQL*Loader overview

Module 24: Loading Data

Topics

• Creating the SQL*Loader control file
• SQL*Loader loading methods and protecting against data loss
• SQL*Loader Express Mode
• Loading a table in a PDB

Labs / Practice

• Load data into a PDB using SQL*Loader

Module 25: Transporting Data

Topics

• Data Pump export/import interfaces, modes, and transformations
• Using Data Pump with PDBs and full transportable export/import
• Transporting databases and tablespaces over the network
• Using RMAN to transport data across platforms

Labs / Practice

• Transport data and tablespaces using Data Pump and RMAN

Module 26: Using External Tables to Load and Transport Data

Topics

• External tables overview and benefits
• ORACLE_LOADER and ORACLE_DATAPUMP access drivers
• Viewing external table information

Labs / Practice

• Create and query external tables

Module 27: Automated Maintenance Tasks: Overview

Topics

• Proactive database maintenance infrastructure
• Predefined automated maintenance tasks and components
• Maintenance windows

Module 28: Automated Maintenance Tasks: Managing Tasks and Windows

Topics

• Configuring, enabling, and disabling automated maintenance tasks
• Creating and managing maintenance windows
• Resource allocations for maintenance tasks

Labs / Practice

• Configure automated maintenance tasks and windows

Module 29: Database Monitoring and Tuning Performance Overview

Topics

• Performance management activities and planning
• Automatic Workload Repository (AWR) and ADDM
• Advisory framework and performance tuning methodology

Module 30: Monitoring Database Performance

Topics

• Server-generated alerts and metric thresholds
• Database server statistics and metrics
• Monitoring wait events, sessions, and services

Labs / Practice

• Monitor database performance using alerts and statistics

Module 31: Analyzing SQL and Optimizing Access Paths

Topics

• SQL tuning process and the Oracle Optimizer
• Optimizer statistics collection and the Statistics Advisor
• SQL Plan Directives and adaptive execution plans
• SQL Tuning Advisor, SQL Access Advisor, and SQL Performance Analyzer

Labs / Practice

• Analyze SQL statements and apply optimizer advisor recommendations