This course runs for a duration of 5 days.
The class will run daily from 9 AM ET to 5 PM ET.
Class Location: Virtual LIVE Instructor Led - Virtual Live Classroom.
This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to manage your database resources effectively. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition, you learn how to create users and administer database security to meet your business requirements. This course provides basic information on backup and recovery techniques. To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.
Skills Gained
Describe Oracle Database architecture
Describe Oracle Database Cloud Service (DBCS) architecture and features
Create and manage DBCS database deployments
Configure the database to support your applications
Manage database security and implement auditing
Implement basic backup and recovery procedures
Move data between databases and files
Employ basic monitoring procedures and manage performance
Lesson 1: Introduction to Oracle Database
Database Server Architecture
Lesson 2: Accessing an Oracle Database
Accessing an Oracle Database
Usage of general DBCA Tools to Interact with Database
Lesson 3: Creating an Oracle Database by Using DBCA
Creating a Database Using DBCA
Creating a New CDB
Lesson 4: Creating an Oracle Database by Using a SQL Command
Creating Database using SQL Command
Creating a New CDB
Lesson 5: Starting Up and Shutting Down a Database Instance
Starting Up and Shutting Down a Database Instance
Opening and Closing PDBs
Shutting Down and Starting Up the Oracle Database
Lesson 6: Managing Database Instances
Managing the Database
Investigating Initialization Parameter Files
Viewing Initialization Parameters by Using SQL*Plus
Modifying Initialization Parameters by Using SQL*Plus
Viewing Diagnostic Information
Lesson 7: Oracle Net Service: Overview
Configuring and Administering Oracle Net Service
Lesson 8: Configuring Naming Methods
Oracle Net Components
Naming Method
Configuring the Oracle Network to Access a Database
Creating a Net Service Name for a PDB
Lesson 9: Configuring and Administering the Listener
Configuring and Administering the Listener
Exploring the Default Listener
Creating a Second Listener
Connecting to a Database Service Using the New Listener
Lesson 10: Configuring a Shared Server Architecture
Configuring a Shared Server Architecture
Configuring Shared Server Mode
Configuring Clients to Use a Shared Server
Lesson 11: Configuring Oracle Connection Manager for Multiplexing and Access Control
Configuring Oracle Connection Manager for Multiplexing and Access Control Connection Manager
Installing Oracle Instant Client
Configuring the cman.ora File
Configuring the Database for Oracle Connection Manager
Configuring Clients for Oracle Connection Manager
Configuring the Oracle Database Server for Session Multiplexing
Lesson 12: Creating PDBs from Seed
Creating PDBs from Seed
Provisioning New Pluggable Databases
Creating a New PDB from the PDB Seed
Lesson 13: Using Other Techniques to Create PDBs
Using Other Techniques to Create PDBs
Method of Creating and Migrating PDBs
Cloning Remote PDBs in Hot Mode
Relocating PDBs
Lesson 14: Managing PDBs
Managing PDBs
Renaming a PDB
Setting Parameter Values for PDBs
Lesson 15: Database Storage Overview
Database Storage Overview
Purpose of the Default Tablespaces
Storage of Data in Blocks
Advantage of Deferred Segment Creation
Lesson 16: Creating and Managing Tablespaces
Creating and Managing Tablespaces
Viewing Tablespace Information
Viewing Tablespace Information
Creating a Tablespace
Managing Temporary and Permanent Tablespaces
Lesson 17: Improving Space Usage
Space Management Features
Creating Global Temporary Tables
Managing Space in Tablespaces
Using Compression
Enabling the Resumable Space Allocation Feature
Lesson 18: Managing Undo Data
Managing the Undo
Enabling Temporary Undo
Managing Undo Tablespaces in a PDB
Lesson 19: Creating and Managing User Accounts
Creating and Managing User Accounts
Creating Common Users in the CDB and PDBs
Assigning Quotas
Creating Common and Local Users
Creating a Local User for an Application
Exploring OS and Password File Authentication
Lesson 20: Configuring Privilege and Roles Authorization
Configuring Privilege and Roles Authorization
Granting a Local Role (DBA) to PDBADMIN
Using SQL*Developer to Create Local Roles
Lesson 21: Configuring User Resource Limits
Configuring User Resource Limits
Using SQL*Developer to Create a Local Profile
Using SQL*Developer to Create Local Users
Configuring a Default Role for a User
Lesson 22: Implementing Oracle Database Auditing
Implementing Oracle Database Auditing
Configuring Auditing
Viewing Audit Policy Information
Enabling Unified Auditing
Creating Audit Users
Creating an Audit Policy
Lesson 23: Introduction Loading and Transporting Data
Introduction Loading and Transporting Data
Lesson 24: Loading Data
Loading Data
Loading Data into a PDB from an External File
Lesson 25: Transporting Data
Transporting Data
Using the RMAN Convert Command
Moving Data from One PDB to Another PDB
Transporting a Tablespace
Lesson 26: Using External Tables to Load and Transport Data
Using External Tables to load Transport Data
External Table Demo
Querying External Tables
Unloading External Tables
Lesson 27: Automated Maintenance Tasks: Overview
Automated Maintenance Tasks: Overview
Automated Maintenance Tasks: Components
Lesson 28: Automated Maintenance Tasks: Managing Tasks and Windows
Configuring Automated Maintenance Tasks
Enabling and Disabling Automated Maintenance Tasks
Modifying the Duration of a Maintenance Window
Lesson 29: Database Monitoring and Performance Tuning Overview
Database Monitoring and Tuning Performance Overview
Lesson 30: Monitoring Database Performance
Understanding What Database Performance is Monitored
Lesson 31: Analyzing SQL and Optimizing Access Paths
Analyzing SQL and Optimizing Access Paths
Adaptive Execution Plans
