How to use tools to access an Oracle Database

Generate database creation scripts by using DBCA

How to create a container database (CDB) by using the CREATE DATABASE command

Learn about Startup and shut down Oracle databases

Initialization parameter files and initialization parameters

Tools that are used to administer Oracle Net Services

How to use the Oracle Connection Manager Control utility to administer Oracle Connection Manager

How to create a new PDB from the PDB seed

Logical and physical storage structures in an Oracle database

Usage of Oracle Database features that save space

Explanation of DML and undo data generation

Learn about general architecture of Oracle Data Pump and SQL*Loader

How to use SQL*Loader to load data from a non-Oracle database (or user files)

<b>Bonus Content / Time Permitting:</b> Explanation of maintenance windows

<b>Bonus Content / Time Permitting:</b> Employ basic monitoring procedures and manage performance

<b>CDB Management Skills</b>: Gain expertise in managing Container Databases (CDBs), including setup, configuration, and maintenance.

<b>PDB Operations Proficiency</b>: Develop the ability to efficiently handle Pluggable Database (PDB) operations like creation, cloning, and management.

<b>Database Security Measures</b>: Learn to implement and manage security protocols in both CDBs and PDBs, ensuring data integrity and compliance.

<b>Backup and Recovery Techniques</b>: Master the techniques for performing backups and recoveries of CDBs and PDBs, ensuring data safety and continuity.

<b>Performance Optimization</b>: Acquire skills to optimize the performance of databases within the Oracle Multitenant environment, including tuning and resource allocation.

<b>Data Movement and Storage Management</b>: Understand and apply methods for effective data movement and storage management in a Multitenant architecture.

Implement 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

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

Develop a solid understanding of Oracle 19c Database Architecture: By the end of this course, you'll be comfortable with the components of Oracle's database system, from Instance Definitions to Datafile Definitions.

Master the Query Optimizer: You'll gain a firm grasp of SQL Parsing, Optimizing Terms, and Query Plan Generation. You'll learn how to build efficient queries that provide the data you need without unnecessary strain on your systems.

Get comfortable with Tuning Container and Pluggable Databases: You'll learn how to optimize and manage pluggable databases, enhancing the performance of your data operations.

Explore Oracle Tuning Features: We'll get you familiar with Oracle's Heat Map and delve into the 19c Compression Levels and Types, boosting your database's efficiency.

Learn to Evaluate Execution Plans: You'll become proficient in defining SQL execution plans and using the Automatic Workload Repository, allowing you to monitor and improve the performance of your queries.

Gain hands-on experience with Oracle Tuning Tools: You'll practice with tools like the Enterprise Manager and Automatic Database Diagnostic Monitor, equipping you to handle real-world tuning tasks with confidence.

Using PL/SQL programming language for database applications and development.

Incorporating PL/SQL modules within the application architecture from the initial design and planning phase.

The essentials of building executable PL/SQL program units.

Each of the major segments of a working program and how these interact with each other during program execution.

Important error or exception handling capabilities of the language.

How database-resident program units can be used as part of the overall database application architecture.

Applying these new skills to the development of PL/SQL packages.

Advanced database programming capabilities and benefits.

How database triggers can be used as part of an advanced database application design.

How to use tools to access an Oracle Database

Generate database creation scripts by using DBCA

How to create a container database (CDB) by using the CREATE DATABASE command

Learn about Startup and shut down Oracle databases

Initialization parameter files and initialization parameters

Tools that are used to administer Oracle Net Services

How to use the Oracle Connection Manager Control utility to administer Oracle Connection Manager

How to create a new PDB from the PDB seed

Logical and physical storage structures in an Oracle database

Usage of Oracle Database features that save space

Explanation of DML and undo data generation

Learn about general architecture of Oracle Data Pump and SQL*Loader

How to use SQL*Loader to load data from a non-Oracle database (or user files)

<b>Bonus Content / Time Permitting:</b> Explanation of maintenance windows

<b>Bonus Content / Time Permitting:</b> Employ basic monitoring procedures and manage performance

<b>CDB Management Skills</b>: Gain expertise in managing Container Databases (CDBs), including setup, configuration, and maintenance.

<b>PDB Operations Proficiency</b>: Develop the ability to efficiently handle Pluggable Database (PDB) operations like creation, cloning, and management.

<b>Database Security Measures</b>: Learn to implement and manage security protocols in both CDBs and PDBs, ensuring data integrity and compliance.

<b>Backup and Recovery Techniques</b>: Master the techniques for performing backups and recoveries of CDBs and PDBs, ensuring data safety and continuity.

<b>Performance Optimization</b>: Acquire skills to optimize the performance of databases within the Oracle Multitenant environment, including tuning and resource allocation.

<b>Data Movement and Storage Management</b>: Understand and apply methods for effective data movement and storage management in a Multitenant architecture.

Implement 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

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

Develop a solid understanding of Oracle 19c Database Architecture: By the end of this course, you'll be comfortable with the components of Oracle's database system, from Instance Definitions to Datafile Definitions.

Master the Query Optimizer: You'll gain a firm grasp of SQL Parsing, Optimizing Terms, and Query Plan Generation. You'll learn how to build efficient queries that provide the data you need without unnecessary strain on your systems.

Get comfortable with Tuning Container and Pluggable Databases: You'll learn how to optimize and manage pluggable databases, enhancing the performance of your data operations.

Explore Oracle Tuning Features: We'll get you familiar with Oracle's Heat Map and delve into the 19c Compression Levels and Types, boosting your database's efficiency.

Learn to Evaluate Execution Plans: You'll become proficient in defining SQL execution plans and using the Automatic Workload Repository, allowing you to monitor and improve the performance of your queries.

Gain hands-on experience with Oracle Tuning Tools: You'll practice with tools like the Enterprise Manager and Automatic Database Diagnostic Monitor, equipping you to handle real-world tuning tasks with confidence.

Using PL/SQL programming language for database applications and development.

Incorporating PL/SQL modules within the application architecture from the initial design and planning phase.

The essentials of building executable PL/SQL program units.

Each of the major segments of a working program and how these interact with each other during program execution.

Important error or exception handling capabilities of the language.

How database-resident program units can be used as part of the overall database application architecture.

Applying these new skills to the development of PL/SQL packages.

Advanced database programming capabilities and benefits.

How database triggers can be used as part of an advanced database application design.