Whether delivered online or on-site, instructor-led live Oracle Database (Oracle RDBMS or Oracle) training courses provide a comprehensive understanding of Oracle through detailed discussion and practical, hands-on exercises.
Oracle training is accessible in two formats: "online live training" or "onsite live training." Online live training (also known as "remote live training") is facilitated via an interactive remote desktop connection. Onsite live training can take place locally at the client's premises in Plovdiv or at NobleProg corporate training centers in Plovdiv.
NobleProg -- Your Local Training Provider
Business Center Plovdiv
Han Kubrat St 1, Plovdiv, Bulgaria, 4017
This is the most modern business center in the city, with all the necessary functionalities, while being located in a green part of the city.
It is about 20 minutes by bus from the main train station as well as the city center.
Oracle Linux 9 provides robust tools and capabilities designed to build secure, scalable, and highly available environments. This advanced-level course emphasizes enterprise system architecture, security hardening, networked services, kernel optimization, and automation via Ansible.
This instructor-led, live training (available online or onsite) is tailored for advanced Linux professionals seeking to deepen their expertise in deploying and maintaining critical Oracle Linux 9 infrastructure.
Upon completion of this training, participants will be able to:
Deploy and manage high-availability services using clustering tools.
Configure secure network services and enforce system-wide hardening measures.
Automate infrastructure management using Ansible playbooks.
Optimize system performance for specific workloads and services.
Course Format
Interactive lectures and discussions.
Extensive exercises and practical practice.
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 enhances its enterprise-ready foundation by providing powerful tools for system performance, networking, automation, and storage management. This course expands the administrator’s expertise by introducing advanced administration techniques, system optimization, and service management within enterprise settings.
This instructor-led, live training (available online or onsite) is designed for intermediate-level Linux administrators who aim to deepen their knowledge of administering Oracle Linux 9 systems in production environments.
Upon completing this training, participants will be able to:
Automate administrative tasks through Bash scripting.
Configure logical volumes, RAID, and advanced storage systems.
Manage SELinux policies and file security contexts.
Monitor system performance and resource utilization.
Course Format
Interactive lectures and discussions.
Extensive exercises and practical sessions.
Hands-on implementation in a live-lab environment.
Customization Options
To request customized training for this course, please contact us to arrange.
Oracle Linux 9 is an enterprise-grade Linux distribution optimized 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
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 incorporates detective controls designed to monitor, log, and generate alerts for potentially unauthorized or malicious activity, thereby ensuring compliance, comprehensive visibility, and accelerated incident response.
This instructor-led live training, available either online or onsite, targets intermediate-level Oracle DBAs and security professionals who wish to configure and monitor auditing, logging, and activity detection features within Oracle environments.
Upon completion of this training, participants will be able to:
Enable and customize Oracle auditing tools to support compliance and monitoring requirements.
Oracle Database Security encompasses a comprehensive suite of technologies and industry best practices aimed at preventing unauthorized access, ensuring regulatory compliance, and safeguarding sensitive data within Oracle environments.
This instructor-led training, available both online and onsite, is tailored for intermediate-level Oracle administrators and security professionals seeking to implement effective preventive controls to protect Oracle databases from internal and external threats.
Upon completion of this training, participants will be able to:
Implement mechanisms for authentication, authorization, and privilege management.
Secure Oracle installations by adhering to industry-standard hardening practices.
Configure advanced options such as data masking, encryption, and database firewall features.
Establish robust policies for access control and meet regulatory compliance requirements.
Course Format
Interactive lectures accompanied by engaging discussions.
Practical application of Oracle security tools and configuration techniques.
Guided exercises focusing on the enforcement of security policies and access control measures.
Customization Options
To arrange a customized version of this course tailored to your specific security policies and Oracle deployment, please contact us.
Oracle Database 23ai represents the next generation of database platforms from Oracle, featuring improved AI integration, automation, and administration capabilities designed for modern data workloads.
This instructor-led training session, available both online and onsite, is designed for Oracle administrators with intermediate skills who want to explore and apply the latest Oracle Database 23ai features to enhance performance, security, and AI-driven functionality.
Upon completion of this training, participants will be able to:
Comprehend and assess the key new features introduced in Oracle 23ai.
Set up AI Vector Search and incorporate AI workloads.
Utilize advanced automation, observability, and performance tools.
Plan version upgrades and deploy new 23ai capabilities in production environments.
Course Format
Interactive lectures and discussions.
Practical application of Oracle 23ai features in test environments.
Guided labs concentrating on implementation and migration planning.
Course Customization Options
To request customized training tailored to your Oracle infrastructure, please reach out to us to arrange.
This instructor-led, live training in Plovdiv (online or onsite) is aimed at intermediate-level to advanced-level system administrators and IT professionals who wish to deepen their expertise in Oracle Linux 9 for 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 conducted in Plovdiv (online or on-site) targets beginner to intermediate-level IT professionals and Linux users seeking a thorough grasp of Oracle Linux 9, spanning installation, configuration, system administration, and security.
By the conclusion of this training, participants will be able to:
This live, instructor-led training in Plovdiv (offered online or onsite) is intended for intermediate-level database administrators and IT professionals seeking to develop practical skills in installing, configuring, securing, and maintaining Oracle Database 23ai.
By the end of the 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 Plovdiv (online or onsite) targets advanced-level system administrators who wish to acquire skills in advanced system administration, 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 session in Plovdiv (available online or onsite) is designed for advanced system administrators seeking to deepen their proficiency in system management, troubleshooting, and performance tuning.
By the conclusion of this training, participants will be able to:
Set up and manage advanced user and group configurations, including the implementation of user quotas and system-wide user environments.
Utilize security auditing tools and configure sudo to manage controlled administrative access.
Monitor and optimize overall system performance.
Configure, analyze, and resolve issues related to system logs.
This instructor-led, live training delivered Plovdiv (online or onsite) is designed for intermediate system administrators aiming to effectively manage Oracle Linux Virtualization environments.
Upon completion, participants will be able to:
Install and configure Oracle Linux Virtualization Manager and its associated components on physical or virtual infrastructure.
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 Plovdiv (online or onsite) is designed for beginner-level database administrators seeking to ensure they are well-prepared to manage and optimize their Oracle environments.
By the conclusion of this training, participants will be able to:
Understand the key features and architecture of Oracle Database 19c, including system requirements and installation methods.
Gain practical skills in installing Oracle Database 19c and Oracle Grid Infrastructure, including configuring the network, storage, and security settings.
Learn the complete process of upgrading to Oracle Database 19c, from pre-upgrade planning to post-upgrade validation.
Develop troubleshooting skills to handle common issues during installation and upgrade.
Apply best practices for Oracle Database installation and upgrade to ensure a smooth and successful deployment.
Oracle Linux Virtualization Manager serves as a robust platform designed for the management and orchestration of virtualized server infrastructures.
This instructor-led training session, available in both online and onsite formats, is designed for intermediate-level professionals aiming to achieve mastery over Oracle Linux Virtualization Manager in order to prepare for the OLVMCA certification exam.
Upon completion of this training, participants will be equipped to:
Install and configure Oracle Linux Virtualization Manager.
Deploy and oversee virtual machines and associated hosts.
Configure network settings, storage domains, and resource management policies.
Adequately prepare for the OLVMCA certification examination.
Course Format
Instructor-led explanations accompanied by practical demonstrations.
Hands-on exercises designed to reinforce essential configuration tasks.
Real-world laboratory scenarios for deploying and managing virtualized environments.
Customization Options
For tailored content or organization-specific customization, please contact us to arrange a customized session.
This instructor-led, live training in Plovdiv (online or onsite) is designed for intermediate-level database administrators who wish to manage, optimize, and secure Data Guard environments for robust disaster recovery and high availability.
Upon completion of this training, participants will be able to:
Grasp the architecture and advantages of Oracle Data Guard for disaster recovery and high availability.
Acquire practical experience in configuring and managing physical and logical standby databases, including the use of the Data Guard broker.
Develop practical skills in monitoring, troubleshooting, and optimizing Data Guard environments for peak performance.
Explore 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 in Plovdiv (online or onsite) targets intermediate-level database administrators seeking to manage and optimize complex, high-availability Oracle database environments.
Upon completing this training, participants will be able to:
Acquire a thorough understanding of Oracle RAC architecture and Grid Infrastructure, covering installation, configuration, and management.
Develop practical expertise in managing Automatic Storage Management (ASM), including disk group administration, instance tuning, and backup/recovery operations.
Master advanced RAC performance tuning techniques, disaster recovery configurations, and high-availability best practices.
Gain troubleshooting and diagnostic capabilities to resolve issues within RAC and Grid Infrastructure environments.
Understand the patching and upgrading processes for Oracle RAC and Grid Infrastructure, ensuring minimal downtime and sustained system stability.
Oracle SOA Suite 12c serves as a consolidated platform for creating, deploying, and managing service-oriented architecture (SOA) applications and integrations throughout the enterprise.
This instructor-led training session (available online or on-site) is designed for intermediate-level integration professionals looking to design, deploy, and manage composite applications utilizing Oracle SOA Suite 12c.
After completing this training, participants will acquire the skills to:
Build, deploy, and monitor SOA composite applications using Oracle JDeveloper and the SOA Suite environment.
Architect integrations leveraging BPEL processes, Mediators, and adapters for diverse data sources.
Execute service orchestration, routing, and transformation following industry best practices.
Administer and troubleshoot composite applications within Oracle Enterprise Manager (EM) Fusion Middleware Control.
Course Format
Interactive lectures and discussions.
Practical exercises and guided laboratory sessions.
Hands-on implementation using Oracle SOA Suite 12c.
Course Customization Options
For a customized version of this course tailored to your organization’s specific integration environment or workflow requirements, please contact us to arrange.
Oracle Cloud Infrastructure (OCI) serves as Oracle's cutting-edge cloud platform, delivering scalable, secure, and high-performance services tailored for enterprise workloads and cloud-native applications.
This instructor-led, live training session (available online or on-site) is designed for intermediate to advanced cloud professionals aiming to design, implement, and manage enterprise-grade solutions on Oracle Cloud Infrastructure, preparing them for the OCI Architect Professional certification.
Upon completion of this training, participants will be equipped to:
Design and deploy complex OCI architectures in accordance with Oracle best practices.
Implement multi-region, multi-tier cloud solutions ensuring high availability and disaster recovery capabilities.
Secure OCI environments through Identity and Access Management (IAM), encryption, and governance policies.
Automate the provisioning of cloud resources using Terraform and the OCI Command Line Interface (CLI).
Prepare for and successfully pass the Oracle Cloud Infrastructure Architect Professional certification exam.
Course Format
Interactive lectures and group discussions.
Hands-on labs and guided exercises.
Practical design scenarios and architecture simulations.
Course Customization Options
For customized training arrangements, please contact us directly.
This instructor-led live training in Plovdiv (online or onsite) is designed for beginner-level database administrators who want to manage backup and recovery operations in Oracle Database 19c.
Upon completion of this training, participants will be able to:
Grasp the core principles of backup and recovery in Oracle Database 19c, including its architecture and different types of failures.
Acquire practical experience in configuring backup and recovery settings, such as the RMAN environment and the fast recovery area.
Build skills in executing various backup and recovery operations, including full, incremental, and point-in-time recovery.
Learn to leverage Oracle's Flashback technology for efficient database recovery and handle 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 data replication and real-time integration solution that enables low-latency change data capture (CDC), transformation, and delivery across heterogeneous database environments.
This instructor-led, live training (online or onsite) is aimed at intermediate-level to advanced-level database administrators and replication engineers who wish to install, configure, operate, and troubleshoot Oracle GoldenGate 19c for reliable real-time data integration and high-availability architectures.
By the end of this training, participants will be able to:
Install and configure Oracle GoldenGate 19c components and topologies.
Design and implement change data capture (CDC) and delivery processes for heterogeneous systems.
Manage GoldenGate Microservices, deployment architectures, and secure communications.
Monitor, tune, and troubleshoot GoldenGate replication performance and latency issues.
Format of the Course
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 Plovdiv (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 Plovdiv (online or onsite) is designed for 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.
Leverage pages, components, and flows to construct 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 Plovdiv (online or onsite) is designed for intermediate-level database administrators who wish to utilize Oracle Enterprise Manager to its full potential, ensuring efficient and effective management of their enterprise IT environments.
By the end of this training, participants will be able to:
Gain a thorough understanding of Oracle Enterprise Manager (OEM) architecture.
Learn the steps for installing and configuring OEM to ensure a properly set-up environment for monitoring and management.
Master the skills to add, configure, and manage different targets and target groups within OEM to organize and streamline management tasks.
Power BI serves as a powerful business intelligence solution, enabling users to link data sources, transform and analyze information, and generate interactive reports and dashboards. Oracle Database, a leading enterprise database system, integrates smoothly with Power BI to support corporate reporting workflows.
This instructor-led live training, available either online or on-site, targets intermediate-level data professionals aiming to connect Oracle databases with Power BI to develop, analyze, and present actionable insights tailored to organizational needs.
Upon completing this training, participants will be equipped to:
Establish connections between Power BI and Oracle databases, along with other data sources.
Execute data cleansing, consolidation, and transformation tasks.
Utilize Power Query and Pivot for ETL processes.
Implement DAX and M formulas for robust data modeling and analysis.
Create professional reports and executive presentations within Power BI.
Access advisory support to meet specific corporate reporting requirements.
Course Format
Instruction-led lectures and interactive discussions.
This instructor-led, live training in Plovdiv (online or onsite) is aimed at intermediate-level database administrators who wish to gain expertise in Oracle Cloud Database 2023, focusing on migration and integration in compliance with ISO109423 standards.
By the end 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 is a versatile multi-model database designed to fully support both relational and non-relational data structures.
This instructor-led training session, available either online or onsite, is tailored for intermediate-level system and database administrators. It aims to equip participants with the skills necessary to administer, monitor, secure, back up, and recover Oracle Database 19c within Standard Edition 2 environments, while also providing a clear roadmap for migrating from version 11g to 19c.
Upon completing this training, participants will be capable of:
Preparing the environment and executing clean installations and configurations of Oracle Database 19c SE2.
Describing the key components of Oracle infrastructure, including the SGA, PGA, Shared Pool, Database Buffer Cache, and Redo mechanisms.
Utilizing administrative tools like Enterprise Manager (EM Express) and SQL Developer for daily operational tasks.
Applying storage management best practices concerning tablespaces, datafiles, and segment space utilization.
Securing databases and maintaining security protocols through the management of users, roles, privileges, profiles, and auditing.
Designing and implementing RMAN-based backup and recovery strategies that align with RTO/RPO objectives.
Monitoring and resolving performance issues using dynamic performance views, SQL tracing, and execution plans.
Planning and executing the migration from version 11g to 19c using supported upgrade paths and tools.
Course Format
Interactive lectures and discussions.
Numerous exercises and practical sessions.
Hands-on implementation within a live-lab environment.
Customization Options for the Course
For requests regarding customized training for this course, please get in touch with us to make arrangements.
Oracle Data Integrator (ODI) serves as a high-performance, ELT-driven platform designed for constructing, deploying, and managing data movement and transformation processes across diverse systems.
This instructor-led live training, available either online or on-site, targets intermediate data integration developers and architects seeking to design, implement, and manage ODI-based solutions.
Upon completing this training, participants will be able to:
Explain the ODI architecture and its fundamental components, such as Agents, Repositories, and Topology.
Create and implement data mappings and interfaces utilizing ODI Studio.
Leverage Knowledge Modules to enhance ELT processing efficiency and performance.
Deploy, schedule, and monitor integration workflows using ODI Agents and the Console.
Course Format
Interactive lectures and discussions.
Extensive exercises and practical practice.
Hands-on implementation within a live-lab environment.
Customization Options
For inquiries regarding customized training for this course, please contact us to make arrangements.
This instructor-led, live training in Plovdiv (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 Plovdiv (online or onsite) targets intermediate-level billing and revenue managers who wish 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 Plovdiv (online or on-site) is designed for beginner-level customer service managers who aim to effectively manage and optimize their customer service operations using Oracle's powerful tools and features.
Upon completion of this training, participants will be able to:
Grasp the core concepts of Oracle Service Management.
Learn the processes for configuring and managing service requests.
Acquire proficiency in utilizing Oracle Service Cloud for customer service operations.
Discover advanced features designed to optimize service delivery.
Develop competencies in reporting and analytics tailored for service management.
This instructor-led, live training in Plovdiv (online or onsite) targets intermediate-level database administrators who wish to improve the performance and efficiency of Oracle Database systems, particularly in environments utilizing 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 instructor-led live training in Plovdiv (online or on-site) is designed for intermediate maintenance professionals aiming to streamline their processes using Oracle Cloud ERP Fusion.
By the conclusion of this training, participants 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 stands as the long-term support release of Oracle’s premier database platform, engineered to provide superior performance, scalability, and reliability for enterprise-level workloads.
This instructor-led training, available both online and onsite, targets beginner to intermediate database administrators and IT professionals seeking to master the installation, configuration, and management of Oracle Database 19c SE2 environments.
Upon completion of this course, participants will be equipped to:
Grasp the architecture of Oracle Database 19c SE2 and its fundamental components.
Install and configure Oracle Database 19c SE2 on supported platforms.
Execute essential administrative duties, including backup, recovery, and security management.
Enhance database performance and monitor system health utilizing Oracle tools.
Plan and carry out migrations from previous Oracle Database versions to 19c.
Course Format
Interactive lectures and discussions.
Ample exercises and practical sessions.
Hands-on implementation within a live laboratory environment.
Customization Options
For tailored training requests, please reach out to us to arrange specifics.
This instructor-led live training in Plovdiv (online or onsite) is designed for beginner-level business and data analysts who want to leverage Oracle BI to derive valuable insights from their data.
By the end of this training, participants will be able to:
Effectively navigate and utilize the Oracle BI interface.
Create and customize reports and dashboards that align with business needs.
Conduct ad-hoc analysis using various BI tools.
Utilize advanced features for comprehensive data exploration.
Oracle Database Appliance (ODA) X11 is an engineered system optimized for running Oracle Databases with high performance, simplified management, and integrated lifecycle automation. It is designed to reduce complexity and improve reliability in Oracle database deployments for on-premises and hybrid environments.
This instructor-led, live training (online or onsite) is aimed at intermediate-level to advanced-level database administrators and system engineers who wish to deploy, manage, and optimize Oracle ODA X11 environments.
By the end 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
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 designed to support complex analytical workloads.
This instructor-led, live training (available online or onsite) is tailored for data professionals and analysts at the beginner level who seek to grasp the core concepts and architectural framework of Oracle-based data warehousing systems.
Upon completion of this training, participants will be able to:
Comprehend the fundamental concepts and architecture of Oracle data warehousing.
Articulate the typical components of a data warehouse, including fact and dimension tables.
Identify practical use cases and the advantages of Oracle data warehousing within business intelligence contexts.
Lay the groundwork for advanced training in Oracle ETL, performance tuning, and warehouse optimization strategies.
Course Format
Interactive lectures and group discussions.
Practical application of Oracle SQL and exploration of warehouse schemas.
Guided conceptual exercises and analysis of warehouse design patterns.
Customization Options
To arrange customized training tailored to your internal data models or specific analytics objectives, please contact us directly.
Oracle Cloud Infrastructure (OCI) provides a robust suite of cloud services that enable organizations to build, deploy, and secure modern applications effectively.
This instructor-led live training, available both online and onsite, targets intermediate-level cloud professionals seeking to design, implement, and manage secure infrastructures on Oracle Cloud Infrastructure (OCI).
Upon completion of this training, participants will be equipped to:
Grasp the security architecture and key components of Oracle Cloud Infrastructure.
Effectively implement Identity and Access Management (IAM) policies and controls.
Apply best practices for encryption, network security, and data protection within OCI.
Monitor, audit, and ensure compliance across OCI environments.
Course Format
Interactive lectures and discussions.
Practical labs and real-world security exercises.
Hands-on implementation in a live OCI environment.
Customization Options
For customized training requests, please reach out to us to make arrangements.
Oracle Database 19c serves as a robust platform for constructing high-performance data warehouses tailored to support business intelligence and analytical 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 utilizing Oracle Database 19c.
Upon completing this training, participants will gain the ability to:
Design and deploy data warehouse schemas, including star and snowflake models.
Utilize Oracle partitioning and compression techniques to manage large datasets effectively.
Enhance ETL processes and query performance for analytical workloads.
Apply Oracle-specific features to facilitate real-time and historical reporting.
Course Format
Engaging lectures paired with interactive discussions.
Practical application of Oracle Data Warehouse features within sample scenarios.
Guided exercises concentrating on data modeling, ETL processes, and performance tuning.
Customization Options
To arrange customized training tailored to your organization's specific data models or reporting requirements, please get in touch with us.
Oracle Database 23ai represents the most recent long-term release, designed to boost developer productivity through integrated AI capabilities. Key innovations include AI Vector Search, enhanced JSON and relational duality, support for async and pipelining drivers, improvements in SQL and PL/SQL, and new operational features tailored for modern application development and AI-driven workloads.
This instructor-led live training, available both online and onsite, targets intermediate developers aiming to master the new 23ai features and apply them to real-world development scenarios to achieve a basic-to-intermediate proficiency level.
Upon completion of this training, participants will be able to:
Identify the primary developer-focused features of Oracle Database 23ai and understand when to utilize them.
Implement AI Vector Search and the updated JSON/relational capabilities within sample applications.
Utilize async/pipelining driver functionalities and practice optimized client-server workflows to enhance throughput.
Apply practical methods for testing, debugging, and deploying 23ai-based application code in development environments.
Course Format
Interactive lectures combined with targeted demonstrations.
Practical labs using Oracle Database 23ai Free and essential developer tools.
Guided exercises featuring sample Java/Quarkus and front-end examples.
Customization Options
To request a customized version of this course (focusing on specific language stacks, deeper PL/SQL content, or additional labs), please contact us to arrange your requirements.
This instructor-led, live training in Plovdiv (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 deliver a comprehensive understanding of SQL usage across various database systems, including Oracle, SQL Server, and MS Access. By mastering analytic functions and techniques for joining tables within a database, participants will learn to shift data analysis tasks from MS Excel to the database layer. This approach not only enhances analytical capabilities but also supports the development of IT systems that rely on relational databases.
This instructor-led, live training (available online or onsite) 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 Plovdiv (online or onsite) is aimed at 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 Plovdiv (offered online or on-site) is intended for professionals who want to learn the fundamental concepts of Oracle Fusion and apply Oracle Fusion HCM within their organization.
By the conclusion of this training, participants will be able to:
Learn and comprehend the core concepts of Oracle Fusion Human Capital Management (HCM).
Implement comprehensive workforce structure management in any organizational setting.
This instructor-led, live training in Plovdiv (online or onsite) is aimed at database administrators who wish to learn and use the features of Oracle Database 21c in performing 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 Plovdiv (online or onsite) targets system administrators seeking to learn how to administer, monitor, and support an Oracle database.
By the end of this training, participants will be able to:
Understand the major feature and architectural changes Oracle database.
This SQL training program is designed for individuals aiming to acquire the essential skills to extract, analyze, and report on data from any database. Participants will learn:
techniques for writing SQL queries
the concept of relational databases and their utilization
the nature of relationships and how to establish them
data structure fundamentals
distinctions among SQL dialects (Oracle, T-SQL, ANSI)
hands-on skills for effective query composition
The course focuses on generic ANSI SQL, which is compatible with various database systems, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL, and other relational databases.
This instructor-led live training in Plovdiv (available online or onsite) is designed for engineers who wish 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 Plovdiv (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.
By the end of this training, participants will be able to:
Build, deploy, and manage cloud applications using Oracle PaaS.
Configure and use data management tools for easy storage and backup.
Visualize and evaluate application performance and logs.
This instructor-led, live training in Plovdiv (online or onsite) is designed for engineers looking to transition from Oracle Forms to Oracle Web Forms.
Upon completing this training, participants will be able to:
Grasp the key feature and architectural updates in Oracle Web Forms.
Successfully migrate to Oracle Web Forms from earlier Forms versions.
***Deploy Oracle Web Forms in cloud or on premise.
Utilize Oracle Web Forms to improve user services and enhance the overall experience.
This workshop is designed for advanced programmers and Oracle users who wish to deepen their understanding of efficiently developing information systems within an Oracle database, as well as tuning and testing performance in existing applications. The course draws upon practical insights gained over many years, which are often absent or inadequately presented in standard technical documentation. This training can serve as a capstone experience for developers or as a specialized step for professionals with extensive Oracle design and programming expertise.
Training Objectives
The primary goal is to elucidate the internal mechanisms of an Oracle database when executing SQL statements. Participants will learn to avoid common errors during software development and gain the ability to explore, diagnose, and resolve performance issues in their current applications.
Special emphasis is placed on practical application and tuning methodologies for SQL statements.
Training Content
Mechanics of SQL command execution
Cost-based optimization management
Data storage and indexing methods
Database performance monitoring using system dictionaries and application tracking tools
Analysis of case studies regarding common performance-affecting problems
Notes
Workshops are conducted using Oracle Database 11g XE software.
Read more...
Last Updated:
Testimonials (9)
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)
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
presentation skills, prompt answers to all questions
Oana - OPEN COURSE
Course - Oracle SQL LP - Fundamentals
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 Plovdiv, Oracle training courses in Plovdiv, Weekend Oracle courses in Plovdiv, Evening Oracle training in Plovdiv, Oracle instructor-led in Plovdiv, Oracle instructor-led in Plovdiv, Oracle trainer in Plovdiv, Weekend Oracle training in Plovdiv, Oracle coaching in Plovdiv, Oracle classes in Plovdiv, Oracle private courses in Plovdiv, Oracle one on one training in Plovdiv, Oracle boot camp in Plovdiv, Evening Oracle courses in Plovdiv, Oracle on-site in Plovdiv, Oracle instructor in Plovdiv, Online Oracle training in Plovdiv