Database Training in Faro

This instructor-led, live training in Faro (online or onsite) is aimed at intermediate-level to advanced-level system administrators and IT professionals who wish to deepen their expertise in Oracle Linux 9 for system administration, performance tuning, security hardening, and automation.

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

• Manage and optimise Oracle Linux 9 for enterprise environments.
• Implement advanced networking and security configurations.
• Automate system administration tasks using scripting.
• Monitor and troubleshoot performance issues effectively.

This instructor-led, live training in Faro (online or onsite) is aimed at beginner-level to intermediate-level IT professionals and Linux users who wish to gain a solid understanding of Oracle Linux 9, from installation and configuration to system administration and security.

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

• Install and configure Oracle Linux 9.
• Manage users, groups, and permissions.
• Work with package management and system updates.
• Configure networking and storage solutions.
• Implement security best practices.
• Automate tasks using shell scripting.

This instructor-led, live training in Faro (online or onsite) is aimed at intermediate-level database administrators who wish to manage, optimize, and secure Data Guard environments for robust disaster recovery and high availability.

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

• Understand the architecture and benefits of Oracle Data Guard for disaster recovery and high availability.
• Gain hands-on experience in configuring and managing physical and logical standby databases, including Data Guard broker.
• Develop practical skills in monitoring, troubleshooting, and optimizing Data Guard environments for optimal performance.
• Learn advanced features such as Active Data Guard, Data Guard with RAC, and securing Data Guard communications.
• Apply best practices for disaster recovery planning, ensuring data consistency, and automating Data Guard operations.

This instructor-led course, centred on Faro, is tailored for intermediate specialists working with Oracle SOA Suite 12c. It covers the design, deployment, and monitoring of composite applications, service orchestration, and system integration using BPEL, Mediators, and adapters to establish robust enterprise solutions.

This instructor-led, live training in Faro (online or on-site) is targeted at intermediate-level billing and revenue managers who aim to effectively manage and optimize their billing and revenue operations using Oracle's powerful tools and features.

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

• Understand the fundamental principles of Oracle Communications Billing and Revenue Management (BRM).
• Learn how to configure and manage billing processes.
• Gain proficiency in using Oracle BRM for revenue management.
• Explore advanced features for optimizing billing and revenue operations.
• Develop skills in reporting and analytics for billing and revenue management.

This live, instructor-led training in Faro (online or on-site) is designed for entry-level customer service managers aiming to effectively oversee and optimize their service operations with Oracle’s advanced tools.

Upon completion, participants will be equipped to:

• Understand the essentials of Oracle Service Management.
• Learn to configure and handle service requests.
• Gain proficiency in using Oracle Service Cloud for service operations.
• Explore advanced features for service optimization.
• Develop skills in service management reporting and analytics.

This instructor-led, live training session in Faro (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 Faro (online or onsite) is tailored for beginner-level business and data analysts seeking to utilise Oracle BI to extract valuable insights from their data.

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

• Effectively navigate and utilise the Oracle BI interface.
• Develop and tailor reports and dashboards to meet specific business requirements.
• Perform ad-hoc analysis using a variety of BI tools.
• Leverage advanced features for in-depth data exploration.

This comprehensive 21-hour instructor-led training held in Faro focuses on the deployment and administration of Oracle Database Appliance X11. Through practical laboratory sessions, participants will master architecture, configuration, and optimization techniques, with a specific emphasis on managing storage, networking, and performance in enterprise-grade settings.

This instructor-led, live training in Faro (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 Faro (available online or in-person) is designed for intermediate software developers and automation engineers who aim 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 Faro (online or onsite) is designed for intermediate-level developers and IT professionals looking to master the new capabilities in APEX 23-24, design efficient workflows, and guarantee robust application security.

Upon completing this training, participants will be able to:

• Develop and manage APEX applications by utilising the latest features in versions 23-24.
• Design and implement efficient workflows within the APEX environment.
• Apply advanced security measures to safeguard APEX applications and data.
• Integrate APEX applications with external systems to ensure seamless data exchange.
• Test, debug, and deploy APEX applications in accordance with best practices.

This instructor-led, live training in Faro (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 Faro (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 Faro—delivered online or onsite—is designed for entry-level software developers and database administrators who aim to understand the basics of vector databases, covering their structure, operation, and applicable use cases.

By the end of the course, participants will be able to:

• Understand the concept and purpose of vector databases.
• Identify the differences between vector and traditional databases.
• Learn basic techniques for creating and managing vector data.
• Perform simple similarity searches.
• Understand the role of vector databases in AI applications.

This instructor-led, live training in Faro (online or onsite) is aimed at database admins and sysadmins who wish to use PostgreSQL to manage large-scale data while optimizing the database systems for high availability and performance.

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

• Install and configure PostgreSQL.
• Understand the features and architecture of PostgreSQL.
• Learn how to perform database operations with SQL.
• Perform database backup and recovery to prevent data loss.
• Configure the server for high availability.
• Learn the tools and techniques for high performance tuning.
• Explore the external tools for monitoring and observability.

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 Faro (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 programme is tailored to offer a comprehensive mastery of the advanced SQL syntax and methodologies available within Microsoft SQL Server. By acquiring proficiency in analytical functions, table joins, subqueries, and aggregation strategies, learners will gain the capability to shift data analysis workflows from MS Excel directly into the database layer. This transition not only enhances operational efficiency but also facilitates the construction of robust IT systems built upon Microsoft SQL Server.

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.

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.

redis

nosql