Instructor-led live training courses for Oracle Database (Oracle RDBMS or Oracle) are offered both online and onsite. These sessions explore the core principles of Oracle through guided discussion and practical exercises.
Oracle training is available in two formats: "online live training" or "onsite live training." Online live training (also known as "remote live training") is delivered via an interactive remote desktop. Onsite live training can take place locally at customer premises in Lyon or at NobleProg corporate training centers in Lyon.
NobleProg -- Your Local Training Provider
Lyon, Swisslife Tower
NobleProg Lyon, 10 Place Charles Béraudier, Lyon, france, 69000
Located 200 meters far from the train station TGV, Swisslife Tower is today the most representative building of this quarter of Lyon. The Business Center offers you a perfect location for your training.
Gares TGV
100meters from Gare TGV Part-Dieu , porte du Rhône Exit
Aéroport
30 minutes from Lyon Saint Exupéry (Satolas)
Rhône Express from Saint Exupéry airport (Terminus Gare part-Dieu)
Oracle Linux 9 provides robust tools and features designed to build secure, scalable, and highly available infrastructure. This advanced-level course emphasizes enterprise system design, security hardening, networked services, kernel optimization, and automation via Ansible.
Delivered as an instructor-led, live training session (available online or onsite), this program targets advanced Linux professionals aiming to deepen their expertise in deploying and maintaining critical Oracle Linux 9 infrastructure.
Upon completion, participants will be capable of:
Deploying and managing high-availability services using clustering tools.
Configuring secure network services and enforcing system-wide security hardening.
Automating infrastructure management through Ansible playbooks.
Tuning system performance to align with specific workloads and services.
Course Format
Interactive lectures and discussions.
Extensive exercises and practical practice.
Hands-on implementation within a live-lab environment.
Customization Options
To arrange customized training for this course, please contact us.
Oracle Linux 9 extends its enterprise-ready foundation by providing powerful tools for system performance, networking, automation, and storage management. This course enhances the administrator's skill set by introducing advanced administration techniques, system optimization, and service management within enterprise environments.
This instructor-led, live training (available online or onsite) is designed for intermediate-level Linux administrators who wish to deepen their expertise in administering Oracle Linux 9 systems in production settings.
Upon completion of this training, participants will be able to:
Automate administrative tasks using Bash scripting.
Configure logical volumes, RAID, and advanced storage systems.
Manage SELinux policies and file security contexts.
Monitor system performance and resource usage.
Course Format
Interactive lectures and discussions.
Extensive exercises and practice sessions.
Hands-on implementation in a live-lab environment.
Course Customization Options
To request customized training for this course, please contact us to arrange.
Oracle Linux 9 is an enterprise-grade Linux distribution optimised for performance, security, and compatibility with Red Hat Enterprise Linux. This course introduces participants to fundamental system administration tasks, covering key concepts in user management, file systems, networking, and software package management.
This instructor-led, live training (online or onsite) is aimed at beginner-level Linux administrators who wish to build a strong foundation in Oracle Linux 9 system administration.
By the end of this training, participants will be able to:
Install and configure Oracle Linux 9 for enterprise use.
Manage users, groups, file systems, and permissions.
Configure software repositories and install packages.
Perform basic system monitoring and troubleshooting tasks.
Format of the Course also allows for the evaluation of participants.
Interactive lecture and discussion.
Lots of exercises and practice.
Hands-on implementation in a live-lab environment.
Course Customization Options
To request a customized training for this course, please contact us to arrange.
Oracle Database Security provides detective controls that monitor, log, and alert on potentially unauthorized or malicious activity, ensuring compliance, visibility, and faster incident response.
This instructor-led, live training (online or onsite) is aimed at intermediate-level Oracle DBAs and security professionals who wish to configure and monitor auditing, logging, and activity detection features in Oracle environments.
By the end of this training, participants will be able to:
Enable and customize Oracle auditing tools for compliance and monitoring.
Configure Oracle Unified Audit, Fine-Grained Auditing (FGA), and audit policies.
Deploy Oracle Audit Vault and Database Firewall for centralized monitoring.
Detect and analyze suspicious behavior and potential threats.
Format of the Course also allows for the evaluation of participants.
Interactive lecture and discussion.
Hands-on use of Oracle auditing and monitoring features.
Guided exercises focused on audit design, policy enforcement, and alerting.
Course Customization Options
To request a customized training for this course based on your organization's audit policies, please contact us to arrange.
Oracle Database Security comprises a suite of technologies and best practices aimed at preventing unauthorized access, ensuring compliance, and safeguarding sensitive data within Oracle environments.
This instructor-led live training, available online or onsite, is designed for intermediate Oracle administrators and security professionals seeking to implement preventive controls to protect Oracle databases from both internal and external threats.
Upon completion of this training, participants will be able to:
Apply mechanisms for authentication, authorization, and privilege management.
Harden Oracle installations in accordance with industry-standard practices.
Configure data masking, encryption, and database firewall options.
Implement policies for access control and regulatory compliance.
Format of the Course also allows for the evaluation of participants.
Interactive lecture and discussion.
Hands-on use of Oracle security tools and configurations.
Guided exercises focused on security policy enforcement and access control.
Course Customization Options
To request a customized training for this course based on your security policies and Oracle deployment, please contact us to arrange.
Oracle Database 23ai represents Oracle’s next-generation database platform, delivering advanced AI integration, automation, and administrative capabilities tailored for contemporary data workloads.
This instructor-led live training (available online or on-site) targets intermediate Oracle administrators seeking to explore and deploy the latest Oracle Database 23ai features to enhance performance, security, and AI-driven functionalities.
Upon completing this training, participants will be able to:
Identify and assess the primary new features introduced in Oracle 23ai.
Configure AI Vector Search and integrate AI-based workloads.
Utilize improved automation, observability, and performance optimization tools.
Plan version upgrades and implement new 23ai capabilities within production environments.
Course Format
Interactive lectures and group discussions.
Practical application of Oracle 23ai features in test environments.
Guided labs focusing on implementation strategies and migration planning.
Customization Options
For tailored training based on your specific Oracle infrastructure, please contact us to arrange a customized session.
This instructor-led, live training session (Lyon or onsite) is designed for intermediate to advanced system administrators and IT professionals aiming to deepen their expertise in Oracle Linux 9, covering system administration, performance tuning, security hardening, and automation.
By the end of this training, participants will be able to:
Manage and optimize Oracle Linux 9 for enterprise environments.
Implement advanced networking and security configurations.
Automate system administration tasks using scripting.
Monitor and troubleshoot performance issues effectively.
This instructor-led, live training in Lyon (online or onsite) is aimed at beginner-level to intermediate-level IT professionals and Linux users who wish to gain a solid understanding of Oracle Linux 9, from installation and configuration to system administration and security.
By the end of this training, participants will be able to:
This instructor-led live training in Lyon (online or onsite) is designed for intermediate-level database administrators and IT professionals aiming to acquire practical expertise in installing, configuring, securing, and maintaining Oracle Database 23ai.
By the end of this training, participants will be able to:
Install and configure Oracle Database 23ai.
Manage database storage, users, and security settings.
Optimize database performance using AI-driven automation.
Implement backup and recovery strategies.
Monitor and troubleshoot database performance issues.
This instructor-led, live training in Lyon (online or onsite) is aimed at advanced-level system administrators who wish to learn advanced system administration tasks, security configurations, network management, automation, and performance tuning for enterprise environments.
By the end of this training, participants will be able to:
Master advanced package management techniques, including creating custom repositories, resolving dependencies, and managing RPM packages with GPG keys.
Implement and manage advanced filesystems and storage solutions using LVM, encryption, snapshots, and high-performance filesystems like XFS, Btrfs, and ZFS.
Configure and manage advanced network services such as NIC bonding/teaming, VPNs, and secure remote administration tools.
Configure high-availability clusters using Pacemaker and Corosync, including setting up failover services and monitoring cluster health.
Manage virtualization environments with Oracle Linux Virtualization Manager (OLVM), and containers using Docker and Podman for container orchestration.
This instructor-led, live training in Lyon (online or onsite) is aimed at advanced-level system administrators who wish to deepen their knowledge in system management, troubleshooting, and performance tuning.
By the end of this training, participants will be able to:
Configure and manage advanced user and group settings, including implementing user quotas and system-wide user environments.
Use security auditing tools and configure sudo for controlled administrative access.
Monitor and optimize system performance.
Configure, analyze, and troubleshoot system logs.
Develop and implement backup and recovery solutions.
This instructor-led, live training in Lyon (online or onsite) targets intermediate-level system administrators seeking to effectively manage Oracle Linux Virtualization environments.
By the end of this training, participants will be able to:
Install and configure Oracle Linux Virtualization Manager and its associated components on a physical or virtual environment.
Create, configure, and manage virtual machines (VMs) using OLVM.
Set up virtual networks, VLANs, and manage network interfaces for virtual machines.
Apply resource management techniques and performance tuning for both VMs and hosts.
Diagnose and resolve common issues in virtualized environments using OLVM diagnostic tools and logs.
This instructor-led, live training in Lyon (online or onsite) is designed for beginner-level database administrators seeking to effectively manage and optimize their Oracle environments.
Upon completing this training, participants will be able to:
Comprehend the core features and architecture of Oracle Database 19c, including system prerequisites and installation procedures.
Acquire practical expertise in installing Oracle Database 19c and Oracle Grid Infrastructure, encompassing network, storage, and security configuration.
Master the end-to-end process of upgrading to Oracle Database 19c, ranging from pre-upgrade planning to post-upgrade validation.
Cultivate troubleshooting capabilities to resolve common issues encountered during installation and upgrade phases.
Implement best practices for Oracle Database installation and upgrade to guarantee a seamless and successful deployment.
Oracle Linux Virtualization Manager serves as a robust platform for managing and orchestrating virtualized server infrastructures.
This instructor-led, live training session (available online or onsite) is designed for intermediate-level professionals aiming to master Oracle Linux Virtualization Manager in preparation for the OLVMCA certification exam.
Upon completion of this training, participants will be equipped with the ability to:
Install and configure Oracle Linux Virtualization Manager.
Deploy and manage virtual machines and hosts.
Set up networking, storage domains, and resource management configurations.
Effectively prepare for the OLVMCA certification examination.
Course Format
Instructor-led explanations accompanied by practical demonstrations.
Hands-on exercises to reinforce essential configuration tasks.
Real-lab scenarios focused on deploying and managing virtualized environments.
Customization Options
For tailored content or organization-specific customization, please contact us to arrange a bespoke session.
This instructor-led, live training in Lyon (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.
This instructor-led, live training session (available online or onsite) targets intermediate-level database administrators looking to manage and optimize complex, high-availability Oracle database environments.
Upon completion of this training, participants will be able to:
Acquire a thorough understanding of Oracle RAC architecture and Grid Infrastructure, covering installation, configuration, and management.
Build practical skills in managing Automatic Storage Management (ASM), including disk group administration, instance tuning, and backup/recovery processes.
Master advanced RAC performance tuning techniques, disaster recovery configurations, and best practices for achieving high availability.
Develop troubleshooting and diagnostic capabilities to resolve issues within RAC and Grid Infrastructure environments.
Grasp the procedures for patching and upgrading Oracle RAC and Grid Infrastructure while minimizing downtime and preserving system stability.
Oracle SOA Suite 12c serves as a consolidated platform for constructing, deploying, and overseeing service-oriented architecture (SOA) applications and enterprise-wide integrations.
This trainer-led live training (available online or on-site) targets integration professionals at an intermediate level who aim to design, deploy, and manage composite applications utilizing Oracle SOA Suite 12c.
After completing this training, participants will acquire the ability to:
Create, deploy, and supervise SOA composite applications using Oracle JDeveloper and the SOA Suite environment.
Design integrations leveraging BPEL processes, Mediators, and adapters for diverse data sources.
Execute service orchestration, routing, and transformation adhering to established best practices.
Administer and diagnose composite applications within Oracle Enterprise Manager (EM) Fusion Middleware Control.
Course Format
Interactive lectures and group discussions.
Practical exercises and guided lab sessions.
Hands-on implementation using Oracle SOA Suite 12c.
Course Customization Options
To request a customized version of this course tailored to your organization’s integration environment or workflow requirements, please contact us to arrange.
Oracle Cloud Infrastructure (OCI) represents Oracle's next-generation cloud platform, offering scalable, secure, and high-performance services tailored for enterprise workloads and cloud-native applications.
This instructor-led live training, available online or onsite, is designed for cloud professionals at intermediate to advanced levels who aim to design, implement, and manage enterprise-grade solutions on Oracle Cloud Infrastructure in preparation for the OCI Architect Professional certification.
Upon completion of this training, participants will be able to:
Design and deploy complex OCI architectures aligned with Oracle best practices.
Implement multi-region, multi-tier cloud solutions ensuring high availability and disaster recovery.
Secure OCI environments through Identity and Access Management (IAM), encryption, and governance policies.
Automate cloud resource provisioning using Terraform and the OCI CLI.
Prepare for and successfully pass the Oracle Cloud Infrastructure Architect Professional certification exam.
Course Format
Interactive lectures and discussions.
Hands-on labs and guided exercises.
Practical design scenarios and architecture simulations.
Course Customization Options
To request customized training for this course, please contact us to arrange.
This instructor-led, live training in Lyon (online or onsite) targets beginner-level database administrators who wish to manage backup and recovery tasks in Oracle Database 19c.
Upon completing this training, participants will be able to:
Grasp the fundamental concepts of backup and recovery in Oracle Database 19c, including architecture and various failure types.
Acquire practical experience in configuring backup and recovery settings, including the RMAN environment and fast recovery area.
Develop hands-on skills for executing different backup and recovery operations, such as full, incremental, and point-in-time recovery.
Learn to leverage Oracle's Flashback technology for effective database recovery and manage disaster recovery scenarios.
Apply best practices for backup, recovery, and disaster recovery to ensure data availability and reduce downtime in Oracle Database 19c.
Oracle GoldenGate 19c is an enterprise-grade solution for data replication and real-time integration, facilitating low-latency change data capture (CDC), transformation, and delivery across diverse database environments.
This instructor-led live training, available online or onsite, is designed for intermediate to advanced database administrators and replication engineers seeking to install, configure, operate, and troubleshoot Oracle GoldenGate 19c to ensure reliable real-time data integration and high-availability architectures.
Upon completion of this course, participants will be capable of:
Installing and configuring Oracle GoldenGate 19c components and topologies.
Designing and implementing change data capture (CDC) and delivery processes for heterogeneous systems.
Managing GoldenGate Microservices, deployment architectures, and secure communications.
Monitoring, tuning, and troubleshooting replication performance and latency issues within GoldenGate.
Course Format
Interactive lectures and discussions.
Numerous exercises and practical sessions.
Hands-on implementation in a live laboratory environment.
Course Customization Options
For customized training requests, please contact us to arrange.
This instructor-led, live training in Lyon (online or onsite) is aimed at intermediate-level database administrators who wish to effectively manage and optimize 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.
This instructor-led, live training in Lyon (online or on-site) is targeted at intermediate-level developers who wish to use Oracle Visual Builder Studio to effectively create and manage visual applications.
By the end of this training, participants will be able to:
Create and design visual applications using Oracle Visual Builder Studio.
Utilize pages, components, and flows to build user interfaces.
Implement data binding and integrate with various data sources.
Deploy applications to Oracle Cloud and manage environments.
This instructor-led live training in Lyon (online or on-site) is designed for intermediate-level database administrators seeking to leverage Oracle Enterprise Manager to its fullest potential, ensuring the efficient and effective management of their enterprise IT environments.
By the conclusion of this training, participants will be able to:
Gain a thorough understanding of Oracle Enterprise Manager (OEM) architecture.
Learn the procedures for installing and configuring OEM to ensure a properly established environment for monitoring and management.
Master the skills required to add, configure, and manage various targets and target groups within OEM to organize and streamline management tasks.
Power BI is a powerful business intelligence solution that enables users to link data sources, transform and analyze information, and generate interactive reports and dashboards. Oracle Database, a prevalent enterprise database platform, integrates seamlessly with Power BI to facilitate robust corporate reporting.
This instructor-led live training, available online or onsite, targets intermediate-level data professionals aiming to bridge Oracle databases with Power BI to design, analyze, and present actionable insights tailored to corporate requirements.
Upon completion of this training, participants will be capable of:
Establishing connections between Power BI and Oracle databases, along with other data sources.
Executing data cleansing, consolidation, and transformation processes.
Utilizing Power Query and Pivot for Extract, Transform, Load (ETL) workflows.
Applying DAX and M formulas for advanced data modeling and analysis.
Designing professional reports and executive presentations within Power BI.
Leveraging advisory support to meet specific corporate reporting mandates.
Course Format
Interactive lectures and discussions led by an instructor.
Practical labs involving Power BI and Oracle.
Real-world exercises addressing actual reporting challenges.
Dedicated advisory support sessions.
Customization Options
For customized training tailored to your specific needs, please contact us to arrange a session.
This instructor-led live training in Lyon (online or onsite) targets intermediate-level database administrators who aim to gain expertise in Oracle Cloud Database 2023, concentrating on migration and integration in adherence to ISO109423 standards.
By the conclusion of this training, participants will be able to:
Understand the features, architecture, and benefits of Oracle Cloud Database 2023.
Comprehend and implement key ISO109423 standards in database migration and integration projects.
Develop effective migration strategies, prepare data, and perform secure and efficient migrations using Oracle tools.
Integrate Oracle Cloud Database with on-premises systems and other cloud services using best practices and Oracle Integration Cloud.
Conduct thorough post-migration testing, optimize database performance, and maintain security and compliance with ISO109423 standards.
Oracle Database 19c functions as a multi-model database, offering comprehensive support for both relational and non-relational data formats.
This instructor-led live training, available either online or onsite, targets intermediate-level system and database administrators. The course is designed for those who wish to administer, monitor, secure, back up, and recover Oracle Database 19c within Standard Edition 2 environments, as well as to establish a clear migration path from version 11g to 19c.
Upon completion of this training, participants will be capable of:
Preparing the necessary environment and performing clean installations and configurations of Oracle Database 19c SE2.
Explaining Oracle infrastructure components, including the SGA, PGA, Shared Pool, Database Buffer Cache, and Redo mechanisms.
Utilizing administration tools such as Enterprise Manager (EM Express) and SQL Developer for daily operational tasks.
Implementing storage management best practices concerning tablespaces, datafiles, and segment space utilization.
Hardening databases and maintaining security through the management of users, roles, privileges, profiles, and auditing.
Designing and executing RMAN-based backup and recovery strategies that align with RTO and RPO objectives.
Monitoring and troubleshooting performance using dynamic performance views, SQL tracing, and execution plans.
Planning and executing the transition/migration from version 11g to 19c using supported upgrade paths and tools.
Course Format
Interactive lectures and discussions.
Extensive exercises and practical application.
Hands-on implementation within a live-lab environment.
Course Customization Options
To request customized training for this course, please contact us to make arrangements.
Oracle Data Integrator (ODI) is a high-performance, ELT-based data integration platform for building, deploying, and managing data movement and transformation across heterogeneous systems.
This instructor-led, live training (online or onsite) is aimed at intermediate-level data integration developers and architects who wish to design, implement, and operate ODI-based integration solutions.
Upon completion of this training, participants will be able to:
Describe ODI architecture and its core components, including Agents, Repositories, and Topology.
Design and implement data mappings and interfaces using ODI Studio.
Use Knowledge Modules to optimize ELT processing and performance.
Deploy, schedule, and monitor integration processes using ODI Agents and Console.
Format of the Course also allows for the evaluation of participants.
Interactive lecture and discussion.
Lots of exercises and practice.
Hands-on implementation in a live-lab environment.
Course Customization Options
To request a customized training for this course, please contact us to arrange.
This instructor-led, live training in Lyon (online or onsite) is aimed at beginner-level CRM managers who wish to effectively manage and optimize their customer relationship management processes using Oracle's powerful tools and features.
By the end of this training, participants will be able to:
Understand the fundamentals of Oracle Siebel CRM.
Learn how to configure and manage Siebel applications.
Gain proficiency in using Siebel tools for customer relationship management.
Explore advanced features for optimizing CRM processes.
Develop skills in reporting and analytics for Siebel CRM.
This instructor-led live training in Lyon (online or onsite) is designed for intermediate-level billing and revenue managers who aim to effectively manage and optimize their billing and revenue operations using Oracle's powerful tools and features.
By the end of this training, participants will be able to:
Understand the fundamentals of Oracle Communications Billing and Revenue Management (BRM).
Learn how to configure and manage billing processes.
Gain proficiency in using Oracle BRM for revenue management.
Explore advanced features for optimizing billing and revenue operations.
Develop skills in reporting and analytics for billing and revenue management.
This instructor-led, live training in Lyon (online or onsite) is aimed at beginner-level customer service managers who wish to effectively manage and optimize their customer service operations using Oracle's powerful tools and features.
By the end of this training, participants will be able to:
Understand the fundamentals of Oracle Service Management.
Learn how to configure and manage service requests.
Gain proficiency in using Oracle Service Cloud for customer service operations.
Explore advanced features for optimizing service delivery.
Develop skills in reporting and analytics for service management.
This instructor-led, live training in Lyon (online or onsite) is designed for intermediate-level database administrators who aim to improve the performance and efficiency of Oracle Database systems, particularly in environments using Oracle Database Appliances.
By the end of this training, participants will be able to:
Understand the architecture and components of Oracle Database Appliance HA X8-X9r.
Learn to identify and resolve performance issues.
Gain practical skills in SQL tuning and instance tuning.
This live, instructor-led training in Lyon (available online or on-site) is designed for intermediate-level maintenance professionals looking to streamline their processes via Oracle Cloud ERP Fusion.
By the conclusion of this training, attendees will be able to:
Understand the core functionalities of the Oracle Maintenance Cloud.
Implement corrective, preventive, and predictive maintenance strategies.
Manage maintenance requests, work orders, and schedules efficiently.
Utilize analytics for maintenance performance and improvement.
Oracle Database 19c serves as the long-term support release for Oracle's premier database platform, engineered to provide high performance, scalability, and reliability for enterprise workloads.
This instructor-led live training, available online or onsite, is designed for beginner to intermediate database administrators and IT professionals seeking to effectively install, configure, and manage Oracle Database 19c SE2 environments.
Upon completion of this training, participants will be capable of:
Comprehending the architecture of Oracle Database 19c SE2 and its core components.
Installing and configuring Oracle Database 19c SE2 on supported platforms.
Executing essential administrative tasks, including backup, recovery, and security management.
Enhancing database performance and monitoring system health using Oracle tools.
Planning and executing migrations from earlier Oracle Database versions to 19c.
Course Format
Interactive lectures and discussions.
Numerous exercises and practice sessions.
Hands-on implementation within a live lab environment.
Course Customization Options
For requests regarding customized training for this course, please contact us to arrange.
This instructor-led, live training in Lyon (online or onsite) is aimed at beginner-level business analysts and data analysts who wish to leverage Oracle BI to extract valuable insights from their data.
By the end of this training, participants will be able to:
Navigate and utilize the Oracle BI interface effectively.
Create and customize reports and dashboards tailored to business needs.
Conduct ad-hoc analysis using various BI tools.
Utilize advanced features for comprehensive data exploration.
The Oracle Database Appliance (ODA) X11 is an engineered system specifically optimized for running Oracle Databases, delivering high performance, simplified management, and integrated lifecycle automation. It is designed to reduce complexity and enhance reliability in Oracle database deployments for both on-premises and hybrid environments.
This instructor-led, live training (available online or onsite) targets intermediate to advanced database administrators and system engineers who aim to deploy, manage, and optimize Oracle ODA X11 environments.
Upon completion of this training, participants will be able to:
Understand the architecture and components of Oracle Database Appliance X11.
Perform installation, configuration, and provisioning of ODA environments.
Manage databases, storage, and networking within ODA.
Implement patching, monitoring, and performance optimization strategies.
Troubleshoot common ODA issues and maintain system health.
Format of the Course also allows for the evaluation of participants.
Interactive lecture and discussion.
Hands-on configuration and deployment exercises.
Real-world scenarios and performance tuning labs.
Course Customization Options
To request a customized training for this course, please contact us to arrange.
Oracle Database 19c serves as a powerful platform for constructing and managing enterprise data warehouses that cater to analytical workloads.
This instructor-led live training, available online or on-site, is designed for data professionals and analysts at the beginner level who seek to grasp the foundational concepts and architecture of Oracle-based data warehouse systems.
Upon completion of this training, participants will be capable of:
Comprehending the core concepts and architecture of Oracle data warehousing.
Explaining standard data warehouse components, such as fact and dimension tables.
Identifying the use cases and advantages of Oracle data warehousing in the context of business intelligence.
Preparing for advanced training in Oracle ETL, performance tuning, and warehouse optimization techniques.
Course Format
Interactive lectures and discussions.
Practical application of Oracle SQL and exploration of warehouse schemas.
Guided conceptual exercises and analysis of warehouse designs.
Course Customization Options
For those interested in a customized training session tailored to their internal data models or analytics objectives, please contact us to arrange details.
Oracle Cloud Infrastructure (OCI) offers a robust suite of cloud services tailored to assist organizations in building, deploying, and securing contemporary applications.
This instructor-led live training, available online or onsite, targets intermediate-level cloud professionals eager to design, implement, and manage secure infrastructures on Oracle Cloud Infrastructure (OCI).
Upon completion of this training, participants will be capable of:
Gaining a clear understanding of the security architecture and components of Oracle Cloud Infrastructure.
Effectively implementing Identity and Access Management (IAM) policies and controls.
Applying best practices for encryption, network security, and data protection within OCI.
Monitoring, auditing, and ensuring compliance across OCI environments.
Course Format
Interactive lectures and discussions.
Hands-on labs and real-world security exercises.
Practical implementation within a live OCI environment.
Customization Options
To arrange customized training for this course, please contact us directly.
Oracle Database 19c serves as a robust platform for constructing high-performance data warehouses that effectively support business intelligence and analytics workloads.
This instructor-led live training, available both online and onsite, is designed for intermediate-level Oracle professionals seeking to implement and optimize data warehousing solutions using Oracle Database 19c.
Upon completing this training, participants will be able to:
Design and implement data warehouse schemas, including star and snowflake models.
Utilize Oracle partitioning and compression techniques for managing large datasets.
Optimize ETL processes and query performance to enhance analytics workloads.
Leverage specific Oracle features to facilitate both real-time and historical reporting.
Course Format
Interactive lectures and discussions.
Hands-on exploration of Oracle Data Warehouse features within sample scenarios.
Guided exercises focusing on modeling, ETL processes, and performance tuning.
Customization Options
To arrange a customized version of this course tailored to your organization's data models or reporting requirements, please contact us.
Oracle Database 23ai represents the most recent long-term release, designed to boost developer productivity and integrate built-in AI capabilities. Key innovations include AI Vector Search, enhanced JSON and relational duality, asynchronous and pipelining drivers, SQL and PL/SQL improvements, and new operational features that support modern application development and AI-driven workloads.
This instructor-led training, available online or on-site, is designed for intermediate-level developers seeking to master the new 23ai features and apply them in real-world scenarios to achieve a basic-to-intermediate proficiency level.
Upon completing this course, participants will be able to:
Identify the core developer-focused features of Oracle Database 23ai and understand when to utilize them.
Implement AI Vector Search and leverage new JSON and relational capabilities within sample applications.
Utilize asynchronous and pipelining driver features to optimize client-server workflows and improve throughput.
Apply practical methods for testing, debugging, and deploying application code based on 23ai within development environments.
Course Format
Interactive lectures combined with targeted demonstrations.
Hands-on labs utilizing Oracle Database 23ai Free and developer tools.
Guided exercises featuring sample Java/Quarkus and front-end examples.
Course Customization Options
To request a customized version of this course (such as a focus on specific language stacks, deeper PL/SQL content, or additional labs), please contact us to arrange.
This instructor-led live training in Lyon (online or onsite) is aimed at system administrators who wish to have a comprehensive understanding of the security features of Oracle Database 19c.
By the end of this training, participants will be able to:
Understand the concepts of database security.
Implement authentication and authorization mechanisms to control access to the database.
Configure and manage user accounts, roles, and privileges effectively.
Implement robust security measures against various threats and vulnerabilities.
This course is designed to give participants a comprehensive understanding of how to utilize SQL across various database platforms (including Oracle, SQL Server, MS Access, etc.). By mastering analytic functions and the techniques for joining tables within a database, attendees will learn to shift data analysis tasks from MS Excel to the database layer. This approach not only enhances efficiency but also supports the development of any IT system that relies on relational databases.
This instructor-led, live training in Lyon (online or on-site) is designed for system administrators who wish to learn how to use and manage an Oracle Linux 8 system.
By the end of this training, participants will be able to:
This instructor-led, live training in Lyon (online or onsite) is designed for database administrators and cloud architects who wish to migrate Oracle databases to Azure SQL or PostgreSQL.
By the end of this training, participants will be able to:
Compare Azure SQL with PostgreSQL to choose the database that best meets business objectives and needs.
Prepare databases to move definitions, data, and procedures from Oracle to AzureSQL or PostgreSQL database system.
Perform post-migration steps to test, optimize, update, and maintain a migrated database.
This instructor-led, live training in Lyon (online or onsite) targets professionals who wish to learn the fundamental concepts of Oracle Fusion and implement Oracle Fusion HCM in their organization.
By the end of this training, participants will be able to:
Learn and understand the concepts of Oracle Fusion Human Capital Management (HCM).
Implement complete workforce structure management in any organization.
This instructor-led, live training in Lyon (online or onsite) is designed for database administrators who wish to learn and apply the features of Oracle Database 21c for administrative tasks.
By the end of this training, participants will be able to:
Understand the core concepts of Oracle Database 21c administration.
Understand the Oracle 21c architecture.
Learn how to perform administration tasks on Oracle 21c.
Understand the Oracle 21c backup and recovery process.
This instructor-led, live training in Lyon (online or onsite) is designed for system administrators who wish to learn how to administer, monitor, and support an Oracle database.
Upon completing this training, participants will be able to:
Understand the key features and architectural changes in Oracle Database.
This SQL training course is designed for individuals seeking to acquire the essential skills to extract and analyze data from any database system and generate reports. Participants will learn:
how to formulate SQL queries
what relational databases are and how they can be utilized
what relations are and how to establish them
the structure of data
the differences between SQL dialects (Oracle, T-SQL, ANSI)
practical techniques for writing queries
This SQL course focuses on generic ANSI SQL. It is applicable to any database system, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL, and other relational databases.
This instructor-led live training in Lyon (offered online or onsite) is intended for engineers seeking to set up, deploy, migrate to, and manage an Oracle 18c Database.
By the end of this training, participants will be able to:
Understand the major feature and architectural changes from previous Oracle versions.
Migrate to Oracle 18c from a previous version.
Deploy Oracle 18c in cloud or on premise.
Understand Oracle 18c's new yearly release cycle and plan maintenance around it.
This instructor-led, live training in Lyon (online or onsite) is designed for IT administrators and developers who wish to set up, deploy, and manage cloud applications using the services and technologies provided by Oracle PaaS.
Upon completion of this training, participants will be able to:
Build, deploy, and manage cloud applications using Oracle PaaS.
Configure and utilize data management tools for streamlined storage and backup.
Visualize and assess application performance and logs.
This workshop is designed for advanced programmers and Oracle users who wish to gain deep insights into the efficient development of information systems within an Oracle database, as well as the tuning and performance testing of existing applications. The course builds upon knowledge that is often incomplete or inaccurately presented in technical documentation, drawing from the extensive practical experience accumulated by the instructors over many years. This workshop can serve as the culmination of a training path for developers or as a single step for individuals with extensive experience in Oracle design and programming.
Training Objectives
The workshop aims to elucidate the mechanisms that occur in an Oracle database during SQL statement execution. It enables participants to avoid errors during software development and to explore, diagnose, and resolve performance issues in existing applications.
Particular emphasis is placed on practical workshops, where we demonstrate the methodology and practical aspects of application and SQL statement tuning.
Training Content
Mechanics of executing SQL commands
Managing the cost optimization process
Data storage and indexing methods
Monitoring database performance and processes using system dictionaries and application tracking
Analysis of case studies involving the most common problems that cause performance issues
Notes
The workshops are conducted using software version 11g XE.
Read more...
Last Updated:
Testimonials (11)
good explanation on each points and provide assignment for practices.
Piseth Ben - ACLEDA Bank Plc.
Course - Oracle Database 19c: SQL Tuning Workshop
I appreciated the trainer’s deep technical knowledge, clear explanations, and the practical approach to Oracle Cloud Infrastructure security topics.
Luigi Zoccano
Course - Oracle Cloud Infrastructure (OCI) 2025 Security Professional
The trainer was extremely well informed about the topic, and was easily able to problem solve issues that we encountered.
David Hummel - Honeywell Federal Manufacturing & Technologies, LLC.
Course - Low-Code Enterprise Application Development with Oracle APEX
The flow and build up to each topic.
Jainoodien Salie - Vodacom
Course - Oracle Siebel
It was very interactive and it kept us interested.
Raluca Alexandra PUNGA
Course - SQL Fundamentals
It was one on one so I could show him my existing environment and discuss my real issues
Virendra Miglani - Westfraser Mills
Course - Developing Applications with Oracle Application Express (APEX)
Greg was very patient and helpful
Chris Havel - Encyclopaedia Britannica
Course - ORACLE SQL Fundamentals
Workflow and Task Definition
Aedrin Joseph - Isuzu Philippines Corporation
Course - Mastering Oracle APEX 23-24: Workflows and Security
peserta langsung hands-on
Bagus - PT. TELKOM INDONESIA
Course - Oracle Linux Virtualization Manager 4
he explained very well, and gave guidance on the exercises.
Stoyan - OPEN COURSE
Course - Oracle Database 19c PL and Advanced SQL
I liked the pace of the training and the level of interaction. All participants were encouraged to actively partake in discussions around exercise solutions, etc.
Online Oracle training in Lyon, Oracle training courses in Lyon, Weekend Oracle courses in Lyon, Evening Oracle training in Lyon, Oracle instructor-led in Lyon, Oracle instructor-led in Lyon, Oracle one on one training in Lyon, Oracle private courses in Lyon, Oracle coaching in Lyon, Oracle boot camp in Lyon, Online Oracle training in Lyon, Evening Oracle courses in Lyon, Oracle trainer in Lyon, Oracle on-site in Lyon, Weekend Oracle training in Lyon, Oracle classes in Lyon, Oracle instructor in Lyon
