Database Training in Berlin

This instructor-led, live training held in Berlin (either online or onsite) is tailored for entry-level database administrators seeking to solidify their readiness for managing and optimizing Oracle environments.

By the conclusion of this program, participants will be equipped to:

• Comprehend the fundamental features and architecture of Oracle Database 19c, along with its system requirements and installation techniques.
• Develop practical proficiency in installing Oracle Database 19c and Oracle Grid Infrastructure, including the configuration of network, storage, and security settings.
• Understand the full scope of the upgrade process to Oracle Database 19c, from preliminary planning to post-upgrade verification.
• Cultivate troubleshooting abilities to address typical issues arising during installation and upgrade cycles.
• Apply recommended best practices for Oracle Database installation and upgrades to ensure a smooth deployment.

This instructor-led, live training in Berlin (online or onsite) is designed for intermediate-level database administrators aiming to manage, optimize, and secure Data Guard environments for robust disaster recovery and high availability.

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

• Understand the architecture and benefits of Oracle Data Guard for disaster recovery and high availability.
• Gain hands-on experience in configuring and managing physical and logical standby databases, including the Data Guard broker.
• Develop practical skills in monitoring, troubleshooting, and optimizing Data Guard environments for optimal performance.
• Learn advanced features such as Active Data Guard, Data Guard with RAC, and securing Data Guard communications.
• Apply best practices for disaster recovery planning, ensuring data consistency, and automating Data Guard operations.

This live, instructor-led training, conducted in Berlin (either online or onsite), is designed for intermediate-level database administrators aiming to oversee and enhance complex, high-availability Oracle database environments.

By the conclusion of this course, participants will be able to:

• Gain a comprehensive understanding of Oracle RAC architecture and Grid Infrastructure, including installation, configuration, and management.
• Develop practical skills in managing Automatic Storage Management (ASM), including disk group management, instance tuning, and backup/recovery.
• Learn advanced RAC performance tuning techniques, disaster recovery configurations, and best practices for high availability.
• Acquire troubleshooting and diagnostic skills for resolving issues in RAC and Grid Infrastructure environments.
• Understand the process of patching and upgrading Oracle RAC and Grid Infrastructure while minimizing downtime and maintaining system stability.

This live, instructor-led training in Berlin (delivered online or onsite) is tailored for junior database administrators aiming to master backup and recovery procedures in Oracle Database 19c.

By the conclusion of the course, attendees will be able to:

• Comprehend the fundamental concepts of backup and recovery in Oracle Database 19c, covering architectural elements and failure typologies.
• Gain hands-on proficiency in setting up backup and recovery configurations, including the RMAN environment and fast recovery area.
• Cultivate practical skills in executing various backup and recovery methods, such as full, incremental, and point-in-time recovery.
• Utilize Oracle's Flashback technology for streamlined database recovery and disaster recovery management.
• Apply best practices to ensure data availability and minimize downtime through effective backup, recovery, and disaster recovery strategies in Oracle Database 19c.

This live, instructor-led training delivered in Berlin (either online or onsite) is designed for intermediate-level database administrators who aim to proficiently manage and optimize multitenant environments.

Following this training, participants will have the capability to:

• Grasp the core components and benefits of Oracle Database 19c’s multitenant architecture, particularly CDBs and PDBs.
• Gain practical abilities in installing, configuring, and overseeing container databases (CDBs) and pluggable databases (PDBs).
• Enhance proficiency in applying security controls, backup and recovery plans, and performance optimization within multitenant frameworks.
• Understand the administration of high availability and disaster recovery in multitenant contexts, including Data Guard and Oracle RAC configurations.
• Master troubleshooting methods and best practices to sustain a secure, high-performing, and dependable multitenant database ecosystem.

This instructor-led, live training in Berlin (available online or onsite) is designed for advanced-level developers and database administrators aiming to harness PL/SQL for developing high-performing, secure, and scalable database solutions through advanced programming techniques and integrations.

By the conclusion of this training, participants will possess the ability to:

• Handle complex data types, collections, and bulk operations to achieve efficient data management.
• Develop object types, table functions, and custom aggregates to bolster database capabilities.
• Implement performance tuning strategies, apply native compilation, and protect systems from SQL injection threats.
• Deploy application contexts, VPD, and secure program units to establish robust database solutions.

This instructor-led, live training session in Berlin, offered online or on-site, targets beginner-level developers and database administrators seeking to acquire PL/SQL skills. The goal is to automate database tasks, embed business logic, and construct robust database applications.

Upon completing this training, participants will be equipped to:

• Develop efficient PL/SQL programs that automate database operations and effectively integrate SQL commands.
• Design reusable program units, such as procedures, functions, packages, and triggers, to facilitate modular and scalable applications.
• Leverage advanced data structures like associative arrays and manage query results via cursors.
• Implement robust error handling and secure code using encryption, obfuscation, and conditional compilation techniques.
• Apply PL/SQL in practical scenarios by harnessing built-in packages for file handling, email automation, and other advanced features. 

This instructor-led, live training conducted in Berlin (available online or onsite) is designed for intermediate-level database administrators aiming to gain a profound understanding of Oracle Database 19c PL/SQL programming and advanced SQL methodologies.

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

• Grasp the essential and advanced aspects of PL/SQL.
• Construct advanced SQL queries for efficient data retrieval and manipulation.
• Apply PL/SQL programming constructs to control data and database operations.
• Improve SQL query performance through optimization.
• Utilize advanced PL/SQL features such as collections, bulk processing, and error handling.
• Proficiently debug and oversee PL/SQL programs.

This live, instructor-led course, delivered in Berlin (either virtually or in person), is designed for experienced DevOps engineers and SREs looking to master the management and scaling of Prometheus and Grafana in massive environments.

By the time this training concludes, participants will be equipped to:

• Structure Prometheus and Grafana implementations for large-scale, distributed contexts.
• Fine-tune Prometheus for optimal performance under heavy traffic loads.
• Configure Grafana to process large volumes of data and complex visual outputs.
• Execute advanced troubleshooting techniques and scalability plans.

This instructor-led, live training is conducted in Berlin (either online or onsite) and is specifically designed for intermediate-level developers and DevOps engineers aiming to instrument their applications for effective custom metric export and monitoring using Prometheus and Grafana.

By the conclusion of this program, participants will be equipped to:

• Recognize the value of custom metrics in enhancing application monitoring.
• Implement instrumentation to export custom metrics for Prometheus.
• Build and fine-tune Grafana dashboards for clear custom metric visualization.
• Apply proven best practices for integrating monitoring strategies into the development lifecycle.

This live, instructor-led training is conducted Berlin (online or onsite) and targets advanced Kubernetes administrators and DevOps engineers seeking to improve their monitoring expertise using Prometheus and Grafana.

By the conclusion of this program, participants will be capable of:

• Setting up Prometheus and Grafana for Kubernetes monitoring.
• Monitoring critical metrics for pods, nodes, and services.
• Building dynamic dashboards to visualize cluster health and performance.
• Implementing alerting strategies to resolve issues proactively.
• Applying best practices for scaling monitoring solutions in Kubernetes environments.

This live, instructor-led training in Berlin (online or on-site) is tailored for senior DevOps and SRE specialists seeking to refine their alerting and automation expertise using Grafana and Prometheus.

By the conclusion of this program, participants will have the capability to:

• Develop and administer advanced alerting rules in Prometheus.
• Link Prometheus Alertmanager with external applications using webhooks.
• Accelerate problem resolution by automating alert handling.
• Effectively monitor and manage alerts through Grafana visualizations.

This live, instructor-led training in Berlin (online or on-site) is tailored for intermediate-level cloud and DevOps engineers aiming to improve cloud observability through Grafana and Prometheus.

By the conclusion of the program, attendees will be capable of:

• Appreciating the merits of integrating Grafana and Prometheus with cloud platforms.
• Deploying Prometheus for the supervision of cloud-based resources.
• Configuring Grafana to render visual insights into cloud service metrics.
• Applying cloud-native tools and integrations to enhance monitoring scalability.

This instructor-led, live training session, conducted in Berlin (either online or on-site), is tailored for intermediate-level DevOps and SRE professionals aiming to build impactful dashboards and enhance their monitoring strategies with Grafana and Prometheus.

By the conclusion of this training, participants will have the ability to:

• Grasp best practices for designing high-performance dashboards.
• Develop and configure advanced Grafana dashboard elements.
• Apply Grafana templating to create dynamic and reusable dashboards.
• Establish alerting frameworks to improve operational situational awareness.

This live, instructor-guided training, conducted in Berlin (either online or on-site), is tailored for junior system administrators and DevOps engineers looking to strengthen their monitoring capabilities using Grafana and Prometheus.

By the conclusion of this session, learners will have the ability to:

• Appreciate the critical role of monitoring in IT settings.
• Install and set up Grafana and Prometheus for standard monitoring operations.
• Develop basic dashboards and alerts to present system performance data.
• Follow established best practices for ensuring system reliability and efficiency.

This live, instructor-led training is conducted in Berlin (either online or on-site) and is designed for data scientists and software developers at beginner to intermediate levels who want to explore Milvus and its practical utility in various AI contexts.

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

• Grasp the architecture and key features of Milvus.
• Deploy vector databases within different AI applications.
• Carry out similarity searches with optimal accuracy and speed.
• Apply Milvus to address real-world AI problems.

This live, instructor-led session in Berlin (delivered online or onsite) is tailored for beginner-level IT experts and DevOps practitioners seeking to master the fundamentals of Grafana and Prometheus.

Following this training, participants will be equipped to:

• Understand the role and core features of Grafana and Prometheus.
• Install and set up Grafana and Prometheus on a Linux platform.
• Define basic data sources and build dashboards in Grafana.
• Monitor system metrics and visualize data through Prometheus.

Delivered live by an instructor in Berlin (either online or on-site), this training is designed for data scientists and software developers with foundational to intermediate skills. It explores the practical application of Pinecone in various AI contexts, such as semantic search and personalization.

By the conclusion of this training, participants will have the capability to:

• Grasp the architecture and functional aspects of Pinecone.
• Deploy vector databases within diverse AI application landscapes.
• Conduct similarity searches that prioritize both accuracy and velocity.
• Utilize Pinecone to address practical, real-world AI problems.

This instructor-led, live training delivered in Berlin (either online or onsite) is targeted at intermediate to advanced database administrators, network engineers, and IT professionals seeking to optimize database performance, scalability, and reliability via 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 live, instructor-led program in Berlin (online or onsite) targets intermediate-level developers and database administrators looking to leverage Oracle SQL for the design, management, and optimization of database applications, as well as for the efficient automation of tasks.

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

• Comprehend Oracle database architecture and oversee users, schemas, and permissions.
• Develop optimized SQL queries to handle data retrieval, manipulation, and analysis.
• Apply advanced SQL techniques, such as joins, subqueries, and hierarchical queries.
• Create and maintain database objects including tables, indexes, views, and sequences.

This instructor-led training in Berlin is dedicated to the design of sophisticated SSIS data flows and transformations. Learners will gain mastery over Slowly Changing Dimensions, manage intricate data sources, and implement robust packages to support efficient data warehousing and migration workflows.

This instructor-led live training in Berlin (online or onsite) is tailored for intermediate to advanced data scientists and machine learning engineers aiming to master vector databases for scalable, high-performance AI applications.

By the end of the program, participants will be able to:

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

This live, instructor-led session, conducted in Berlin (either online or on-site), is designed for intermediate-level developers and IT experts aiming to master the new features in APEX 23-24, create efficient workflows, and bolster application security.

Upon completing this training, participants will have the ability to:

• Develop and manage APEX applications by leveraging the latest features in versions 23-24.
• Design and deploy efficient workflows within APEX.
• Apply advanced security measures to protect APEX applications and data.
• Integrate APEX applications with external systems to ensure smooth data exchange.
• Test, debug, and deploy APEX applications following best practices.

This live, instructor-led training in Berlin (online or onsite) is designed for intermediate IT professionals seeking to learn the design, implementation, and management of relational databases, along with querying and manipulating data through SQL.

By the conclusion of this session, participants will be able to:

• Understand the foundational aspects of database design.
• Create and manage relational databases effectively.
• Gain confidence in writing SQL queries to retrieve and alter data.
• Explore advanced SQL techniques and concepts.
• Build competencies in optimizing and maintaining databases.

This live, instructor-led training is delivered in Berlin (online or onsite) and is designed for entry-level database administrators and developers seeking to master SQL. The goal is to equip participants with the skills to effectively manage, query, and modify data within Oracle databases for both administrative and day-to-day operational duties.

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

• Grasp the fundamental architecture of Oracle databases, including the roles of schemas, users, and active sessions.
• Develop and refine SQL queries for efficient data extraction, filtering, and modification.
• Leverage joins, subqueries, and set operators to navigate multiple tables and construct complex logical queries.
• Execute data aggregation, grouping, and analytical tasks using standard SQL functions.
• Oversee key schema objects such as views, sequences, and indexes to improve overall database performance and operations. 

This instructor-led, live training in Berlin (online or onsite) is tailored for beginner-level data professionals aiming to learn how to design, implement, and manage SSIS packages for data integration and transformation tasks.

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

• Understand the architecture and components of SSIS.
• Design and implement ETL processes using SSIS.
• Use SSIS tools to develop, deploy, and manage data integration solutions.
• Troubleshoot and optimize SSIS packages for performance and reliability.

This instructor-led, live training in Berlin (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 live, instructor-led training in Berlin, delivered online or on-site, is tailored for system administrators aiming to acquire the skills necessary to administer, monitor, and support an Oracle database.

By the conclusion of this program, participants will be able to:

• Comprehend the significant feature updates and architectural modifications in the Oracle database.
• Oversee the management and monitoring of Oracle databases.
• Refine Oracle database performance.

CockroachDB is an open-source distributed SQL database built for resilience and data locality, offering an alternative to proprietary global systems like Google Spanner while ensuring full infrastructure control. This live, instructor-led training—delivered either online or onsite—is designed for experienced database engineers and architects seeking to replace proprietary global SQL solutions with CockroachDB.

This instructor-led, live training session, conducted either online or onsite, is designed for database administrators and developers seeking to use Microsoft Azure Cosmos DB for building and managing highly responsive, low-latency applications.

Upon finishing this training, participants will be able to:

• Provision the necessary Cosmos DB resources to begin building databases and applications.
• Scale application performance and storage by utilizing APIs in Cosmos DB.
• Manage database operations and reduce cost by optimizing Cosmos DB resources.

This instructor-led, live training in Berlin (online or onsite) targets database administrators and developers aiming to migrate from proprietary databases to open-source PostgreSQL.

By the conclusion of this training, participants will be able to assess migration readiness, plan and execute schema migration strategies, transfer data with appropriate tools, and manage application code conversion.

This live, instructor-led training in Berlin (online or onsite) is tailored for developers seeking to use Oracle APEX to accelerate the development, scaling, and deployment of applications with reduced code complexity.

By the conclusion of this training, participants will have acquired the ability to:

• Establish the essential development environment for creating database applications with Oracle APEX.
• Investigate Oracle APEX tools to assemble a complete, feature-rich application.
• Develop applications and pages leveraging Oracle APEX and the Page Designer UI.
• Easily augment the functionality of complex enterprise systems using Oracle APEX.
• Enhance application performance and optimize deployment scalability.
• Regulate and safeguard access to application data and various components.

This Oracle SQL Fundamentals training offers a comprehensive pathway to mastering essential Structured Query Language (SQL) skills within the Oracle Database ecosystem.

Upon finishing the program, participants will be equipped to:

• Demonstrate proficiency in writing SQL queries for effective data retrieval and modification in Oracle databases.
• Develop key skills in table joining and managing intricate data relationships.
• Apply functions with precision for data manipulation and computational tasks.
• Excel at creating efficient sub-queries for sophisticated data filtering and processing.
• Gain the assurance needed to navigate real-world Oracle SQL challenges, boosting their career potential in database fields.

This live, instructor-led session in Berlin (offered online or on-site) is designed for system administrators and DevOps engineers seeking to utilize Prometheus for native monitoring of systems and applications, or for observing dynamic microservices in cloud-based architectures.

By the conclusion of this training, learners will possess the capability to:

• Perform the installation and configuration of Prometheus.
• Grasp the core concepts, architectural design, and feature set of Prometheus.
• Construct and execute PromQL queries for data retrieval.
• Design and implement Grafana dashboards for visualization.
• Establish monitoring frameworks and alerting logic.
• Diagnose and improve system and application performance metrics.
• Implement secure connections with external endpoints and existing infrastructure.

Targeted at teams aiming to extract information from their own documentation and guidelines, this live, instructor-led session takes place in Berlin.

By the conclusion of the program, participants will be able to:

• Structure documents to facilitate effective AI interaction
• Develop a knowledge assistant using Claude Projects, custom GPTs, or Langdock
• Access answers with cited sources
• Ensure the knowledge base remains current and relevant

This live, instructor-led training is conducted in Berlin (either online or on-site) and is designed for developers aiming to utilize SQLite for creating embedded applications on diverse devices, such as desktops, mobile phones, Android TV, and cameras.

By the conclusion of this training, participants will have the ability to:

• Install and configure SQLite on any compatible platform.
• Understand the core features and architecture of SQLite.
• Execute common SQL operations using SQLite.
• Manipulate data and tables effectively within SQLite.
• Master various SQLite data types, tools, and functions.
• Perform calculations using SQLite’s aggregate functions.