Online Database Training in Portugal

This instructor-led, live training in Portugal (online or onsite) is aimed at beginner-level database administrators who wish to ensure that they are well-prepared to manage and optimize their Oracle environments.

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

• Understand the key features and architecture of Oracle Database 19c, including system requirements and installation methods.
• Gain practical skills in installing Oracle Database 19c and Oracle Grid Infrastructure, including configuring the network, storage, and security settings.
• Learn the complete process of upgrading to Oracle Database 19c, from pre-upgrade planning to post-upgrade validation.
• Develop troubleshooting skills to handle common issues during installation and upgrade.
• Apply best practices for Oracle Database installation and upgrade to ensure a smooth and successful deployment.

This instructor-led, live training in Portugal (online or onsite) is aimed at intermediate-level developers who wish to use Oracle Visual Builder Studio to create and manage visual applications effectively.

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

• Create and design visual applications using Oracle Visual Builder Studio.
• Utilize pages, components, and flows to build user interfaces.
• Implement data binding and integrate with various data sources.
• Deploy applications to Oracle Cloud and manage environments.

This instructor-led, live training in Portugal (online or onsite) is aimed at advanced-level DevOps engineers and SREs who wish to manage and scale Prometheus and Grafana for large environments effectively.

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

• Architect Prometheus and Grafana for large-scale and distributed environments.
• Optimize Prometheus performance for high-traffic systems.
• Configure Grafana for large datasets and complex visualizations.
• Implement advanced troubleshooting and scalability strategies.

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.

Oracle Database 19c is a robust platform for building and managing enterprise data warehouses that support analytical workloads.

This instructor-led, live training (online or onsite) is aimed at beginner-level data professionals and analysts who wish to understand the foundational concepts and architecture of Oracle-based data warehouse systems.

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

• Understand key concepts and architecture of Oracle data warehousing.
• Describe typical data warehouse components like fact and dimension tables.
• Recognize use cases and benefits of Oracle data warehousing in business intelligence.
• Prepare for deeper training in Oracle ETL, performance, and warehouse optimization techniques.

Format of the Course

• Interactive lecture and discussion.
• Hands-on use of Oracle SQL and warehouse schema exploration.
• Guided conceptual exercises and warehouse design analysis.

Course Customization Options

• To request a customized training for this course based on your internal data models or analytics goals, 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.

SQL Tuning in Oracle Database 19c is the process of improving SQL performance through analysis, statistics, and optimization techniques.

This instructor-led, live training (online or onsite) is aimed at intermediate-level Oracle professionals who wish to understand and apply SQL tuning techniques for Oracle Database 19c to improve query execution and database efficiency.

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

• Interpret execution plans and identify performance bottlenecks.
• Apply Oracle tuning tools such as AWR, ADDM, and SQL Tuning Advisor.
• Use indexes, hints, and statistics to optimize queries.
• Diagnose and resolve inefficient SQL statements in real-world environments.

Format of the Course

• Interactive lecture and discussion.
• Hands-on use of Oracle tuning tools and SQL queries.
• Guided exercises focused on real tuning scenarios and performance analysis.

Course Customization Options

• To request a customized training for this course based on your system or business queries, please contact us to arrange.

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 advanced-level developers who wish to learn and use MySQL and database technologies for building web applications.

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

• Write SQL queries to retrieve, filter, sort, and aggregate data.
• Perform data manipulation operations such as inserting, updating, and deleting data.
• Implement advanced SQL concepts such as subqueries, derived tables, and conditional logic.
• Integrate MySQL with popular programming languages and execute queries from application code.

This instructor-led, live training in Portugal (online or onsite) is aimed at system administrators who wish to have a comprehensive understanding of the security features of Oracle Database 19c.

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

• Understand the concepts of database security.
• Implement authentication and authorization mechanisms to control access to the database.
• Configure and manage user accounts, roles, and privileges effectively.
• Implement robust security measures against various threats and vulnerabilities.

This course covers everything a database administrator needs to know to successfully deploy and maintain MongoDB databases.

Diagnosing performance issues, importing and exporting data, and establishing the proper backup and restore routines, overview of the MongoDB CRUD API, the command shell, and the drivers are also covered.

The audience of this course include people who want to:

• Understand MongoDB from a developer's perspective, including its command shell, query API, and driver tools.
• Deploy MongoDB in all its configurations - as a single server, with master/slave replication, as a replica set, and as a sharded cluster.
• Evaluate applications and choose hardware appropriately.
• Monitor MongoDB instances and integrate with standard monitoring software (Munin, Nagios, etc.)
• Plan for backups and manage large data imports and exports.
• Troubleshoot the most common developer issues and failure scenarios.

Each delegate will need to perform a series of practical exercises.

This course handles the administration and performance tuning of PostgreSQL databases. Attendees will learn the use of specialised PostgreSQL (AKA Postgres) modules such as replication, connection pooling and full text searching.

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.

Listeners

This course is designed for people who want to use the advanced features of SQL in Oracle

The course answers the questions

• How to build advanced queries?
• How to create advanced reports?

The course participants will learn the terminology of relational databases, acquire the skills to design database applications, know the basic principles of creating forms and reports.

The Microsoft Access course is an intensive learning of using the database engine, focusing on practical skills. Master table design, creating queries, relationships between them, and effective collaboration with Excel. The course also covers creating forms, reports and automating work using macros.

This course will introduce Cassandra –  a popular NoSQL database.  It will cover Cassandra principles, architecture and data model.   Students will learn data modeling  in CQL (Cassandra Query Language) in hands-on, interactive labs.  This session also discusses Cassandra internals and some admin topics.

Audience : Developers

This course will introduce Cassandra –  a popular NoSQL database.  It will cover Cassandra principles, architecture and data model.   Students will learn data modeling  in CQL (Cassandra Query Language) in hands-on, interactive labs.  This session also discusses Cassandra internals and some admin topics.

Duration : 3 days

Audience : Developers

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 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 database administrators and developers who wish to use Hasura to build, access, and manage databases and applications efficiently with GraphQL.

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

• Set up the necessary development environment to start building databases with Hasura.
• Build, run, manage data access and queries on Hasura using GraphQL models.
• Secure data access by setting up authentication with JSON Web Tokens and Firebase.
• Extend database functions by integrating business logic.
• Manage database migrations and metadata effectively on Hasura to prevent data loss.

Audience

*KDB+/Q developer

Format of the course

50% lectures, 40% labs, 10% tests

MariaDB Administration training course is for anyone who wants to administrate the MariaDB database server. It is a comprehensive course covering all administrator duties.

The course explains how MariaDB Database works, what tools are available, how we can use them, how we can secure the MariaDB Database Server and configure it. During the training course you will learn how to manage user accounts and how the MariaDB Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and perform crash recovery.

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.

This bespoke course has been designed specifically against the requirements provided by Now Managed Learning Services

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.

The course answers questions

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