Database Training in Coimbra

Oracle Cloud Infrastructure (OCI) is Oracle’s next-generation cloud platform that provides scalable, secure, and high-performance services for enterprise workloads and cloud-native applications.

This instructor-led, live training (online or onsite) is aimed at intermediate-level to advanced-level cloud professionals who wish to design, implement, and manage enterprise-grade solutions on Oracle Cloud Infrastructure in preparation for the OCI Architect Professional certification.

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

• Design and deploy complex OCI architectures following Oracle best practices.
• Implement multi-region, multi-tier cloud solutions with high availability and disaster recovery.
• Secure OCI environments using IAM, encryption, and governance policies.
• Automate cloud resource provisioning using Terraform and the OCI CLI.
• Prepare for and pass the Oracle Cloud Infrastructure Architect Professional certification exam.

Format of the Course

• Interactive lecture and discussion.
• Hands-on labs and guided exercises.
• Practical design scenarios and architecture simulations.

Course Customization Options

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

This instructor-led, live training in Coimbra (online or onsite) is aimed at beginner-level database administrators who wish to manage backup and recovery tasks in Oracle Database 19c.

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

• Understand the essential concepts of backup and recovery in Oracle Database 19c, including the architecture and various types of failures.
• Gain hands-on experience in configuring backup and recovery settings, including the RMAN environment and fast recovery area.
• Develop practical skills in performing different types of backups and recovery operations, including full, incremental, and point-in-time recovery.
• Learn how to utilize Oracle's Flashback technology for effective database recovery and manage disaster recovery scenarios.
• Apply best practices for backup, recovery, and disaster recovery to ensure data availability and minimize downtime in Oracle Database 19c.

Power BI is a business intelligence tool that allows users to connect to data sources, transform and analyze data, and create interactive reports and dashboards. Oracle Database is a widely used enterprise database solution that integrates seamlessly with Power BI for corporate reporting.

This instructor-led, live training (online or onsite) is aimed at intermediate-level data professionals who wish to connect Oracle databases with Power BI to design, analyze, and present actionable insights for corporate needs.

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

• Connect Power BI to Oracle databases and other data sources.
• Perform data cleansing, consolidation, and transformation.
• Use Power Query and Pivot for ETL processes.
• Apply DAX and M formulas for data modeling and analysis.
• Design professional reports and executive presentations in Power BI.
• Leverage advisory support to address corporate reporting requirements.

Format of the Course

• Instructor-led lectures and discussions.
• Hands-on labs with Power BI and Oracle.
• Practical exercises for 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 Coimbra (online or onsite) is aimed at beginner-level developers and database administrators who wish to learn PL/SQL to automate database tasks, implement business logic, and develop robust database applications.

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

• Develop efficient PL/SQL programs to automate database operations and integrate SQL commands effectively.
• Create reusable program units, including procedures, functions, packages, and triggers, for modular and scalable applications.
• Implement advanced data structures like associative arrays and manage query results using cursors.
• Handle errors robustly and secure code with encryption, obfuscation, and conditional compilation techniques.
• Apply PL/SQL in real-world scenarios, leveraging built-in packages for file handling, email automation, and other advanced functionalities. 

Oracle Database 19c is a multi-model database that provides full support for relational and non-relational data.

This instructor-led, live training (online or onsite) is aimed at intermediate-level system administrators and database administrators who wish to administer, monitor, secure, back up, and recover Oracle Database 19c in Standard Edition 2 environments, and to plan a clear path from 11g to 19c.

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

• Prepare the environment and perform clean installations and configurations of Oracle Database 19c SE2.
• Explain Oracle infrastructure components including SGA, PGA, Shared Pool, Database Buffer Cache, and Redo mechanisms.
• Use administration tools such as Enterprise Manager (EM Express) and SQL Developer for daily operations.
• Implement storage management best practices for tablespaces, datafiles, and segment space usage.
• Harden databases and maintain security with users, roles, privileges, profiles, and auditing.
• Design and execute RMAN-based backup and recovery strategies aligned to RTO/RPO objectives.
• Monitor and troubleshoot performance using dynamic performance views, SQL tracing, and execution plans.
• Plan and execute transition/migration from 11g to 19c using supported upgrade paths and 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.

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 Coimbra (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.

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 Coimbra (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 Coimbra (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 Coimbra (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

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

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

Teradata is a highly scalable database platform designed to manage large volumes of data and facilitate efficient complex analysis.

This live, instructor-led training (on-site or remote) is aimed at data analysts, SQL developers, database administrators, and business intelligence professionals who want to learn Teradata from an introductory level to advanced. The course combines theory with practical exercises to master querying, managing, optimizing, and administering data in Teradata environments, enabling participants to confidently work on real-world data analysis and big data processing projects.

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

• Understand Teradata's distributed architecture and parallel execution model.
• Write optimized SQL queries from basic to advanced analytical functions.
• 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 security in a shared environment.

Course Format

• Interactive presentations and conceptual explanations
• Practical exercises based on real-world scenarios
• Integration and optimization labs
• Use of official tools like Teradata Studio or BTEQ for live demonstrations

Custom Course Options

To request a customized training for this course, please contact us to coordinate it.

This training is designed for Database Administrators and Architects who want to learn PostgreSQL from basics.

You will learn PostgreSQL architecture, installation, designing as well as how to perform backup and recovery databases in PostgreSQL.

This instructor-led, live training in Coimbra (online or onsite) is aimed at intermediate-level database administrators, developers, and analysts who wish to master advanced SQL functionalities for complex data operations and database management.

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

• Perform advanced querying techniques using unions, subqueries, and complex joins.
• Add, update, and delete data, tables, views, and indexes with precision.
• Ensure data integrity through transactions and manipulate database structures.
• Create and manage databases efficiently for robust data storage and retrieval.

This instructor-led, live training in Coimbra (online or onsite) is aimed at system administrators who wish to learn how to administer, monitor, and support an Oracle database.

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

• Understand the major feature and architectural changes Oracle database.
• Manage and monitor Oracle databases.
• Optimize Oracle database performance.

This instructor-led, live training in Coimbra (online or onsite) is aimed at sysadmins and developers who wish to use Cassandra 4.0 to create, build, and manage large-scale databases with high availability and less failures.

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

• Install and configure Apache Cassandra.
• Migrate from earlier versions to Cassandra 4.0.
• Learn more about the new features in Cassandra 4.0.
• Build, manage, and scale high-performing databases.
• Monitor table activities and optimize internode communications.
• Use zero copy streaming to quickly transfer data across a distributed database.

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

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

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

In this instructor-led, live training in Coimbra, participants will learn how to install, configure and manage MariaDB for high availability and performance. Other topics include backup and recovery, security and clustering.

This instructor-led, live training in Coimbra (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 Coimbra, 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 Coimbra (online or onsite) is aimed at beginners, programmers, and database administrators who wish to learn or improve their SQL development skills and knowledge.

By the end of this training, participants will be able to install, create, manage, manipulate, and monitor databases using SQL and database management systems.