Oracle 19c database administration

⏰ 4 days (32 training hours) of practical training

Live online course with hands-on workshop combining expert theory, practical labs, and interactive Q&A sessions in each module.

Bite-Sized Learning Theory: Grasp key concepts quickly through clear, concise mini-lectures.
Hands-On Practice: Immediately apply what you've learned through practical computer exercises.
Learn-by-Doing Approach: This dual format solidifies your skills by bridging the gap between theory and application.

Official training certificate issued upon course completion.

Check available dates and register via this form.

The training will enable the acquisition of skills for monitoring server health and databases. Skills acquired during the training also includes server configuration management database schemas and users, as well as the current performance of administrative tasks. Practical exercises will be carried out on MS Windows.

Registration form

Participants will learn about the structure of the Oracle server, principles of instance architecture and data organization in databases. Knowledge includes the issues of the impact of database storage structures, schemas and server configuration to its proper work. The participant will gain knowledge of safety rules in the databases and the practical ability to configure access management and Oracle Network Environment configuration.

After completing the course, participants will know how to:

modify the relevant instance, database and session parameters
start, stop and restart the server
design and create a new database
prepare parameters file
create and manage users
grant and revoke the roles and privileges
manage schema objects and their parameters
manage tablespaces
use Flashback mechanisms to recover data
monitor database on different levels
configure the listener
create a database link and use remote query

This course is for database administrators.

The training can be useful also for developers implementing databases and database applications who – by understanding the principles of operation of the server – will be able to better use its potential.

The training is carried out in the form of theoretical part in the form of mini lectures and the practical part in the form of computer exercises.

4 days, 32 training hours

Oracle Server Architecture Overview

Databases and instances

New features in Oracle 19c instance architecture

Multitenant Architecture

Container databases

Pluggable databases

The differences in the container management in the Enterprise and Standard editions

Logical storage structure

Tablespaces
Blocks
Extents
Segments

Database users

Database and Diagrams
Schemes and their objects

Logical database structure

Tables
Limitations
Indexes
Views
Profiles
Sequences
Synonyms

The physical data storage structure

Data Files
Redo log files
Control files
Archived log files
Initialization parameter files
Alerts log and trace files
Backup files
Oracle ManagedFiles
Password files

Instance memory structures

SGA
PGA
Shared SQL Area
Background Processes

Starting and Closing instance

Creating a database

Initialization parameters

Binary and text parameters file
Basic parameters
Advanced Parameters

Selecting and updating data (how SQL commands are processed)

Dynamic memory management of the SGA

Ensuring consistency and concurrency transactions

Managing database structure

Tablespaces

Types of tablespaces
Architecture OFA (Optimal Flexible Architecture)
SYSTEM tablespace
SYSAUX tablespace
TEMP tablespace
UNDOTBS1 tablespace
USERS tablespace
EXAMPLE tablespace
Managing tablespaces
Changing the size of the tablespace
Segments in the spaces tables

Managing the physical structure of the database

Moving data files
Moving redo log files
Transferring control files
Automatic Storage Management architecture

Storage Space management

Free space management in tablespaces
Providing space for temporary segments
Undo tablespace management
Fragmented tablespaces and segments
Local tablespace management
Bigfile tablespaces
Segment Advisor
Undo Advisor
Automatic Workload Repository
The use of indices

Rollback

Data read consistency
Recovering

Oracle Flashback

Flashback Query
DBMS_FLASHBACK package
FlashbackVersions Query
FlashbackTransaction Query
FlashbackTable
Flashback Drop
Flashback Database

National language support

Oracle Scheduler and DBMS_SCHEDULER package

Oracle Net

Descriptors
Network Services
Listener Processes
Oracle Net Configuration Assistant
Oracle Net Manager
Server Listener

Distributed Databases

Database Connectivity
Remote selects

System resources control and management

Database users support

Security system

Privileges
Roles
Database access management
Profile Management

Monitoring

Data monitoring location
Instructions monitoring
Privileges monitoring
Schema objects monitoring
Precision monitoring
Monitoring dictionary views

Sign up for training!

Join us to build your expertise and take the next step in your career!

Registration form

Oracle 19c database administration

Oracle 19c database administration

Quick Facts

Full program

Sign up for training!

Similar trainings

📩 Any questions? Get in touch with us!