Database Training in Aveiro

This instructor-led, live training in Aveiro (online or onsite) is aimed at beginner-level to intermediate-level IT professionals and Linux users who wish to gain a solid understanding of Oracle Linux 9, from installation and configuration to system administration and security.

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

• Install and configure Oracle Linux 9.
• Manage users, groups, and permissions.
• Work with package management and system updates.
• Configure networking and storage solutions.
• Implement security best practices.
• Automate tasks using shell scripting.

Oracle SOA Suite 12c serves as a unified platform designed for building, deploying, and managing service-oriented architecture (SOA) applications and enterprise-wide integrations.

This instructor-led training session, available either online or onsite, targets integration specialists at an intermediate level who aim to design, deploy, and manage composite applications using Oracle SOA Suite 12c.

After completing this training, participants will be equipped with the skills to:

• Develop, deploy, and monitor SOA composite applications using Oracle JDeveloper and the SOA Suite environment.
• Design integrations leveraging BPEL processes, Mediators, and adapters for diverse data sources.
• Implement service orchestration, routing, and transformation following industry best practices.
• Administer and troubleshoot composite applications within Oracle Enterprise Manager (EM) Fusion Middleware Control.

Course Format

• Interactive lectures and discussions.
• Practical exercises and guided laboratory sessions.
• Hands-on implementation activities using Oracle SOA Suite 12c.

Customisation Options

• To request a tailored version of this course that focuses on your organisation’s specific integration environment or workflow requirements, please get in touch with us to arrange.

This instructor-led live training in Aveiro (online or onsite) is tailored for intermediate-level database administrators aiming to develop expertise in Oracle Cloud Database 2023, focusing on migration and integration in compliance with ISO109423 standards.

Upon completing this training, participants will be equipped to:

• Grasp the features, architecture, and advantages of Oracle Cloud Database 2023.
• Understand and apply essential ISO109423 standards within database migration and integration initiatives.
• Formulate effective migration strategies, prepare data appropriately, and execute secure, efficient migrations using Oracle tools.
• Integrate Oracle Cloud Database with on-premises infrastructure and other cloud services by leveraging best practices and Oracle Integration Cloud.
• Perform comprehensive post-migration testing, enhance database performance, and ensure ongoing security and adherence to ISO109423 standards.

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

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.

SQL serves as a robust tool for managing and analyzing structured data within relational databases.

This instructor-led training, available both online and onsite, is designed for intermediate users looking to enhance their SQL capabilities for handling complex queries, data manipulation, and performance optimization.

Upon completion of this training, participants will gain the ability to:

• Compose intricate SQL queries by utilizing advanced joins and subqueries.
• Manage data effectively through INSERT, UPDATE, and DELETE operations.
• Apply window functions to conduct advanced analytics.
• Enhance query performance through optimization techniques.

Course Structure

• Engaging lectures and interactive discussions.
• Extensive practical exercises and drills.
• Practical application within a live laboratory environment.

Customization Opportunities

• For tailored training solutions, please reach out to us to discuss your specific needs.

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 Database 19c serves as a powerful platform for constructing and managing enterprise data warehouses designed to handle analytical workloads.

This instructor-led live training, available either online or on-site, targets beginner-level data professionals and analysts eager to grasp the foundational concepts and architecture of Oracle-based data warehouse systems.

Upon completing this training, participants will be capable of:

• Grasping the core concepts and architecture of Oracle data warehousing.
• Describing standard data warehouse components, such as fact and dimension tables.
• Identifying use cases and advantages of Oracle data warehousing within business intelligence.
• Preparing for advanced training in Oracle ETL, performance tuning, and warehouse optimization techniques.

Course Format

• Interactive lectures and discussions.
• Practical application of Oracle SQL and exploration of warehouse schemas.
• Guided conceptual exercises and warehouse design analysis.

Customization Options

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

SQL serves as the standard language for accessing and manipulating databases.

This instructor-led live training, available online or on-site, is designed for beginners who want to grasp the fundamentals of SQL for data querying and reporting.

Upon completing this training, participants will be able to:

• Comprehend the structure of relational databases.
• Compose basic SQL statements to retrieve, filter, and sort data.
• Utilize aggregate functions to summarize data.
• Execute basic joins between multiple tables.

Course Format

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

Course Customization Options

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

This instructor-led, live training in Aveiro (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 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, delivered in Aveiro (either online or onsite), targets intermediate to advanced data scientists and machine learning engineers who aim to master the utilization of vector databases for scalable, high-performance AI applications.

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

• Understand the principles of vector databases.
• Learn techniques for creating and managing vector embeddings.
• Explore indexing strategies for high-dimensional data.
• Develop skills for performing efficient similarity searches.
• Apply vector database knowledge to machine learning projects.

This instructor-led, live training in Aveiro (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 Aveiro (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 Aveiro (online or onsite) is aimed at beginner-level software developers and database administrators who wish to learn the basics of vector databases, including their structure, operation, and use cases.

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

• Understand the concept and purpose of vector databases.
• Recognize the differences between vector and traditional databases.
• Learn basic techniques for creating and managing vector data.
• Perform simple similarity searches.
• Appreciate the role of vector databases in AI applications.

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.

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.

This training program is tailored for Database Administrators and Architects seeking to master the tools and techniques required to implement effective backups, high availability, and database security within PostgreSQL.
Participants will also acquire the skills necessary to identify slow queries, monitor database performance, and optimize PostgreSQL settings for enhanced efficiency.

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.

Automate workflows and develop robust desktop applications using VBA across Microsoft Excel and Access. This comprehensive VBA training covers programming fundamentals, object-oriented coding, SQL database design, user interface development, debugging techniques, error handling, and advanced Excel analysis routines through practical exercises — empowering analysts, financial professionals, and developers to eliminate manual tasks and unlock advanced data management and reporting capabilities.

 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.

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 Aveiro (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 MariaDB Administration training course is designed for individuals seeking to manage the MariaDB database server. It is a comprehensive program that covers all essential administrative responsibilities.

The curriculum explains the inner workings of the MariaDB Database, available tools, their practical applications, and methods for securing and configuring the MariaDB Database Server. Participants will learn how to manage user accounts and understand the mechanics of the MariaDB Access Privilege System. Additionally, the course teaches database maintenance, backup and recovery procedures, and crash recovery techniques.

This course is designed for database administrators.

It explores high-availability solutions utilizing the Galera Cluster.

You will master the fundamentals of Galera technology, along with advanced topics and practical insights into configuring, optimizing, and managing a Galera Cluster.

The MySQL Administration training course is designed for individuals seeking to manage the MySQL database server effectively. It is a comprehensive programme that addresses all essential administrative responsibilities.

The course explains the workings of the MySQL Database, the tools available, their practical application, and methods to secure and configure the MySQL Database Server. During the training, you will learn to manage user accounts and understand the MySQL Access Privilege System. Additionally, you will acquire skills in maintaining your database, performing backups and recovery, and executing crash recovery.

This instructor-led live training in Aveiro (online or onsite) is designed for system administrators and DevOps engineers who wish to use Prometheus to monitor systems and applications natively or via highly dynamic microservices running in a cloud environment.

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

• Install and configure Prometheus.
• Understand the features, architecture, and core concepts of Prometheus.
• Learn how to query data using PromQL.
• Build visualizations and dashboards with Grafana.
• Configure systems monitoring and alerting rules.
• Analyze and optimize systems and application performance.
• Enable secure integration to remote endpoints and existing systems.

SSAS (SQL Server Analysis Services) is a Microsoft SQL Server tool designed for Online Analytical Processing (OLAP) and data mining, enabling the analysis of data across multiple databases, tables, or files. The semantic data models provided by SSAS serve as a foundation for client applications such as Power BI, Excel, Reporting Services, and various data visualization tools.

In this instructor-led live training (available onsite or remotely), participants will learn how to utilize SSAS to analyze large volumes of data stored in databases and data warehouses.

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

• Install and configure SSAS
• Understand the relationship between SSAS, SSIS, and SSRS
• Apply multidimensional data modeling to extract business insights from data
• Design OLAP (Online Analytical Processing) cubes
• Query and manipulate multidimensional data using the MDX (Multidimensional Expressions) query language
• Deploy real-world BI solutions using SSAS

Audience

• BI (Business Intelligence) professionals
• Data Analysts
• Database and data warehousing professionals

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 the latest version of Microsoft SQL Server and SSAS.
• To request a customized training for this course, please contact us to arrange.