Online Database Training in Portugal

This instructor-led, live training in Portugal (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 Portugal (online or on-site) is designed for intermediate-level database administrators looking to manage and optimise complex, high-availability Oracle database environments.

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

• Gain a thorough understanding of Oracle RAC architecture and Grid Infrastructure, covering installation, configuration, and management.
• Develop practical skills in managing Automatic Storage Management (ASM), including disk group management, instance tuning, and backup/recovery procedures.
• Learn advanced RAC performance tuning techniques, disaster recovery configurations, and best practices for achieving high availability.
• Acquire troubleshooting and diagnostic skills to resolve issues within RAC and Grid Infrastructure environments.
• Understand the process of patching and upgrading Oracle RAC and Grid Infrastructure while minimising downtime and maintaining system stability.

This live, instructor-led training in Portugal provides focused preparation for the Oracle Cloud Infrastructure Architect Professional certification. Learners will gain the ability to design, implement, and secure enterprise-grade OCI architectures, automate deployments using Terraform, and effectively prepare to pass the official Oracle certification exam.

This instructor-led live training in Portugal (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 Portugal focuses on linking Power BI with Oracle databases to facilitate comprehensive data analysis. Participants will gain proficiency in ETL processes using Power Query, apply DAX and M formulas for data modeling, and construct executive dashboards, thereby acquiring practical skills essential for corporate reporting.

This live, instructor-led training in Portugal (online or on-site) is designed for entry-level customer service managers aiming to effectively oversee and optimize their service operations with Oracle’s advanced tools.

Upon completion, participants will be equipped to:

• Understand the essentials of Oracle Service Management.
• Learn to configure and handle service requests.
• Gain proficiency in using Oracle Service Cloud for service operations.
• Explore advanced features for service optimization.
• Develop skills in service management reporting and analytics.

This instructor-led, live training in Portugal (online or onsite) is aimed at intermediate-level cloud and DevOps engineers who wish to enhance cloud observability with Grafana and Prometheus.

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

• Understand the benefits of integrating Grafana and Prometheus with cloud platforms.
• Set up Prometheus for monitoring cloud-based resources.
• Configure Grafana for visualizing cloud service metrics.
• Leverage cloud-native tools and integrations for monitoring scalability.

This instructor-led, live training in Portugal (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 Portugal is designed to help intermediate developers master PL/SQL. The curriculum emphasizes building robust programs and managing exceptions, enabling learners to create reusable procedures, functions, and packages. Participants will also gain proficiency in applying effective control structures, cursors, and security features within Oracle Database.

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

Designed to equip you with the core competencies for installing, configuring, and overseeing PostgreSQL databases, this module focuses on essential operational tasks. You will gain proficiency in implementing user security protocols, executing backup and recovery procedures, overseeing system logs, and optimising fundamental parameters. By engaging in hands-on scenarios, you will execute realistic administrative duties while building a strong foundation for advanced subjects such as performance tuning and replication strategies.

This live, instructor-led training in Portugal (delivered online or on-site) is designed for system administrators seeking to acquire the skills necessary to administer, monitor, and support Oracle databases.

By the conclusion of this training, participants will be capable of:

• Comprehending the significant feature and architectural updates in Oracle Database.
• Managing and overseeing Oracle databases.
• Optimizing the performance of Oracle databases.

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 Portugal (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 Portugal (online or onsite) is targeted at developers seeking 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 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.

This instructor-led live training in Portugal (online or onsite) is designed for system administrators and DevOps engineers who wish to use Prometheus to monitor systems and applications natively or via highly dynamic microservices running in a cloud environment.

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

• Install and configure Prometheus.
• Understand the features, architecture, and core concepts of Prometheus.
• Learn how to query data using PromQL.
• Build visualizations and dashboards with Grafana.
• Configure systems monitoring and alerting rules.
• Analyze and optimize systems and application performance.
• Enable secure integration to remote endpoints and existing systems.

This live, instructor-led training on Portugal is tailored for teams looking to extract answers from their own documents and guidelines.

By the end of the session, participants will be equipped to:

• Prepare documents for AI processing
• Create a knowledge assistant via Claude Projects, custom GPTs, or Langdock
• Obtain answers with cited sources
• Keep the knowledge base current