Online Database Training in Portugal

This instructor-led, live training in Portugal (online or onsite) is aimed at intermediate-level database administrators who wish to manage and optimize complex, high-availability Oracle database environments.

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

• Gain a comprehensive understanding of Oracle RAC architecture and Grid Infrastructure, including installation, configuration, and management.
• Develop practical skills in managing Automatic Storage Management (ASM), including disk group management, instance tuning, and backup/recovery.
• Learn advanced RAC performance tuning techniques, disaster recovery configurations, and best practices for high availability.
• Acquire troubleshooting and diagnostic skills for resolving issues in RAC and Grid Infrastructure environments.
• Understand the process of patching and upgrading Oracle RAC and Grid Infrastructure while minimizing downtime and maintaining system stability.

This instructor-led, live training in Portugal (online or onsite) is aimed at intermediate-level billing and revenue managers who wish to effectively manage and optimize their billing and revenue operations using Oracle's powerful tools and features.

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

• Understand the fundamentals 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 Portugal (online or onsite) is aimed at beginner-level customer service managers who wish to effectively manage and optimize their customer service operations using Oracle's powerful tools and features.

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

• Understand the fundamentals of Oracle Service Management.
• Learn how to configure and manage service requests.
• Gain proficiency in using Oracle Service Cloud for customer service operations.
• Explore advanced features for optimizing service delivery.
• Develop skills in reporting and analytics for service management.

This instructor-led, live training in Portugal (online or onsite) is aimed at advanced-level DevOps and SRE professionals who wish to enhance their alerting and automation skills with Grafana and Prometheus.

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

• Create and manage advanced alerting rules in Prometheus.
• Integrate Prometheus Alertmanager with external tools using webhooks.
• Automate responses to alerts for faster issue resolution.
• Use Grafana to visualize and manage alerts effectively.

This instructor-led, live training in Portugal (online or onsite) is aimed at intermediate-level maintenance personnel who wish to streamline their maintenance processes using Oracle Cloud ERP Fusion.

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

• Understand the core functionalities of the Oracle Maintenance Cloud.
• Implement corrective, preventive, and predictive maintenance strategies.
• Manage maintenance requests, work orders, and schedules efficiently.
• Utilize analytics for maintenance performance and improvement.

This instructor-led, live training in Portugal (online or onsite) is aimed at intermediate-level DevOps and SRE professionals who wish to create impactful dashboards and optimize their monitoring practices using Grafana and Prometheus.

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

• Understand best practices for designing effective dashboards.
• Create and configure advanced Grafana dashboard elements.
• Leverage Grafana templating for dynamic and reusable dashboards.
• Implement alerting mechanisms to enhance operational awareness.

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

• Understand the Spine-Leaf network topology and its benefits.
• Implement VXLAN for scalable and efficient database networking.
• Optimize database workloads across distributed data center environments.
• Deploy Spine-Leaf architecture in cloud and on-premises data centers.
• Enhance 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 Portugal (online or onsite) is aimed at intermediate-level to advanced-level database administrators who wish to deepen their knowledge of SQL Server for efficient database management, performance tuning, high availability, and advanced troubleshooting.

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

• Administer and configure SQL Server instances using best practices.
• Optimize performance of queries and databases.
• Implement high availability and disaster recovery strategies.
• Diagnose and resolve complex issues in production environments.A

Greenplum is an open-source massively parallel data platform based on PostgreSQL, designed for advanced analytics and large-scale data warehousing.

This instructor-led, live training (online or onsite) is aimed at intermediate-level administrators who wish to install, configure, and manage Greenplum environments effectively, including managing system updates and libraries.

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

• Install and configure a production-ready Greenplum cluster.
• Manage system updates and apply patches safely.
• 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 Portugal (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 Portugal (online or onsite) is aimed at intermediate-level developers and IT professionals who wish to learn how to leverage new features in APEX 23-24, design efficient workflows, and ensure application security.

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

• Develop and manage APEX applications using the latest features in versions 23-24.
• Design and implement efficient workflows within APEX.
• Apply advanced security measures to protect APEX applications and data.
• Integrate APEX applications with external systems and ensure smooth data exchange.
• Test, debug, and deploy APEX applications following best practices.

This instructor-led, live training in Portugal (online or onsite) is aimed at intermediate-level IT professionals who wish to learn how to design, implement, and manage relational databases, and how to query and manipulate data using SQL.

By the end 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 optimize and maintain databases.

This instructor-led, live training in (online or onsite) is aimed at 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.

After the training, you will be able to write extract and modify the data in MongoDB database. You will also learn about powerful Aggregation Pipeline that is a flexible and fast tool for data analytics, and if it's not enough for you, how to connect your current BI tools like Tableau or Excel to data stored in Mongo.

This course provides programmatic interaction with PostgreSQL databases. Learn techniques, syntaxes and structures needed to develop quality applications using PostgreSQL backend. This training also covers SQL Tuning covering best practices for writing efficient SQL.

Target audience includes developers who want to use or extend PostgreSQL, as well as database architects.

This training is designed for Database Administrators and Architects who want to learn Streaming Replication in PostgreSQL and how pgpool-II can be used to achieve automatic failovers and setup a highly available PostgreSQL Database Cluster.

Este curso de formação em SQL destina-se a indivíduos que desejam adquirir as competências necessárias para extrair e analisar dados de qualquer base de dados e criar relatórios. Os participantes irão aprender:

• a redigir consultas SQL
• o que são bases de dados relacionais e como utilizá-las
• o conceito de relações e como as criar
• a estrutura dos dados
• as diferenças entre os dialetos SQL (Oracle, T-SQL, ANSI)
• habilidades práticas para redigir consultas

Este curso de SQL aborda o SQL genérico ANSI. Pode ser aplicado em qualquer base de dados, incluindo Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix e PostgreSQL, entre outras bases de dados relacionais.

Audience: Any IT professionals who aspire to become DBAs or database support professionals on MySql Database on linx/windows platforms.

Format: 40% theoretical/lectures, 60%Practical/hands on lab

This course introduces the basics of Cassandra including its installation & configuration, internal architecture, tools, Cassandra Query Language, and administration.

Audience

Administrators and developers seeking to use Cassandra. This course serves as a foundation and prerequisite for other advanced Cassandra courses.

Audience

• Programmers
• Beginner IT professionals

Format of the course

    Part lecture, part discussion, heavy hands-on practice

This course is divided into 3 main sections and is made up of a mixture of presentations and practical exercises.

1. VB.NET Language in Visual Studio 2012
2. VB.NET Object Orientation
3. VB.NET and Sql Server 2012

This instructor-led, live training in Portugal (online or onsite) will teach how to configure and run flyway to build a migration pipeline in SQL. Database-specific syntax such as PL/SQL and T-SQL are supported, as well as Java (for advanced data transformations or for dealing with LOBs). Practical scenarios will help to understand real-world usages.

In this instructor-led, live training in Portugal, participants will learn the fundamentals of GraphQL as they step through the creation of a simple API with GraphQL.

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

• Understand what GraphQL is and what distinguishes it from REST.
• Understand top-level GraphQL terms.
• Set up a GraphQL coding environment.
• Build and improve a GraphQL API.

This instructor-led, live training in Portugal (online or onsite) is aimed at administrators who wish to set up Greenplum Database for business intelligence and data warehousing solutions.

By the end 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 Portugal (online or onsite) is aimed at system administrators, database administrators, data architects, and developers who wish to install, configure, and manage MarkLogic Server to optimize 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.

MongoDB Atlas is a multi-cloud database-as-a-service (DBaaS) platform. It simplifies the setup, operation, and management of MongoDB deployments in the cloud.

This instructor-led, live training in Portugal (online or onsite) is aimed at developers and sysadmins who wish to use MongoDB Atlas to run, deploy, and manage databases at scale through automation and simplified configurations.

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

• Set up, configure, and access the MongoDB Atlas cluster.
• Understand the features, architecture, and advantages of MongoDB Atlas.
• Learn how to import/export, query, and manipulate data in MongoDB Atlas.
• Use Atlas APIs to automate database operations and administration.
• Apply the best practices in managing and scaling MongoDB deployments.

This instructor-led, live training in Portugal (online or onsite) is aimed at IT administrators and developers who wish to set up, deploy and manage cloud applications using the services and technologies provided by Oracle PaaS.

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

• Build, deploy, and manage cloud applications using Oracle PaaS.
• Configure and use data management tools for easy storage and backup.
• Visualize and evaluate application performance and logs.
• Generate business analytics reports.
• Understand and implement security standards.

This instructor-led, live training in Portugal (onsite or remote) is aimed at developers who wish to use GraphQL and Relay to manage data on React applications.

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

• Set up the necessary development environment to start data control for React applications.
• Deliver instant UI-response interactions.
• Aggregate data from multiple libraries into one convenient API.
• Pre-fetch using GraphQL and Relay.

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

In this instructor-led, live training in Portugal, 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.