Most popular
Oracle 19c Database Administration II
76 Lessons
40 hours
Intermediate
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 Data Integrator 19c Configuration and Administration
80 Lessons
24 hours
Intermediate
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 Tuning
40 hours
Intermediate
What you'll learn
Overview Oracle Database Architecture
Query Optimizer
Tuning Container Databases and Pluggable Databases
Oracle 12c Tuning features
Evaluating Execution Plans
Oracle Tuning Tools
Using Automatic Workload Repository
Join Types
AWR Using Baselines
Additional AWR performance tools
Optimizer Statistics
Monitoring a Service
Bind Variables and database parameters
Oracle’s Real Application Testing (RAT)
SQL Tuning Advisor
Automatic Sql Tuning
Sql Plan Management
Shared Pool Tuning
Tuning the database buffer cache
Tuning the PGA (Program Global Area)
Automatic Memory Management (AMM)
Tuning Segment Space Utilization (ASSM)
Automatic Storage Management
Oracle 19C PL/SQL FUNDAMENTALS | Introduction to PL/SQL
24 hours
Intermediate
What you'll learn
Oracle 19C PL/SQL Fundamentals provides a complete, hands-on, comprehensive introduction to PL/SQL including the use of both SQL Developer and SQL Plus.
Oracle 19c Database Administration I
40 hours
Intermediate
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
Oracle Data Integrator (ODI) 19c
24 hours
Intermediate
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 Database 19c Multitenant Architecture
24 hours
Intermediate
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 Enterprise Manager (OEM) 19c Cloud Control
24 hours
Intermediate
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 19c SQL Fundamentals
24 hours
Intermediate
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 19c New Features
24 hours
Intermediate
What you'll learn
New Features Overview
Multitenant New Features
Security Features
Cloud Services
Networking
Globalization
Big Data Support
Database Installation and Configuration
Database Tuning
Backup and Recovery
Trending
Oracle 19c Database Administration II
76 Lessons
40 hours
Intermediate
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 Data Integrator 19c Configuration and Administration
80 Lessons
24 hours
Intermediate
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 Tuning
40 hours
Intermediate
What you'll learn
Overview Oracle Database Architecture
Query Optimizer
Tuning Container Databases and Pluggable Databases
Oracle 12c Tuning features
Evaluating Execution Plans
Oracle Tuning Tools
Using Automatic Workload Repository
Join Types
AWR Using Baselines
Additional AWR performance tools
Optimizer Statistics
Monitoring a Service
Bind Variables and database parameters
Oracle’s Real Application Testing (RAT)
SQL Tuning Advisor
Automatic Sql Tuning
Sql Plan Management
Shared Pool Tuning
Tuning the database buffer cache
Tuning the PGA (Program Global Area)
Automatic Memory Management (AMM)
Tuning Segment Space Utilization (ASSM)
Automatic Storage Management
Oracle 19C PL/SQL FUNDAMENTALS | Introduction to PL/SQL
24 hours
Intermediate
What you'll learn
Oracle 19C PL/SQL Fundamentals provides a complete, hands-on, comprehensive introduction to PL/SQL including the use of both SQL Developer and SQL Plus.
Oracle 19c Database Administration I
40 hours
Intermediate
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
Oracle Data Integrator (ODI) 19c
24 hours
Intermediate
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 Database 19c Multitenant Architecture
24 hours
Intermediate
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 Enterprise Manager (OEM) 19c Cloud Control
24 hours
Intermediate
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 19c SQL Fundamentals
24 hours
Intermediate
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 19c New Features
24 hours
Intermediate
What you'll learn
New Features Overview
Multitenant New Features
Security Features
Cloud Services
Networking
Globalization
Big Data Support
Database Installation and Configuration
Database Tuning
Backup and Recovery
All Oracle Courses
Oracle Certification Online Training Courses - Live
Filter by category
Filter by Vendor
We found 11 courses available for you
Oracle 19C PL/SQL FUNDAMENTALS | Introduction to PL/SQL
24 hours
Intermediate
Course Description: Oracle 19C PL/SQL Fundamentals provides a complete, hands-on, …
$2,395.00
What you'll learn
Oracle 19C PL/SQL Fundamentals provides a complete, hands-on, comprehensive introduction to PL/SQL including the use of both SQL Developer and SQL Plus.
Oracle 19c Database Tuning
40 hours
Intermediate
Course Description: Oracle 19C Database Tuning is an intermediate level …
$2,795.00
What you'll learn
Overview Oracle Database Architecture
Query Optimizer
Tuning Container Databases and Pluggable Databases
Oracle 12c Tuning features
Evaluating Execution Plans
Oracle Tuning Tools
Using Automatic Workload Repository
Join Types
AWR Using Baselines
Additional AWR performance tools
Optimizer Statistics
Monitoring a Service
Bind Variables and database parameters
Oracle’s Real Application Testing (RAT)
SQL Tuning Advisor
Automatic Sql Tuning
Sql Plan Management
Shared Pool Tuning
Tuning the database buffer cache
Tuning the PGA (Program Global Area)
Automatic Memory Management (AMM)
Tuning Segment Space Utilization (ASSM)
Automatic Storage Management
Oracle Data Integrator 19c Configuration and Administration
80 Lessons
24 hours
Intermediate
Course Description: Oracle Data Integrator 19c Administration and Configuration. Explore …
$2,495.00
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
- 1
- 2