Database Training in Évora

This instructor-led, live training in Évora (online or on-site) is designed for advanced system administrators aiming to enhance their proficiency in system management, troubleshooting, and performance tuning.

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

• Configure and manage advanced user and group settings, including the implementation of user quotas and system-wide user environments.
• Use security auditing tools and configure sudo for controlled administrative access.
• Monitor and optimize system performance.
• Configure, analyze, and troubleshoot system logs.
• Develop and implement backup and recovery solutions.

This instructor-led, live training in Évora (online or onsite) is aimed at advanced-level Kubernetes administrators and DevOps engineers who wish to enhance their monitoring skills for Kubernetes clusters using Prometheus and Grafana.

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

• Set up Prometheus and Grafana for Kubernetes monitoring.
• Monitor key metrics for pods, nodes, and services.
• Create dynamic dashboards to visualise cluster health and performance.
• Implement alerting strategies for proactive issue resolution.
• Apply best practices for scaling monitoring solutions in Kubernetes environments.

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 session in Évora (online or onsite) is designed for intermediate-level database administrators seeking to boost the performance and efficiency of Oracle Database systems, particularly those operating in environments that utilize Oracle Database Appliances.

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

• Comprehending the architecture and key components of the Oracle Database Appliance HA X8-X9r.
• Identifying and addressing performance bottlenecks.
• Acquiring hands-on expertise in SQL and instance tuning.
• Effectively leveraging Oracle's performance analysis tools.
• Applying industry best practices for database tuning and optimization.

This instructor-led, live training in Évora (online or onsite) is aimed at intermediate-level database administrators who wish to learn the necessary skills and knowledge to effectively manage and administer SQL Server databases using SQL Server Management Studio.

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

• Understand system requirements and perform installations.
• Create, configure, and manage databases using SSMS.
• Manage logins, users, roles, and permissions.
• Perform various types of backups and restore databases.
• Create, schedule, and manage jobs using SQL Server Agent.
• Implement best practices for efficient and secure SQL Server administration.

This live, instructor-led training in Évora empowers data engineers to blend LLMs into their SQL environments. Learners will construct natural language pathways, apply AI-led optimisation, and architect secure enterprise workflows for automated analytics.

This instructor-led, live training in Évora (online or onsite) is aimed at beginner-level system administrators and DevOps engineers who wish to develop core monitoring skills using Grafana and Prometheus.

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

• Understand the purpose and importance of monitoring in IT environments.
• Install and configure Grafana and Prometheus for basic monitoring tasks.
• Create simple dashboards and alerts to visualize system performance.
• Apply best practices for monitoring system availability and performance.

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 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 É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 database admins and sysadmins who wish to use PostgreSQL to manage large-scale data while optimizing the database systems for high availability and performance.

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

• Install and configure PostgreSQL.
• Understand the features and architecture of PostgreSQL.
• Learn how to perform database operations with SQL.
• Perform database backup and recovery to prevent data loss.
• Configure the server for high availability.
• Learn the tools and techniques for high performance tuning.
• Explore the external tools for monitoring and observability.

This instructor-led, live training conducted in Évora (available online or onsite) is tailored for system administrators seeking to learn how to utilize and manage Oracle Linux 8 systems.

By the end of the session, participants will be capable of:

• Configuring passwordless authentication.
• Administering user and group accounts.
• Setting up network interfaces.
• Monitoring and troubleshooting Oracle Linux.

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.

This course explores the core concepts of PostgreSQL server extensions and libraries designed to incorporate artificial intelligence techniques into database architectures. Key topics include similarity and semantic search utilizing embedding vectors, Text-to-SQL query capabilities, and Retrieval-Augmented Generation (RAG). Participants will acquire the skills necessary to install PgVector and PgAI, generate and ingest vector embeddings, construct vector indexes, and implement semantic search alongside RAG solutions. Additionally, attendees will develop Text-to-SQL applications leveraging LangChain with either Python or JavaScript. These learning experiences are solidified through live demonstrations and practical exercises that reinforce both theoretical understanding and technical proficiency.

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.