Database Training in Sintra

Oracle Linux 9 is an enterprise-grade Linux distribution engineered for optimal performance, robust security, and seamless compatibility with Red Hat Enterprise Linux. This course provides participants with an introduction to essential system administration tasks, addressing core concepts such as user management, file systems, networking, and software package handling.

Delivered as a live, instructor-led training session (available online or onsite), this programme is designed for beginner-level Linux administrators seeking to establish a solid foundation in Oracle Linux 9 system administration.

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

• Install and configure Oracle Linux 9 for enterprise deployment.
• Manage users, groups, file systems, and access permissions.
• Configure software repositories and install packages.
• Execute basic system monitoring and troubleshooting procedures.

Course Format

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

Customisation Options

• To request a tailored training session for this course, please contact us to arrange.

This instructor-led, live training in Sintra (online or on-site) is designed for advanced system administrators aiming to enhance their proficiency in system management, troubleshooting, and performance tuning.

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

• Configure and manage advanced user and group settings, including the implementation of user quotas and system-wide user environments.
• Use security auditing tools and configure sudo for controlled administrative access.
• Monitor and optimize system performance.
• Configure, analyze, and troubleshoot system logs.
• Develop and implement backup and recovery solutions.

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.

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 powerful platform for constructing and managing enterprise data warehouses designed to handle analytical workloads.

This instructor-led live training, available either online or on-site, targets beginner-level data professionals and analysts eager to grasp the foundational concepts and architecture of Oracle-based data warehouse systems.

Upon completing this training, participants will be capable of:

• Grasping the core concepts and architecture of Oracle data warehousing.
• Describing standard data warehouse components, such as fact and dimension tables.
• Identifying use cases and advantages of Oracle data warehousing within business intelligence.
• Preparing for advanced training in Oracle ETL, performance tuning, and warehouse optimization techniques.

Course Format

• Interactive lectures and discussions.
• Practical application of Oracle SQL and exploration of warehouse schemas.
• Guided conceptual exercises and warehouse design analysis.

Customization Options

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

This instructor-led, live training in Sintra (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 Sintra (online or onsite) is aimed at intermediate-level to advanced-level database administrators who wish to deepen their knowledge of SQL Server for efficient database management, performance tuning, high availability, and advanced troubleshooting.

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

• Administer and configure SQL Server instances using best practices.
• Optimize performance of queries and databases.
• Implement high availability and disaster recovery strategies.
• Diagnose and resolve complex issues in production environments.

SQL Tuning in Oracle Database 19c involves enhancing SQL performance through the application of analysis, statistical data, and optimization strategies.

This instructor-led live training, available online or onsite, is designed for intermediate Oracle professionals seeking to understand and implement SQL tuning techniques for Oracle Database 19c to enhance query execution and overall database efficiency.

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

• Interpreting execution plans to identify performance bottlenecks.
• Applying Oracle tuning tools such as AWR, ADDM, and the SQL Tuning Advisor.
• Utilizing indexes, hints, and statistics to optimize queries.
• Diagnosing and resolving inefficient SQL statements in practical environments.

Course Format

• Interactive lectures and discussions.
• Practical application of Oracle tuning tools and SQL queries.
• Guided exercises focused on real-world tuning scenarios and performance analysis.

Course Customization Options

• For customized training tailored to your specific system or business queries, please contact us to make arrangements.

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

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 Sintra (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 Sintra (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 programme provides comprehensive guidance for database administrators on the effective deployment and maintenance of MongoDB environments.

Key topics include diagnosing performance bottlenecks, managing data imports and exports, establishing robust backup and restoration procedures, and an overview of the MongoDB CRUD API, command-line shell, and associated drivers.

The target audience comprises individuals seeking to:

• Gain a developer-centric understanding of MongoDB, including its command shell, query API, and driver utilities.
• Deploy MongoDB across various configurations, such as single servers, master-slave replication, replica sets, and sharded clusters.
• Evaluate application requirements and select appropriate hardware.
• Monitor MongoDB instances and integrate them with standard monitoring solutions (e.g., Munin, Nagios).
• Plan for backups and manage large-scale data imports and exports.
• Troubleshoot frequent developer-related issues and failure scenarios.

Participants will engage in a series of hands-on practical exercises.

This instructor-led live training (available online or on-site) is designed for administrators seeking to address complex deployment and management challenges using MongoDB Ops Manager.

Upon completion, participants will be equipped to:

• Install and configure MongoDB Ops Manager
• Establish and manage diverse environment types
• Understand and apply MongoDB Enterprise Server-specific solutions to tackle intricate enterprise hurdles

Course Format

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

Customization Options

• This training relies on MongoDB Enterprise Server, which includes Ops Manager. Please contact us to discuss licensing requirements.
• For tailored training requests, please reach out to us for arrangement.

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.

This instructor-led, live training in Sintra (online or onsite) is aimed at beginner-level and intermediate-level professionals who wish to use big data and database concepts to understand modern data platforms and make better technology and business decisions.

By the end of this training, participants will be able to: explain core database and big data concepts, compare major data platform options, describe how data is stored and processed, and identify practical use cases and governance needs.

CockroachDB is an open-source distributed SQL database built for resilience and data locality. It offers a viable alternative to proprietary global databases like Google Spanner, enabling full infrastructure autonomy. This instructor-led, live training (online or on-site) is designed for advanced database engineers and architects looking to leverage CockroachDB to replace vendor-locked global SQL solutions.

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

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

This live, instructor-led training in Sintra (online or onsite) is aimed at beginners, programmers, and database administrators who wish to learn or improve their SQL development skills and knowledge.

By the end of this training, participants will be able to install, create, manage, manipulate, and monitor databases using SQL and database management systems.