Database Training in Almada

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.

This instructor-led, live training in Almada (online or onsite) is tailored for beginner-level business and data analysts seeking to utilise Oracle BI to extract valuable insights from their data.

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

• Effectively navigate and utilise the Oracle BI interface.
• Develop and tailor reports and dashboards to meet specific business requirements.
• Perform ad-hoc analysis using a variety of BI tools.
• Leverage advanced features for in-depth data exploration.

PostgreSQL is a robust, open-source relational database that can be augmented with AI capabilities to support enterprise data intelligence, predictive analytics, and automation.

This instructor-led, live training (available online or onsite) is designed for intermediate to advanced data engineers, DBAs, and solution architects looking to design, implement, and govern enterprise-grade AI systems leveraging PostgreSQL.

By completing this program, participants will gain the expertise to:

• Integrate AI models and vector search capabilities directly into PostgreSQL.
• Deploy AI-optimized architectures for high-volume enterprise workloads.
• Implement robust governance, auditing, and compliance for AI data pipelines.
• Securely leverage open source and proprietary AI frameworks within PostgreSQL environments.

Format of the Course

• Interactive lectures and enterprise case discussions.
• Practical exercises and real-world labs.
• Hands-on implementation in a live PostgreSQL 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.

This instructor-led, live training in Almada (online or onsite) is aimed at beginner-level to intermediate-level data scientists and software developers who wish to learn about Milvus and its practical applications in various AI scenarios.

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

• Understand the architecture and features of Milvus.
• Implement vector databases in different AI applications.
• Perform similarity searches with high accuracy and speed.
• Apply Milvus to real-world AI challenges.

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 Almada (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 Almada (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 Almada (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.

Oracle APEX (Application Express) is a low-code development platform designed for rapidly creating scalable and secure enterprise applications with minimal coding effort.

This instructor-led live training, available both online and onsite, is tailored for intermediate-level developers and IT professionals looking to build secure, scalable enterprise applications using Oracle APEX while minimising hand-coding.

Upon completing this training, participants will be able to:

• Design and construct data-driven applications using APEX.
• Leverage built-in components to speed up the development process.
• Deploy, evaluate, and certify applications efficiently.
• Manage user authentication and application security.

Course Format

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

Course Customisation Options

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

This instructor-led live training in Almada (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 Almada (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 Almada (online or onsite) is designed for data scientists and developers who wish to utilise and integrate SQL, Python, and Tableau to perform complex data analysis, processing, and visualisation.

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

• Configure the required environment to perform data analysis using SQL, Python, and Tableau.
• Grasp the core concepts of software integration, including data, servers, clients, APIs, and endpoints.
• Review the fundamental principles of Python and SQL.
• Apply data pre-processing techniques within Python.
• Establish connections between Python and SQL for effective data analysis.
• Produce insightful data visualisations and charts using Tableau.

This three-day course provides an introduction to Oracle PL/SQL, an application development environment that facilitates the creation of stored procedures, functions, and triggers using both SQL and PL/SQL commands.

The course is structured as a workshop, combining lectures, practical examples, and hands-on exercises. While the content can be customised to meet specific needs, a minimum of two days is required to cover the core elements.

Participants will receive comprehensive course notes, sample database files, example SQL scripts, and access to free software tools for interacting with Oracle databases.

This course is designed to deliver a thorough comprehension of advanced SQL techniques and Transact-SQL applications within the context of Microsoft SQL Server. To ensure comprehensive coverage of the subject matter, the training can be delivered as a three-day programme.

Participants in this course will master the terminology of relational databases, develop the ability to design database applications, and understand the fundamental principles behind creating forms and reports.

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 Almada (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 Almada (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 Almada (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 Almada (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 Almada (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 course provides an introduction to HBase, a NoSQL database built on top of Hadoop. It is designed for developers who intend to build applications using HBase, as well as administrators responsible for managing HBase clusters.

We will guide developers through HBase architecture, data modelling, and application development on the platform. The course also covers the integration of MapReduce with HBase and addresses key administration topics related to performance optimization. This is a highly practical course featuring numerous lab exercises.

Duration: 3 days

Audience: Developers & Administrators

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

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

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 practical course emphasises the hands-on approach to performance tuning within PostgreSQL. Participants will gain the skills to analyse query execution, refine indexing strategies, tweak memory and system settings, and effectively monitor workloads. Through real-world scenarios and live exercises, learners will discover how to pinpoint and resolve bottlenecks at both the database and system levels.

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

This live, instructor-led training in Almada (online or onsite) is aimed at beginners, programmers, and database administrators who wish to learn or improve their SQL development skills and knowledge.

By the end of this training, participants will be able to install, create, manage, manipulate, and monitor databases using SQL and database management systems.