Database Training in Gaia

Oracle Linux 9 provides robust tools and features for constructing secure, scalable, and highly available environments. This advanced-level course centres on enterprise system design, security hardening, networked services, kernel tuning, and automation via Ansible.

This instructor-led, live training (available online or onsite) is designed for advanced Linux professionals seeking to deepen their expertise in deploying and maintaining mission-critical Oracle Linux 9 infrastructure.

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

• Deploy and manage high-availability services using clustering tools.
• Configure secure network services and enforce system-wide hardening.
• Automate infrastructure using Ansible playbooks.
• Tune system performance for specific workloads and services.

Course Format

• Interactive lectures and discussions.
• Extensive exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

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

This instructor-led, live training in Gaia (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 Gaia (online or onsite) is designed for intermediate-level database administrators and IT professionals seeking to acquire practical expertise in installing, configuring, securing, and maintaining Oracle Database 23ai.

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

• Install and configure Oracle Database 23ai.
• Manage database storage, users, and security settings.
• Optimise database performance using AI-driven automation.
• Implement backup and recovery strategies.
• Monitor and troubleshoot database performance issues.

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

Greenplum is an open-source massively parallel data platform built on PostgreSQL, designed for advanced analytics and large-scale data warehousing.

This instructor-led live training (available online or onsite) is designed for intermediate-level administrators who want to effectively install, configure, and manage Greenplum environments, including handling system updates and libraries.

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

• Install and configure a production-ready Greenplum cluster.
• Manage system updates and safely apply patches.
• 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 Gaia (online or onsite) is designed for intermediate-level DevOps and SRE professionals aiming to create impactful dashboards and optimize their monitoring practices using Grafana and Prometheus.

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

• Grasping best practices for designing effective dashboards.
• Creating and configuring advanced Grafana dashboard components.
• Utilizing Grafana templating to produce dynamic and reusable dashboards.
• Implementing alerting mechanisms to boost operational awareness.

A database constitutes a structured system designed for the efficient storage, management, and retrieval of data. This course introduces participants to the foundational principles of database systems, placing particular emphasis on relational database models, data normalization techniques, and SQL-based querying methods.

This instructor-led live training, available either online or onsite, is tailored for intermediate-level IT professionals seeking to grasp database management concepts, with a specific focus on relational database models, while acquiring practical skills in database operations.

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

• Comprehending database concepts and relational database models.
• Designing simple data models and understanding normalization principles.
• Utilizing fundamental SQL queries to retrieve, insert, and update data.
• Grasping key concepts related to database administration and security.

Course Format

• Interactive lectures and discussions.
• Extensive exercises and practice sessions.
• Hands-on implementation within a live-lab environment.

Course Customization Options

• To request customized training for this course, please contact us to make arrangements.

Oracle Database 19c serves as a robust platform for constructing high-performance data warehouses tailored to business intelligence and analytics workloads.

This instructor-led training, available online or onsite, targets intermediate Oracle professionals looking to implement and refine data warehousing solutions using Oracle Database 19c.

Upon completion, participants will be equipped to:

• Design and deploy data warehouse schemas, including star and snowflake structures.
• Utilize Oracle partitioning and compression techniques for managing large datasets.
• Enhance ETL processes and optimize query performance for analytical tasks.
• Exploit Oracle capabilities for both real-time and historical reporting.

Course Format

• Engaging lectures and group discussions.
• Practical application of Oracle Data Warehouse features within sample scenarios.
• Guided exercises centred on data modeling, ETL, and performance tuning.

Customization Options

• For tailored training aligned with your organization's specific data models or reporting requirements, please contact us to arrange a session.

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

Oracle Database 23ai represents the most recent long-term release, prioritising developer productivity and integrating built-in AI capabilities. Key enhancements include AI Vector Search, advancements in JSON and relational duality, support for async and pipelining drivers, SQL and PL/SQL improvements, and novel operational features designed to support modern application development and AI-driven workloads.

This instructor-led live training, available either online or onsite, is tailored for developers with intermediate-level skills. It aims to equip participants with the knowledge to utilise the new 23ai features in real-world development scenarios, thereby achieving a basic to intermediate competency level.

Upon completing this training, participants will be able to:

• Articulate the principal developer-focused features introduced in Oracle Database 23ai and determine appropriate use cases.
• Implement AI Vector Search and new JSON/relational capabilities within sample applications.
• Utilise async and pipelining driver functionalities to optimise client-server workflows and enhance throughput.
• Apply practical methods for testing, debugging, and deploying application code based on 23ai within development environments.

Course Format

• Interactive lectures combined with targeted demonstrations.
• Practical hands-on labs utilising Oracle Database 23ai Free and essential developer tools.
• Guided exercises featuring sample Java/Quarkus and front-end examples.

Course Customisation Options

• For a bespoke version of this course—such as focusing on specific language stacks, deepening PL/SQL content, or adding extra labs—please contact us to make arrangements.

This instructor-led live training in Gaia (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 Gaia (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 Gaia (online or onsite) targets intermediate-level developers and administrators looking to capitalize on the new features and improvements introduced in PostgreSQL 16.

By the conclusion of this training, participants will be capable of:

• Comprehending the architecture and components of PostgreSQL 16.
• Utilizing advanced SQL functionalities and PostgreSQL extensions.
• Implementing security best practices and managing access controls.
• Carrying out database administration duties, including backup, recovery, and monitoring.
• Optimizing database performance via tuning and indexing methods.
• Employing PostgreSQL's native tools for high availability and replication.
• Integrating PostgreSQL with modern application development frameworks.

Upon completing this training, you will gain the ability to extract and modify data within a MongoDB database. You will also explore the powerful Aggregation Pipeline, a flexible and high-performance tool for data analytics. Furthermore, you will learn how to connect your existing BI tools, such as Tableau or Excel, to data stored in MongoDB.

This training course equips participants with the skills required for Web Application Development using Python, specifically focusing on Data Analytics. It highlights how effective data visualization serves as a powerful decision-making tool for senior management.

This instructor-led, live training in Gaia (online or on-site) is tailored for web developers interested in leveraging the MERN Stack for fullstack development.

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

• Integrating React with MongoDB, Express, and Node.js.
• Constructing a fullstack web application from the ground up.
• Ensuring application security via authorization and authentication mechanisms.

This instructor-led, live training in Gaia (available online or onsite) is designed for system administrators and developers who want to leverage Prometheus to monitor Kubernetes clusters.

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

• Install and configure Prometheus.
• Monitor dynamic cloud environments.
• Gain deeper insights into their Kubernetes clusters.
• Set up precise and insightful alerts.

This instructor-led live training in Gaia (available online or onsite) is tailored for intermediate-level database professionals who wish to enhance their skills in Oracle SQL development and administration.

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

• Build and optimize complex SQL queries.
• Manage databases efficiently using Oracle SQL tools.
• Apply best practices in database development and maintenance.
• Administer user access and database security in an Oracle environment.

This SQL training programme is designed for individuals seeking to acquire the essential skills to extract, analyse, and report on data from any database. Participants will learn:

• how to write SQL queries
• what relational databases are and how to utilise them
• the concept of relations and how to establish them
• the structure of data
• differences between SQL dialects (Oracle, T-SQL, ANSI)
• practical skills for writing queries

This SQL course focuses on generic ANSI SQL, making it applicable to any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL, and other relational databases.

This extensive training program empowers participants with the essential theoretical knowledge and hands-on expertise needed to construct, oversee, and analyze business intelligence (BI) solutions using contemporary Microsoft technologies. The curriculum concentrates on SQL Server (2017/2019/2022 features) and Azure Analysis Services (AAS), addressing the full data analytics lifecycle from data acquisition to visualization.

Attendees will acquire skills to design and implement modern data warehousing solutions, establish robust ETL/ELT pipelines utilizing SQL Server Integration Services (SSIS), develop sophisticated analytical models via SQL Server Analysis Services (SSAS - Tabular) and Azure Analysis Services, and produce insightful reports and visualizations. There is a strong emphasis on exploiting in-memory technologies, cloud integration, and contemporary query languages.

Target Audience

• Programmers
• IT professionals at the beginner level

Course Format

   A blend of lectures, discussions, and extensive hands-on practice

This instructor-led, live training in Gaia (online or onsite) is aimed at database administrators and developers who wish to migrate from proprietary databases to open source PostgreSQL.

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

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

This instructor-led, live training in Gaia (online or onsite) is designed for engineers who wish to configure applications to continuously monitor and stream all database commits.

• Install and configure ZooKeeper, Kafka, and the Debezium connector service.
• Configure applications to automatically consume and react to database inserts, updates, and deletions.
• Transform database row-level changes into event streams that applications can process in real-time.
• Ensure that each row-level change is streamed in the exact order it was committed to the database.

This instructor-led, live training in Gaia (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 live, instructor-led training in Gaia (online or on-site) will teach you how to configure and run Flyway to build a SQL migration pipeline. It supports database-specific syntax like PL/SQL and T-SQL, as well as Java (for advanced data transformations or handling LOBs). Practical scenarios will be used to demonstrate real-world usage.

This instructor-led live training in Gaia (online or onsite) is targeted at administrators who aim to set up Greenplum Database for business intelligence and data warehousing solutions.

By the conclusion 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 Gaia (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.

This instructor-led, live training in Gaia (online or onsite) is aimed at system administrators, database administrators, data architects, and developers who wish to install, configure, and manage MarkLogic Server to optimise 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 instructor-led, live training in Gaia (online or onsite) is designed for IT administrators and developers who wish to set up, deploy, and manage cloud applications using the services and technologies provided by Oracle PaaS.

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

• Build, deploy, and manage cloud applications using Oracle PaaS.
• Configure and use data management tools for easy storage and backup.
• Visualize and evaluate application performance and logs.
• Generate business analytics reports.
• Understand and implement security standards.

During this instructor-led live training conducted in Gaia, 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.