Database Training in Setúbal

This instructor-led, live training in Setúbal (online or onsite) is aimed at beginner-level to intermediate-level IT professionals and Linux users who wish to gain a solid understanding of Oracle Linux 9, from installation and configuration to system administration and security.

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

• Install and configure Oracle Linux 9.
• Manage users, groups, and permissions.
• Work with package management and system updates.
• Configure networking and storage solutions.
• Implement security best practices.
• Automate tasks using shell scripting.

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

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.

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

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.

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 Setúbal (online or onsite) is aimed at beginner-level professionals who wish to learn how to use PostgreSQL for creating databases, writing SQL queries, manipulating data, and managing tables using both SQL commands and PGAdmin. The course also provides a basic introduction to the Timescale extension for time-series data.

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

• Understand relational database principles and PostgreSQL architecture.
• Install, configure, and navigate PostgreSQL and PGAdmin.
• Write and run SQL queries for data selection, filtering, grouping, and joining.
• Manipulate data with SQL statements and manage database objects.
• Create and manage views and explore PostgreSQL extensions like Timescale.

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

SQL Server Integration Services (SSIS) is a core component of Microsoft SQL Server, providing a robust platform for data integration and workflow applications. It is widely utilized for data migration, data warehousing, and transformation tasks.

This instructor-led live training, available either online or onsite, is designed for intermediate-level data professionals and developers aiming to master the design of advanced SSIS data flows and transformations, as well as the management of Slowly Changing Dimensions (SCD) within data warehousing contexts.

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

• Design and implement resilient data flows using SSIS.
• Interact with diverse data sources, destinations, and transformation components.
• Apply Slowly Changing Dimensions (SCD) to manage historical data changes effectively.
• Deploy, execute, and troubleshoot SSIS packages with efficiency.

Course Format

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

Course Customization Options

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

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 programme provides comprehensive guidance for database administrators on the effective deployment and maintenance of MongoDB environments.

Key topics include diagnosing performance bottlenecks, managing data imports and exports, establishing robust backup and restoration procedures, and an overview of the MongoDB CRUD API, command-line shell, and associated drivers.

The target audience comprises individuals seeking to:

• Gain a developer-centric understanding of MongoDB, including its command shell, query API, and driver utilities.
• Deploy MongoDB across various configurations, such as single servers, master-slave replication, replica sets, and sharded clusters.
• Evaluate application requirements and select appropriate hardware.
• Monitor MongoDB instances and integrate them with standard monitoring solutions (e.g., Munin, Nagios).
• Plan for backups and manage large-scale data imports and exports.
• Troubleshoot frequent developer-related issues and failure scenarios.

Participants will engage in a series of hands-on practical exercises.

In this instructor-led, live training in Setúbal (onsite or remote), participants will explore the general and advanced aspects of PostgreSQL, including administration, performance tuning, advanced development, and replication as they step through a series of hands-on, live-lab exercises involving setup, configuration, testing, deployment and troubleshooting.

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

• Use advanced administration techniques to configure and manage a PostgreSQL server.
• Optimize the database and queries for maximum performance.
• Replicate and scale a PostgreSQL server.

• How to build a query?
• What is a relational database?
• What is the structure and SQL commands?

This instructor-led live training in Setúbal (online or onsite) is designed for database administrators and cloud architects who wish to migrate Oracle databases to Azure SQL or PostgreSQL.

Upon completing this training, participants will be able to:

• Evaluate Azure SQL against PostgreSQL to select the database system that best aligns with business goals and requirements.
• Prepare databases to transfer definitions, data, and procedures from Oracle to either the AzureSQL or PostgreSQL database system.
• Execute post-migration tasks to test, optimize, update, and maintain the migrated database.

This course covers the essentials of Cassandra, including its installation and configuration, internal architecture, tools, Cassandra Query Language, and administration.

Target Audience

Administrators and developers looking to work with Cassandra. This course serves as a foundational prerequisite for more advanced Cassandra training.

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

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

The course addresses the following questions

How to construct a query?

What capabilities does SQL offer?

What constitutes a relational database?

What is the structure and the SQL commands?