Database Training in Gaia

This instructor-led, live training in Gaia (online or onsite) is aimed at intermediate-level database administrators and IT professionals who wish to gain 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.
• Optimize database performance using AI-driven automation.
• Implement backup and recovery strategies.
• Monitor and troubleshoot database performance issues.

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.

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 Gaia (online or onsite) is aimed at beginner-level to intermediate-level data scientists and software developers who wish to learn about Milvus and its practical applications in various AI scenarios.

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

• Understand the architecture and features of Milvus.
• Implement vector databases in different AI applications.
• Perform similarity searches with high accuracy and speed.
• Apply Milvus to real-world AI challenges.

Oracle Database 19c is a robust platform for building and managing enterprise data warehouses that support analytical workloads.

This instructor-led, live training (online or onsite) is aimed at beginner-level data professionals and analysts who wish to understand the foundational concepts and architecture of Oracle-based data warehouse systems.

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

• Understand key concepts and architecture of Oracle data warehousing.
• Describe typical data warehouse components like fact and dimension tables.
• Recognize use cases and benefits of Oracle data warehousing in business intelligence.
• Prepare for deeper training in Oracle ETL, performance, and warehouse optimization techniques.

Format of the Course

• Interactive lecture and discussion.
• Hands-on use of Oracle SQL and warehouse schema exploration.
• Guided conceptual exercises and warehouse design analysis.

Course Customization Options

• To request a customized training for this course based on your internal data models or analytics goals, please contact us to arrange.

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:

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

Oracle APEX (Application Express) is a low-code development platform that enables the rapid creation of scalable, secure enterprise apps using minimal code.

This instructor-led, live training (online or onsite) is aimed at intermediate-level developers and IT professionals who wish to build secure and scalable enterprise applications using Oracle APEX with minimal hand-coding.

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

• Design and build data-driven applications using APEX.
• Use built-in components to accelerate development.
• Deploy, evaluate, and certify applications efficiently.
• Manage user authentication and application 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.

SQL Tuning in Oracle Database 19c is the process of improving SQL performance through analysis, statistics, and optimization techniques.

This instructor-led, live training (online or onsite) is aimed at intermediate-level Oracle professionals who wish to understand and apply SQL tuning techniques for Oracle Database 19c to improve query execution and database efficiency.

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

• Interpret execution plans and identify performance bottlenecks.
• Apply Oracle tuning tools such as AWR, ADDM, and SQL Tuning Advisor.
• Use indexes, hints, and statistics to optimize queries.
• Diagnose and resolve inefficient SQL statements in real-world environments.

Format of the Course

• Interactive lecture and discussion.
• Hands-on use of Oracle tuning tools and SQL queries.
• Guided exercises focused on real tuning scenarios and performance analysis.

Course Customization Options

• To request a customized training for this course based on your system or business queries, please contact us to arrange.

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

This instructor-led, live training in Gaia (online or onsite) is aimed at advanced-level developers who wish to learn and use MySQL and database technologies for building web applications.

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

• Write SQL queries to retrieve, filter, sort, and aggregate data.
• Perform data manipulation operations such as inserting, updating, and deleting data.
• Implement advanced SQL concepts such as subqueries, derived tables, and conditional logic.
• Integrate MySQL with popular programming languages and execute queries from application code.

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

This live instructor-led training (in-person or remote) is aimed at data analysts, SQL developers, database administrators, and business intelligence professionals who wish to learn Teradata from an introductory to advanced level. The course combines theory with practical exercises to master data querying, management, optimization, and administration in Teradata environments, enabling participants to confidently work on real projects involving data analysis and massive data processing.

Upon completing this training, participants will be able to:

• Understand the distributed architecture and parallel execution model of Teradata.
• Write optimized SQL queries from basic levels 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 cases
• Integration and optimization labs
• Use of official tools like Teradata Studio or BTEQ for live demonstrations

Course Customization Options

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

This instructor-led, live training in Gaia (online or onsite) is aimed at beginner-level software developers and database administrators who wish to learn the basics of vector databases, including their structure, operation, and use cases.

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

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

This SQL training course is for people who want to gain the necessary skills to extract and analyse data using Microsoft Access. Course members will learn:

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

This SQL course deals with Microsoft Access dialect of SQL.

This training is designed for Database Administrators and Architects who want to tune PostgreSQL Database for Performance. Learn how to log slow workload and find the possible pain points in a query. This topic also covers the most important parameters that must be tuned for optimal performance. 

The objective of the course is to enable participants to gain a mastery of the fundamentals and usages of VBA for Access & Excel.

Delegates will gain an understanding of the basic principles of Structured Query Language as well as being able to do each of the following:

• Construct queries to extract and filter data from an SQL Server database
• Create summarised results
• Change, derive and format data to suit the required output
• Change data and maintain database components and definitions

This course is for anybody who needs information from a Microsoft SQL Server database. It is suitable for either system developers or people from other areas who need to use SQL to extract and analyse data.

This instructor-led, live training in Gaia (online or onsite) is aimed at developers and administrators who wish to use PostgreSQL with Python to build secure, reliable, and stable applications at scale.

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

• Install, configure, and connect PostgreSQL with Python.
• Get a refresher on Python programming fundamentals.
• Understand the benefits of using PostgreSQL with Python.
• Learn how to perform basic SQL operations with Python.
• Learn how to use the advanced PostgreSQL features with Python.
• Implement data safety, security, monitoring, and optimization techniques.

This instructor-led, live training in Gaia (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 Gaia (online or onsite) is aimed at beginner-level to intermediate-level professionals who wish to enhance their skills in extracting, analyzing, and manipulating data within Microsoft Access using queries and SQL.

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

• Understand different types of queries in Microsoft Access.
• Use query design tools to extract and analyze data effectively.
• Write SQL queries to retrieve and manipulate data.
• Perform data aggregation, filtering, and sorting using queries.
• Apply advanced query techniques for troubleshooting and optimization.

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

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

MySQL Administration training course is for anyone who wants to administrate the MySQL database server. It is a comprehensive course covering all administrator duties.

The course explains how MySQL Database works, what tools are available, how we can use them, how we can secure the MySQL Database Server and configure it. During the training course you will learn how to manage user accounts and how the MySQL Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and perform crash recovery.

In this instructor-led, live training 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.