Database Training in Portugal

This instructor-led, live training in Portugal (online or onsite) is aimed at intermediate-level to advanced-level system administrators and IT professionals who wish to deepen their expertise in Oracle Linux 9 for system administration, performance tuning, security hardening, and automation.

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

• Manage and optimize Oracle Linux 9 for enterprise environments.
• Implement advanced networking and security configurations.
• Automate system administration tasks using scripting.
• Monitor and troubleshoot performance issues effectively.

This instructor-led, live training in Portugal (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 Database 19c is a multi-model database that provides full support for relational and non-relational data.

This instructor-led, live training (online or onsite) is aimed at intermediate-level system administrators and database administrators who wish to administer, monitor, secure, back up, and recover Oracle Database 19c in Standard Edition 2 environments, and to plan a clear path from 11g to 19c.

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

• Prepare the environment and perform clean installations and configurations of Oracle Database 19c SE2.
• Explain Oracle infrastructure components including SGA, PGA, Shared Pool, Database Buffer Cache, and Redo mechanisms.
• Use administration tools such as Enterprise Manager (EM Express) and SQL Developer for daily operations.
• Implement storage management best practices for tablespaces, datafiles, and segment space usage.
• Harden databases and maintain security with users, roles, privileges, profiles, and auditing.
• Design and execute RMAN-based backup and recovery strategies aligned to RTO/RPO objectives.
• Monitor and troubleshoot performance using dynamic performance views, SQL tracing, and execution plans.
• Plan and execute transition/migration from 11g to 19c using supported upgrade paths and tools.

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 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 visualize 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 based on PostgreSQL, designed for advanced analytics and large-scale data warehousing.

This instructor-led, live training (online or onsite) is aimed at intermediate-level administrators who wish to install, configure, and manage Greenplum environments effectively, including managing system updates and libraries.

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

• Install and configure a production-ready Greenplum cluster.
• Manage system updates and apply patches safely.
• 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.

Database is a structured system for storing, managing, and retrieving data efficiently. This course introduces participants to the principles of database systems, with a focus on relational database models, data normalization, and SQL-based querying.

This instructor-led, live training (online or onsite) is aimed at intermediate-level IT professionals who wish to understand database management concepts, with a focus on relational database models, and gain practical skills in working with databases.

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

• Understand database concepts and relational database models.
• Design simple data models and understand normalization.
• Use basic SQL queries to retrieve, insert, and update data.
• Understand key concepts in database administration and security.

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.

Oracle Database 19c is a robust platform for building and managing enterprise data warehouses that support analytical workloads.

This instructor-led, live training (online or onsite) is aimed at beginner-level data professionals and analysts who wish to understand the foundational concepts and architecture of Oracle-based data warehouse systems.

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

• Understand key concepts and architecture of Oracle data warehousing.
• Describe typical data warehouse components like fact and dimension tables.
• Recognize use cases and benefits of Oracle data warehousing in business intelligence.
• Prepare for deeper training in Oracle ETL, performance, and warehouse optimization techniques.

Format of the Course

• Interactive lecture and discussion.
• Hands-on use of Oracle SQL and warehouse schema exploration.
• Guided conceptual exercises and warehouse design analysis.

Course Customization Options

• To request a customized training for this course based on your internal data models or analytics goals, please contact us to arrange.

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:

• Understand the Spine-Leaf network topology and its benefits.
• Implement VXLAN for scalable and efficient database networking.
• Optimize database workloads across distributed data center environments.
• Deploy Spine-Leaf architecture in cloud and on-premises data centers.
• Enhance 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 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 aimed at intermediate-level IT professionals who wish to learn how to design, implement, and manage relational databases, and how to query and manipulate data using SQL.

By the end 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 optimize and maintain databases.

This instructor-led, live training in Portugal (online or onsite) is aimed at beginner-level data professionals who wish to learn how to design, implement, and manage SSIS packages to perform data integration and transformation tasks.

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

• Understand the architecture and components of SSIS.
• Design and implement ETL processes using SSIS.
• Use SSIS tools to develop, deploy, and manage data integration solutions.
• Troubleshoot and optimize SSIS packages for performance and reliability.

This course covers everything a database developer needs to know to successfully develop applications using MongoDB.

This training is designed for Database Administrators and Architects who want to learn PostgreSQL from basics.

You will learn PostgreSQL architecture, installation, designing as well as how to perform backup and recovery databases in PostgreSQL.

This SQL training course is for people who want to gain the necessary skills to extract and analyse data using Microsoft Access. Course members will learn:

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

This SQL course deals with Microsoft Access dialect of SQL.

This instructor-led, live training (online or onsite) is aimed at administrators wishing to solve complex deployment and management problems using MongoDB Ops Manager.

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

• Install and configure MongoDB Ops Manager
• Set up and manage different types of environments
• Understand and implement MongoDB Enterprise Server specific solutions to solve complex enterprise challenges

Format of the Course

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

Course Customization Options

• This training is based on MongoDB Enterprise Server, which includes Ops Manager. Please consult with us to arrange license requirements.
• To request a customized training for this course, please contact us to arrange.

This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn:

• how to write SQL queries
• what relational databases are and how we can use them
• what are relations and how to create them
• the structure of data
• differences between T-SQL and other dialects
• practical skills for writing queries

This SQL course deals with Microsoft T-SQL dialect. If you are interested in generic SQL, please see SQL Fundamentals course.

This training is designed for Database Administrators and Architects who want to learn Streaming Replication in PostgreSQL and how pgpool-II can be used to achieve automatic failovers and setup a highly available PostgreSQL Database Cluster.

The course participants will learn how to speed up the operation of the database, how to write advanced queries, create a convenient system of forms and reporting. The course introduces the participant to automate all operations using macros and VBA.

When traditional storage technologies don't handle the amount of data you need to store there are hundereds of alternatives. This course try to guide the participants what are alternatives for storing and analyzing Big Data and what are theirs pros and cons.

This course is mostly focused on discussion and presentation of solutions, though hands-on exercises are available on demand.

The course is part of the Data Scientist skill set (Domain: Data and Technology).

Audience

• Programmers
• Beginner IT professionals

Format of the course

    Part lecture, part discussion, heavy hands-on practice

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

This instructor-led, live training in Portugal (online or onsite) is aimed at engineers who wish to enable applications to continuously monitor and stream all commits made to their database.

• Install and configure ZooKeeper, Kafka, and the Debezium connector service.
• Set up applications to automatically consume and respond to database inserts, updates, and deletes.
• Turn database row-level changes into event streams that applications can respond to immediately.
• Stream each row-level change in the same order that it was committed to the database.

This instructor-led, live training in Portugal (online or onsite) is aimed at database administrators and developers who wish to install, configure, and manage Flyway to track and apply changes in their continuous database delivery efforts.

By the end of this training, participants will be able to implement, track, reverse, and manage database workflows and changes to improve their continuous database delivery.

This instructor-led, live training in Portugal (online or onsite) will teach how to configure and run flyway to build a migration pipeline in SQL. Database-specific syntax such as PL/SQL and T-SQL are supported, as well as Java (for advanced data transformations or for dealing with LOBs). Practical scenarios will help to understand real-world usages.

This instructor-led, live training in Portugal (online or onsite) is aimed at administrators who wish to set up Greenplum Database for business intelligence and data warehousing solutions.

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

• Address processing needs with Greenplum.
• Perform ETL operations for data processing.
• Leverage existing query processing infrastructures.

This instructor-led, live training in Portugal (online or onsite) is aimed at engineers who wish to use JanusGraph to process very large graphs that require abnormal storage and computational capacity.

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

• Install and configure JanusGraph.
• Integrate JanusGraph with multiple backend storage systems (Cassandra, HBase, etc.) and multiple indexing software (Elasticsearch, Solr, etc.). 
• Configure multiples machines into a cluster for use by JanusGraph.
• Query the database using the Gremlin query language.
• Process graph data at scale, beyond what a single machine can provide.
• Support thousands of concurrent users traversing graph data in real time.
• Query graph data for analysis.

This instructor-led, live training in Portugal (online or onsite) is aimed at system administrators, database administrators, data architects, and developers who wish to install, configure, and manage MarkLogic Server to optimize their database systems.

By the end of this training, participants will be able to implement, develop, manage, and secure their enterprise data and database systems using MarkLogic Server.

Redis is an open source (BSD licensed), in-memory data structure store, used as database, cache and message broker.

In this instructor-led, live training in Portugal, participants will learn the fundamentals of SAP ASE (SAP Adaptive Server Enterprise) Database Administration as they step through the creation and deployment of a sample SAP ASE Database System.

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

• Install and configure SAP ASE for data storage as well as transactional operations.
• Understand and use SAP ASE components, tools, and utilities.
• Integrate SAP ASE with non-SAP ASE applications.