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

This live, instructor-led training is delivered in Latvia (either online or on-site) and is tailored for database administrators or developers seeking to leverage Microsoft Azure Cosmos DB to build and manage highly responsive, low-latency applications.

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

• Provision the essential Cosmos DB resources required to initiate the development of databases and applications.
• Enhance application performance and storage scalability by leveraging Cosmos DB APIs.
• Streamline database operations and control expenses by optimizing Cosmos DB resources.

This instructor-led live training session, conducted in Latvia (either online or onsite), is specifically tailored for system administrators seeking to master the administration, monitoring, and support of Oracle databases.

By the conclusion of the course, participants will have the capability to:

• Understand the key feature developments and architectural modifications in Oracle database systems.
• Manage and monitor Oracle databases effectively.
• Enhance the performance of Oracle databases.

This live, instructor-led training, conducted in Latvia (either online or on-site), is designed for novice database administrators looking to manage backup and recovery functions in Oracle Database 19c.

By the conclusion of this session, attendees will be capable of:

• Comprehending the core concepts of backup and recovery in Oracle Database 19c, including the system architecture and different failure modes.
• Gaining practical experience in configuring backup and recovery settings, particularly the RMAN environment and fast recovery area.
• Developing practical skills to perform various backup and recovery operations, such as full, incremental, and point-in-time recovery.
• Learning to apply Oracle’s Flashback technology for effective database restoration and managing disaster recovery scenarios.
• Applying best practices for backup, recovery, and disaster recovery to ensure data availability and minimize downtime in Oracle Database 19c.

This instructor-led live training in Latvia (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 end of this training, participants will be able to:

• Comprehend the architectural design and advantages of Oracle Data Guard in facilitating disaster recovery and high availability.
• Acquire hands-on proficiency in setting up and maintaining physical and logical standby databases, including the use of the Data Guard broker.
• Cultivate practical abilities in monitoring, troubleshooting, and fine-tuning Data Guard environments to ensure peak performance.
• Master advanced functionalities such as Active Data Guard, Data Guard integration with RAC, and the security of Data Guard communications.
• Implement industry best practices for disaster recovery planning, data consistency assurance, and the automation of Data Guard operations.

This live, instructor-led training in Latvia (online or onsite) is tailored for entry-level database administrators looking to solidify their ability to manage and optimize Oracle environments.

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

• Comprehend the essential features and architecture of Oracle Database 19c, along with system prerequisites and installation approaches.
• Build practical competencies in installing Oracle Database 19c and Oracle Grid Infrastructure, including the setup of network, storage, and security configurations.
• Navigate the full upgrade cycle to Oracle Database 19c, from initial planning through to post-upgrade verification.
• Enhance troubleshooting abilities to manage typical issues during the installation and upgrade phases.
• Utilize best practices for Oracle Database installation and upgrading to ensure a smooth and effective deployment.

This live, instructor-led training, conducted in Latvia (either online or onsite), is designed for intermediate database administrators looking to efficiently manage and optimize multitenant environments.

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

• Understanding the essential elements and benefits of Oracle Database 19c’s multitenant architecture, including CDBs and PDBs.
• Developing practical skills in the installation, configuration, and management of Container Databases (CDBs) and Pluggable Databases (PDBs).
• Cultivating proficiency in applying security measures, backup and recovery strategies, and performance tuning within multitenant frameworks.
• Learning to oversee high availability and disaster recovery in multitenant setups, including Data Guard and Oracle RAC configurations.
• Gaining troubleshooting expertise and best practices for sustaining a secure, efficient, and dependable multitenant database environment.

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

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

• Develop a comprehensive understanding of Oracle RAC architecture and Grid Infrastructure, including installation, configuration, and management.
• Enhance practical skills in managing Automatic Storage Management (ASM), including disk group administration, instance tuning, and backup/recovery.
• Master advanced RAC performance tuning techniques, disaster recovery setups, and best practices for high availability.
• Improve troubleshooting and diagnostic abilities for addressing issues in RAC and Grid Infrastructure environments.
• Understand the patching and upgrade workflows for Oracle RAC and Grid Infrastructure, focusing on minimizing downtime and maintaining stability.

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

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

• Comprehend the architecture and components of SSIS.
• Design and implement ETL processes using SSIS.
• Utilize SSIS tools to develop, deploy, and manage data integration solutions.
• Troubleshoot and optimize SSIS packages to ensure high performance and reliability.

This instructor-led program in Latvia is dedicated to the design of advanced SSIS data flows and transformations. Participants will gain mastery over Slowly Changing Dimensions, learn to manage complex data sources, and deploy robust packages to streamline data warehousing and migration workflows.