Get in Touch
 Duration 21 hours

Course Outline

Introduction

  • Overview of the Oracle Database Appliance.
  • Deployment scenarios and use cases.
  • Initial configuration and setup procedures.

Oracle Database Performance Tuning Basics

  • Introduction to performance tuning principles.
  • Key performance metrics and indicators.
  • Analyzing workload and system performance.

SQL Tuning

  • Foundations of SQL tuning.
  • Leveraging the Oracle SQL Tuning Advisor.
  • SQL Plan Management.
  • Optimizing queries for improved performance.

Instance Tuning

  • Overview of instance tuning.
  • Utilizing the Oracle Automatic Workload Repository (AWR).
  • Understanding and applying Active Session History (ASH).
  • Identifying and resolving common instance-related performance issues.

Advanced Performance Diagnostics

  • Utilizing the Oracle Diagnostics Pack.
  • Monitoring performance with Oracle Enterprise Manager.
  • Advanced troubleshooting techniques.

Tuning Oracle Database on ODA

  • Specific tuning considerations for ODA.
  • Resource allocation and management strategies.
  • High Availability and disaster recovery tuning.
  • Best practices for ODA performance optimization.

Summary and Next Steps

Requirements

  • Fundamental knowledge of Oracle Database administration.
  • Proficiency in SQL and PL/SQL.
  • Understanding of core database performance concepts.

Target Audience

  • Database administrators.
  • System administrators.

Custom Corporate Training

Training solutions designed exclusively for businesses.

  • Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
  • Flexible Schedule: Dates and times adapted to your team's agenda.
  • Format: Online (live), In-company (at your offices), or Hybrid.
Investment

Price per private group, online live training, starting from 3900 € + VAT*

Contact us for an exact quote and to hear our latest promotions

(*The final price may vary depending on the technical specialization of the course, the level of customization, the method of delivery and the number of learners)

Need help picking the right course?
info@nobleprog.pt or +351 30 050 9666

Testimonials (2)

good explanation on each points and provide assignment for practices.

Piseth Ben - ACLEDA Bank Plc.
Course - Oracle Database 19c: SQL Tuning Workshop

Greg was very patient and helpful

Chris Havel - Encyclopaedia Britannica
Course - ORACLE SQL Fundamentals

Provisional Upcoming Courses (Contact Us For More Information)

Oracle Database Appliance HA X8-X9r

2026-11-16 09:30
21 hours
Hotel Tivoli Coimbra

Oracle Database Appliance HA X8-X9r

2026-11-30 09:30
21 hours
Évora Hotel

Oracle Database Appliance HA X8-X9r

2026-12-14 09:30
21 hours
Hotel Faro & Beach Club

Oracle Database Appliance HA X8-X9r

2026-12-28 09:30
21 hours
Holiday Inn Porto - Gaia

Related Courses

Oracle Database 19c Administration

 35 Hours
This instructor-led training in Portugal guides intermediate DBAs through Oracle Database 19c SE2 administration. Participants will master installation, security, backup, and performance tuning. It also covers migration strategies from 11g to 19c using practical tools.
Read more...

Oracle Database 19c SE2 Administration Essentials

 49 Hours
This instructor-led training in Portugal focuses on the installation, configuration, and management of Oracle Database 19c SE2. Participants will acquire practical skills in administration, backup, recovery, and migration, ensuring dependable database management and operational efficiency for real-world enterprise workloads.
Read more...

Oracle Database 19c: Administration

 35 Hours

This instructor-led, live training in Portugal (online or onsite) is designed for system administrators who wish to learn how to administer, monitor, and support an Oracle database.

By the end of this training, participants will be able to:

  • Comprehend the key features and architectural changes in the Oracle database.
  • Manage and monitor Oracle databases.
  • Optimize Oracle database performance.
Read more...

Oracle Database 19c - Backup and Recovery

 14 Hours

This instructor-led, live training in Portugal (online or onsite) is designed for beginner-level database administrators who wish to manage backup and recovery tasks in Oracle Database 19c.

Upon completion of this training, participants will be able to:

  • Grasp the fundamental concepts of backup and recovery in Oracle Database 19c, including its architecture and various failure modes.
  • Acquire practical experience in configuring backup and recovery settings, such as the RMAN environment and the fast recovery area.
  • Develop hands-on skills in executing diverse backup and recovery operations, including full, incremental, and point-in-time recovery.
  • Learn to leverage Oracle's Flashback technology for efficient database recovery and to manage disaster recovery scenarios.
  • Implement best practices for backup, recovery, and disaster recovery to ensure data availability and reduce downtime in Oracle Database 19c.
Read more...

Oracle Database 19c - Data Guard Administration

 21 Hours

This instructor-led, live training in Portugal (online or onsite) is aimed at intermediate-level database administrators who wish to manage, optimize, and secure Data Guard environments for robust disaster recovery and high availability.

By the end of this training, participants will be able to:

  • Understand the architecture and benefits of Oracle Data Guard for disaster recovery and high availability.
  • Gain hands-on experience in configuring and managing physical and logical standby databases, including Data Guard broker.
  • Develop practical skills in monitoring, troubleshooting, and optimizing Data Guard environments for optimal performance.
  • Learn advanced features such as Active Data Guard, Data Guard with RAC, and securing Data Guard communications.
  • Apply best practices for disaster recovery planning, ensuring data consistency, and automating Data Guard operations.
Read more...

Oracle Database 19c - Install and Upgrade

 7 Hours

This instructor-led, live training in Portugal (online or onsite) is designed for beginner-level database administrators aiming to equip themselves with the necessary skills to manage and optimise their Oracle environments effectively.

Upon completing this training, participants will be capable of:

  • Grasping the core features and architecture of Oracle Database 19c, encompassing system requirements and installation procedures.
  • Acquiring practical expertise in installing Oracle Database 19c and Oracle Grid Infrastructure, including the configuration of network, storage, and security settings.
  • Mastering the full upgrade process for Oracle Database 19c, ranging from pre-upgrade planning to post-upgrade validation.
  • Developing troubleshooting capabilities to address common challenges encountered during installation and upgrade phases.
  • Applying best practices for Oracle Database installation and upgrades to guarantee a seamless and successful deployment.
Read more...

Oracle Database 19c - Multitenant Architecture

 21 Hours

This instructor-led, live training in Portugal (online or on-site) is aimed at intermediate-level database administrators who wish to effectively manage and optimise a multitenant environment.

By the end of this training, participants will be able to:

  • Understand the key components and benefits of Oracle Database 19c's multitenant architecture, including CDBs and PDBs.
  • Gain practical skills in installing, configuring, and managing container databases (CDBs) and pluggable databases (PDBs).
  • Develop proficiency in implementing security measures, backup and recovery strategies, and performance tuning in a multitenant environment.
  • Learn how to manage high availability and disaster recovery in a multitenant architecture, including configuring Data Guard and Oracle RAC.
  • Acquire troubleshooting techniques and best practices for maintaining a secure, efficient, and reliable multitenant database environment.
Read more...

Oracle Database 19c - RAC, ASM, and Grid Infrastructure Administration

 35 Hours

This instructor-led, live training in Portugal (online or on-site) is designed for intermediate-level database administrators looking to manage and optimise complex, high-availability Oracle database environments.

Upon completion of this training, participants will be able to:

  • Gain a thorough understanding of Oracle RAC architecture and Grid Infrastructure, covering installation, configuration, and management.
  • Develop practical skills in managing Automatic Storage Management (ASM), including disk group management, instance tuning, and backup/recovery procedures.
  • Learn advanced RAC performance tuning techniques, disaster recovery configurations, and best practices for achieving high availability.
  • Acquire troubleshooting and diagnostic skills to resolve issues within RAC and Grid Infrastructure environments.
  • Understand the process of patching and upgrading Oracle RAC and Grid Infrastructure while minimising downtime and maintaining system stability.
Read more...

Oracle SQL for Administrators

 21 Hours

This instructor-led, live training in Portugal (online or onsite) is tailored for beginner-level database administrators and developers who want to master SQL for efficiently managing, querying, and manipulating data in Oracle databases for administrative and operational tasks.

Upon completing this training, participants will be able to:

  • Grasp Oracle database architecture, including schemas, users, and sessions.
  • Write and optimize SQL queries for data retrieval, filtering, and manipulation.
  • Utilize joins, subqueries, and set operators to work with multiple tables and complex queries.
  • Perform data aggregation, grouping, and analysis using SQL functions.
  • Manage schema objects such as views, sequences, and indexes to enhance database operations. 
Read more...

Oracle SQL for Developers

 35 Hours

This instructor-led, live training in Portugal (online or onsite) is tailored for intermediate-level developers and database administrators who aim to leverage Oracle SQL to design, manage, and optimize database applications while automating tasks efficiently.

Upon completion of this training, participants will be able to:

  • Grasp Oracle database architecture and manage users, schemas, and permissions.
  • Write optimized SQL queries for data retrieval, manipulation, and analysis.
  • Employ advanced SQL techniques, including joins, subqueries, and hierarchical queries.
  • Design and manage database objects such as tables, indexes, views, and sequences.
Read more...

Oracle Database 19c: Data Warehousing Concepts

 14 Hours
This live, instructor-led training in Portugal guides entry-level data professionals through the data warehousing concepts of Oracle Database 19c. Participants will acquire knowledge of core architecture, data modeling, and fundamental ETL practices to establish a robust analytical foundation for business intelligence.
Read more...

Oracle Database 19c: Data Warehousing Techniques

 21 Hours
This instructor-led training in Portugal covers data warehousing techniques in Oracle Database 19c, including schema design, ETL optimisation, and performance tuning. Participants will acquire hands-on skills to build efficient, scalable analytics solutions for business intelligence and reporting.
Read more...

Oracle Database 19c: SQL Tuning Workshop

 21 Hours
Participate in this instructor-led SQL tuning workshop in Portugal to master performance optimization for Oracle Database 19c. Participants will develop the ability to interpret execution plans, deploy tuning tools like AWR and ADDM, and employ indexing strategies to effectively resolve inefficient queries in practical scenarios.
Read more...

Oracle SQL for beginners

 21 Hours
This Oracle SQL introductory training in Portugal assists in developing fundamental database skills from the basics. Acquire the ability to write queries, manage data, and comprehend relational structures. Ideal for beginners seeking a robust foundation in SQL fundamentals.
Read more...

ORACLE SQL Fundamentals

 14 Hours
This two-day workshop in Portugal provides a foundational introduction to SQL for Oracle and other databases. It explores relational concepts, data retrieval, functions, joins, and advanced queries through practical exercises, empowering participants to develop core database competencies using sample data and free tools.
Read more...

Related Categories

Oracle
Oracle