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.

This instructor-led, live training in Lisbon (online or onsite) is aimed at advanced-level system administrators who wish to learn advanced system administration tasks, security configurations, network management, automation, and performance tuning for enterprise environments.

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

• Master advanced package management techniques, including creating custom repositories, resolving dependencies, and managing RPM packages with GPG keys.
• Implement and manage advanced filesystems and storage solutions using LVM, encryption, snapshots, and high-performance filesystems like XFS, Btrfs, and ZFS.
• Configure and manage advanced network services such as NIC bonding/teaming, VPNs, and secure remote administration tools.
• Configure high-availability clusters using Pacemaker and Corosync, including setting up failover services and monitoring cluster health.
• Manage virtualization environments with Oracle Linux Virtualization Manager (OLVM), and containers using Docker and Podman for container orchestration.

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 Lisbon (online or onsite) is designed for intermediate-level DevOps and SRE professionals aiming to create impactful dashboards and optimize their monitoring practices using Grafana and Prometheus.

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

• Grasping best practices for designing effective dashboards.
• Creating and configuring advanced Grafana dashboard components.
• Utilizing Grafana templating to produce dynamic and reusable dashboards.
• Implementing alerting mechanisms to boost operational awareness.

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.

This instructor-led live training in Lisbon (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 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 instructor-led live training, available online or onsite, targets developers who wish to use the FARM (FastAPI, React, and MongoDB) stack to build dynamic, high-performance, and scalable web applications.

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

• Set up the necessary development environment that integrates FastAPI, React, and MongoDB.
• Understand the key concepts, features, and benefits of the FARM stack.
• Learn how to build REST APIs with FastAPI.
• Learn how to design interactive applications with React.
• Develop, test, and deploy applications (front end and back end) using the FARM stack.

This SQL training course is designed for individuals seeking to acquire the essential skills required to extract and analyse data using Microsoft Access. Participants will learn:

• how to write SQL queries
• the concept of relational databases and their practical application
• the nature of relations and how to establish them
• the fundamental structure of data
• the distinctions between SQL dialects (Oracle, T-SQL, ANSI)
• practical techniques for composing queries

This SQL course specifically addresses the SQL dialect used in Microsoft Access.

This SQL training course is designed for individuals seeking to acquire the essential skills required to extract, analyse, and report data from any database. Participants will master:

• writing SQL queries
• the concept of relational databases and their practical applications
• the nature of relations and methods for creating them
• data structure fundamentals
• distinctions between T-SQL and other SQL dialects
• hands-on techniques for constructing queries

This course focuses on the Microsoft T-SQL dialect. For those interested in generic SQL, we recommend our SQL Fundamentals course.

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.

This instructor-led, live training in Lisbon (online or onsite) is aimed at system administrators who wish to learn how to use and manage an Oracle Linux 8 system.

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

• Configure passwordless authentication.
• Administer user and group accounts.
• Configure network interfaces.
• Monitor and troubleshoot Oracle Linux.

Participants will gain the skills to design databases and tailor them for effective end-user interaction.

This course provides an introduction to Cassandra, a widely used NoSQL database. Participants will explore 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 delves into Cassandra internals and key administrative topics.

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.

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

Redis is an open-source (BSD-licensed), in-memory data structure store that functions as a database, cache, and message broker.

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

Scylla is an open-source, distributed NoSQL data store designed to be compatible with Apache Cassandra, while delivering significantly higher throughput and lower latency.

In this course, participants will explore Scylla’s features and architecture, gaining practical experience in setting up, administering, monitoring, and troubleshooting Scylla.

Audience

• Database administrators
• Developers
• System Engineers

Course Format

• The course is interactive, covering the principles and approaches for deploying and managing Scylla distributed databases and clusters.
• A significant portion of the course is dedicated to hands-on exercises and practical application.

Microsoft SQL Server serves as a robust relational database management system (RDBMS) designed for efficient data storage and retrieval.

Through this instructor-led live training, available either onsite or remotely, attendees will acquire the fundamental SQL skills necessary to effectively query Microsoft SQL Server databases.

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

• Install and configure Microsoft SQL Server
• Execute queries on a Microsoft SQL Server database using the Transact-SQL (T-SQL) language
• Grasp the core principles of database design
• Enhance database performance through normalization
• Utilize aggregate functions to generate results comparable to those produced by pivot tables
• Connect to Microsoft SQL Server directly from Excel

Target Audience

• Data analysts
• Business Intelligence specialists
• Business managers
• Excel specialists looking to broaden their analytical capabilities

Course Structure

• Interactive lectures and group discussions
• Extensive practical exercises and hands-on practice
• Live implementation within a lab environment

Customization Options

• This training utilizes the most recent version of Microsoft SQL Server
• For inquiries regarding customized training arrangements, please contact us directly.