Database Training in Matosinhos

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

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

This comprehensive 21-hour instructor-led training held in Matosinhos focuses on the deployment and administration of Oracle Database Appliance X11. Through practical laboratory sessions, participants will master architecture, configuration, and optimization techniques, with a specific emphasis on managing storage, networking, and performance in enterprise-grade settings.

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

Delve into the developer-centric capabilities of Oracle Database 23ai in this live training session in Matosinhos. Participants will cultivate practical skills by leveraging AI Vector Search, enhanced JSON/relational duality, and asynchronous driver pipelines to optimize modern application development and AI-enabled workloads.

This instructor-led, live training in Matosinhos (online or onsite) is designed for intermediate-level developers and IT professionals looking to master the new capabilities in APEX 23-24, design efficient workflows, and guarantee robust application security.

Upon completing this training, participants will be able to:

• Develop and manage APEX applications by utilising the latest features in versions 23-24.
• Design and implement efficient workflows within the APEX environment.
• Apply advanced security measures to safeguard APEX applications and data.
• Integrate APEX applications with external systems to ensure seamless data exchange.
• Test, debug, and deploy APEX applications in accordance with best practices.

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

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 Matosinhos (online or onsite) is aimed at database administrators or developers who wish to use Microsoft Azure Cosmos DB to develop and manage highly responsive and low latency applications.

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

• Provision the necessary Cosmos DB resources to start building databases and applications.
• Scale application performance and storage by utilizing APIs in Cosmos DB.
• Manage database operations and reduce cost by optimizing Cosmos DB resources.

This instructor-led, live training in Matosinhos (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 in Matosinhos, participants will explore the fundamentals of GraphQL through the practical creation of a simple API using GraphQL.

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

• Comprehend the definition of GraphQL and how it differs from REST.
• Master key GraphQL terminology.
• Configure a GraphQL development environment.
• Construct and refine a GraphQL API.

This instructor-led live training, conducted Matosinhos (either online or onsite), is designed for developers and system administrators who intend to utilize Hazelcast for processing distributed data structures and optimizing application performance.

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

• Install and configure Hazelcast to start creating and managing a cluster.
• Create a cluster for initiating automatic discovery of multiple processes.
• Set up Management Center for cluster connections and monitoring.
• Develop applications and deploy them through the Hazelcast cluster.

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

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.