Oracle Courses

Most popular

All Oracle Courses

Oracle Certification Online Training Courses - Live

We found 11 courses available for you

Oracle 19c Database Administration II

76 Lessons
40 hours

Course Description Geared for participants experienced with Oracle 19c DBA …

What you'll learn
Creating CDBs and Regular PDBs
Managing CDBs and PDBs
Backup and Duplicate
Upgrading and Transporting CDBs and Regular PDBs
Backup Strategies and Terminology
Restore and Recovery Concepts
Using Flashback Technologies
Duplicating a Database
Installing Grid Infrastructure and Oracle Database
Patching Grid Infrastructure and Oracle Database
Upgrading to Oracle Grid Infrastructure
Oracle Database 18c: New Features
Using General Overall Database Enhancements
Monitoring and Tuning Database Performance
Managing Application PDBs
Managing Security in Multitenant databases
Recovery and Flashback
Configuring and Using RMAN
Diagnosing Failures
Performing Recovery
Transporting Data
RMAN Troubleshooting and Tuning
Creating an Oracle Database by using DBCA
Oracle Restart
Upgrading the Oracle Database
Installing Grid Infrastructure for a Standalone server
Using Availability Enhancements
Tuning SQL Statements

Oracle 19c Backup, Recovery, & Tuning

24 hours

Course Description: Oracle Database 19c Backup and Recovery is a …

What you'll learn
mplement backup and recovery settings and perform backup operations to the media of your choice.
Move data between databases and files
Use Oracle Database recovery processes to recover from media and other failures.
Diagnose and repair data failures
Use flashback technologies and data duplication to complement backup and recovery procedures
Secure the availability of their database using backup and recovery strategies

Oracle 19c New Features

24 hours

Course Description: Oracle 19c New Features is a hands on …

What you'll learn
New Features Overview
Multitenant New Features
Security Features
Cloud Services
Big Data Support
Database Installation and Configuration
Database Tuning
Backup and Recovery

Oracle 19c SQL Fundamentals

24 hours

Course Description: Oracle 19C SQL Fundamentals Is a three-day, hands-on …

What you'll learn
Initially, you will learn about all the key elements of a database and the way Oracle systems facilitate their induction in the system. Then you will discover the tools you can use and the strategies you can implement to store, retrieve, compare and organize data according to your requirements.
You will also learn the process of creating simple to complex reports from existing data. By the end of this course, you will also have hands-on knowledge of SQL systems that are required to proceed to other advanced to professional programs.

Oracle Enterprise Manager (OEM) 19c Cloud Control

24 hours

Course Description: Oracle Enterprise Manager Cloud Control 19C (OEM 19c) …

What you'll learn
Use Cloud Control to organize your managed enterprise
Describe roles and privileges
Monitor the overall performance and health of your managed system
Manage incidents and set up notifications
Use the Job System to automate commonly performed tasks
Patch and provision new systems
View, search, and compare configurations
Explain compliance policies and evaluate policy violations
Create and use Cloud Control reports

Oracle Database 19c Multitenant Architecture

24 hours

Course Description: The multitenant architecture enables you to have many …

What you'll learn
Core concepts of regular PDBs
Creating a CDB, and then using different methods to create PDBs.
How to start and shut down a CDB and how to open and close a PDB.
Security aspects in CDBs and PDBs in various areas like privileges and roles, lockdown profiles, auditing, Database Vault, and encryption.
Availability through backup, duplicate, recovery, and flashback topics and then performance, monitoring, and resources allocation management in CDBs and PDBs.
How you can move data from a non-CDB environment to a PDB.
How to move data between PDBs by using utilities such as the export and import features of Oracle Data Pump, SQL*Loader, external tables, and Oracle Recovery Manager.

Oracle Data Integrator (ODI) 19c

24 hours

Course Description: Oracle Data Integrator 19c (ODI 19c) is a …

What you'll learn
Administer ODI resources and setup security with ODI
Apply ODI Topology concepts for data integration
Describe ODI Model concepts
Describe architecture of Oracle Data Integrator 12c
Design ODI Mappings, Procedures, Packages, and Load Plans to perform ELT data transformations
Explore, audit data, and enforce data quality with ODI
Implement Changed Data Capture with ODI

Oracle 19c Database Administration I

40 hours

Course Description: Oracle 19c Database Administration I is a comprehensive, …

What you'll learn
Describe Oracle Database architecture
Describe Oracle Database Cloud Service (DBCS) architecture and features
Create and manage DBCS database deployments
Configure the database to support your applications
Manage database security and implement auditing
Implement basic backup and recovery procedures
Move data between databases and files
Employ basic monitoring procedures and manage performance