Online Database Training in Portugal

Building upon its enterprise-ready foundation, Oracle Linux 9 provides robust tools for system performance, networking, automation, and storage management. This course expands the administrator’s skillset by introducing advanced administration techniques, system optimization, and service management within enterprise environments.

This instructor-led, live training (available online or onsite) is designed for intermediate-level Linux administrators seeking to advance their knowledge in administering Oracle Linux 9 systems in production environments.

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

• Automate administrative tasks using Bash scripting.
• Configure logical volumes, RAID, and advanced storage systems.
• Manage SELinux policies and file security contexts.
• Monitor system performance and resource usage.

Format of the Course

• Interactive lecture and discussion.
• Extensive 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.

This instructor-led, live training in Portugal (online or onsite) is designed for beginner-level database administrators aiming to equip themselves with the necessary skills to manage and optimise their Oracle environments effectively.

Upon completing this training, participants will be capable of:

• Grasping the core features and architecture of Oracle Database 19c, encompassing system requirements and installation procedures.
• Acquiring practical expertise in installing Oracle Database 19c and Oracle Grid Infrastructure, including the configuration of network, storage, and security settings.
• Mastering the full upgrade process for Oracle Database 19c, ranging from pre-upgrade planning to post-upgrade validation.
• Developing troubleshooting capabilities to address common challenges encountered during installation and upgrade phases.
• Applying best practices for Oracle Database installation and upgrades to guarantee a seamless and successful deployment.

Oracle Cloud Infrastructure (OCI) represents Oracle’s next-generation cloud platform, delivering scalable, secure, and high-performance services tailored for enterprise workloads and cloud-native applications.

This instructor-led, live training (available online or onsite) is designed for intermediate to advanced cloud professionals aiming to design, implement, and manage enterprise-grade solutions on Oracle Cloud Infrastructure as part of their preparation for the OCI Architect Professional certification.

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

• Design and deploy complex OCI architectures in accordance with Oracle best practices.
• Implement multi-region, multi-tier cloud solutions featuring high availability and disaster recovery capabilities.
• Secure OCI environments through IAM, encryption, and governance policies.
• Automate cloud resource provisioning using Terraform and the OCI CLI.
• Prepare for and successfully pass the Oracle Cloud Infrastructure Architect Professional certification exam.

Course Format

• Interactive lectures and discussions.
• Hands-on labs and guided exercises.
• Practical design scenarios and architecture simulations.

Course Customization Options

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

This instructor-led, live training in Portugal (online or onsite) is designed for intermediate-level developers who wish to use Oracle Visual Builder Studio to create and manage visual applications effectively.

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

• Create and design visual applications using Oracle Visual Builder Studio.
• Leverage pages, components, and flows to construct user interfaces.
• Implement data binding and integrate with diverse data sources.
• Deploy applications to Oracle Cloud and manage various environments.

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.

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

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.

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.

SQL Server is Microsoft’s enterprise-grade relational database management system, engineered for the efficient storage, management, and retrieval of data.

This instructor-led live training (available online or onsite) is tailored for IT professionals at an intermediate level who aim to administer, configure, and maintain SQL Server environments.

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

• Install and configure SQL Server environments.
• Manage databases, users, and permissions.
• Monitor performance and troubleshoot issues.
• Automate tasks using jobs and maintenance plans.

Course Format

• Interactive lectures and discussions.
• Ample exercises and practical practice.
• Hands-on implementation within a live-lab environment.

Customization Options

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

This instructor-led live training in Portugal (online or onsite) is designed for beginner to intermediate data scientists and software developers who wish to learn how to apply Pinecone in various AI scenarios, from semantic search to personalization.

Upon completing this training, participants will be able to:

• Grasp the architecture and key features of Pinecone.
• Deploy vector databases across different AI applications.
• Execute similarity searches with high precision and speed.
• Apply Pinecone to address real-world AI challenges.

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 (online or onsite) is aimed at intermediate-level to advanced-level database administrators who wish to deepen their knowledge of SQL Server for efficient database management, performance tuning, high availability, and advanced troubleshooting.

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

• Administer and configure SQL Server instances using best practices.
• Optimize performance of queries and databases.
• Implement high availability and disaster recovery strategies.
• Diagnose and resolve complex issues in production environments.

Oracle Database 23ai represents the most recent long-term release, prioritising developer productivity and integrating built-in AI capabilities. Key enhancements include AI Vector Search, advancements in JSON and relational duality, support for async and pipelining drivers, SQL and PL/SQL improvements, and novel operational features designed to support modern application development and AI-driven workloads.

This instructor-led live training, available either online or onsite, is tailored for developers with intermediate-level skills. It aims to equip participants with the knowledge to utilise the new 23ai features in real-world development scenarios, thereby achieving a basic to intermediate competency level.

Upon completing this training, participants will be able to:

• Articulate the principal developer-focused features introduced in Oracle Database 23ai and determine appropriate use cases.
• Implement AI Vector Search and new JSON/relational capabilities within sample applications.
• Utilise async and pipelining driver functionalities to optimise client-server workflows and enhance throughput.
• Apply practical methods for testing, debugging, and deploying application code based on 23ai within development environments.

Course Format

• Interactive lectures combined with targeted demonstrations.
• Practical hands-on labs utilising Oracle Database 23ai Free and essential developer tools.
• Guided exercises featuring sample Java/Quarkus and front-end examples.

Course Customisation Options

• For a bespoke version of this course—such as focusing on specific language stacks, deepening PL/SQL content, or adding extra labs—please contact us to make arrangements.

This instructor-led live training in Portugal (online or onsite) is aimed at intermediate-level data scientists who wish to learn how to utilize the COST IT module of Presto for cost analysis.

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

• Understand the fundamentals of Presto and its role in big data analytics.
• Gain proficiency in using Presto's COST IT module for cost analysis.
• Optimize Presto queries for improved performance and resource utilization.
• Identify and implement cost-based optimizations in Presto.
• Troubleshoot and resolve common performance and cost-related issues in Presto.

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

In this instructor-led, live training in Portugal (onsite or remote), participants will explore the general and advanced aspects of PostgreSQL, including administration, performance tuning, advanced development, and replication as they step through a series of hands-on, live-lab exercises involving setup, configuration, testing, deployment and troubleshooting.

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

• Use advanced administration techniques to configure and manage a PostgreSQL server.
• Optimize the database and queries for maximum performance.
• Replicate and scale a PostgreSQL server.

Ensuring zero-downtime PostgreSQL deployments requires expert handling of Streaming Replication and automated failover management. This course delves into synchronous and asynchronous replication, cascaded replication, transaction log archiving, base backups, and monitoring streaming configurations. Participants will learn to deploy pgpool-II for connection pooling, set up automated high availability, and achieve production-grade database reliability for critical enterprise environments supporting high-traffic business applications.

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

Designed for delegates who already possess familiarity with SQL within the Microsoft SQL Server 2008/2012 environment, this course concentrates on set-based querying and query tuning. Key areas of study include working with indexes and analyzing execution plans.

Additionally, the training covers table expressions, ranking functions, and techniques for handling partitioned tables.

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 built for resilience and data locality. It offers a viable alternative to proprietary global databases like Google Spanner, enabling full infrastructure autonomy. This instructor-led, live training (online or on-site) is designed for advanced database engineers and architects looking to leverage CockroachDB to replace vendor-locked global SQL solutions.

This instructor-led, live training in Portugal (online or onsite) is aimed at database administrators and developers who wish to migrate from proprietary databases to open source PostgreSQL.

By the end of this training, participants will be able to assess database migration readiness, plan and execute schema migration strategies, migrate data using appropriate tools, and handle application code conversion.

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.

Scylla is an open-source distributed NoSQL data store. Compatible with Apache Cassandra, it delivers significantly higher throughput and lower latency.

In this course, participants will explore Scylla's features and architecture while gaining practical experience in setting up, administering, monitoring, and troubleshooting Scylla.

Audience

• Database administrators
• Developers
• System Engineers

Course Format

• The course is interactive, featuring discussions on the principles and approaches for deploying and managing Scylla distributed databases and clusters.
• The curriculum includes a substantial component of hands-on exercises and practice.

Microsoft SQL Server serves as a robust relational database management system (RDBMS) designed for efficient data storage and retrieval.

Through this instructor-led live training, available either onsite or remotely, attendees will acquire the fundamental SQL skills necessary to effectively query Microsoft SQL Server databases.

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

• Install and configure Microsoft SQL Server
• Execute queries on a Microsoft SQL Server database using the Transact-SQL (T-SQL) language
• Grasp the core principles of database design
• Enhance database performance through normalization
• Utilize aggregate functions to generate results comparable to those produced by pivot tables
• Connect to Microsoft SQL Server directly from Excel

Target Audience

• Data analysts
• Business Intelligence specialists
• Business managers
• Excel specialists looking to broaden their analytical capabilities

Course Structure

• Interactive lectures and group discussions
• Extensive practical exercises and hands-on practice
• Live implementation within a lab environment

Customization Options

• This training utilizes the most recent version of Microsoft SQL Server
• For inquiries regarding customized training arrangements, please contact us directly.

This training course provides an introduction to the Teradata relational database management system and its parallel architecture designed for large-scale data warehousing. It covers core concepts such as installation, architecture, SQL basics, and advanced topics, empowering data engineers with the knowledge needed for enterprise data warehouse design, relational modeling, and distributed query processing for business intelligence applications.

redis

nosql