Database Migration: Moving from Proprietary to Open Source - Strategies for migrating Oracle/SQL Server to PostgreSQL Training Course

This instructor-led, live training in Denmark (online or on-site) is designed for database administrators and developers seeking to utilize Microsoft Azure Cosmos DB for the development and management of highly responsive, low-latency applications.

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

• Provision the necessary Cosmos DB resources to begin constructing databases and applications.
• Improve application performance and storage capacity by applying Cosmos DB APIs.
• Optimize Cosmos DB resources to manage operations and lower costs.

This live, instructor-led course, available either online or on-site, is tailored for system administrators seeking to master the administration, monitoring, and support of Oracle databases.

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

• Gain a clear understanding of the significant feature and architectural changes in the Oracle database.
• Manage and monitor Oracle database systems effectively.
• Optimize the performance of Oracle databases.

This instructor-led, live session in Denmark (available online or onsite) is designed for entry-level database administrators seeking to master backup and recovery procedures in Oracle Database 19c.

Upon completion of this program, participants will have the capability to:

• Grasp the core principles of backup and recovery in Oracle Database 19c, covering both architectural components and the nature of various failure modes.
• Acquire practical experience in configuring protection settings, with a focus on the RMAN environment and the fast recovery area.
• Build proficiency in executing diverse backup and restoration operations, including full, incremental, and point-in-time recoveries.
• Explore the application of Oracle Flashback technology for efficient database recovery and the management of disaster recovery scenarios.
• Implement industry best practices for data protection, restoration, and disaster resilience to maximize availability and reduce downtime in Oracle Database 19c.

Aimed at intermediate-level database administrators, this instructor-led live training in Denmark (online or onsite) covers the management, optimization, and security of Data Guard environments to support robust disaster recovery and high availability.

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

• Comprehend the architecture and benefits of Oracle Data Guard for disaster recovery and high availability.
• Develop hands-on skills in configuring and maintaining physical and logical standby databases, including Data Guard broker management.
• Enhance practical abilities in monitoring, troubleshooting, and optimizing Data Guard environments for peak performance.
• Understand advanced features like Active Data Guard, Data Guard with RAC, and securing Data Guard communications.
• Apply best practices for disaster recovery planning, maintaining data consistency, and automating Data Guard operations.

This live training, led by an instructor in Denmark (available online or onsite), is intended for entry-level database administrators who wish to ensure 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 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.

This live, instructor-led training in Denmark (online or onsite) is tailored for intermediate-level database administrators aiming to effectively manage and optimize multitenant environments.

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

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

This live, instructor-led training available in Denmark (online or onsite) targets intermediate-level database administrators seeking to manage and optimize complex, high-availability Oracle database environments.

Upon completing this training, participants will be able to:

• Achieve a thorough grasp of Oracle RAC architecture and Grid Infrastructure, encompassing installation, configuration, and management.
• Build hands-on proficiency in administering Automatic Storage Management (ASM), covering disk group administration, instance tuning, and backup/recovery procedures.
• Master advanced RAC performance tuning methods, disaster recovery setups, and best practices for high availability.
• Cultivate troubleshooting and diagnostic skills to resolve issues in RAC and Grid Infrastructure settings.
• Understand how to patch and upgrade Oracle RAC and Grid Infrastructure while reducing downtime and ensuring stability.

This live, instructor-led training, delivered either online or onsite, is designed for beginner-level data professionals aiming to acquire the skills necessary to design, implement, and manage SSIS packages for data integration and transformation objectives.

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

• Comprehending the structure and key elements of SSIS.
• Building and executing ETL processes utilizing SSIS.
• Utilizing SSIS utilities to create, roll out, and administer data integration strategies.
• Resolving issues and optimizing SSIS packages to ensure peak performance and stability.