Database Training in Évora

This instructor-led, live training in Évora (online or onsite) is designed for intermediate-level system administrators who aim to effectively manage Oracle Linux Virtualization environments.

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

• Install and configure Oracle Linux Virtualization Manager and its associated components on physical or virtual environments.
• 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 Évora (online or on-site) is aimed at intermediate-level database administrators who wish to effectively manage and optimise a multitenant environment.

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

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

Grafana and Prometheus are industry-standard tools used to monitor, visualize, and alert on IT infrastructure and application metrics through real-time dashboards and integrations.

This instructor-led, live training (online or onsite) is aimed at intermediate-level to advanced-level IT professionals who wish to integrate Grafana with Prometheus and multiple data sources, and build actionable visualizations and alerts across distributed systems.

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

• Install and configure Grafana and Prometheus in production-ready setups.
• Integrate multiple data sources including SQL, Elasticsearch, InfluxDB, and cloud APIs.
• Create advanced dashboards with variables, templating, transformations, and alerts.
• Apply best practices in data modeling, performance tuning, and user access control.

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.

Power BI serves as a business intelligence platform enabling users to connect with data sources, transform and analyse data, and generate interactive reports and dashboards. Oracle Database, a widely adopted enterprise database solution, integrates seamlessly with Power BI to facilitate corporate reporting.

This instructor-led live training, available either online or onsite, is designed for intermediate-level data professionals seeking to link Oracle databases with Power BI to design, analyse, and present actionable insights tailored to corporate requirements.

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

• Connect Power BI to Oracle databases and other data sources.
• Execute data cleansing, consolidation, and transformation.
• Utilise Power Query and Pivot for ETL processes.
• Apply DAX and M formulas for data modelling and analysis.
• Design professional reports and executive presentations within Power BI.
• Leverage advisory support to meet corporate reporting requirements.

Format of the Course

• Instructor-led lectures and discussions.
• Hands-on labs involving Power BI and Oracle.
• Practical exercises addressing real-world reporting needs.
• Advisory support sessions.

Course Customization Options

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

This instructor-led, live training in Évora (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 Évora (online or onsite) is aimed at advanced-level DevOps engineers and SREs who wish to manage and scale Prometheus and Grafana for large environments effectively.

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

• Architect Prometheus and Grafana for large-scale and distributed environments.
• Optimise Prometheus performance for high-traffic systems.
• Configure Grafana for large datasets and complex visualisations.
• Implement advanced troubleshooting and scalability strategies.

This instructor-led, live training in Évora (online or onsite) is tailored 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:

• 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.

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.

This instructor-led training, available in Évora (online or onsite), is designed for intermediate-level maintenance personnel aiming to streamline their processes using Oracle Cloud ERP Fusion.

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

• Grasping the core functionalities of Oracle Maintenance Cloud.
• Deploying corrective, preventive, and predictive maintenance strategies.
• Efficiently handling maintenance requests, work orders, and scheduling.
• Leveraging analytics to enhance maintenance performance and drive improvements.

PostgresAI is a platform that allows database teams to clone, test, and optimize PostgreSQL environments using AI-driven automation.

This instructor-led, live training (available online or onsite) is designed for advanced-level DevOps professionals and database engineers who wish to implement PostgresAI at enterprise scale for database monitoring, cloning, and AI-driven optimization.

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

• Deploy and configure PostgresAI in enterprise environments.
• Integrate PostgresAI with CI/CD pipelines and PostgreSQL clusters.
• Leverage AI-driven insights for query optimization and performance tuning.
• Implement governance, auditing, and data privacy controls for cloned environments.

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.

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 Évora (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.

This instructor-led, live training in Évora (online or onsite) is aimed at beginner-level professionals who wish to learn how to use PostgreSQL for creating databases, writing SQL queries, manipulating data, and managing tables using both SQL commands and PGAdmin. The course also provides a basic introduction to the Timescale extension for time-series data.

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

• Understand relational database principles and PostgreSQL architecture.
• Install, configure, and navigate PostgreSQL and PGAdmin.
• Write and run SQL queries for data selection, filtering, grouping, and joining.
• Manipulate data with SQL statements and manage database objects.
• Create and manage views and explore PostgreSQL extensions like Timescale.

This instructor-led, live training in Évora (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, available online or onsite, targets developers who wish to use the FARM (FastAPI, React, and MongoDB) stack to build dynamic, high-performance, and scalable web applications.

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

• Set up the necessary development environment that integrates FastAPI, React, and MongoDB.
• Understand the key concepts, features, and benefits of the FARM stack.
• Learn how to build REST APIs with FastAPI.
• Learn how to design interactive applications with React.
• Develop, test, and deploy applications (front end and back end) using the FARM stack.

This programme provides comprehensive guidance for database administrators on the effective deployment and maintenance of MongoDB environments.

Key topics include diagnosing performance bottlenecks, managing data imports and exports, establishing robust backup and restoration procedures, and an overview of the MongoDB CRUD API, command-line shell, and associated drivers.

The target audience comprises individuals seeking to:

• Gain a developer-centric understanding of MongoDB, including its command shell, query API, and driver utilities.
• Deploy MongoDB across various configurations, such as single servers, master-slave replication, replica sets, and sharded clusters.
• Evaluate application requirements and select appropriate hardware.
• Monitor MongoDB instances and integrate them with standard monitoring solutions (e.g., Munin, Nagios).
• Plan for backups and manage large-scale data imports and exports.
• Troubleshoot frequent developer-related issues and failure scenarios.

Participants will engage in a series of hands-on practical exercises.

Effective management and development of PostgreSQL databases demand a profound understanding of performance tuning, database replication strategies, and connection pooling techniques. This course encompasses server administration, core SQL principles, client-side interfaces, server-side programming, and the internal architecture of the database. Through practical, hands-on training, Database Administrators and developers will learn to optimize query execution, manage backup procedures, set up monitoring systems, and establish robust, production-ready configurations tailored for enterprise-level PostgreSQL environments.

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.

Designed for Database Administrators and Architects seeking to optimize PostgreSQL performance, this training demonstrates how to log slow workloads and identify potential query bottlenecks. It also addresses the critical parameters that require tuning to achieve optimal efficiency.

This training program is tailored for Database Administrators and Architects seeking to master the tools and techniques required to implement effective backups, high availability, and database security within PostgreSQL.
Participants will also acquire the skills necessary to identify slow queries, monitor database performance, and optimize PostgreSQL settings for enhanced efficiency.

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 provides an introduction to Cassandra, a widely used NoSQL database. Participants will explore Cassandra's core principles, architecture, and data model. Through hands-on, interactive labs, students will master data modeling using CQL (Cassandra Query Language). The session also delves into Cassandra internals and key administrative topics.

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 Évora (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.

In this instructor-led, live training session in Évora, participants will learn how to install, configure, and manage MariaDB to achieve high availability and performance. The curriculum also covers backup and recovery, security, and clustering.

Oracle Linux Administration provides comprehensive training on deploying, configuring, and managing Oracle Linux in enterprise environments.

This instructor-led live training is aimed at system administrators, infrastructure engineers, and DevOps professionals.

By the end of the course, participants will be able to:

• Install, administer, and secure Oracle Linux in production
• Manage storage, networking, packages, and services effectively
• Apply SELinux security, automate tasks, and perform recovery

Available in Évora.

This practical course emphasises the hands-on approach to performance tuning within PostgreSQL. Participants will gain the skills to analyse query execution, refine indexing strategies, tweak memory and system settings, and effectively monitor workloads. Through real-world scenarios and live exercises, learners will discover how to pinpoint and resolve bottlenecks at both the database and system levels.

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.

redis

nosql

Target Audience

This workshop is designed for advanced programmers and Oracle users who wish to acquire in-depth knowledge on efficiently developing information systems within an Oracle database, as well as tuning and resolving performance issues in existing applications. The course leverages insights gathered over many years of practical experience by the instructors, often addressing gaps or inaccuracies found in standard technical documentation. This workshop can serve as the culmination of a developer's training path or as a critical step for professionals with extensive experience in Oracle design and programming.

Training Objectives

The primary aim of this workshop is to explain the internal mechanisms of an Oracle database when executing SQL statements. It enables participants to prevent errors during software development and to effectively explore, diagnose, and resolve performance problems in current applications.

Particular emphasis is placed on the practical methodology and hands-on aspects of applying and tuning SQL statements.

Training Content

• Mechanics of executing SQL commands
• Managing the cost-based optimization process
• Data storage methods and indexing strategies
• Monitoring database performance and processes using system dictionaries and application tracking
• Case analysis of the most common problems causing performance issues

Notes

The workshops utilize software version 11g XE.