Database Training in Matosinhos

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.

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.

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.

SQL Tuning in Oracle Database 19c involves enhancing SQL performance through the application of analysis, statistical data, and optimization strategies.

This instructor-led live training, available online or onsite, is designed for intermediate Oracle professionals seeking to understand and implement SQL tuning techniques for Oracle Database 19c to enhance query execution and overall database efficiency.

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

• Interpreting execution plans to identify performance bottlenecks.
• Applying Oracle tuning tools such as AWR, ADDM, and the SQL Tuning Advisor.
• Utilizing indexes, hints, and statistics to optimize queries.
• Diagnosing and resolving inefficient SQL statements in practical environments.

Course Format

• Interactive lectures and discussions.
• Practical application of Oracle tuning tools and SQL queries.
• Guided exercises focused on real-world tuning scenarios and performance analysis.

Course Customization Options

• For customized training tailored to your specific system or business queries, please contact us to make arrangements.

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

SQL Server Integration Services (SSIS) is a core component of Microsoft SQL Server, providing a robust platform for data integration and workflow applications. It is widely utilized for data migration, data warehousing, and transformation tasks.

This instructor-led live training, available either online or onsite, is designed for intermediate-level data professionals and developers aiming to master the design of advanced SSIS data flows and transformations, as well as the management of Slowly Changing Dimensions (SCD) within data warehousing contexts.

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

• Design and implement resilient data flows using SSIS.
• Interact with diverse data sources, destinations, and transformation components.
• Apply Slowly Changing Dimensions (SCD) to manage historical data changes effectively.
• Deploy, execute, and troubleshoot SSIS packages with efficiency.

Course Format

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

Course Customization Options

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

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.

Target Audience

This training is designed for individuals who are beginning their journey with the SQL language within an Oracle database environment.

Course Learning Outcomes:

• How to construct queries.
• What capabilities SQL offers.
• What constitutes a relational database.
• The structure of SQL and its commands.

Upon completing this training, you will gain the ability to extract and modify data within a MongoDB database. You will also explore the powerful Aggregation Pipeline, a flexible and high-performance tool for data analytics. Furthermore, you will learn how to connect your existing BI tools, such as Tableau or Excel, to data stored in MongoDB.

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

Listeners

This course is intended for professionals seeking to master the advanced features of SQL within the Oracle environment.

Key learning outcomes include

• Techniques for constructing advanced queries.
• Strategies for generating complex reports.

Participants will acquire the skills to optimise database performance, author complex queries, and design efficient forms and reporting structures. The course also guides learners in automating operational tasks through macros and VBA.

Audience: IT professionals aiming to pursue careers as DBAs or database support specialists for MySQL databases on Linux/Windows platforms.

Format: 40% theoretical/lectures, 60% practical/hands-on lab

This course provides an introduction to Cassandra, a widely adopted NoSQL database. It explores 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 covers Cassandra internals and selected administrative topics.

Duration : 3 days

Audience : Developers

Target Audience

• Programmers
• IT professionals at the beginner level

Course Format

   A blend of lectures, discussions, and extensive hands-on practice

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

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

This instructor-led, live training in Matosinhos (online or onsite) is designed for engineers who wish to configure applications to continuously monitor and stream all database commits.

• Install and configure ZooKeeper, Kafka, and the Debezium connector service.
• Configure applications to automatically consume and react to database inserts, updates, and deletions.
• Transform database row-level changes into event streams that applications can process in real-time.
• Ensure that each row-level change is streamed in the exact order it was committed to the database.

This instructor-led, live training in Matosinhos (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 live, instructor-led training in Matosinhos (online or on-site) will teach you how to configure and run Flyway to build a SQL migration pipeline. It supports database-specific syntax like PL/SQL and T-SQL, as well as Java (for advanced data transformations or handling LOBs). Practical scenarios will be used to demonstrate real-world usage.

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

By the conclusion 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 Matosinhos (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 Matosinhos (online or onsite) is aimed at system administrators, database administrators, data architects, and developers who wish to install, configure, and manage MarkLogic Server to optimise 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.

As the cornerstone of the Microsoft data platform, SQL Server stands out as a premier operational database management system.

Relational databases have long been the preferred technology for storing, retrieving, and querying data. They enable users to organize information using a structured, well-defined model. While this approach is effective for standardized data with pre-defined requirements (such as a hospital check-in system maintaining patient records with consistent fields like ID, name, and visit date), it presents limitations for organizations dealing with less structured data. For instance, a startup experimenting with various fields in an online inquiry form must frequently redefine its schema to accommodate evolving business needs. This constant need to recreate data structures and allowed data types before saving new information can be cumbersome.

NoSQL (Not Only SQL) databases address these challenges by freeing users from the need to predefine data structures, allowing for immediate insertion and updates. NoSQL systems are typically faster than relational databases and handle vast volumes of data effortlessly. They also scale more effectively by efficiently partitioning data across server clusters and load balancing access. NoSQL databases integrate seamlessly with applications requiring real-time analytics, site personalization, IoT support, and mobile development.

In this instructor-led live training, participants will explore the architecture, design principles, and functionality of leading NoSQL databases. Through a live lab environment, attendees will set up, operate, and assess various NoSQL solutions. The objective is to equip participants with the skills to intelligently evaluate, propose, and implement suitable NoSQL database solutions within their organizations.

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

• Install and configure diverse NoSQL databases, including MongoDB, Cassandra, Redis, and Neo4j.
• Understand the advantages and disadvantages of NoSQL databases compared to relational databases.
• Grasp the underlying data formats used by NoSQL databases and how to leverage them for modern application development (desktop, mobile, cloud, IoT).
• Perform CRUD operations (create, read, update, delete) within a NoSQL environment.
• Set up a hybrid environment where relational and NoSQL databases work in tandem.
• Configure a NoSQL database cluster to distribute the processing of large datasets.
• Understand the security implications associated with using NoSQL databases.
• Deploy and scale a NoSQL database in a production environment.

Audience

• Database professionals
• Data architects
• Data strategists
• Project managers
• Application developers seeking to integrate flexible database solutions

Format of the Course

• A blend of lectures, discussions, exercises, and extensive hands-on practice.

Note

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

This instructor-led, live training in Matosinhos (online or onsite) targets engineers who want to migrate from Oracle Forms to Oracle Web Forms.

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

• Understand the major feature and architectural changes in Oracle Web Forms.
• Migrate to Oracle Web Forms from previous Forms versions.
• ***Deploy Oracle Web Forms in cloud or on premise.
• Leverage Oracle Web Forms to enhance user services and experience.

This instructor-led, live training in Matosinhos (onsite or remote) is aimed at developers who wish to use GraphQL and Relay to manage data on React applications.

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

• Set up the necessary development environment to start data control for React applications.
• Deliver instant UI-response interactions.
• Aggregate data from multiple libraries into one convenient API.
• Pre-fetch using GraphQL and Relay.

During this instructor-led live training conducted in Matosinhos, 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.

Teradata stands as one of the most widely adopted Relational Database Management Systems (RDBMS), particularly well-suited for constructing large-scale data warehousing solutions. It leverages parallelism to achieve high performance and scalability.

This course provides delegates with a comprehensive introduction to the Teradata ecosystem.