Database Training in Porto

This instructor-led, live training in Porto (online or onsite) is aimed at intermediate-level database administrators who wish to manage, optimize, and secure Data Guard environments for robust disaster recovery and high availability.

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

• Understand the architecture and benefits of Oracle Data Guard for disaster recovery and high availability.
• Gain hands-on experience in configuring and managing physical and logical standby databases, including Data Guard broker.
• Develop practical skills in monitoring, troubleshooting, and optimizing Data Guard environments for optimal performance.
• Learn advanced features such as Active Data Guard, Data Guard with RAC, and securing Data Guard communications.
• Apply best practices for disaster recovery planning, ensuring data consistency, and automating Data Guard operations.

This instructor-led, live training in Porto (online or onsite) is designed for beginner-level database administrators who wish to manage backup and recovery tasks in Oracle Database 19c.

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

• Grasp the fundamental concepts of backup and recovery in Oracle Database 19c, including its architecture and various failure modes.
• Acquire practical experience in configuring backup and recovery settings, such as the RMAN environment and the fast recovery area.
• Develop hands-on skills in executing diverse backup and recovery operations, including full, incremental, and point-in-time recovery.
• Learn to leverage Oracle's Flashback technology for efficient database recovery and to manage disaster recovery scenarios.
• Implement best practices for backup, recovery, and disaster recovery to ensure data availability and reduce downtime in Oracle Database 19c.

Oracle GoldenGate 19c is an enterprise-grade data replication and real-time integration solution that enables low-latency change data capture (CDC), transformation, and delivery across heterogeneous database environments.

This instructor-led, live training (online or onsite) is aimed at intermediate-level to advanced-level database administrators and replication engineers who wish to install, configure, operate, and troubleshoot Oracle GoldenGate 19c for reliable real-time data integration and high-availability architectures.

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

• Install and configure Oracle GoldenGate 19c components and topologies.
• Design and implement change data capture (CDC) and delivery processes for heterogeneous systems.
• Manage GoldenGate Microservices, deployment architectures, and secure communications.
• Monitor, tune, and troubleshoot GoldenGate replication performance and latency issues.

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 Porto (online or onsite) is aimed at beginner-level developers and database administrators who wish to learn PL/SQL to automate database tasks, implement business logic, and develop robust database applications.

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

• Develop efficient PL/SQL programs to automate database operations and integrate SQL commands effectively.
• Create reusable program units, including procedures, functions, packages, and triggers, for modular and scalable applications.
• Implement advanced data structures like associative arrays and manage query results using cursors.
• Handle errors robustly and secure code with encryption, obfuscation, and conditional compilation techniques.
• Apply PL/SQL in real-world scenarios, leveraging built-in packages for file handling, email automation, and other advanced functionalities.

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.

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

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.

MongoDB is a widely adopted NoSQL database celebrated for its flexibility, scalability, and distributed architecture, making it an excellent choice for modern application backends, data aggregation, and real-time analytics.

This instructor-led live training, available online or on-site, is designed for intermediate to advanced technical professionals seeking to acquire practical, in-depth knowledge of MongoDB operations. The curriculum covers the full lifecycle, from deployment to high availability, security, and disaster recovery.

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

• Installing, configuring, and maintaining MongoDB across various environments.
• Designing data models that optimize performance and scalability.
• Configuring secure access protocols and establishing backup and recovery procedures.
• Establishing high-availability clusters and monitoring key performance metrics.
• Managing real-world administrative duties, including upgrades and automation.

Course Format

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

Course Customization Options

• To request a customized training session 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 Porto (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 Porto (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 Porto (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 Porto (online or onsite) is tailored for beginner-level database administrators and developers who want to master SQL for efficiently managing, querying, and manipulating data in Oracle databases for administrative and operational tasks.

Upon completing this training, participants will be able to:

• Grasp Oracle database architecture, including schemas, users, and sessions.
• Write and optimize SQL queries for data retrieval, filtering, and manipulation.
• Utilize joins, subqueries, and set operators to work with multiple tables and complex queries.
• Perform data aggregation, grouping, and analysis using SQL functions.
• Manage schema objects such as views, sequences, and indexes to enhance database operations. 

This instructor-led, live training in Porto (online or onsite) targets intermediate-level developers and administrators who aim to establish a solid PL/SQL programming foundation for developing efficient and robust database applications using Oracle 19c.

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

• Gain a comprehensive understanding of PL/SQL and its advantages over standard SQL.
• Learn how to declare and use variables and different data types within PL/SQL blocks.
• Apply control structures like IF-THEN-ELSE, CASE statements, and loops to create robust PL/SQL programs.
• Understand and implement explicit and implicit cursors for data retrieval.
• Handle exceptions effectively using predefined and user-defined exceptions.
• Develop and manage triggers to automate and enforce business rules.
• Create and use PL/SQL packages to encapsulate and modularize code for reuse and maintainability.

Mastering advanced Transact-SQL within Microsoft SQL Server unleashes the full potential of enterprise database automation. This course explores essential development constructs, including procedural programming, structured error handling, transaction management, cursor operations, stored procedures, and database triggers. It empowers seasoned developers to design complex backend data processes, minimize application-layer overhead, and deliver robust, production-ready solutions for critical enterprise database applications.

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 Porto (online or onsite) is aimed at system administrators who wish to learn how to use and manage an Oracle Linux 8 system.

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

• Configure passwordless authentication.
• Administer user and group accounts.
• Configure network interface.
• Monitor and troubleshoot Oracle Linux.

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

This SQL training course is designed for individuals seeking to acquire the essential skills required to extract and analyze data from any database, as well as to generate comprehensive reports. Participants will learn:

• how to write SQL queries
• what relational databases are and how they can be utilized
• the concept of relations and how to establish them
• the structure of data
• differences between SQL dialects (Oracle, T-SQL, ANSI)
• practical skills for writing queries

This SQL course covers generic ANSI SQL. It can be used in any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL or any other relational databases.

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.

Effectively managing MySQL databases requires robust expertise in system architecture, data integrity assurance, and performance optimization. This course explores essential administration domains, including system configuration, storage engine selection, transaction management, data partitioning, and securing multi-user access across Linux and Windows environments. Participants engage in practical exercises covering backup strategies, disaster recovery procedures, replication architecture design, and performance monitoring. The training aims to build the confidence necessary to maintain high-availability MySQL environments that support mission-critical applications.

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 Porto (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, conducted Porto (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.

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 intensive one-day practical course concentrates on the design and implementation of distributed databases using the Citus extension for PostgreSQL.
Attendees will learn how to shard large datasets, handle distributed queries, and construct scalable, fault-tolerant PostgreSQL clusters.
Practical labs and real-world scenarios illustrate performance tuning, replication integration, and the management of distributed workloads.

Establish high-performance caching and messaging infrastructure with the Redis for Developers and System Administrators course. This programme guides learners from installation and configuration through data modelling, performance tuning, operational best practices, and scaling across multiple instances. Tailored for backend developers, DevOps engineers, DBAs, and infrastructure professionals implementing in-memory data stores, it provides practical expertise in Redis Sentinel clustering, master-slave replication, AOF and RDB persistence strategies, pipelining optimisation, memory management, and latency debugging to deploy reliable, enterprise-grade Redis environments.

redis

nosql