Name: Oracle Database 19c: Administration Workshop
SKU: D106546GC10
Price: 4000.00 USD
Availability: InStock

Oracle Database 19c: Administration Workshop

$4,000.00

SCHEDULED, 10-Jul-2023 - 14-Jul-2023, 09:00 AM - 05:00 PM US Pacific

SCHEDULED, 18-Sep-2023 - 22-Sep-2023, 09:00 AM - 05:00 PM US Pacific

SCHEDULED, 22-Jan-2024 - 26-Jan-2024, 09:00 AM - 05:00 PM US Eastern

Class Type

Schedules

TimeZone

Clear

Overview

This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. 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. Basic information on backup and recovery techniques is presented in this course.
To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.

Benefits to You

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

Topics

Introduction to Oracle Database

Accessing an Oracle Database

Creating an Oracle Database by Using DBCA

Creating an Oracle Database by Using a SQL Command

Starting Up and Shutting Down a Database Instance

Managing Database Instances

Oracle Net Services: Overview

Configuring Naming Methods

Configuring and Administering the Listener

Configuring a Shared Server Architecture

Configuring Oracle Connection Manager for Mulitplexing and Access Control

Creating PDBs from Seed

Using Other Techniques to Create PDBs

Managing PDBs

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

Introduction to Loading and Transporting Data

Loading Data

Transporting Data

Using External Tables to Load and Transport Data

Automated Maintenance Tasks: Overview

Automated Maintenance Tasks: Managing Tasks and Windows

Database Monitoring and Tuning Overview

Monitoring Database Performance

Database Processes

Managing Memory

Analyzing SQL and Optimizing Access Paths

Overview

Benefits to You

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

Audience

Database Administrator

Suggested Prerequisites

Familiarity with relational database design and concepts
Familiarity with Oracle SQL and Oracle PL/SQL

Topics

Introduction to Oracle Database
Accessing an Oracle Database
Creating an Oracle Database by Using DBCA
Creating an Oracle Database by Using a SQL Command
Starting Up and Shutting Down a Database Instance
Managing Database Instances
Oracle Net Services: Overview
Configuring Naming Methods
Configuring and Administering the Listener
Configuring a Shared Server Architecture
Configuring Oracle Connection Manager for Mulitplexing and Access Control
Creating PDBs from Seed
Using Other Techniques to Create PDBs
Managing PDBs
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
Introduction to Loading and Transporting Data
Loading Data
Transporting Data
Using External Tables to Load and Transport Data
Automated Maintenance Tasks: Overview
Automated Maintenance Tasks: Managing Tasks and Windows
Database Monitoring and Tuning Overview
Monitoring Database Performance
Database Processes
Managing Memory
Analyzing SQL and Optimizing Access Paths