Oracle Database 19c: Administration Workshop

Course code

19cDB-ADMIN

Duration

5 Days, 40 Acad. Hours

Download pdf

Course Overview

Objectives

Prerequisites

Course Outline

Course Overview

Course overview

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.

Objectives

Course Objectives

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

Prerequisites

Prerequisites:

Understanding of relational database concepts and a good knowledge of the operating system.
Completed Oracle SQL course or familiar with Oracle SQL.

Audience

Database Administrator
System Administrator

Course Outline

Introduction to Oracle Database
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

Back to trainings (Oracle)

Request the training

Oracle Database 19c: Administration Workshop

Course code:

19cDB-ADMIN

Duration:

5 Days, 40 Acad. Hours

Apply

Download pdf