Oracle Database 19c Administration - 5 days online classroom

Total timeinfoThe time required for a learning intervention (e.g., one month, with a study load of 32 hours)
StudyloadinfoThe total time commitment expected of a participant, consisting of teaching hours and self-study hours for the total learning intervention.
Location
Online
Starting date and place

Oracle Database 19c Administration - 5 days online classroom

Adding Value Consulting EN
Logo Adding Value Consulting EN
Provider rating: starstarstarstarstar 9.9 Adding Value Consulting EN has an average rating of 9.9 (out of 28 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places
computer Online:
7 Dec 2026 until 11 Dec 2026
Description

Oracle Database 19c Administration - 5 days online classroom

Master the essential skills required to administer and support Oracle Database 19c environments with this hands-on Oracle Database 19c Administration course. Designed for database administrators and IT professionals, the course provides practical experience in configuring, managing, securing, monitoring, and maintaining Oracle databases in real-world enterprise environments.

Throughout the training, learners will work with Oracle architecture, storage management, user administration, networking, backup and recovery, performance monitoring, job scheduling, and security management using Oracle 19c tools and utilities. Interactive l…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Oracle, CompTIA A+ / Network+ / Security+, IT Security, Retail (Management), and Security.

Oracle Database 19c Administration - 5 days online classroom

Master the essential skills required to administer and support Oracle Database 19c environments with this hands-on Oracle Database 19c Administration course. Designed for database administrators and IT professionals, the course provides practical experience in configuring, managing, securing, monitoring, and maintaining Oracle databases in real-world enterprise environments.

Throughout the training, learners will work with Oracle architecture, storage management, user administration, networking, backup and recovery, performance monitoring, job scheduling, and security management using Oracle 19c tools and utilities. Interactive live labs and guided exercises help participants build the confidence to handle common DBA responsibilities efficiently and securely.

The course also covers Oracle Net Services, performance tuning concepts, automated job scheduling, auditing, and backup strategies — giving learners the practical DBA knowledge needed to support modern Oracle database infrastructures

Key Features

  • Course and material in english
  • Beginner - Intermediate level
  • 5 days of live instructor-led virtual training (8 hours / day)
  • Interactive hands-on live labs
  • All relevant course materials
  • 60+ recommended study hours
  • Certification included

Learning Outcomes

  • Oracle Database Administration Fundamentals: Develop the skills to manage and maintain Oracle Database 19c environments, including database architecture, storage management, user administration, and data security.
  • Oracle Network Configuration: Learn how to configure Oracle Net Services, manage listeners and naming methods, and troubleshoot connectivity using tools such as TNSPING and Net Manager to ensure reliable database access.
  • User & Privilege Management: Gain practical experience creating users, managing authentication, assigning roles, and controlling privileges while maintaining secure and compliant Oracle database environments.
  • Job Scheduling & Automation: Use Oracle Scheduler to automate administrative tasks such as backups, reporting, and maintenance jobs through time-based and event-driven scheduling for improved operational efficiency.

Target Audience

  • Oracle Database Administrators (DBAs)
  • Junior and mid-level database administrators
  • IT infrastructure and operations professionals
  • Database support engineers and system administrators
  • Technical professionals managing Oracle environments
  • Professionals preparing for Oracle DBA responsibilities
  • Teams responsible for database performance, security, and maintenance

Prerequisites

  • Basic understanding of relational database concepts
  • Familiarity with Oracle SQL and database querying
  • Basic Linux or command-line experience is beneficial
  • Previous exposure to PL/SQL or Oracle environments is helpful but not mandatory
  • Completion of an Oracle SQL course or equivalent experience is recommended

Course Outline

Day 1

Session 1: Introduction to Oracle Database

  • Oracle database and relational concepts
  • Oracle architecture and multitenant environment
  • Overview of Data Guard, RAC, ASM, and Oracle Cloud
  • Core database administration tasks

Session 2: Oracle Database Architecture

  • Oracle instance and architecture components
  • Memory and process structures
  • Client/server processes
  • Storage architecture and database connections

Session 3: Administering a Database Instance

  • DBA administration tools
  • Managing databases with SQL*Plus, SQL Developer, and Enterprise Manager
  • Enterprise Manager framework and Database Express
  • Initialization parameter files

Session 4: Configuring the Oracle Network Environment

  • Oracle networking fundamentals
  • Listener configuration and management
  • Net naming methods and connectivity tools
  • Configuring connections with Net Manager and Enterprise Manager
  • Using TNSPING and managing Oracle Net services

Session 5: Storage Structures

  • Database storage concepts and blocks
  • Tablespaces and datafiles
  • Managing storage with Enterprise Manager
  • Creating, altering, and dropping tablespaces and datafiles
  • Temporary tablespaces and Oracle Managed Files (OMF)

Day 2

Session 6: Managing Users

  • Database administration accounts
  • Creating and managing user accounts
  • User authentication and password management
  • Monitoring users and terminating sessions
  • Schema-only accounts

Session 7: Managing Privileges

  • Database access control
  • System and object privileges
  • Grant and revoke commands
  • Creating and managing roles
  • Using predefined Oracle roles

Session 8: Managing Profiles & Resources

  • User profiles and resource parameters
  • Creating and maintaining profiles
  • Password and resource management

Session 9: Database Auditing

  • Database security and auditing concepts
  • Standard auditing and unified audit trails
  • AUDIT_ADMIN and AUDIT_VIEWER roles
  • Configuring audit trails and audit options

Day 3

Session 10: Data Concurrency & Lock Conflicts

  • Oracle locking and concurrency control
  • DML locks and contention issues
  • Detecting and resolving lock conflicts
  • Preventing locking problems

Session 11: Undo Management

  • Undo data and tablespaces
  • Configuring undo retention
  • Monitoring and sizing undo space
  • Flashback query retention and Undo Advisor

Session 12: Backup & Recovery Configuration

  • Oracle backup and recovery concepts
  • Flashback technology and recovery methods
  • Instance and media recovery
  • Configuring database recoverability and MTTR

Session 13: Proactive Database Maintenance

  • Database monitoring and maintenance
  • Alert logs and Automatic Workload Repository (AWR)
  • Automatic Database Diagnostic Monitor (ADDM)
  • Advisors and notification rules

Session 14: Performance Management

  • Performance monitoring and tuning
  • Tuning methodologies and planning
  • Memory management and instance tuning
  • Managing private temporary tables

Day 4

Session 15: SQL Tuning

  • SQL performance tuning
  • Oracle Optimizer and execution plans
  • SQL Advisors and tuning recommendations
  • SQL Tuning Advisor and statement management

Session 16: Moving Data

  • Data Pump export and import
  • Directory objects and Data Pump architecture
  • SQL Loader fundamentals
  • Record filtering and control files
  • External tables and data loading methods

Session 17: Managing Resources with Resource Manager

  • Database Resource Manager overview
  • Creating resource plans and directives
  • Resource allocation and maintenance plans

Session 18: Automating Tasks with the Scheduler

  • Oracle Scheduler fundamentals
  • Scheduler workflow and access rights
  • Creating jobs and job classes
  • Time-based and event-based scheduling

Day 5

Session 19: Managing Space

  • Space management concepts
  • Segment and extent management
  • Space allocation techniques
  • Row chaining and migration
  • Creating tables without segments

Session 20: Oracle Support

  • Enterprise Manager Support Workbench
  • Oracle Support and security updates
  • My Oracle Support integration
  • Managing service requests and patches
  • Applying database patches

FAQ

What will I learn in this Oracle Database 19c Administration course?

You will learn how to administer Oracle databases, manage users and storage, configure networking, monitor performance, automate jobs, implement security controls, and perform backup and recovery operations.

Is this course suitable for beginner DBAs?

Yes. The course is designed for entry-level and aspiring DBAs who already have basic database and SQL knowledge and want to develop practical Oracle administration skills.

Does the course include hands-on labs?

Yes. The training includes interactive live labs and practical exercises focused on real-world Oracle DBA tasks and administration scenarios.

Will I learn backup and recovery techniques?

Yes. The course covers Oracle backup, restore, and recovery concepts, including ARCHIVELOG configuration and recovery management techniques.

Does the course cover Oracle performance monitoring?

Yes. You’ll learn how to monitor database performance using Oracle tools such as AWR, ADDM, and other diagnostic and performance management utilities.

Will I learn Oracle networking and connectivity?

Yes. The course includes Oracle Net Services, listener configuration, naming methods, connection testing, and troubleshooting connectivity issues.

Is Oracle 19c still relevant for database administrators?

Yes. Oracle Database 19c is a long-term support release widely used in enterprise environments, making Oracle 19c administration skills highly valuable for DBAs and infrastructure professionals.

What job roles benefit from Oracle DBA skills?

Oracle administration skills are valuable for database administrators, infrastructure engineers, database support specialists, cloud database professionals, and enterprise IT operations teams.

There are no reviews yet.
  • View related products with reviews: Oracle.
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.