Oracle Certified Professional (OCP) 12C / 19C Database Administration
Course Duration: 120 Hours
About Oracle Database: Introduction to SQL (40 Hours)
Prerequisites
- No prior database knowledge required.
- Preferred OS: Windows (detailed guidance provided for installation).
Objectives
- Understand the major structural components of Oracle Database 12c.
- Execute advanced SELECT statements to query and retrieve data.
- Perform data manipulation (DML) and manage schema objects.
- Create and manage tables, views, sequences, synonyms, and indexes.
- Display data using ANSI SQL 99 JOIN syntax.
- Develop custom reports using SQL functions and aggregate data.
About Oracle Database 19c: Administration (40 Hours)
Prerequisites
- Proficiency in Oracle SQL (e.g., completion of the 1Z0-071 exam).
- Minimum hardware requirements: 50 GB free disk space, 8 GB RAM.
Objectives
- Understand and manage Oracle Database architecture.
- Monitor and manage Oracle Database 12C/19C instances.
- Configure and manage network connections, security, and user privileges.
- Manage tablespaces and undo data for optimized database performance.
- Implement auditing and data concurrency control.
About Oracle Database 19C: Backup and Recovery Workshop (40 Hours)
Prerequisites
- Familiarity with Oracle database administration.
- Basic understanding of Linux operating systems.
Objectives
- Diagnose and repair database failures using Data Recovery Advisor.
- Use Oracle Flashback Technologies for error recovery.
- Perform encrypted database backup and restore.
- Execute tablespace point-in-time recovery.
- Plan and implement effective backup strategies for business continuity.
Oracle 19c: Database Administration
Course Outline
Module 1: Oracle Database 12c: Introduction to SQL (1Z0-071)
Duration: 40 Hours
- Introduction
- Data Retrieval
- Retrieve Data using the SQL SELECT Statement
- Restricting and Sorting Data
- Using Single-Row Functions to Customize Output
- Using Conversion Functions and Conditional Expressions
- Data Aggregation and Reporting
- Reporting Aggregate Data Using the Group Functions
- Data Relationships
- Displaying Data From Multiple Tables Using Joins
- Using Subqueries to Solve Queries
- Using the SET Operators
- Data Manipulation
- Managing Tables Using DML Statements
- Introduction to Data Definition Language
- Introduction to Data Dictionary Views
- Creating Sequences, Synonyms, and Indexes
- Creating Views
- Managing Schema Objects
- Advanced Subqueries
- Retrieving Data by Using Subqueries
- Manipulating Data by Using Subqueries
- User and Data Access Control
- Controlling User Access
- Managing Data in Different Time Zones
Module 2: Oracle Database 19c: Administration (1Z0-082)
Duration: 40 Hours
- Getting Started
- Exploring Oracle Database Architecture
- Managing Database Instances
- Creating Pluggable Databases (PDBs)
- Configuring the Oracle Network Environment
- User and Security Administration
- Administering User Security
- Storage and Tablespaces
- Creating and Managing Tablespaces
- Managing Storage Space
- Managing Undo Data
- Data Management
- Moving Data
- Backup and Recovery Concepts
- Database Performance
- Monitoring and Tuning Database Performance
- SQL Tuning
- Oracle Database Resource Manager
- Enterprise Manager and Cloud
- Enterprise Manager Cloud Control
- Introduction to Oracle Database Cloud Service
- Creating and Managing DBCS (Database Cloud Service) Database Deployments
- Backing Up, Restoring, and Patching DBCS Database Deployments
- Data Security
- Creating Master Encryption Keys for PDBs
- Tablespace Encryption by Default
Module 3: Oracle Database 19c: Backup and Recovery Workshop (1Z0-083)
Duration: 40 Hours
- Introduction and Setup
- Getting Started
- Configuring for Recoverability
- Using the RMAN Recovery Catalog
- Backup Management
- Backup Strategies and Terminology
- Performing Backups
- Improving Backup Performance
- Using RMAN-Encrypted Backups
- Failure Diagnostics and Recovery
- Diagnosing Database Failures
- Restore and Recovery Concepts
- Performing Recovery (Parts 1 & 2)
- Advanced Backup and Flashback
- RMAN and Oracle Secure Backup
- Performing Tape Backups and Restores
- Using Flashback Technologies (Including Flashback Database)
- Database Management
- Managing Backup Space
- Transporting Data
- Duplicating a Database
- RMAN Performance and Tuning
- Workshop and Cloud Service
- Backup and Recovery Workshop
- Oracle Database Cloud Service: Overview
