Most popular
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
Oracle 19c Backup, Recovery, & Tuning
24 hours
Intermediate
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 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.
Trending
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
Oracle 19c Backup, Recovery, & Tuning
24 hours
Intermediate
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 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.
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