Database Training in Faro

Oracle Linux 9 is an enterprise-grade Linux distribution engineered for optimal performance, robust security, and seamless compatibility with Red Hat Enterprise Linux. This course provides participants with an introduction to essential system administration tasks, addressing core concepts such as user management, file systems, networking, and software package handling.

Delivered as a live, instructor-led training session (available online or onsite), this programme is designed for beginner-level Linux administrators seeking to establish a solid foundation in Oracle Linux 9 system administration.

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

• Install and configure Oracle Linux 9 for enterprise deployment.
• Manage users, groups, file systems, and access permissions.
• Configure software repositories and install packages.
• Execute basic system monitoring and troubleshooting procedures.

Course Format

• Interactive lectures and discussions.
• Extensive exercises and practical practice.
• Hands-on implementation within a live-lab environment.

Customisation Options

• To request a tailored training session for this course, please contact us to arrange.

This instructor-led, live training in Faro (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:

• Install and configure Oracle Linux 9.
• Manage users, groups, and permissions.
• Work with package management and system updates.
• Configure networking and storage solutions.
• Implement security best practices.
• Automate tasks using shell scripting.

This instructor-led, live training in Faro (online or onsite) is designed for intermediate-level database administrators and IT professionals seeking 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.
• Optimise database performance using AI-driven automation.
• Implement backup and recovery strategies.
• Monitor and troubleshoot database performance issues.

This instructor-led, live training in Faro (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.

Oracle SOA Suite 12c serves as a unified platform designed for building, deploying, and managing service-oriented architecture (SOA) applications and enterprise-wide integrations.

This instructor-led training session, available either online or onsite, targets integration specialists at an intermediate level who aim to design, deploy, and manage composite applications using Oracle SOA Suite 12c.

After completing this training, participants will be equipped with the skills to:

• Develop, deploy, and monitor SOA composite applications using Oracle JDeveloper and the SOA Suite environment.
• Design integrations leveraging BPEL processes, Mediators, and adapters for diverse data sources.
• Implement 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 activities using Oracle SOA Suite 12c.

Customisation Options

• To request a tailored version of this course that focuses on your organisation’s specific integration environment or workflow requirements, please get in touch with us to arrange.

This instructor-led, live training in Faro (online or onsite) is designed for intermediate-level developers who wish to use Oracle Visual Builder Studio to create and manage visual applications effectively.

Upon completion 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 diverse data sources.
• Deploy applications to Oracle Cloud and manage various environments.

This instructor-led live training in Faro (online or onsite) is designed for intermediate-level database administrators who aim 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.

This instructor-led, live training in Faro (online or onsite) is aimed at advanced-level developers and database administrators who wish to use PL/SQL to develop high-performing, secure, and scalable database solutions while leveraging advanced programming techniques and integrations.

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

• Work with complex data types, collections, and bulk operations for efficient data management.
• Develop object types, table functions, and custom aggregates to enhance database functionality.
• Apply performance tuning techniques, use native compilation, and safeguard against SQL injection.
• Implement application contexts, VPD, and secure program units for robust database solutions.

This instructor-led live training in Faro (online or onsite) is tailored for intermediate-level database administrators aiming to develop expertise in Oracle Cloud Database 2023, focusing on migration and integration in compliance with ISO109423 standards.

Upon completing this training, participants will be equipped to:

• Grasp the features, architecture, and advantages of Oracle Cloud Database 2023.
• Understand and apply essential ISO109423 standards within database migration and integration initiatives.
• Formulate effective migration strategies, prepare data appropriately, and execute secure, efficient migrations using Oracle tools.
• Integrate Oracle Cloud Database with on-premises infrastructure and other cloud services by leveraging best practices and Oracle Integration Cloud.
• Perform comprehensive post-migration testing, enhance database performance, and ensure ongoing security and adherence to ISO109423 standards.

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

• 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 Faro (online or onsite) is aimed at advanced-level DevOps and SRE professionals who wish to enhance their alerting and automation skills with Grafana and Prometheus.

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

• Create and manage advanced alerting rules in Prometheus.
• Integrate Prometheus Alertmanager with external tools using webhooks.
• Automate responses to alerts for faster issue resolution.
• Use Grafana to visualize and manage alerts effectively.

AI for SQL refers to the application of artificial intelligence and large language models (LLMs) to automate, optimize, and improve how SQL queries are generated, executed, and interpreted within enterprise data environments.

This instructor-led, live training (available online or onsite) targets intermediate-level data engineers and technical leads who wish to integrate AI capabilities into SQL workflows to enable natural language querying, intelligent optimization, and automated data analysis.

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

• Integrate LLMs such as GPT, DeepSeek, LLaMA, Qwen, and Mistral into SQL environments.
• Build natural-language-to-SQL pipelines for conversational data access.
• Implement AI-driven query optimization and error detection.
• Design secure, auditable AI-SQL workflows for enterprise use.

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.

Greenplum is an open-source massively parallel data platform built on PostgreSQL, designed for advanced analytics and large-scale data warehousing.

This instructor-led live training (available online or onsite) is designed for intermediate-level administrators who want to effectively install, configure, and manage Greenplum environments, including handling system updates and libraries.

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

• Install and configure a production-ready Greenplum cluster.
• Manage system updates and safely apply patches.
• Handle Greenplum library management for analytics and extensions.
• Troubleshoot and monitor Greenplum systems.

Format of the Course

• Interactive lecture and discussion.
• Hands-on use of Greenplum in a controlled lab environment.
• Guided exercises focused on cluster setup, upgrade workflows, and system extensions.

Course Customization Options

• To request a customized training for this course based on your environment or data platform, please contact us to arrange.

Oracle Database 19c represents the long-term support release of Oracle's flagship 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 completing this training, participants will be able to:

• Comprehend the architecture of Oracle Database 19c SE2 and its core components.
• Install and configure Oracle Database 19c SE2 on supported platforms.
• Execute essential administrative tasks, including backup, recovery, and security management.
• Enhance database performance and monitor system health using Oracle tools.
• Plan and implement migrations from earlier Oracle Database versions to 19c.

Course Format

• Interactive lectures and discussions.
• Numerous exercises and practical practice sessions.
• Hands-on implementation within a live-lab environment.

Customization Options

• To request customized training for this course, please contact us to arrange details.

This instructor-led, live training in Faro (online or onsite) is tailored for beginner-level business and data analysts seeking to utilise Oracle BI to extract valuable insights from their data.

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

• Effectively navigate and utilise the Oracle BI interface.
• Develop and tailor reports and dashboards to meet specific business requirements.
• Perform ad-hoc analysis using a variety of BI tools.
• Leverage advanced features for in-depth data exploration.

A database constitutes a structured system designed for the efficient storage, management, and retrieval of data. This course introduces participants to the foundational principles of database systems, placing particular emphasis on relational database models, data normalization techniques, and SQL-based querying methods.

This instructor-led live training, available either online or onsite, is tailored for intermediate-level IT professionals seeking to grasp database management concepts, with a specific focus on relational database models, while acquiring practical skills in database operations.

Upon completion of this training, participants will be capable of:

• Comprehending database concepts and relational database models.
• Designing simple data models and understanding normalization principles.
• Utilizing fundamental SQL queries to retrieve, insert, and update data.
• Grasping key concepts related to database administration and security.

Course Format

• Interactive lectures and discussions.
• Extensive exercises and practice sessions.
• Hands-on implementation within a live-lab environment.

Course Customization Options

• To request customized training for this course, please contact us to make arrangements.

This instructor-led, live training in Faro (online or onsite) is aimed at intermediate-level to advanced-level database administrators, network engineers, and IT professionals who wish to optimize database performance, scalability, and reliability using Spine-Leaf architecture with VXLAN.

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

• Grasp the Spine-Leaf network topology and its advantages.
• Deploy VXLAN for scalable and efficient database networking.
• Optimize database workloads across distributed data centre environments.
• Implement Spine-Leaf architecture in both cloud and on-premises data centres.
• Strengthen network security, redundancy, and fault tolerance for database environments.
• Automate network configurations for database management using Python and Ansible.

PL/SQL (Procedural Language/SQL) is Oracle’s extension to SQL that enables developers to write procedural logic directly within the database.

This instructor-led live training, available online or onsite, targets intermediate-level developers and technical professionals who wish to create robust PL/SQL programs, manage exceptions, and build reusable procedures, functions, and packages in Oracle Database.

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

• Create PL/SQL blocks, procedures, and functions to encapsulate business logic.
• Effectively use control structures, cursors, and exception handling.
• Define and manage packages, triggers, and stored logic securely.
• Debug and test PL/SQL code using standard Oracle tools.

Course Format

• Interactive lecture and discussion.
• Ample exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request customized training for this course, please contact us to arrange.

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

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

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

This instructor-led, live training in Faro (online or onsite) is targeted at intermediate-level IT professionals seeking to learn how to design, implement, and manage relational databases, as well as how to query and manipulate data using SQL.

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

• Understand the fundamentals of database design.
• Learn to create and manage relational databases.
• Gain proficiency in writing SQL queries to retrieve and manipulate data.
• Understand advanced SQL concepts and techniques.
• Develop skills to optimise and maintain databases.

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

Upon completing this training, participants will be able to:

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

This instructor-led, live training in Faro (online or onsite) targets intermediate-level developers and administrators who aim to establish a solid PL/SQL programming foundation for developing efficient and robust database applications using Oracle 19c.

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

• Gain a comprehensive understanding of PL/SQL and its advantages over standard SQL.
• Learn how to declare and use variables and different data types within PL/SQL blocks.
• Apply control structures like IF-THEN-ELSE, CASE statements, and loops to create robust PL/SQL programs.
• Understand and implement explicit and implicit cursors for data retrieval.
• Handle exceptions effectively using predefined and user-defined exceptions.
• Develop and manage triggers to automate and enforce business rules.
• Create and use PL/SQL packages to encapsulate and modularize code for reuse and maintainability.

This training is tailored for Database Administrators and Architects seeking to master PostgreSQL from the ground up.

Participants will gain insights into PostgreSQL architecture, installation procedures, database design, as well as the methods for performing backup and recovery operations within PostgreSQL.

In this instructor-led, live training in Faro (onsite or remote), participants will explore the general and advanced aspects of PostgreSQL, including administration, performance tuning, advanced development, and replication as they step through a series of hands-on, live-lab exercises involving setup, configuration, testing, deployment and troubleshooting.

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

• Use advanced administration techniques to configure and manage a PostgreSQL server.
• Optimize the database and queries for maximum performance.
• Replicate and scale a PostgreSQL server.

This SQL training course is designed for individuals seeking to acquire the essential skills required to extract and analyze data from any database, as well as to generate comprehensive reports. Participants will learn:

• how to write SQL queries
• what relational databases are and how they can be utilized
• the concept of relations and how to establish them
• the structure of data
• differences between SQL dialects (Oracle, T-SQL, ANSI)
• practical skills for writing queries

This SQL course covers generic ANSI SQL. It can be used in any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL or any other relational databases.

This course is tailored for system administrators, developers, and database professionals.

Training Objectives:

• Gain and reinforce the skills necessary to create and manage databases
• Understand SQL syntax and apply it to retrieve and modify data
• Implement security protocols within the database environment
• Utilize advanced features such as replication, automation, and Business Intelligence (BI)
• Leverage Microsoft SQL Server capabilities to develop complex reports and solutions for developers

CockroachDB is an open-source distributed SQL database engineered for resilience and data locality. It serves as a replacement for proprietary global databases such as Google Spanner, while allowing organisations to retain full control over their infrastructure. This instructor-led live training (available online or onsite) is designed for advanced database engineers and architects who aim to utilise CockroachDB to replace proprietary global SQL databases.

This instructor-led, live training in Faro (online or onsite) targets database administrators and developers looking to migrate from proprietary databases to the open-source PostgreSQL platform.

By the end of this training, participants will be able to assess readiness for database migration, plan and execute schema migration strategies, migrate data using appropriate tools, and manage application code conversion.

This instructor-led, live training in Faro (online or onsite) is aimed at developers who wish to use Oracle APEX to develop, scale, and deploy applications faster with less code.

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

• Set up the necessary development environment to start developing database apps with Oracle APEX.
• Understand and explore the Oracle APEX tools to build a fully-featured application.
• Learn how to create applications and pages using Oracle APEX and the Page Designer UI.
• Extend the functionality of complex enterprise apps easily with Oracle APEX.
• Optimize and scale application performance and deployment.
• Control and secure access to application data and components.

This course delivers comprehensive coverage of replication, high availability, and cluster management within PostgreSQL. Participants will learn to construct and administer multi-node environments, set up automated failover mechanisms, and investigate solutions for load balancing and connection pooling. The curriculum features live replication laboratories and recovery simulations.