Description

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:

Generate database creation scripts using the Database Configuration Assistant (DBCA) and create a container database (CDB)
View and modify initialization parameters in SQL*Plus
Work with the Automatic Diagnostic Repository (ADR)
Implement Oracle Managed Files (OMF)
Use techniques to save space Understand DBA responsibilities for security and auditing
Transport tablespaces and databases
Use performance views and tools to monitor database instance performance

Course Overview

Accessing an Oracle Database
Creating an Oracle Database by Using DBCA and by Using a SQL Command
Starting Up and Shutting Down a Database Instance
Managing Database Instances
Configuring Naming Methods with Oracle Net Services
Configuring and Administering the Listener
Configuring a Shared Server Architecture
Configuring Oracle Connection Manager for Multiplexing and Access Control
Creating PDBs from Seed and Using Other Techniques
Managing PDBs
Database Storage Overview
Creating and Managing Tablespaces
Improving Space Usage
Managing Undo Data
Creating and Managing User Accounts
Configuring Privilege and Role Authorization
Configuring User Resource Limits
Implementing Oracle Database Auditing
Loading Data
Transporting Data
Using External Tables to Load and Transport Data
Automated Maintenance Tasks: Managing Tasks and Windows
Tuning Database Performance Overview
Monitoring Database Performance
Database Processes
Managing Memory
Analyzing SQL and Optimizing Access Paths

Oracle Database 19c: Administration Workshop Virtual Classroom Live June 09, 2025

Price: $5,000

Enroll today to reserve your spot!

Description

Course Overview

Other Available Dates for this Course

Find a Course

Corporate Services

Contact us