Get in Touch
 Duration 35 hours

Course Outline

Preparing the Environment, Installation, and Configuration (SE2 Focus)

  • Review of prerequisites and supported platforms
  • Installation of Oracle Database 19c SE2 and creation of the initial database
  • Post-installation setup, including listeners, services, and EM Express

Oracle Database Architecture and Core Infrastructure

  • Distinguishing between instance and database concepts
  • Overview of SGA, PGA, Shared Pool, Database Buffer Cache, Redo Log, and background processes
  • Configuration of parameter files, diagnostic destinations, and alert/trace files

Administrative Tools and Connectivity

  • Fundamentals and common tasks in Enterprise Manager Express
  • Utilizing SQL Developer for both administrative and development workflows
  • Setting up Oracle Net Services and listener configurations (dedicated/shared basics)

Database Creation and Instance Management

  • Creating databases via DBCA and SQL commands
  • Managing startup/shutdown modes, services, and basic PDB awareness (as applicable to SE2)
  • Configuring initialization parameters and utilizing dynamic performance views (V$)

Best Practices for Storage Management

  • Managing tablespaces and datafiles, including local extent management, temp/undo segments
  • Monitoring segments, extents, blocks, and space usage
  • Handling growth, migrating datafiles, and considering OMF

Security and Auditing

  • Designing with least privilege in mind for users, roles, and system/object privileges
  • Implementing password policies, profiles, and resource limits
  • Introducing auditing concepts and implementation suitable for SE2

RMAN Backup and Recovery Strategies

  • Understanding backup types, retention policies, and recovery objectives
  • Configuring RMAN, managing catalogs (where applicable), and validating backups
  • Executing media recovery, point-in-time recovery, and handling failure scenarios

Performance Monitoring and Troubleshooting (SE2-Safe Methods)

  • Analyzing execution plans using EXPLAIN PLAN and AUTOTRACE
  • Basics of SQL tracing and wait events
  • Implementing proactive monitoring through data dictionary and dynamic views

Migration from 11g to 19c

  • Evaluating upgrade paths, prerequisites, and compatibility factors
  • Leveraging pre/auto-upgrade utilities and executing validation steps
  • Completing post-upgrade tasks, addressing deprecated features, and testing

Summary and Next Steps

Requirements

  • Fundamental understanding of SQL
  • Experience with operating system administration (Linux or Windows)
  • Basic grasp of core networking concepts, such as ports, services, and hostnames

Target Audience

  • System administrators
  • Technical consultants
  • Database administrators

Custom Corporate Training

Training solutions designed exclusively for businesses.

  • Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
  • Flexible Schedule: Dates and times adapted to your team's agenda.
  • Format: Online (live), In-company (at your offices), or Hybrid.
Investment

Price per private group, online live training, starting from 7250 € + VAT*

Contact us for an exact quote and to hear our latest promotions

Testimonials (2)

Upcoming Courses

Related Categories