This course runs for a duration of 5 days.
The class will run daily from 10 AM ET to 6 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
Database Server Architecture
Accessing an Oracle Database
Usage of general DBCA Tools to Interact with Database
Creating a Database Using DBCA
Creating a New CDB
Creating Database using SQL Command
Creating a New CDB
Starting Up and Shutting Down a Database Instance
Opening and Closing PDBs
Shutting Down and Starting Up the Oracle Database
Managing the Database
Investigating Initialization Parameter Files
Viewing Initialization Parameters by Using SQL*Plus
Modifying Initialization Parameters by Using SQL*Plus
Viewing Diagnostic Information
Configuring and Administering Oracle Net Service
Oracle Net Components
Naming Method
Configuring the Oracle Network to Access a Database
Creating a Net Service Name for a PDB
Configuring and Administering the Listener
Exploring the Default Listener
Creating a Second Listener
Connecting to a Database Service Using the New Listener
Configuring a Shared Server Architecture
Configuring Shared Server Mode
Configuring Clients to Use a Shared Server
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
Creating PDBs from Seed
Provisioning New Pluggable Databases
Creating a New PDB from the PDB Seed
Using Other Techniques to Create PDBs
Method of Creating and Migrating PDBs
Cloning Remote PDBs in Hot Mode
Relocating PDBs
Managing PDBs
Renaming a PDB
Setting Parameter Values for PDBs
Database Storage Overview
Purpose of the Default Tablespaces
Storage of Data in Blocks
Advantage of Deferred Segment Creation
Creating and Managing Tablespaces
Viewing Tablespace Information
Viewing Tablespace Information
Creating a Tablespace
Managing Temporary and Permanent Tablespaces
Space Management Features
Creating Global Temporary Tables
Managing Space in Tablespaces
Using Compression
Enabling the Resumable Space Allocation Feature
Managing the Undo
Enabling Temporary Undo
Managing Undo Tablespaces in a PDB
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
Configuring Privilege and Roles Authorization
Granting a Local Role (DBA) to PDBADMIN
Using SQL*Developer to Create Local Roles
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
Implementing Oracle Database Auditing
Configuring Auditing
Viewing Audit Policy Information
Enabling Unified Auditing
Creating Audit Users
Creating an Audit Policy
Introduction Loading and Transporting Data
Loading Data
Loading Data into a PDB from an External File
Transporting Data
Using the RMAN Convert Command
Moving Data from One PDB to Another PDB
Transporting a Tablespace
Using External Tables to load Transport Data
External Table Demo
Querying External Tables
Unloading External Tables
Automated Maintenance Tasks: Overview
Automated Maintenance Tasks: Components
Configuring Automated Maintenance Tasks
Enabling and Disabling Automated Maintenance Tasks
Modifying the Duration of a Maintenance Window
Database Monitoring and Tuning Performance Overview
Understanding What Database Performance is Monitored
Analyzing SQL and Optimizing Access Paths
Adaptive Execution Plans
