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 onsite) is targeted at intermediate-level database administrators seeking an in-depth understanding of Oracle Database 19c PL/SQL programming and advanced SQL techniques.

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

• Understand the fundamentals and advanced features of PL/SQL.
• Develop advanced SQL queries to retrieve and manipulate data efficiently.
• Implement PL/SQL programming constructs to manage data and database operations.
• Optimise SQL queries for better performance.
• Use advanced PL/SQL features like collections, bulk processing, and error handling.
• Learn to debug and manage PL/SQL programs effectively.

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

This instructor-led, live training in Évora (online or onsite) is aimed at beginner-level IT professionals and DevOps practitioners who wish to learn the basics of Grafana and Prometheus.

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

• Understand the purpose and key features of Grafana and Prometheus.
• Install and configure Grafana and Prometheus on a Linux environment.
• Set up basic data sources and dashboards in Grafana.
• Monitor system metrics and visualize data using Prometheus.

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 designed for beginner to intermediate-level data analysts, database professionals, and software developers who wish to learn SQL for effective database management.

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

• Grasp and utilize core SQL commands and queries.
• Construct and manipulate tables and databases.
• Employ SQL to sort, filter, and summarize data.
• Execute more complex operations, including joins, subqueries, and set operations.
• Apply intermediate techniques such as indexes, views, stored procedures, and triggers.

This instructor-led, live training in Évora (available online or in-person) is designed for intermediate software developers and automation engineers who aim to build applications that communicate with PLCs and interact with SQL databases using Visual Studio.

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

• Develop .NET applications in Visual Studio for industrial automation.
• Communicate with PLCs using industrial protocols such as OPC UA.
• Implement database interactions with SQL Server for storing and retrieving PLC data.
• Optimize application performance for real-time industrial environments.

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 in Évora (online or onsite) is aimed at beginner-level data professionals who wish to learn how to design, implement, and manage SSIS packages to perform data integration and transformation tasks.

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

• Understand the architecture and components of SSIS.
• Design and implement ETL processes using SSIS.
• Use SSIS tools to develop, deploy, and manage data integration solutions.
• Troubleshoot and optimize SSIS packages for performance and reliability.

This instructor-led, live training in Évora (online or onsite) is aimed at intermediate-level database administrators, developers, and analysts who wish to master advanced SQL functionalities for complex data operations and database management.

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

• Execute advanced querying techniques using unions, subqueries, and complex joins.
• Add, update, and delete data, tables, views, and indexes with precision.
• Ensure data integrity through transactions and manipulate database structures.
• Create and manage databases efficiently for robust data storage and retrieval.

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.

This practical course delves into the essential aspects of performance tuning in PostgreSQL. Learners will gain skills in analysing query execution, refining indexing strategies, tuning memory and system parameters, and effectively monitoring workloads. Through real-world case studies and live practical exercises, the course illustrates how to pinpoint and eliminate performance bottlenecks at both the database and system levels.

This intensive one-day, hands-on workshop is dedicated to the design and implementation of distributed database solutions using the Citus extension for PostgreSQL. Learners will gain practical insights into sharding large datasets, managing distributed queries, and constructing scalable, fault-tolerant PostgreSQL clusters. Through real-world scenarios and practical labs, the course illustrates techniques for performance tuning, integrating replication, and managing distributed workloads.