Database Training in Setúbal

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 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 Setúbal (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.

Oracle GoldenGate 19c is an enterprise-grade data replication and real-time integration solution that enables low-latency change data capture (CDC), transformation, and delivery across heterogeneous database environments.

This instructor-led, live training (online or onsite) is aimed at intermediate-level to advanced-level database administrators and replication engineers who wish to install, configure, operate, and troubleshoot Oracle GoldenGate 19c for reliable real-time data integration and high-availability architectures.

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

• Install and configure Oracle GoldenGate 19c components and topologies.
• Design and implement change data capture (CDC) and delivery processes for heterogeneous systems.
• Manage GoldenGate Microservices, deployment architectures, and secure communications.
• Monitor, tune, and troubleshoot GoldenGate replication performance and latency issues.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

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

Power BI serves as a business intelligence platform enabling users to connect with data sources, transform and analyse data, and generate interactive reports and dashboards. Oracle Database, a widely adopted enterprise database solution, integrates seamlessly with Power BI to facilitate corporate reporting.

This instructor-led live training, available either online or onsite, is designed for intermediate-level data professionals seeking to link Oracle databases with Power BI to design, analyse, and present actionable insights tailored to corporate requirements.

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

• Connect Power BI to Oracle databases and other data sources.
• Execute data cleansing, consolidation, and transformation.
• Utilise Power Query and Pivot for ETL processes.
• Apply DAX and M formulas for data modelling and analysis.
• Design professional reports and executive presentations within Power BI.
• Leverage advisory support to meet corporate reporting requirements.

Format of the Course

• Instructor-led lectures and discussions.
• Hands-on labs involving Power BI and Oracle.
• Practical exercises addressing real-world reporting needs.
• Advisory support sessions.

Course Customization Options

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

This instructor-led live training in Setúbal (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 Setúbal (online or on-site) is targeted at intermediate-level billing and revenue managers who aim to effectively manage and optimize their billing and revenue operations using Oracle's powerful tools and features.

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

• Understand the fundamental principles of Oracle Communications Billing and Revenue Management (BRM).
• Learn how to configure and manage billing processes.
• Gain proficiency in using Oracle BRM for revenue management.
• Explore advanced features for optimizing billing and revenue operations.
• Develop skills in reporting and analytics for billing and revenue management.

This instructor-led, live training in Setúbal (online or onsite) is aimed at intermediate-level database administrators who wish to learn the necessary skills and knowledge to effectively manage and administer SQL Server databases using SQL Server Management Studio.

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

• Understand system requirements and perform installations.
• Create, configure, and manage databases using SSMS.
• Manage logins, users, roles, and permissions.
• Perform various types of backups and restore databases.
• Create, schedule, and manage jobs using SQL Server Agent.
• Implement best practices for efficient and secure SQL Server administration.

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 Setúbal (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 Setúbal (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 Setúbal (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 Setúbal (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. 

This instructor-led, live training in Setúbal (online or onsite) targets intermediate-level developers and administrators who aim to establish a solid PL/SQL programming foundation for developing efficient and robust database applications using Oracle 19c.

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

• Gain a comprehensive understanding of PL/SQL and its advantages over standard SQL.
• Learn how to declare and use variables and different data types within PL/SQL blocks.
• Apply control structures like IF-THEN-ELSE, CASE statements, and loops to create robust PL/SQL programs.
• Understand and implement explicit and implicit cursors for data retrieval.
• Handle exceptions effectively using predefined and user-defined exceptions.
• Develop and manage triggers to automate and enforce business rules.
• Create and use PL/SQL packages to encapsulate and modularize code for reuse and maintainability.

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

This course provides comprehensive guidance on all the knowledge database developers require to effectively build applications with MongoDB.

Acquire advanced MongoDB expertise. Achieve mastery in document manipulation, efficient querying techniques, and data modeling. Discover how to use aggregation pipelines, indexing strategies, and schema design to construct scalable NoSQL applications.

This training is tailored for Database Administrators and Architects seeking to master PostgreSQL from the ground up.

Participants will gain insights into PostgreSQL architecture, installation procedures, database design, as well as the methods for performing backup and recovery operations within PostgreSQL.

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.

 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.

This course aims to provide a comprehensive understanding of SQL usage across various databases (such as Oracle, SQL Server, and MS Access). Gaining insight into analytic functions and techniques for joining different tables within a database will enable participants to shift data analysis operations to the database layer, rather than relying on MS Excel. This knowledge is also valuable for developing any IT system that utilizes relational databases.

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 Setúbal (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 instructor-led live training, conducted Setúbal (either online or onsite), is designed for developers and system administrators who intend to utilize Hazelcast for processing distributed data structures and optimizing application performance.

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

• Install and configure Hazelcast to start creating and managing a cluster.
• Create a cluster for initiating automatic discovery of multiple processes.
• Set up Management Center for cluster connections and monitoring.
• Develop applications and deploy them through the Hazelcast cluster.

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

redis

nosql