Database Training in Coimbra

This instructor-led, live training in Coimbra (online or onsite) is designed for beginner-level database administrators aiming to equip themselves with the necessary skills to manage and optimise their Oracle environments effectively.

Upon completing this training, participants will be capable of:

• Grasping the core features and architecture of Oracle Database 19c, encompassing system requirements and installation procedures.
• Acquiring practical expertise in installing Oracle Database 19c and Oracle Grid Infrastructure, including the configuration of network, storage, and security settings.
• Mastering the full upgrade process for Oracle Database 19c, ranging from pre-upgrade planning to post-upgrade validation.
• Developing troubleshooting capabilities to address common challenges encountered during installation and upgrade phases.
• Applying best practices for Oracle Database installation and upgrades to guarantee a seamless and successful deployment.

This instructor-led, live training in Coimbra (online or on-site) is designed for intermediate-level database administrators looking to manage and optimise complex, high-availability Oracle database environments.

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

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

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

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.

This instructor-led, live training in Coimbra (online or onsite) is aimed at beginner-level CRM managers who wish to effectively manage and optimize their customer relationship management processes using Oracle's powerful tools and features.

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

• Understand the fundamentals of Oracle Siebel CRM.
• Learn how to configure and manage Siebel applications.
• Gain proficiency in using Siebel tools for customer relationship management.
• Explore advanced features for optimizing CRM processes.
• Develop skills in reporting and analytics for Siebel CRM.

This instructor-led live training in Coimbra is designed to equip advanced DevOps professionals and database engineers with the skills to implement PostgresAI at enterprise scale. Through hands-on exercises in a live-lab environment, participants will gain mastery over database cloning, AI-driven query optimization, and advanced monitoring techniques.

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:

• 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.

This instructor-led, live training in Coimbra (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 Coimbra (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 instructor-led live training in Coimbra (online or onsite) is aimed at beginner-level data professionals who wish to learn how to design, implement, and manage SSIS packages to perform data integration and transformation tasks.

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

• Understand the architecture and components of SSIS.
• Design and implement ETL processes using SSIS.
• Use SSIS tools to develop, deploy, and manage data integration solutions.
• Troubleshoot and optimize SSIS packages for performance and reliability.

This instructor-led, live training in Coimbra (online or onsite) is designed for 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:

• Comprehend the key features and architectural changes in the Oracle database.
• Manage and monitor Oracle databases.
• Optimize Oracle database performance.

CockroachDB is an open-source distributed SQL database engineered for resilience and data locality. It serves as a replacement for proprietary global databases such as Google Spanner, while allowing organisations to retain full control over their infrastructure. This instructor-led live training (available online or onsite) is designed for advanced database engineers and architects who aim to utilise CockroachDB to replace proprietary global SQL databases.

This instructor-led, live training in Coimbra (online or onsite) targets database administrators and developers looking to migrate from proprietary databases to the open-source PostgreSQL platform.

By the end of this training, participants will be able to assess readiness for database migration, plan and execute schema migration strategies, migrate data using appropriate tools, and manage application code conversion.

This instructor-led live training, conducted Coimbra (either online or onsite), is designed for developers and system administrators who intend to utilize Hazelcast for processing distributed data structures and optimizing application performance.

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

• Install and configure Hazelcast to start creating and managing a cluster.
• Create a cluster for initiating automatic discovery of multiple processes.
• Set up Management Center for cluster connections and monitoring.
• Develop applications and deploy them through the Hazelcast cluster.

This course explores the foundational PostgreSQL server extensions designed to incorporate AI techniques into database environments, specifically highlighting similarity and semantic search through the use of embedding vectors. Learners will be guided through the processes of installing PgVector, creating and loading vector embeddings, building vector indexes, and implementing semantic search. The course utilizes practical demonstrations and hands-on activities to solidify key concepts and develop essential practical skills.

This practical course delves into the essential aspects of performance tuning in PostgreSQL. Learners will gain skills in analysing query execution, refining indexing strategies, tuning memory and system parameters, and effectively monitoring workloads. Through real-world case studies and live practical exercises, the course illustrates how to pinpoint and eliminate performance bottlenecks at both the database and system levels.