Oracle 19c training

Lesson 1 • Creating and Configuring Databases

Demonstrates database creation using DBCA and manual scripts. Connects architecture concepts to real database provisioning tasks.

Lesson 2 • Oracle Net Services Configuration

Configures listener, tnsnames, and connection descriptors for client-server communication. Enables reliable remote connectivity required throughout the course.

Lesson 3 • Oracle 19c Installation and Configuration

Guides through pre-installation checks, software installation, and post-install validation. Ensures a correctly configured Oracle home ready for database creation.

Lesson 1 • DML and Transaction Control

Covers INSERT, UPDATE, DELETE, MERGE, and transaction management commands. Establishes data modification skills required for application development and administration.

Lesson 2 • Aggregation and Grouping

Introduces aggregate functions, GROUP BY, HAVING, and analytic functions. Supports reporting and summary queries used in application and DBA work.

Lesson 3 • DDL and Schema Objects

Teaches CREATE, ALTER, DROP for tables, indexes, views, and sequences. Prepares students to build and maintain schema structures independently.

Lesson 4 • Data Retrieval with SELECT

Teaches SELECT syntax, filtering, sorting, and column expressions. Forms the baseline query skill used in every subsequent chapter.

Lesson 1 • Exception Handling and Debugging

Addresses predefined exceptions, user-defined errors, and DBMS_OUTPUT debugging. Produces robust PL/SQL code that handles failures gracefully.

Lesson 2 • PL/SQL Block Structure and Variables

Introduces anonymous blocks, variable declaration, and data types. Establishes the structural foundation for all PL/SQL programming tasks.

Lesson 3 • Packages and Triggers

Covers package specification, body, and DML/DDL trigger creation. Organizes code into modular units and automates event-driven database actions.

Lesson 4 • Stored Procedures and Functions

Teaches creation, parameter modes, and invocation of procedures and functions. Enables reusable server-side logic callable from SQL and applications.

Lesson 1 • Tablespace and Storage Management

Teaches tablespace creation, datafile management, and space monitoring. Ensures efficient storage allocation and prevents space-related outages.

Lesson 2 • Redo Log and Archiving

Covers redo log groups, members, log switches, and ARCHIVELOG mode. Prepares the database for backup and recovery operations.

Lesson 3 • Undo Management and Flashback

Explains undo retention, undo tablespace sizing, and Flashback Query. Enables recovery from accidental DML without full database restore.

Lesson 4 • User and Privilege Management

Covers user creation, roles, system and object privileges, and profiles. Implements secure access control aligned with least-privilege principles.

Lesson 1 • RMAN Reporting and Catalog Maintenance

Uses RMAN LIST, REPORT, and catalog maintenance commands to manage backup metadata. Ensures backup inventory accuracy and supports compliance reporting.

Lesson 2 • Complete and Incomplete Recovery

Demonstrates complete database restore and point-in-time recovery procedures. Enables restoration of databases after media failure or logical corruption.

Lesson 3 • RMAN Architecture and Configuration

Introduces RMAN components, catalog vs. nocatalog mode, and channel configuration. Establishes the RMAN environment required for all backup operations.

Lesson 4 • Performing Backups with RMAN

Covers full, incremental, and image copy backups with compression and encryption. Produces reliable backup sets suitable for various recovery scenarios.

Lesson 1 • SQL Tuning and Execution Plans

Covers EXPLAIN PLAN, SQL Trace, TKPROF, and SQL Tuning Advisor. Identifies and resolves inefficient SQL execution paths.

Lesson 2 • Optimizer Statistics and Hints

Explains CBO statistics collection, histograms, and optimizer hints. Ensures the optimiser generates optimal execution plans for complex queries.

Lesson 3 • Contention and Locking Resolution

Diagnoses latch contention, enqueue waits, and blocking lock chains. Resolves concurrency issues that degrade multi-user application performance.

Lesson 4 • Memory and I/O Tuning

Addresses SGA, PGA, buffer cache, and I/O subsystem tuning. Reduces memory pressure and I/O latency for high-throughput workloads.

Lesson 1 • PDB Lifecycle Management

Manages PDB open modes, save states, and unplug/drop operations. Maintains PDB availability and supports controlled decommissioning.

Lesson 2 • Backup and Recovery for CDB/PDB

Applies RMAN backup and recovery commands at CDB and individual PDB levels. Extends backup skills to multitenant-specific recovery scenarios.

Lesson 3 • Creating and Cloning PDBs

Covers PDB creation from seed, cloning from existing PDBs, and plug-in operations. Enables rapid database provisioning and environment duplication.

Lesson 4 • CDB and PDB Architecture Deep Dive

Explains CDB root, seed, and PDB containers with shared and local objects. Builds the conceptual model required for all multitenant administration tasks.

Lesson 1 • Unified Auditing Configuration

Configures unified audit policies for actions, objects, and privilege use. Provides a centralised audit trail required for compliance and forensic investigation.

Lesson 2 • Privilege Analysis and Least Privilege

Uses Oracle Privilege Analysis to identify unused privileges and reduce attack surface. Enforces least-privilege access across database users and roles.

Lesson 3 • Transparent Data Encryption

Implements TDE for tablespace and column-level encryption using Oracle Wallet. Protects data at rest from unauthorised storage-level access.

Lesson 4 • Network Encryption and Data Redaction

Configures Oracle Native Network Encryption and Data Redaction policies. Secures data in transit and masks sensitive output for unauthorised users.