Oracle Database 19c: Administration Workshop

COURSE TOPICS

Module 1 :Introduction to Oracle Database

• Database Server Architecture
• Course Practice Environment: Security Credentials

Module 2 :Accessing an Oracle Database

• Accessing an Oracle Database
• Demonstration: Usage of general DBCA Tools to Interact with Database

Module 3 :Creating an Oracle Database by Using DBCA

• Creating a Database Using DBCA
• Practice 3-1: Creating a New CDB (Part 01)
• Practice 3-1: Creating a New CDB (Part 02)

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

• Creating Database using SQL Command
• Practice 4-1: Creating a New CDB (Part 01)
• Practice 4-1: Creating a New CDB (Part 02)
• Practice 4-1: Creating a New CDB (Part 03)

Module 5 :Starting Up and Shutting Down a Database Instance

• Starting Up and Shutting Down a Database Instance
• Opening and Closing PDBs
• Practice 5-1: Shutting Down and Starting Up the Oracle Database

Module 6 :Managing Database Instances

• Managing the Database
• Practice 6-1: Investigating Initialization Parameter Files
• Practice 6-2: Viewing Initialization Parameters by Using SQL*Plus (Part 01)
• Practice 6-2: Viewing Initialization Parameters by Using SQL*Plus (Part 02)
• Practice 6-3: Modifying Initialization Parameters by Using SQL*Plus
• Practice 6-4: Viewing Diagnostic Information

Module 7 :Oracle Net Service: Overview

• Configuring and Administering Oracle Net Service
• Course Practice Environment: Security Credentials

Module 8 :Configuring Naming Methods

• Oracle Net Components
• Naming Method
• Practice 2-1: Configuring the Oracle Network to Access a Database (Part 01)
• Practice 2-1: Configuring the Oracle Network to Access a Database (Part 02)
• Practice 2-2: Creating a Net Service Name for a PDB

Module 9 :Configuring and Administering the Listener

• Configuring and Administering the Listener
• Practice 3-1: Exploring the Default Listener
• Practice 3-2: Creating a Second Listener
• Practice 3-3: Connecting to a Database Service Using the New Listener

Module 10 :Configuring a Shared Server Architecture

• Configuring a Shared Server Architecture
• Practice 4-1: Configuring Shared Server Mode
• Practice 4-2: Configuring Clients to Use a Shared Server

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

• Connection Manager
• Practice 5-1: Installing Oracle Instant Client
• Practice 5-2: Configuring the cman.ora File
• Practice 5-3: Configuring the Database for Oracle Connection Manager
• Practice 5-4: Configuring Clients for Oracle Connection Manager
• Practice 5-5: Configuring the Oracle Database Server for Session Multiplexing

Module 12 :Creating PDBs from Seed

• Creating PDBs from Seed
• Provisioning New Pluggable Databases-(Continued)
• Practice 1-1: Creating a New PDB from the PDB Seed

Module 13 :Using Other Techniques to Create PDBs

• Using Other Techniques to Create PDBs
• Method of Creating and Migrating PDBs
• Practice 2-1: Cloning Remote PDBs in Hot Mode (Part 01)
• Practice 2-1: Cloning Remote PDBs in Hot Mode (Part 02)
• Practice 2-2: Relocating PDBs

Module 14 :Managing PDBs

• Managing PDBs
• Practice 3-1: Renaming a PDB
• Practice 3-2: Setting Parameter Values for PDBs

Module 15 :Database Storage Overview

• Database Storage Overview
• Purpose of the Default Tablespaces
• Storage of Data in Blocks
• Advantage of Deferred Segment Creation
• Course Practice Environment: Security Credentials

Module 16 :Creating and Managing Tablespaces

• Creating and Managing Tablespaces
• Viewing Tablespace Information
• Practice 2-1: Viewing Tablespace Information
• Practice 2-2: Creating a Tablespace (Part 01)
• Practice 2-2: Creating a Tablespace (Part 02)
• Practice 2-3: Managing Temporary and Permanent Tablespaces

Module 17 :Improving Space Usage

• Space Management Features
• Creating Global Temporary Tables
• Practice 3-1: Managing Space in Tablespaces (Part 01)
• Practice 3-1: Managing Space in Tablespaces (Part 02)
• Practice 3-1: Managing Space in Tablespaces (Part 03)
• Practice 3-2: Using Compression
• Practice 3-3: Enabling the Resumable Space Allocation Feature (Part 01)
• Practice 3-3: Enabling the Resumable Space Allocation Feature (Part 02)

Module 18 :Managing Undo Data

• Managing the Undo
• Enabling Temporary Undo
• Practice 4-1: Managing Undo Tablespaces in a PDB

Module 19 :Creating and Managing User Accounts

• Creating and Managing User Accounts
• Creating Common Users in the CDB and PDBs
• Assigning Quotas
• Practice 1-1: Creating Common and Local Users
• Practice 1-2: Creating a Local User for an Application
• Practice 1-3: Exploring OS and Password File Authentication

Module 20 :Configuring Privilege and Roles Authorization

• Configuring Privilege and Roles Authorization
• Practice 2-1: Granting a Local Role (DBA) to PDBADMIN
• Practice 2-2: Using SQL*Developer to Create Local Roles

Module 21 :Configuring User Resource Limits

• Configuring User Resource Limits
• Practice 3-1: Using SQL*Developer to Create a Local Profile
• Practice 3-2: Using SQL*Developer to Create Local Users (Part 01)
• Practice 3-2: Using SQL*Developer to Create Local Users (Part 02)
• Practice 3-3: Configuring a Default Role for a User

Module 22 :Implementing Oracle Database Auditing

• Implementing Oracle Database Auditing
• Configuring Auditing
• Viewing Audit Policy Information
• Practice 4-1: Enabling Unified Auditing
• Practice 4-2: Creating Audit Users
• Practice 4-3: Creating an Audit Policy

Module 23 :Introduction Loading and Transporting Data

• Introduction Loading and Transporting Data
• Course Practice Environment: Security Credentials

Module 24 :Loading Data

• Loading Data
• Practice 2-1: Loading Data into a PDB from an External File

Module 25 :Transporting Data

• Transporting Data
• Using the RMAN Convert Command
• Practice 3-1: Moving Data from One PDB to Another PDB (Part 01)
• Practice 3-1: Moving Data from One PDB to Another PDB (Part 02)
• Practice 3-2: Transporting a Tablespace

Module 26 :Using External Tables to Load and Transport Data

• Using External Tables to load Transport Data
• External Table Demo
• Practice 4-1: Querying External Tables
• Practice 4-2: Unloading External Tables

Module 27 :Automated Maintenance Tasks: Overview

• Automated Maintenance Tasks: Overview
• Automated Maintenance Tasks: Components
• Course Practice Environment: Security Credentials

Module 28 :Automated Maintenance Tasks: Managing Tasks and Windows

• Configuring Automated Maintenance Tasks
• Practice 2-1: Enabling and Disabling Automated Maintenance Tasks
• Practice 2-2: Modifying the Duration of a Maintenance Window

Module 29 :Database Monitoring and Performance Tuning Overview

• Database Monitoring and Tuning Performance Overview

Module 30 :Monitoring Database Performance

• Understanding What Database Performance is Monitored

Module 31 :Analyzing SQL and Optimizing Access Paths

• Analyzing SQL and Optimizing Access Paths
• Adaptive Execution Plans