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

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 provides a complete, hands-on, comprehensive introduction to PL/SQL including the use of both SQL Developer and SQL Plus.

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

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

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.

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

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.

New Features Overview

Multitenant New Features

Security Features

Cloud Services

Networking

Globalization

Big Data Support

Database Installation and Configuration

Database Tuning

Backup and Recovery

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

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

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 provides a complete, hands-on, comprehensive introduction to PL/SQL including the use of both SQL Developer and SQL Plus.

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

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

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.

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

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.

New Features Overview

Multitenant New Features

Security Features

Cloud Services

Networking

Globalization

Big Data Support

Database Installation and Configuration

Database Tuning

Backup and Recovery

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