Database Training in Évora

Oracle Linux 9 builds on its enterprise-ready foundation by offering robust tools for system performance, networking, automation, and storage management. This course expands the administrator’s skillset by introducing advanced administration techniques, system optimization, and service management in enterprise environments.

This instructor-led, live training (online or onsite) is aimed at intermediate-level Linux administrators who wish to advance their knowledge in administering Oracle Linux 9 systems in production environments.

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

• Automate administrative tasks using Bash scripting.
• Configure logical volumes, RAID, and advanced storage systems.
• Manage SELinux policies and file security contexts.
• Monitor system performance and resource usage.

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 Évora (online or onsite) is aimed at intermediate-level developers who wish to use Oracle Visual Builder Studio to create and manage visual applications effectively.

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

• Create and design visual applications using Oracle Visual Builder Studio.
• Utilize pages, components, and flows to build user interfaces.
• Implement data binding and integrate with various data sources.
• Deploy applications to Oracle Cloud and manage environments.

This instructor-led, live training in Évora (online or onsite) is aimed at intermediate-level database administrators who wish to improve the performance and efficiency of Oracle Database systems, particularly in environments utilizing Oracle Database Appliances.

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

• Understand the architecture and components of Oracle Database Appliance HA X8-X9r.
• Learn to identify and resolve performance issues.
• Gain practical skills in SQL tuning and instance tuning.
• Utilize Oracle's performance analysis tools effectively.
• Implement best practices for database tuning and optimization.

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.

This instructor-led, live training in Évora (online or onsite) is aimed at beginner-level business analysts and data analysts who wish to leverage Oracle BI to extract valuable insights from their data.

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

• Navigate and utilize the Oracle BI interface effectively.
• Create and customize reports and dashboards tailored to business needs.
• Conduct ad-hoc analysis using various BI tools.
• Utilize advanced features for comprehensive data exploration.

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 Évora (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.

This instructor-led, live training in Évora (online or onsite) is aimed at intermediate-level database administrators, SQL developers, and data analysts who wish to enhance their SQL skills by mastering the use of Analytic Functions.

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

• Understand the concept and importance of Analytic Functions.
• Apply various Analytic Functions to solve complex analytical problems.
• Combine Analytic Functions with other SQL features for comprehensive data analysis.
• Optimize queries for better performance using Analytic Functions.

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.

This instructor-led, live training in Évora (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 Évora (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 Évora (online or onsite) is aimed at intermediate-level developers and administrators who wish to leverage the latest features and improvements in PostgreSQL 16.

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

• Understand the architecture and components of PostgreSQL 16.
• Utilize advanced SQL features and PostgreSQL extensions.
• Implement security best practices and access controls.
• Perform database administration tasks, including backup, recovery, and monitoring.
• Optimize database performance through tuning and indexing strategies.
• Utilize PostgreSQL's built-in tools for high availability and replication.
• Integrate PostgreSQL with modern application development frameworks.

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

This instructor-led, live training (online or onsite) is aimed at beginner-level to advanced-level data professionals who wish to learn how to query, manage, optimize, and administer data within Teradata environments through theory and hands-on practice.

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

• Understand the distributed architecture and parallel execution model of Teradata.
• Write optimized SQL queries from basic selection to advanced analytics.
• 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 shared environment best practices.

Format of the Course

• Interactive presentations and conceptual explanations.
• Practical exercises based on real-world scenarios.
• Integration and optimization labs using official tools like Teradata Studio or BTEQ.

Course Customization Options

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

After the training, you will be able to write extract and modify the data in MongoDB database. You will also learn about powerful Aggregation Pipeline that is a flexible and fast tool for data analytics, and if it's not enough for you, how to connect your current BI tools like Tableau or Excel to data stored in Mongo.

The aim of this course is to provide a clear understanding of the advanced use of (SQL) for Microsoft SQL Server and the advanced use of Transact-SQL. For more in depth coverage of the topics this course can be run as a three day course.

The course participants will learn how to speed up the operation of the database, how to write advanced queries, create a convenient system of forms and reporting. The course introduces the participant to automate all operations using macros and VBA.

This instructor-led, live training in Évora (online or onsite) is aimed at application developers and engineers who wish to master more sophisticated usages of the Teradata database.

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

• Manage Teradata space.
• Protect and distribute data in Teradata.
• Read Explain Plan.
• Improve SQL proficiency.
• Use main utilities of Teradata.

This instructor-led, live training in Évora (online or onsite) is aimed at sysadmins and developers who wish to use Cassandra 4.0 to create, build, and manage large-scale databases with high availability and less failures.

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

• Install and configure Apache Cassandra.
• Migrate from earlier versions to Cassandra 4.0.
• Learn more about the new features in Cassandra 4.0.
• Build, manage, and scale high-performing databases.
• Monitor table activities and optimize internode communications.
• Use zero copy streaming to quickly transfer data across a distributed database.

This course will introduce Cassandra –  a popular NoSQL database.  It will cover Cassandra principles, architecture and data model.   Students will learn data modeling  in CQL (Cassandra Query Language) in hands-on, interactive labs.  This session also discusses Cassandra internals and some admin topics.

Duration : 3 days

Audience : Developers

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 Évora (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 Évora (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 Évora (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 Évora (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 Évora (online or onsite) is aimed at developers and system administrators who wish to use Hazelcast for processing distributed data structures and optimizing application performance.

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

• Install and configure Hazelcast to start creating and managing a cluster.
• Create a cluster for initiating automatic discovery of multiple processes.
• Set up Management Center for cluster connections and monitoring.
• Develop applications and deploy them through the Hazelcast cluster.

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

This instructor-led, live training in Évora (online or onsite) is aimed at developers who wish 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.

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

SSAS (SQL Server Analysis Services), is a Microsoft SQL Server transactional processing (OLAP) and data mining tool for analyzing data across multiple databases, tables or files. The semantic data models provided by SSAS are used by client applications such as Power BI, Excel, Reporting Services, and other data visualization tools.

In this instructor-led, live training (onsite or remote), participants will learn how to use SSAS to analyze large volumes of data in databases and data warehouses.

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

• Install and configure SSAS
• Understand the relationship between SSAS, SSIS, and SSRS
• Apply multidimensional data modeling to extract 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 using SSAS

Audience

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

 
Format of the Course

• Interactive lecture and discussion
• Lots of 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.