Database Training in Almada

Oracle Database 23ai represents the next generation of Oracle's database platform, delivering advanced AI integration, automation, and administration capabilities tailored for contemporary data demands.

This instructor-led live training (available online or onsite) is designed for intermediate Oracle administrators looking to explore and deploy the latest Oracle Database 23ai features to enhance performance, security, and AI-driven functionality.

Upon completing this course, participants will be able to:

• Comprehend and assess the key new features introduced in Oracle 23ai.
• Configure AI Vector Search and integrate AI workloads effectively.
• Utilise enhanced automation, observability, and performance optimisation tools.
• Plan version upgrades and implement new 23ai capabilities within production environments.

Course Format

• Interactive lectures and discussions.
• Hands-on experience with Oracle 23ai features in test environments.
• Guided labs focusing on implementation and migration planning.

Customisation Options

• To arrange customised training tailored to your Oracle infrastructure, please contact us.

This instructor-led, live training in Almada (online or on-site) is designed for advanced system administrators aiming to enhance their proficiency in system management, troubleshooting, and performance tuning.

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

• Configure and manage advanced user and group settings, including the implementation of user quotas and system-wide user environments.
• Use security auditing tools and configure sudo for controlled administrative access.
• Monitor and optimize system performance.
• Configure, analyze, and troubleshoot system logs.
• Develop and implement backup and recovery solutions.

Oracle Linux Virtualization Manager serves as a robust platform for managing and orchestrating virtualized server environments.

This instructor-led training session, available either online or onsite, is designed for intermediate-level professionals seeking to master Oracle Linux Virtualization Manager in preparation for the OLVMCA certification exam.

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

• Install and configure Oracle Linux Virtualization Manager.
• Deploy and manage virtual machines and hosts.
• Configure networking, storage domains, and resource management settings.
• Prepare effectively for the OLVMCA certification examination.

Course Format

• Instructor explanations supported by practical demonstrations.
• Hands-on exercises that reinforce key configuration tasks.
• Real-lab scenarios for deploying and managing virtualized environments.

Course Customization Options

• For tailored content or organization-specific customization, please contact us to arrange a customized session.

This instructor-led, live training in Almada (online or on-site) is aimed at intermediate-level database administrators who wish to effectively manage and optimise a multitenant environment.

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

• Understand the key components and benefits of Oracle Database 19c's multitenant architecture, including CDBs and PDBs.
• Gain practical skills in installing, configuring, and managing container databases (CDBs) and pluggable databases (PDBs).
• Develop proficiency in implementing security measures, backup and recovery strategies, and performance tuning in a multitenant environment.
• Learn how to manage high availability and disaster recovery in a multitenant architecture, including configuring Data Guard and Oracle RAC.
• Acquire troubleshooting techniques and best practices for maintaining a secure, efficient, and reliable multitenant database environment.

This instructor-led live training in Almada (online or onsite) is targeted at intermediate-level database administrators seeking an in-depth understanding of Oracle Database 19c PL/SQL programming and advanced SQL techniques.

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

• Understand the fundamentals and advanced features of PL/SQL.
• Develop advanced SQL queries to retrieve and manipulate data efficiently.
• Implement PL/SQL programming constructs to manage data and database operations.
• Optimise SQL queries for better performance.
• Use advanced PL/SQL features like collections, bulk processing, and error handling.
• Learn to debug and manage PL/SQL programs effectively.

This instructor-led, live training in Almada (online or onsite) is designed for intermediate-level developers and DevOps engineers who wish to instrument their applications to export and monitor custom metrics efficiently using Prometheus and Grafana.

Upon completing this training, participants will be able to:

• Grasp the significance of custom metrics for application monitoring.
• Instrument applications to export custom metrics for Prometheus.
• Build and configure Grafana dashboards to visualise custom metrics.
• Implement best practices for embedding monitoring within the development lifecycle.

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

This instructor-led, live training in Almada (online or onsite) is aimed at beginner-level system administrators and DevOps engineers who wish to develop core monitoring skills using Grafana and Prometheus.

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

• Understand the purpose and importance of monitoring in IT environments.
• Install and configure Grafana and Prometheus for basic monitoring tasks.
• Create simple dashboards and alerts to visualize system performance.
• Apply best practices for monitoring system availability and performance.

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 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 intermediate-level database administrators, SQL developers, and data analysts who wish to enhance their SQL skills by mastering the use of Analytic Functions.

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

• Understand the concept and importance of Analytic Functions.
• Apply various Analytic Functions to solve complex analytical problems.
• Combine Analytic Functions with other SQL features for comprehensive data analysis.
• Optimize queries for better performance using Analytic Functions.

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

Teradata is a highly scalable database platform, designed to manage large data volumes and facilitate efficient complex data analysis.

This instructor-led live training (in-person or remote) is aimed at data analysts, SQL developers, database administrators, and business intelligence professionals who wish to learn Teradata from an introductory to advanced level. The course combines theory with practical exercises to master data querying, management, optimisation, and administration in Teradata environments, enabling participants to work confidently on real-world analytics and big data processing projects.

Upon completing this training, participants will be able to:

• Understand Teradata's distributed architecture and parallel execution model.
• Write optimised SQL queries from basic level to advanced analytical functions.
• Design and execute large-scale data loading and transformation processes.
• Diagnose and improve query performance using tools such as EXPLAIN and statistics.
• Manage permissions, resources, and security in a shared environment.

Course Format

• Interactive presentations and conceptual explanations
• Practical exercises based on real-life cases
• Integration and optimisation labs
• Use of official tools such as Teradata Studio or BTEQ for live demonstrations

Customisation Options

To request custom training for this course, please contact us to arrange it.

This two-day course provides an introduction to SQL Developer, SQL*Plus, and SQL (Structured Query Language), the language used to access relational databases. It also covers the new features of the latest ORACLE version. The principles learned can be applied to various databases, such as Microsoft SQL Server, MySQL, Access, Informix, and DB2.

The course is delivered as a workshop, combining lectures, working examples, and practical exercises. Although the content can be customized, at least two days are required to cover the core elements.

Full course notes are provided, along with sample database files, example SQL files, and free software tools for accessing an ORACLE database.

This instructor-led live training (available online or on-site) is designed for administrators seeking to address complex deployment and management challenges using MongoDB Ops Manager.

Upon completion, participants will be equipped to:

• Install and configure MongoDB Ops Manager
• Establish and manage diverse environment types
• Understand and apply MongoDB Enterprise Server-specific solutions to tackle intricate enterprise hurdles

Course Format

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

Customization Options

• This training relies on MongoDB Enterprise Server, which includes Ops Manager. Please contact us to discuss licensing requirements.
• For tailored training requests, please reach out to us for arrangement.

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.

CockroachDB is an open-source distributed SQL database built for resilience and data locality. It offers a viable alternative to proprietary global databases like Google Spanner, enabling full infrastructure autonomy. This instructor-led, live training (online or on-site) is designed for advanced database engineers and architects looking to leverage CockroachDB to replace vendor-locked global SQL solutions.

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.

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 course delivers comprehensive coverage of replication, high availability, and cluster management within PostgreSQL. Participants will learn to construct and administer multi-node environments, set up automated failover mechanisms, and investigate solutions for load balancing and connection pooling. The curriculum features live replication laboratories and recovery simulations.

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.

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

Developing efficient SQL queries for Microsoft SQL Server forms the bedrock of every enterprise data pipeline. This course explores core techniques, beginning with relational database models, and advancing through data retrieval, filtering, sorting, and aggregation using grouping functions and subqueries. It guides participants through multi-table joins, set operators, DML operations, and transaction control to reliably extract and manipulate business intelligence datasets.

This training course provides an introduction to the Teradata relational database management system and its parallel architecture designed for large-scale data warehousing. It covers core concepts such as installation, architecture, SQL basics, and advanced topics, empowering data engineers with the knowledge needed for enterprise data warehouse design, relational modeling, and distributed query processing for business intelligence applications.

Target Audience

This workshop is designed for advanced programmers and Oracle users who wish to acquire in-depth knowledge on efficiently developing information systems within an Oracle database, as well as tuning and resolving performance issues in existing applications. The course leverages insights gathered over many years of practical experience by the instructors, often addressing gaps or inaccuracies found in standard technical documentation. This workshop can serve as the culmination of a developer's training path or as a critical step for professionals with extensive experience in Oracle design and programming.

Training Objectives

The primary aim of this workshop is to explain the internal mechanisms of an Oracle database when executing SQL statements. It enables participants to prevent errors during software development and to effectively explore, diagnose, and resolve performance problems in current applications.

Particular emphasis is placed on the practical methodology and hands-on aspects of applying and tuning SQL statements.

Training Content

• Mechanics of executing SQL commands
• Managing the cost-based optimization process
• Data storage methods and indexing strategies
• Monitoring database performance and processes using system dictionaries and application tracking
• Case analysis of the most common problems causing performance issues

Notes

The workshops utilize software version 11g XE.