Database Training in Lisbon

Oracle Database Security incorporates detective controls designed to monitor, log, and issue alerts for potentially unauthorized or malicious activity, thereby ensuring compliance, visibility, and accelerated incident response.

This instructor-led, live training (available online or onsite) is targeted at intermediate-level Oracle DBAs and security professionals aiming to configure and monitor auditing, logging, and activity detection capabilities within Oracle environments.

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

• Enable and tailor Oracle auditing tools to meet compliance and monitoring requirements.
• Configure Oracle Unified Audit, Fine-Grained Auditing (FGA), and audit policies.
• Deploy Oracle Audit Vault and Database Firewall for centralized monitoring.
• Detect and analyze suspicious behavior and potential threats.

Course Format

• Interactive lectures and discussions.
• Hands-on practice with Oracle auditing and monitoring features.
• Guided exercises focusing on audit design, policy enforcement, and alerting.

Course Customization Options

• For customized training based on your organization's audit policies, please contact us to arrange a session.

Oracle Database Security comprises a collection of technologies and best practices aimed at preventing unauthorized access, ensuring compliance, and safeguarding sensitive data within Oracle environments.

This instructor-led, live training (available online or onsite) targets intermediate-level Oracle administrators and security professionals seeking to implement preventive controls to protect Oracle databases from both internal and external threats.

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

• Apply mechanisms for authentication, authorization, and privilege management.
• Harden Oracle installations in accordance with industry-standard practices.
• Configure data masking, encryption, and database firewall options.
• Implement policies for access control and regulatory compliance.

Format of the Course

• Interactive lectures and discussions.
• Practical experience with Oracle security tools and configurations.
• Guided exercises focused on enforcing security policies and managing access control.

Course Customization Options

• To request customized training tailored to your security policies and Oracle deployment, please contact us to arrange.

This instructor-led, live training in Lisbon (online or onsite) is designed for beginner-level database administrators aiming to equip themselves with the necessary skills to manage and optimise their Oracle environments effectively.

Upon completing this training, participants will be capable of:

• Grasping the core features and architecture of Oracle Database 19c, encompassing system requirements and installation procedures.
• Acquiring practical expertise in installing Oracle Database 19c and Oracle Grid Infrastructure, including the configuration of network, storage, and security settings.
• Mastering the full upgrade process for Oracle Database 19c, ranging from pre-upgrade planning to post-upgrade validation.
• Developing troubleshooting capabilities to address common challenges encountered during installation and upgrade phases.
• Applying best practices for Oracle Database installation and upgrades to guarantee a seamless and successful deployment.

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 Lisbon (online or onsite) is aimed at intermediate-level database administrators who wish to manage, optimize, and secure Data Guard environments for robust disaster recovery and high availability.

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

• Understand the architecture and benefits of Oracle Data Guard for disaster recovery and high availability.
• Gain hands-on experience in configuring and managing physical and logical standby databases, including Data Guard broker.
• Develop practical skills in monitoring, troubleshooting, and optimizing Data Guard environments for optimal performance.
• Learn advanced features such as Active Data Guard, Data Guard with RAC, and securing Data Guard communications.
• Apply best practices for disaster recovery planning, ensuring data consistency, and automating Data Guard operations.

This instructor-led, live training in Lisbon (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 Lisbon (online or onsite) is designed for intermediate-level database administrators who aim to utilize Oracle Enterprise Manager to its full potential, ensuring efficient and effective management of their enterprise IT environments.

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

• Gain a thorough understanding of Oracle Enterprise Manager (OEM) architecture.
• Learn the steps for installing and configuring OEM to ensure a properly set-up environment for monitoring and management.
• Master the skills to add, configure, and manage different targets and target groups within OEM to organize and streamline management tasks.

Oracle Database 19c serves as a multi-model database, offering comprehensive support for both relational and non-relational data formats.

This instructor-led live training, available either online or on-site, is designed for system and database administrators with intermediate proficiency. The course equips participants with the skills to administer, monitor, secure, back up, and recover Oracle Database 19c within Standard Edition 2 environments, while also guiding them in planning a structured migration path from version 11g to 19c.

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

• Setting up the necessary environment and executing clean installations and configurations of Oracle Database 19c SE2.
• Describing key Oracle infrastructure components, such as the SGA, PGA, Shared Pool, Database Buffer Cache, and Redo mechanisms.
• Utilising administration tools like Enterprise Manager (EM Express) and SQL Developer for routine operational tasks.
• Applying storage management best practices for tablespaces, datafiles, and segment space allocation.
• Enhancing database security and maintaining hardened configurations through user management, roles, privileges, profiles, and auditing.
• Designing and implementing RMAN-based backup and recovery strategies that align with defined RTO and RPO objectives.
• Monitoring system performance and troubleshooting issues using dynamic performance views, SQL tracing, and execution plans.
• Planning and executing the transition from version 11g to 19c using approved upgrade paths and tools.

Course Format

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

Course Customisation Options

• For those interested in a bespoke training solution for this course, please contact us to discuss arrangements.

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

This instructor-led, live training session in Lisbon (online or onsite) is designed for intermediate-level database administrators seeking to boost the performance and efficiency of Oracle Database systems, particularly those operating in environments that utilize Oracle Database Appliances.

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

• Comprehending the architecture and key components of the Oracle Database Appliance HA X8-X9r.
• Identifying and addressing performance bottlenecks.
• Acquiring hands-on expertise in SQL and instance tuning.
• Effectively leveraging Oracle's performance analysis tools.
• Applying industry best practices for database tuning and optimization.

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 training, available in Lisbon (online or onsite), is designed for intermediate-level maintenance personnel aiming to streamline their processes using Oracle Cloud ERP Fusion.

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

• Grasping the core functionalities of Oracle Maintenance Cloud.
• Deploying corrective, preventive, and predictive maintenance strategies.
• Efficiently handling maintenance requests, work orders, and scheduling.
• Leveraging analytics to enhance maintenance performance and drive improvements.

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

MongoDB for Advanced Practitioners empowers seasoned developers with expert-level NoSQL strategies to construct high-performance, scalable applications. The curriculum covers fundamental principles of sophisticated data manipulation, CRUD optimization, indexing mechanics, and aggregation pipelines. It explores practical methodologies for replication, sharding, performance profiling, and enterprise-grade security. Participants will learn to deploy robust MongoDB clusters, integrating automated backup solutions and monitoring systems for production-ready environments.

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.

This instructor-led, live training in Lisbon (online or onsite) is aimed at database admins and sysadmins who wish to use PostgreSQL to manage large-scale data while optimizing the database systems for high availability and performance.

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

• Install and configure PostgreSQL.
• Understand the features and architecture of PostgreSQL.
• Learn how to perform database operations with SQL.
• Perform database backup and recovery to prevent data loss.
• Configure the server for high availability.
• Learn the tools and techniques for high performance tuning.
• Explore the external tools for monitoring and observability.

This instructor-led, live training in Lisbon (online or onsite) is designed for system administrators who wish to learn how to administer, monitor, and support an Oracle database.

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

• Comprehend the key features and architectural changes in the Oracle database.
• Manage and monitor Oracle databases.
• Optimize Oracle database performance.

This course is tailored for system administrators, developers, and database professionals.

Training Objectives:

• Gain and reinforce the skills necessary to create and manage databases
• Understand SQL syntax and apply it to retrieve and modify data
• Implement security protocols within the database environment
• Utilize advanced features such as replication, automation, and Business Intelligence (BI)
• Leverage Microsoft SQL Server capabilities to develop complex reports and solutions for developers

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

In this instructor-led, live training session in Lisbon, participants will learn how to install, configure, and manage MariaDB to achieve high availability and performance. The curriculum also covers backup and recovery, security, and clustering.

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.

Oracle Linux Administration provides comprehensive training on deploying, configuring, and managing Oracle Linux in enterprise environments.

This instructor-led live training is aimed at system administrators, infrastructure engineers, and DevOps professionals.

By the end of the course, participants will be able to:

• Install, administer, and secure Oracle Linux in production
• Manage storage, networking, packages, and services effectively
• Apply SELinux security, automate tasks, and perform recovery

Available in Lisbon.

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.