• Understand Oracle Database 19c architecture and administration.
• Configure Oracle Net Services and database connectivity.
• Manage tablespaces, datafiles, users, privileges, and profiles.
• Implement database auditing and security controls.
• Configure backup, recovery, and Flashback capabilities.
• Monitor and tune database performance.
• Perform SQL tuning and use Oracle tuning advisors.
• Move data using Oracle Data Pump and SQL*Loader.
• Manage resources, scheduled jobs, and database space.
• Use Oracle Support tools and manage database patches.

Day 1

Session 1: Introduction to Oracle Database

• Overview of the Oracle database
• Relational database concepts
• Overview of Oracle Database Architecture
• Overview of Oracle Multitenant Architecture
• Overview of Oracle Data Guard
• Overview of Oracle RAC
• Overview of Oracle ASM
• Overview of the Oracle Cloud
• Database administration tasks

Session 2: Oracle Database Architecture

• Oracle database architecture
• The Oracle database instance
• Oracle Database memory structures
• Process architecture and structures
• Server and client processes
• Oracle database storage architecture
• Connecting to the Oracle database instance

Session 3: Administer a Database Instance

• Administrative tools available to a DBA
• SQL*Plus
• SQL Developer
• Enterprise Manager
• Enterprise Manager Database Express
• Enterprise Manager Cloud Control
• Initialization parameter files

Session 4: Configure the Oracle Network Environment

• Oracle Net Services
• Oracle Net Listener configuration and management
• Oracle Net naming methods
• Net Configuration Assistant
• Net Manager
• Listener configuration and management
• TNSPING
• Enterprise Manager network configuration

Session 5: Storage Structures

• Database blocks
• Tablespaces and datafiles
• Storage structures
• Tablespace creation and management
• Temporary tablespaces
• Datafile management
• Oracle Managed Files
• Dropping tablespaces and datafiles

Day 2

Session 6: Manage Users

• Database administration accounts
• User accounts
• User authentication
• Password management
• Managing and dropping user accounts
• Monitoring user information
• Terminating user sessions
• Schema-only accounts

Session 7: Manage Privileges

• Database access
• Oracle-supplied roles
• System and object privileges
• GRANT and REVOKE commands
• Creating and managing roles

Session 8: Manage Profiles and Resources

• User profiles
• Profile resource parameters
• Password management
• Resource usage controls
• Profile maintenance

Session 9: Database Auditing

• Database security
• Database auditing
• Security compliance
• Standard auditing
• Unified Audit Trail
• AUDIT_ADMIN and AUDIT_VIEWER roles
• Audit trail configuration
• Audit options

Day 3

Session 10: Data Concurrency and Lock Conflicts

• Levels of locking in Oracle
• Lock acquisition methods
• Data concurrency
• Causes of contention
• DML locks
• Preventing locking problems
• Detecting lock contention
• Resolving conflicts

Session 11: Undo Management

• Undo data
• Monitoring and administering undo
• Undo retention
• Undo tablespaces
• Retention periods
• Flashback query retention
• Undo space information
• Undo Advisor
• Undo tablespace sizing

Session 12: Backup and Recovery Configuration

• Oracle backup solutions
• Oracle backup strategy
• Database backup, restore, and recovery
• Flashback technology
• Types of failure
• Instance recovery
• MTTR Advisor
• Media failure
• Database recoverability

Session 13: Proactive Database Maintenance

• Database maintenance
• Alert log
• Automatic Workload Repository
• Statistics levels
• Automatic Database Diagnostic Monitoring
• Database monitoring
• Advisors
• Notification rules

Session 14: Performance Management

• Performance information sources
• Performance monitoring
• Tuning activities
• Performance planning
• Instance tuning
• Performance tuning methodology
• Performance data
• Memory management
• Private temporary tables

Day 4

Session 15: SQL Tuning

• SQL tuning
• Cancelling SQL statements
• Oracle Optimizer
• SQL Plan Directives
• Adaptive execution plans
• SQL Advisors
• Automatic SQL Tuning
• SQL Tuning Advisor

Session 16: Moving Data

• Directory objects
• Data Pump architecture
• Data Pump dictionary views
• Data Pump interactive mode
• Data Pump API
• Export and import operations
• SQL*Loader
• Command-line parameters
• Record filtering
• Control file keywords
• Datafiles
• SQL*Loader data paths
• External tables

Session 17: Managing Resources with Resource Manager

• Database Resource Manager
• Resource Manager configuration
• Resource plans
• Maintenance resource manager plan
• Resource plan directives
• Resource allocation

Session 18: Automate Tasks with the Scheduler

• Oracle Scheduler
• Access rights
• Scheduler components and workflow
• Creating jobs
• Job classes
• Time-based schedules
• Event-based schedules

Day 5

Session 19: Manage Space

• Space management
• Block space management
• Segment types
• Extent allocation
• Space allocation
• Row chaining and migration
• Tables without segments

Session 20: Oracle Support

• Enterprise Manager Support Workbench
• Security updates
• Oracle Support
• My Oracle Support integration
• Service Requests
• Patch management
• Applying patches

5 Days

• Explore Oracle Database architecture and administration tools.
• Administer database instances using SQL*Plus, SQL Developer, and Enterprise Manager.
• Configure Oracle Net Listener and test connectivity with TNSPING.
• Create and manage tablespaces and datafiles.
• Create and manage database users and roles.
• Configure privileges, profiles, and resource limits.
• Configure and review database auditing.
• Monitor locking and resolve lock contention.
• Configure and manage undo tablespaces.
• Configure database backup and recovery capabilities.
• Monitor database performance using Oracle diagnostic tools.
• Perform SQL tuning activities.
• Export and import data using Oracle Data Pump.
• Work with SQL*Loader and external tables.
• Configure Resource Manager plans.
• Create scheduled database jobs.
• Manage database space and segments.
• Use Enterprise Manager Support Workbench and patch management tools.

• Certification Exam: Oracle Database Administration I
• Exam Code: 1Z0-082
• Certification Path: Oracle Database Administration / Oracle Database certification pathway

• Oracle Database Administrators
• Database Support Professionals
• System Administrators supporting Oracle environments
• IT professionals responsible for Oracle database operations
• Professionals seeking practical Oracle Database 19c administration skills

• Understanding of relational database concepts.
• Good operating system knowledge.
• Working knowledge of Oracle SQL or prior Oracle SQL training.
• Basic Linux/UNIX knowledge is recommended.
• Familiarity with Oracle PL/SQL packages is advantageous but not mandatory.