Database Training in Setúbal

Oracle Linux 9 is an enterprise-grade Linux distribution engineered for optimal performance, robust security, and seamless compatibility with Red Hat Enterprise Linux. This course provides participants with an introduction to essential system administration tasks, addressing core concepts such as user management, file systems, networking, and software package handling.

Delivered as a live, instructor-led training session (available online or onsite), this programme is designed for beginner-level Linux administrators seeking to establish a solid foundation in Oracle Linux 9 system administration.

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

• Install and configure Oracle Linux 9 for enterprise deployment.
• Manage users, groups, file systems, and access permissions.
• Configure software repositories and install packages.
• Execute basic system monitoring and troubleshooting procedures.

Course Format

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

Customisation Options

• To request a tailored training session for this course, please contact us to arrange.

This instructor-led, live training in Setúbal (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 Setúbal (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 Setúbal (online or onsite) is aimed at advanced-level developers and database administrators who wish to use PL/SQL to develop high-performing, secure, and scalable database solutions while leveraging advanced programming techniques and integrations.

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

• Work with complex data types, collections, and bulk operations for efficient data management.
• Develop object types, table functions, and custom aggregates to enhance database functionality.
• Apply performance tuning techniques, use native compilation, and safeguard against SQL injection.
• Implement application contexts, VPD, and secure program units for robust database solutions.

Oracle Data Integrator (ODI) is a high-performance, ELT-based data integration platform for building, deploying, and managing data movement and transformation across heterogeneous systems.

This instructor-led, live training (online or onsite) is aimed at intermediate-level data integration developers and architects who wish to design, implement, and operate ODI-based integration solutions.

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

• Describe ODI architecture and its core components, including Agents, Repositories, and Topology.
• Design and implement data mappings and interfaces using ODI Studio.
• Use Knowledge Modules to optimize ELT processing and performance.
• Deploy, schedule, and monitor integration processes using ODI Agents and Console.

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.

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.

PostgresAI is a platform that allows database teams to clone, test, and optimize PostgreSQL environments using AI-driven automation.

This instructor-led, live training (available online or onsite) is designed for advanced-level DevOps professionals and database engineers who wish to implement PostgresAI at enterprise scale for database monitoring, cloning, and AI-driven optimization.

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

• Deploy and configure PostgresAI in enterprise environments.
• Integrate PostgresAI with CI/CD pipelines and PostgreSQL clusters.
• Leverage AI-driven insights for query optimization and performance tuning.
• Implement governance, auditing, and data privacy controls for cloned environments.

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.

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.

Oracle Cloud Infrastructure (OCI) offers a comprehensive suite of cloud services, empowering organisations to build, deploy, and secure modern applications effectively.

This instructor-led training session, available either online or onsite, is tailored for intermediate-level cloud professionals keen on designing, implementing, and managing secure infrastructures within the Oracle Cloud Infrastructure (OCI) ecosystem.

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

• Comprehend the security architecture and key components of Oracle Cloud Infrastructure.
• Effectively implement Identity and Access Management (IAM) policies and controls.
• Apply best practices for encryption, networking, and data protection within OCI.
• Monitor, audit, and ensure compliance across OCI environments.

Course Format

• Interactive lectures and discussions.
• Hands-on labs and real-world security exercises.
• Practical implementation in a live OCI environment.

Course Customization Options

• To arrange a bespoke training for this course, please contact us.

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

This instructor-led, live training in Setúbal (online or onsite) is designed for data analysts and data scientists who wish to utilize the MongoDB Aggregation Framework for data analysis, simplifying complex operations and aggregation pipelines.

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

• Install and configure MongoDB for data analysis purposes.
• Grasp the core concepts and stages of the MongoDB Aggregation Framework.
• Understand the fundamental structure, syntax, and operations used in aggregation.
• Master the handling of advanced aggregation operations.
• Apply optimization tools and techniques to enhance aggregation performance.

PL/SQL (Procedural Language/SQL) is Oracle’s extension to SQL that enables developers to write procedural logic directly within the database.

This instructor-led live training, available online or onsite, targets intermediate-level developers and technical professionals who wish to create robust PL/SQL programs, manage exceptions, and build reusable procedures, functions, and packages in Oracle Database.

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

• Create PL/SQL blocks, procedures, and functions to encapsulate business logic.
• Effectively use control structures, cursors, and exception handling.
• Define and manage packages, triggers, and stored logic securely.
• Debug and test PL/SQL code using standard Oracle tools.

Course Format

• Interactive lecture and discussion.
• Ample exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

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

This instructor-led live training in Setúbal (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 Setúbal (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 Setúbal (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 Setúbal (online or onsite) targets intermediate-level developers and administrators looking to capitalize on the new features and improvements introduced in PostgreSQL 16.

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

• Comprehending the architecture and components of PostgreSQL 16.
• Utilizing advanced SQL functionalities and PostgreSQL extensions.
• Implementing security best practices and managing access controls.
• Carrying out database administration duties, including backup, recovery, and monitoring.
• Optimizing database performance via tuning and indexing methods.
• Employing PostgreSQL's native tools for high availability and replication.
• Integrating PostgreSQL with modern application development frameworks.

This two-day course provides an introduction to SQL Developer, SQL*Plus, and SQL (Structured Query Language), the language used to access relational databases. It also covers the new features of the latest ORACLE version. The principles learned can be applied to various databases, such as Microsoft SQL Server, MySQL, Access, Informix, and DB2.

The course is delivered as a workshop, combining lectures, working examples, and practical exercises. Although the content can be customized, at least two days are required to cover the core elements.

Full course notes are provided, along with sample database files, example SQL files, and free software tools for accessing an ORACLE database.

This course focuses on programmatic interaction with PostgreSQL databases. It teaches the techniques, syntax, and structures required to build high-quality applications using a PostgreSQL backend. Additionally, the training covers SQL Tuning, highlighting best practices for writing efficient SQL code.

The target audience includes developers looking to use or extend PostgreSQL, as well as database architects.

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 Setúbal (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.

 SQL Database Management and Design equips practitioners with advanced techniques for building relational databases from foundational queries to schema design. Covers core principles of SQL query commands, union operations, aggregation functions, and entity relationship modeling. Examines proven methods for multi-table joins, transaction management, and ACID properties. Helps professionals normalize tables, optimize data selection, and design robust database architectures for reliable information systems.

This instructor-led, live training in Setúbal (online or onsite) is designed for system administrators who wish to learn how to administer, monitor, and support an Oracle database.

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

• Comprehend the key features and architectural changes in the Oracle database.
• Manage and monitor Oracle databases.
• Optimize Oracle database performance.

Access VBA training empowers developers and power users to author macros, automate Microsoft Access operations, and construct bespoke database applications. This programme covers the fundamental principles of integrating Visual Basic for Applications with MS Access, delving into critical techniques for object model automation and data manipulation. It equips database professionals with the necessary expertise to develop custom forms, reports, and event-driven workflows tailored for enterprise solutions.

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.

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 Setúbal (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.

In this instructor-led, live training session in Setúbal, 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.

Developing efficient SQL queries for Microsoft SQL Server forms the bedrock of every enterprise data pipeline. This course explores core techniques, beginning with relational database models, and advancing through data retrieval, filtering, sorting, and aggregation using grouping functions and subqueries. It guides participants through multi-table joins, set operators, DML operations, and transaction control to reliably extract and manipulate business intelligence datasets.