Database Training in Portugal

This instructor-led, live training in Portugal (online or onsite) is aimed at intermediate-level cloud and DevOps engineers who wish to enhance cloud observability with Grafana and Prometheus.

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

• Understand the benefits of integrating Grafana and Prometheus with cloud platforms.
• Set up Prometheus for monitoring cloud-based resources.
• Configure Grafana for visualizing cloud service metrics.
• Leverage cloud-native tools and integrations for monitoring scalability.

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.

Database is a structured system for storing, managing, and retrieving data efficiently. This course introduces participants to the principles of database systems, with a focus on relational database models, data normalization, and SQL-based querying.

This instructor-led, live training (online or onsite) is aimed at intermediate-level IT professionals who wish to understand database management concepts, with a focus on relational database models, and gain practical skills in working with databases.

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

• Understand database concepts and relational database models.
• Design simple data models and understand normalization.
• Use basic SQL queries to retrieve, insert, and update data.
• Understand key concepts in database administration and security.

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.

This instructor-led, live training in Portugal (online or onsite) is aimed at beginner-level system administrators and DevOps engineers who wish to develop core monitoring skills using Grafana and Prometheus.

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

• Understand the purpose and importance of monitoring in IT environments.
• Install and configure Grafana and Prometheus for basic monitoring tasks.
• Create simple dashboards and alerts to visualize system performance.
• Apply best practices for monitoring system availability and performance.

SQL Server is Microsoft’s enterprise-level relational database management system designed to store, manage, and retrieve data efficiently.

This instructor-led, live training (online or onsite) is aimed at intermediate-level IT professionals who wish to administer, configure, and maintain SQL Server environments.

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

• Install and configure SQL Server environments.
• Manage databases, users, and permissions.
• Monitor performance and troubleshoot issues.
• Automate tasks using jobs and maintenance plans.

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.

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 beginner-level to intermediate-level data analysts, database professionals, and software developers who wish to learn SQL to manage databases effectively.

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

• Understand and use fundamental SQL commands and queries.
• Create and manipulate tables and databases.
• Use SQL to sort, filter, and summarize data.
• Implement more complex operations like joins, subqueries, and set operations.
• Apply intermediate techniques such as indexes, views, stored procedures, and triggers.

PL/SQL (Procedural Language/SQL) is Oracle’s extension to SQL that enables developers to write procedural logic directly inside the database.

This instructor-led, live training (online or onsite) is aimed at intermediate-level developers and technical professionals who wish to write robust PL/SQL programs, manage exceptions, and create reusable procedures, functions, and packages in Oracle Database.

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

• Create PL/SQL blocks, procedures, and functions to encapsulate business logic.
• Use control structures, cursors, and exception handling effectively.
• Define and manage packages, triggers, and stored logic securely.
• Debug and test PL/SQL code using standard Oracle tools.

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.

This instructor-led, live training in Portugal (online or onsite) is aimed at intermediate-level software developers and automation engineers who wish to build applications that communicate with PLCs and interact with SQL databases using Visual Studio.

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

• Develop .NET applications in Visual Studio for industrial automation.
• Communicate with PLCs using industrial protocols such as OPC UA.
• Implement database interactions with SQL Server for storing and retrieving PLC data.
• Optimize application performance for real-time industrial environments.

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 Portugal (online or onsite) is aimed at intermediate-level developers and administrators who wish to have a solid PL/SQL programming foundation to develop efficient and robust database applications using Oracle 19c.

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

• Gain a comprehensive understanding of what PL/SQL is 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.

Teradata is a highly scalable database platform designed to manage large volumes of data and enable complex analytics efficiently.

This instructor-led, live training (online or onsite) is aimed at beginner-level to advanced-level data professionals who wish to learn how to query, manage, optimize, and administer data within Teradata environments through theory and hands-on practice.

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

• Understand the distributed architecture and parallel execution model of Teradata.
• Write optimized SQL queries from basic selection to advanced analytics.
• Design and execute large-scale data loading and transformation processes.
• Diagnose and improve query performance using tools like EXPLAIN and statistics.
• Manage permissions, resources, and shared environment best practices.

Format of the Course

• Interactive presentations and conceptual explanations.
• Practical exercises based on real-world scenarios.
• Integration and optimization labs using official tools like Teradata Studio or BTEQ.

Course Customization Options

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

This training is designed for Database Administrators and Architects who want to learn the tools and techniques for implementing Backups, High Availability and Database Security in PostgreSQL.
You will also learn how to find slow queries, monitor database performance and tune PostgreSQL for Performance.

The aim of this course is to provide a clear understanding of the advanced use of (SQL) for Microsoft SQL Server and the advanced use of Transact-SQL. For more in depth coverage of the topics this course can be run as a three day course.

This instructor-led, live training in Portugal (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 interface.
• Monitor and troubleshoot Oracle Linux.

This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn:

• how to write SQL queries
• what relational databases are and how we can use them
• what are relations and how to create them
• the structure of data
• differences between SQL dialects (Oracle, T-SQL, ANSI)
• practical skills for writing queries

This SQL course deals with generic ANSI SQL. It can be used in any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL any other relational databases.

Audience

• Programmers
• Beginner IT professionals

Format of the course

    Part lecture, part discussion, heavy hands-on practice

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

This instructor-led, live training in Portugal (online or onsite) is aimed at engineers who wish to enable applications to continuously monitor and stream all commits made to their database.

• Install and configure ZooKeeper, Kafka, and the Debezium connector service.
• Set up applications to automatically consume and respond to database inserts, updates, and deletes.
• Turn database row-level changes into event streams that applications can respond to immediately.
• Stream each row-level change in the same order that it was committed to the database.

This instructor-led, live training (online or onsite) is aimed at developers who wish to use Firebase to build powerful data-driven mobile or web application. 

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

• Understand the Firebase Web Platform
• Understand how to simplify a database by using Firebase data modeling
• Develop powerful applications that can process real-time data without the need to define detailed database structures.
• Transact data on Firebase
• Perform realtime data synchronization
• Authenticate users with Firebase
• Monitor users

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.
• To learn more about Firebase, please visit: https://firebase.google.com/

This instructor-led, live training in Portugal (online or onsite) is aimed at database administrators who wish to install, set up, and manage Flyway and its capabilities to perform database migrations.
    
By the end of this training, participants will be able to clean up, migrate, validate, repair, and monitor databases using Flyway.

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.

Audience

*KDB+/Q developer

Format of the course

50% lectures, 40% labs, 10% tests

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.

In this instructor-led, live training in Portugal, participants will learn how to build React applications using Flux and GraphQL. The course covers installation, setup, integration, testing, deployment and best practices as it walks participants through the creation of a series of sample applications that demonstrate how to add additional levels of complexity and "coolness" to an application using the most advanced toolkits and techniques.

Developing applications with React requires a different kind of thinking, compared to what some developers are accustomed to, especially when coming from the mindset of other MVC frameworks such as AngularJS and Bootstrap.
This training covers the fundamentals behind of the technologies used each step of the way so that participants are not only able to build a functional application, but also understand why a particular approach is used. This lays the groundwork for thinking independently and creatively about the design and the desired results for building their own applications in the future.

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.

This instructor-led, live training in Portugal (online or onsite) is aimed at developers who wish to use SQLite to develop embedded applications for various devices, such as desktops, mobile phones, Android TV, cameras, etc.

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

• Install and configure SQLite on any platform.
• Understand the features and architecture of SQLite.
• Learn how to execute common SQL operations in SQLite.
• Learn how to manipulate data and tables in SQLite.
• Understand the various SQLite data types, tools, and functions.
• Perform calculations with SQLite aggregate functions.

Microsoft SQL Server is a relational database management system (RDBMS) for storing and retrieving data.

In this instructor-led, live training (onsite or remote), participants will learn the essentials of the SQL language needed to query a Microsoft SQL Server database.

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

• Install and configure Microsoft SQL Server
• Query a Microsoft SQL Server database using Microsoft's Transact-SQL (T-SQL) language
• Understand the essentials of database design
• Optimize a database through normalization
• Use aggregate functions to generate results similar to those of "pivot-tables"
• Access Microsoft SQL Server through Excel

Audience

• Data analysts
• Business Intelligence professionals
• Business managers
• Excel experts who wish to expand their analysis skill set

Format of the Course

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

Course Customization Options

• This training is based on the latest version of Microsoft SQL Server
• To request a customized training for this course, please contact us to arrange.

redis

nosql