Get in Touch
 Duration 49 hours

Course Outline

Introduction to Core Concepts

  • Comprehensive overview of Oracle Database architecture
  • Distinguishing between a database instance and a database
  • Memory structures and process architectures (SGA, PGA, and background processes)
  • Management of parameter files, control files, redo logs, alert logs, and trace files
  • General introduction to Oracle Multitenant technology (CDB and PDB, and their scope within SE2)

Environment Setup and Installation

  • Reviewing prerequisites and supported platform requirements
  • Step-by-step installation of Oracle Database 19c SE2
  • Initial database creation using DBCA
  • Configuring post-installation elements: listeners, services, and Enterprise Manager Express

Administrative Tools and Connectivity

  • Establishing connections to Oracle Database instances
  • Basic commands and administration tasks in SQL*Plus
  • Leveraging Oracle SQL Developer for development and administration
  • Utilizing Oracle Enterprise Manager Express for monitoring and routine tasks
  • Configuration of Net Services and listener parameters

Instance and Database Governance

  • Understanding various startup and shutdown modes
  • Creating databases via DBCA and SQL scripts
  • Managing initialization parameters and dynamic performance views (V$)
  • Oversight of alert logs, trace files, and the Automatic Diagnostic Repository
  • Exploring the data dictionary

Connectivity Protocols and Naming Strategies

  • Setting up network connections
  • Implementing naming methods: Easy Connect, Local Naming, and Directory Naming
  • Managing database services
  • Configuring listener agents (both dynamic and static registration)

Multitenant Architecture (CDB and PDB) – SE2 Focus

  • Core concepts of CDBs and PDBs
  • Creating PDBs using PDB$SEED, OMF, and PDB_FILE_NAME_CONVERT parameters
  • Managing PDBs, including modes, parameters, and host/port settings
  • Procedures for removing PDBs
  • Configuring shared servers (SGA, PGA, and shared server modes)

Storage Management

  • Handling tablespaces and datafiles
  • Managing temporary and undo tablespaces
  • Understanding segments, extents, blocks, and space management strategies
  • Managing file growth, Oracle Managed Files (OMF), and datafile relocation

Security Frameworks and Auditing

  • Defining users, roles, and privileges (adhering to the principle of least privilege)
  • Establishing profiles, password policies, and resource limitations
  • Overview of auditing concepts within Oracle SE2
  • Implementing audits for critical operations

Backup and Recovery Strategies (RMAN)

  • Developing backup strategies: types, retention policies, and recovery targets
  • Configuring RMAN and managing catalogs
  • Addressing recovery scenarios: media failure, point-in-time recovery, and common errors
  • Validating backup integrity

Performance Monitoring and Optimization

  • Analyzing execution plans using EXPLAIN PLAN and AUTOTRACE
  • Diagnosing wait states and common events
  • Proactive monitoring through data dictionary and dynamic views
  • Applying tuning techniques specific to SE2

Migrating from Oracle 11g to 19c

  • Identifying upgrade paths and meeting prerequisites
  • Utilizing pre-upgrade and auto-upgrade tools
  • Performing validation steps and resolving compatibility issues
  • Executing post-upgrade tasks and addressing deprecated features
  • Conducting post-migration testing

Course Conclusion

  • Comprehensive summary of key topics
  • Recommendations for best practices

Recap and Future Steps

Requirements

  • A solid grasp of relational database fundamentals
  • Proficiency in writing SQL queries
  • Foundational knowledge of operating systems, such as Windows or Linux

Intended Audience

  • Database administrators
  • System administrators
  • IT specialists tasked with overseeing Oracle database environments

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories