Database Training in Gaia

Oracle Database 23ai represents the next generation of Oracle's database platform, delivering advanced AI integration, automation, and administration capabilities tailored for contemporary data demands.

This instructor-led live training (available online or onsite) is designed for intermediate Oracle administrators looking to explore and deploy the latest Oracle Database 23ai features to enhance performance, security, and AI-driven functionality.

Upon completing this course, participants will be able to:

• Comprehend and assess the key new features introduced in Oracle 23ai.
• Configure AI Vector Search and integrate AI workloads effectively.
• Utilise enhanced automation, observability, and performance optimisation tools.
• Plan version upgrades and implement new 23ai capabilities within production environments.

Course Format

• Interactive lectures and discussions.
• Hands-on experience with Oracle 23ai features in test environments.
• Guided labs focusing on implementation and migration planning.

Customisation Options

• To arrange customised training tailored to your Oracle infrastructure, please contact us.

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 aimed at advanced-level developers and database administrators who wish to use PL/SQL to develop high-performing, secure, and scalable database solutions while leveraging advanced programming techniques and integrations.

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

• Work with complex data types, collections, and bulk operations for efficient data management.
• Develop object types, table functions, and custom aggregates to enhance database functionality.
• Apply performance tuning techniques, use native compilation, and safeguard against SQL injection.
• Implement application contexts, VPD, and secure program units for robust database solutions.

This instructor-led, live training in Gaia (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 Gaia (online or onsite) is tailored for beginner-level customer service managers who aim to effectively manage and optimize their customer service operations using Oracle's powerful tools and features.

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

• Understand the fundamentals of Oracle Service Management.
• Learn how to configure and manage service requests.
• Gain proficiency in using Oracle Service Cloud for customer service operations.
• Explore advanced features for optimizing service delivery.
• Develop skills in reporting and analytics for service management.

SQL serves as a standardized language designed to query, manipulate, and manage data within relational database systems.

This instructor-led, live training (available online or onsite) is tailored for users ranging from beginner to advanced levels who aim to construct efficient SQL queries and work confidently with relational databases.

Upon completion of this training, participants will acquire the skills to:

• Construct SQL queries to retrieve, filter, and sort data.
• Manipulate data through insert, update, and delete operations.
• Create joins, subqueries, and aggregated reports.
• Apply advanced SQL techniques for real-world data analysis.

Format of the Course

• Instructor-led lectures combined with guided discussions.
• Hands-on query building and practical exercises.
• Live-lab demonstrations using real datasets.

Course Customization Options

• If you require a tailored SQL program for your organization, please contact us to arrange.

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.

Oracle Database 19c represents the long-term support release of Oracle's flagship database platform, engineered to provide high performance, scalability, and reliability for enterprise workloads.

This instructor-led live training, available online or onsite, is designed for beginner to intermediate database administrators and IT professionals seeking to effectively install, configure, and manage Oracle Database 19c SE2 environments.

Upon completing this training, participants will be able to:

• Comprehend the architecture of Oracle Database 19c SE2 and its core components.
• Install and configure Oracle Database 19c SE2 on supported platforms.
• Execute essential administrative tasks, including backup, recovery, and security management.
• Enhance database performance and monitor system health using Oracle tools.
• Plan and implement migrations from earlier Oracle Database versions to 19c.

Course Format

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

Customization Options

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

SQL serves as a robust tool for managing and analyzing structured data within relational databases.

This instructor-led training, available both online and onsite, is designed for intermediate users looking to enhance their SQL capabilities for handling complex queries, data manipulation, and performance optimization.

Upon completion of this training, participants will gain the ability to:

• Compose intricate SQL queries by utilizing advanced joins and subqueries.
• Manage data effectively through INSERT, UPDATE, and DELETE operations.
• Apply window functions to conduct advanced analytics.
• Enhance query performance through optimization techniques.

Course Structure

• Engaging lectures and interactive discussions.
• Extensive practical exercises and drills.
• Practical application within a live laboratory environment.

Customization Opportunities

• For tailored training solutions, please reach out to us to discuss your specific needs.

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.

SQL serves as the standard language for accessing and manipulating databases.

This instructor-led live training, available online or on-site, is designed for beginners who want to grasp the fundamentals of SQL for data querying and reporting.

Upon completing this training, participants will be able to:

• Comprehend the structure of relational databases.
• Compose basic SQL statements to retrieve, filter, and sort data.
• Utilize aggregate functions to summarize data.
• Execute basic joins between multiple tables.

Course Format

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

Course Customization Options

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

SQL Server is Microsoft’s enterprise-grade relational database management system, engineered for the efficient storage, management, and retrieval of data.

This instructor-led live training (available online or onsite) is tailored for IT professionals at an intermediate level who aim to administer, configure, and maintain SQL Server environments.

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

• Install and configure SQL Server environments.
• Manage databases, users, and permissions.
• Monitor performance and troubleshoot issues.
• Automate tasks using jobs and maintenance plans.

Course Format

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

Customization Options

• To request a customized training version of this course, please contact us to arrange.

This instructor-led live training in Gaia (online or onsite) is designed for beginner to intermediate data scientists and software developers who wish to learn how to apply Pinecone in various AI scenarios, from semantic search to personalization.

Upon completing this training, participants will be able to:

• Grasp the architecture and key features of Pinecone.
• Deploy vector databases across different AI applications.
• Execute similarity searches with high precision and speed.
• Apply Pinecone to address real-world AI challenges.

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 APEX (Application Express) is a low-code development platform designed for rapidly creating scalable and secure enterprise applications with minimal coding effort.

This instructor-led live training, available both online and onsite, is tailored for intermediate-level developers and IT professionals looking to build secure, scalable enterprise applications using Oracle APEX while minimising hand-coding.

Upon completing this training, participants will be able to:

• Design and construct data-driven applications using APEX.
• Leverage built-in components to speed up the development process.
• Deploy, evaluate, and certify applications efficiently.
• Manage user authentication and application security.

Course Format

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

Course Customisation Options

• To arrange a customised training session for this course, please contact us.

This instructor-led live training, delivered in Gaia (either online or onsite), targets intermediate to advanced data scientists and machine learning engineers who aim to master the utilization of vector databases for scalable, high-performance AI applications.

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

• Understand the principles of vector databases.
• Learn techniques for creating and managing vector embeddings.
• Explore indexing strategies for high-dimensional data.
• Develop skills for performing efficient similarity searches.
• Apply vector database knowledge to machine learning projects.

Microsoft Azure serves as a cloud computing platform that facilitates the hosting, management, and optimization of relational database workloads via services such as Azure SQL Database and SQL Managed Instance.

This instructor-led live training, available either online or onsite, is designed for intermediate-level database administrators and IT professionals seeking to master the provisioning, management, monitoring, and securing of relational databases on Azure.

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

• Provisioning Azure SQL resources, including single databases, elastic pools, and managed instances.
• Configuring high availability, disaster recovery mechanisms, and automated backups.
• Monitoring and optimizing performance through built-in tools and telemetry data.
• Implementing security controls, authentication methods, and auditing within cloud database environments.

Course Format

• Interactive lectures and discussions.
• Extensive exercises and practical application.
• Hands-on implementation within a live laboratory environment.

Customization Options

• To arrange a customized version of this course, please contact us.

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

Effective management and development of PostgreSQL databases demand a profound understanding of performance tuning, database replication strategies, and connection pooling techniques. This course encompasses server administration, core SQL principles, client-side interfaces, server-side programming, and the internal architecture of the database. Through practical, hands-on training, Database Administrators and developers will learn to optimize query execution, manage backup procedures, set up monitoring systems, and establish robust, production-ready configurations tailored for enterprise-level PostgreSQL environments.

In this instructor-led, live training in Gaia (onsite or remote), participants will explore the general and advanced aspects of PostgreSQL, including administration, performance tuning, advanced development, and replication as they step through a series of hands-on, live-lab exercises involving setup, configuration, testing, deployment and troubleshooting.

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

• Use advanced administration techniques to configure and manage a PostgreSQL server.
• Optimize the database and queries for maximum performance.
• Replicate and scale a PostgreSQL server.

Participants will develop a solid understanding of several advanced Transact SQL capabilities, alongside gaining the ability to perform the following tasks:

• Employ queries to retrieve complex result sets
• Manage database objects to enhance query performance
• Optimize queries for greater efficiency

This course is designed for individuals who currently utilise Transact SQL to extract data from a Microsoft SQL Server database and wish to broaden their expertise, particularly regarding data analysis and improving query speed.

Designed for delegates who already possess familiarity with SQL within the Microsoft SQL Server 2008/2012 environment, this course concentrates on set-based querying and query tuning. Key areas of study include working with indexes and analyzing execution plans.

Additionally, the training covers table expressions, ranking functions, and techniques for handling partitioned tables.

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 Gaia (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 MariaDB Administration training course is designed for individuals seeking to manage the MariaDB database server. It is a comprehensive program that covers all essential administrative responsibilities.

The curriculum explains the inner workings of the MariaDB Database, available tools, their practical applications, and methods for securing and configuring the MariaDB Database Server. Participants will learn how to manage user accounts and understand the mechanics of the MariaDB Access Privilege System. Additionally, the course teaches database maintenance, backup and recovery procedures, and crash recovery techniques.

This instructor-led live training in Gaia (online or onsite) is aimed at developers who wish to use SQLite to develop embedded applications for various devices, such as desktops, mobile phones, Android TV, cameras, etc.

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

• Install and configure SQLite on any platform.
• Understand the features and architecture of SQLite.
• Learn how to execute common SQL operations in SQLite.
• Learn how to manipulate data and tables in SQLite.
• Understand the various SQLite data types, tools, and functions.
• Perform calculations with SQLite aggregate functions.

Developing efficient SQL queries for Microsoft SQL Server forms the bedrock of every enterprise data pipeline. This course explores core techniques, beginning with relational database models, and advancing through data retrieval, filtering, sorting, and aggregation using grouping functions and subqueries. It guides participants through multi-table joins, set operators, DML operations, and transaction control to reliably extract and manipulate business intelligence datasets.

SSAS (SQL Server Analysis Services) is a Microsoft SQL Server tool for online analytical processing (OLAP) and data mining, enabling the analysis of data across multiple databases, tables, or files. The semantic data models provided by SSAS are utilized by client applications such as Power BI, Excel, Reporting Services, and various other data visualization tools.

Through this instructor-led live training (available onsite or remotely), participants will learn how to leverage SSAS to analyze substantial volumes of data within databases and data warehouses.

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

• Install and configure SSAS
• Grasp the relationships between SSAS, SSIS, and SSRS
• Apply multidimensional data modeling to derive business insights from data
• Design OLAP (Online Analytical Processing) cubes
• Query and manipulate multidimensional data using the MDX (Multidimensional Expressions) query language
• Deploy real-world BI solutions utilizing SSAS

Audience

• BI (Business Intelligence) professionals
• Data Analysts
• Database and data warehousing professionals

Format of the Course

• Interactive lecture and discussion
• Extensive exercises and practice
• Hands-on implementation in a live-lab environment

Course Customization Options

• This training is based on the latest version of Microsoft SQL Server and SSAS.
• To request a customized training for this course, please contact us to arrange.