Database Training in Portugal

This instructor-led, live training in Portugal (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 Portugal (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 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.
• Optimise Prometheus performance for high-traffic systems.
• Configure Grafana for large datasets and complex visualisations.
• Implement advanced troubleshooting and scalability strategies.

This instructor-led, live training session in Portugal (online or onsite) is designed for intermediate-level database administrators seeking to boost the performance and efficiency of Oracle Database systems, particularly those operating in environments that utilize Oracle Database Appliances.

Upon completion of this training, participants will be capable of:

• Comprehending the architecture and key components of the Oracle Database Appliance HA X8-X9r.
• Identifying and addressing performance bottlenecks.
• Acquiring hands-on expertise in SQL and instance tuning.
• Effectively leveraging Oracle's performance analysis tools.
• Applying industry best practices for database tuning and optimization.

This instructor-led, live training in Portugal (online or onsite) is aimed at intermediate-level database administrators who wish to learn the necessary skills and knowledge to effectively manage and administer SQL Server databases using SQL Server Management Studio.

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

• Understand system requirements and perform installations.
• Create, configure, and manage databases using SSMS.
• Manage logins, users, roles, and permissions.
• Perform various types of backups and restore databases.
• Create, schedule, and manage jobs using SQL Server Agent.
• Implement best practices for efficient and secure SQL Server administration.

This 21-hour instructor-led course in Portugal equips data engineers and DBAs with the skills to integrate AI models into PostgreSQL. Participants will learn to deploy optimized architectures, implement vector search, and enforce strict governance, ensuring secure and high-performance enterprise-grade AI solutions.

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:

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

Designed to equip you with the core competencies for installing, configuring, and overseeing PostgreSQL databases, this module focuses on essential operational tasks. You will gain proficiency in implementing user security protocols, executing backup and recovery procedures, overseeing system logs, and optimising fundamental parameters. By engaging in hands-on scenarios, you will execute realistic administrative duties while building a strong foundation for advanced subjects such as performance tuning and replication strategies.

This instructor-led, live training in Portugal (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 Portugal (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 in Portugal (online or onsite) is targeted at developers seeking to use Oracle APEX to develop, scale, and deploy applications faster with less code.

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

• Set up the necessary development environment to start developing database apps with Oracle APEX.
• Understand and explore the Oracle APEX tools to build a fully-featured application.
• Learn how to create applications and pages using Oracle APEX and the Page Designer UI.
• Extend the functionality of complex enterprise apps easily with Oracle APEX.
• Optimize and scale application performance and deployment.
• Control and secure access to application data and components.

This intensive one-day, hands-on workshop is dedicated to the design and implementation of distributed database solutions using the Citus extension for PostgreSQL. Learners will gain practical insights into sharding large datasets, managing distributed queries, and constructing scalable, fault-tolerant PostgreSQL clusters. Through real-world scenarios and practical labs, the course illustrates techniques for performance tuning, integrating replication, and managing distributed workloads.