Database Training in Tunis

This instructor-led, live training in Tunis (online or onsite) is aimed at advanced-level system administrators who wish to deepen their knowledge 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 implementing 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.

This instructor-led, live training in Tunis (online or onsite) is aimed at beginner-level database administrators who wish to ensure that they are well-prepared to manage and optimize their Oracle environments.

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

• Understand the key features and architecture of Oracle Database 19c, including system requirements and installation methods.
• Gain practical skills in installing Oracle Database 19c and Oracle Grid Infrastructure, including configuring the network, storage, and security settings.
• Learn the complete process of upgrading to Oracle Database 19c, from pre-upgrade planning to post-upgrade validation.
• Develop troubleshooting skills to handle common issues during installation and upgrade.
• Apply best practices for Oracle Database installation and upgrade to ensure a smooth and successful deployment.

Oracle SOA Suite 12c is a unified platform for building, deploying, and managing service-oriented architecture (SOA) applications and integrations across the enterprise.

This instructor-led, live training (online or onsite) is aimed at intermediate-level integration specialists who wish to design, deploy, and manage composite applications using Oracle SOA Suite 12c.

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

• Develop, deploy, and monitor SOA composite applications using Oracle JDeveloper and the SOA Suite environment.
• Design integrations using BPEL processes, Mediators, and adapters for various data sources.
• Implement service orchestration, routing, and transformation using best practices.
• Administer and troubleshoot composite applications in Oracle Enterprise Manager (EM) Fusion Middleware Control.

Format of the Course

• Interactive lecture and discussion.
• Practical exercises and guided labs.
• Hands-on implementation using Oracle SOA Suite 12c.

Course Customization Options

• To request a customized version of this course focusing on your organization’s integration environment or workflow requirements, please contact us to arrange.

This instructor-led, live training in Tunis (online or onsite) is aimed at intermediate-level database administrators who wish to effectively manage and optimize a multitenant environment.

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

• Understand the key components and benefits of Oracle Database 19c's multitenant architecture, including CDBs and PDBs.
• Gain practical skills in installing, configuring, and managing container databases (CDBs) and pluggable databases (PDBs).
• Develop proficiency in implementing security measures, backup and recovery strategies, and performance tuning in a multitenant environment.
• Learn how to manage high availability and disaster recovery in a multitenant architecture, including configuring Data Guard and Oracle RAC.
• Acquire troubleshooting techniques and best practices for maintaining a secure, efficient, and reliable multitenant database environment.

This instructor-led, live training in Tunis (online or onsite) is aimed at intermediate-level database administrators who wish to have an in-depth understanding of Oracle Database 19c PL/SQL programming and advanced SQL techniques.

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

• Understand the fundamentals and advanced features of PL/SQL.
• Develop advanced SQL queries to retrieve and manipulate data efficiently.
• Implement PL/SQL programming constructs to manage data and database operations.
• Optimize SQL queries for better performance.
• Use advanced PL/SQL features like collections, bulk processing, and error handling.
• Learn to debug and manage PL/SQL programs effectively.

This instructor-led, live training in Tunis (online or onsite) is aimed at beginner-level customer service managers who wish to effectively manage and optimize their customer service operations using Oracle's powerful tools and features.

By the end 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.

This instructor-led, live training in Tunis (online or onsite) is aimed at intermediate-level cloud and DevOps engineers who wish to enhance cloud observability with Grafana and Prometheus.

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

• Understand the benefits of integrating Grafana and Prometheus with cloud platforms.
• Set up Prometheus for monitoring cloud-based resources.
• Configure Grafana for visualizing cloud service metrics.
• Leverage cloud-native tools and integrations for monitoring scalability.

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.

Oracle Database Appliance (ODA) X11 is an engineered system optimized for running Oracle Databases with high performance, simplified management, and integrated lifecycle automation. It is designed to reduce complexity and improve reliability in Oracle database deployments for on-premises and hybrid environments.

This instructor-led, live training (online or onsite) is aimed at intermediate-level to advanced-level database administrators and system engineers who wish to deploy, manage, and optimize Oracle ODA X11 environments.

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

• Understand the architecture and components of Oracle Database Appliance X11.
• Perform installation, configuration, and provisioning of ODA environments.
• Manage databases, storage, and networking within ODA.
• Implement patching, monitoring, and performance optimization strategies.
• Troubleshoot common ODA issues and maintain system health.

Format of the Course

• Interactive lecture and discussion.
• Hands-on configuration and deployment exercises.
• Real-world scenarios and performance tuning labs.

Course Customization Options

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

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 Tunis (online or onsite) is aimed at beginner-level IT professionals and DevOps practitioners who wish to learn the basics of Grafana and Prometheus.

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

• Understand the purpose and key features of Grafana and Prometheus.
• Install and configure Grafana and Prometheus on a Linux environment.
• Set up basic data sources and dashboards in Grafana.
• Monitor system metrics and visualize data using Prometheus.

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

SQL Server Integration Services (SSIS) is a component of Microsoft SQL Server that provides a platform for data integration and workflow applications. It is used for data migration, warehousing, and transformation tasks.

This instructor-led, live training (online or onsite) is aimed at intermediate-level data professionals and developers who wish to focus on designing advanced SSIS data flows, transformations, and managing Slowly Changing Dimensions (SCD) for data warehousing scenarios.

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

• Design and implement robust data flows using SSIS.
• Work with a variety of data sources, destinations, and transformations.
• Implement Slowly Changing Dimensions (SCD) for handling historical data changes.
• Deploy, execute, and troubleshoot SSIS packages effectively.

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 Tunis (online or onsite) is aimed at intermediate-level to advanced-level data scientists and machine learning engineers who wish to master the use 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.

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

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

This live, instructor-led training (on-site or remote) is aimed at data analysts, SQL developers, database administrators, and business intelligence professionals who want to learn Teradata from an introductory level to advanced. The course combines theory with practical exercises to master querying, managing, optimizing, and administering data in Teradata environments, enabling participants to confidently work on real-world data analysis and big data processing projects.

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

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

Custom Course Options

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

This course covers everything a database developer needs to know to successfully develop applications using MongoDB.

Gain expert MongoDB skills. Master document manipulation, efficient querying, and data modeling. Learn aggregation pipelines, indexing strategies, and schema design to build scalable NoSQL applications.

Listeners

This training is addressed for people starting to work with the SQL language in Oracle database

The course answer for questions:

• How to build a query?
• What possibilities have SQL?
• What is a relational database?
• What is the structure and SQL commands

This 3 day course gives an introduction to ORACLE PL/SQL, an application development environment that enables the writing of stored procedures, functions and triggers using both SQL and PL/SQL commands.

The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core elements.

Full course notes are provided along with sample database files, example SQL files and free software tools for use in accessing an ORACLE database.

In this instructor-led, live training in Tunis (onsite or remote), participants will learn the general and advanced aspects of PostgreSQL, including administration, performance turning, 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.

Automate workflows and build robust desktop applications with VBA across Microsoft Excel and Access. This comprehensive VBA training covers programming fundamentals, object-oriented coding, SQL database design, user interface development, debugging techniques, error handling, and advanced Excel analysis routines through practical exercises — empowering analysts, financial professionals, and developers to eliminate manual tasks and unlock advanced data management and reporting capabilities.

Delegates will gain an understanding of some of the more advanced features of Transact SQL as well as being able to do each of the following:

• Use queries to return complex result sets
• Manage database objects to aid query performance
• Tune queries to perform more efficiently

This course is for anyone who currently uses Transact SQL to extract data from a Microsoft SQL Server database and wishes to expand their knowledge particularly in the areas of data analysis and improving query speed.

This instructor-led, live training in Tunis (online or onsite) is aimed at intermediate-level database administrators and IT professionals who wish to implement and manage ASM solutions in Oracle Database 19c.

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

• Administer and manage ASM instances and disk groups.
• Implement and manage ACFS (Automatic Storage Management Cluster File System).
• Perform client database failover with Flex ASM.
• Troubleshoot and resolve common ASM-related issues.

Access VBA training enables developers and power users to write macros, automate Microsoft Access operations, and build custom database applications. Covers core concepts of Visual Basic for Applications integration with MS Access, explores essential techniques in object model automation and data manipulation, equips database professionals with skills to develop custom forms, reports, and event-driven workflows for enterprise applications.

CockroachDB is an open-source distributed SQL database designed for resilience and data locality. It replaces proprietary global databases like Google Spanner while keeping full infrastructure control. This instructor-led, live training (online or onsite) is aimed at advanced database engineers and architects who wish to use CockroachDB to replace proprietary global SQL databases.

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

This instructor-led, live training in Tunis (online or onsite) is aimed at intermediate-level database administrators and IT professionals who wish to optimize the performance of Oracle Database 19c.

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

• Understand Oracle Database 19c performance tuning concepts.
• Use performance management tools effectively.
• Optimize database performance through tuning techniques.
• Troubleshoot and resolve performance issues.