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

This live, instructor-led curriculum in US (delivered online or onsite) targets mid-level database administrators and IT professionals aiming to implement and manage ASM solutions within Oracle Database 19c.

Following the completion of this course, participants will be equipped to:

• Oversee the administration and lifecycle management of ASM instances and disk group structures.
• Deploy and maintain ACFS (Automatic Storage Management Cluster File System) environments.
• Execute failover procedures for client databases utilizing Flex ASM capabilities.
• Diagnose and remediate standard operational challenges associated with ASM.

This instructor-led, live training conducted in US (online or on-site) is designed for database administrators and developers intending to leverage Microsoft Azure Cosmos DB to build and oversee highly responsive, low-latency applications.

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

• Provision essential Cosmos DB resources to initiate database and application development.
• Enhance application performance and storage efficiency through the utilization of Cosmos DB APIs.
• Optimize Cosmos DB resources to manage database operations and reduce operational costs.

This training module on Oracle Database 19c Clusterware Administration provides an in-depth examination of fundamental cluster principles and the underlying architecture of Oracle Clusterware for government environments.

Skills Gained

• Detail the architecture of Clusterware and its associated cluster services

• Define the primary objectives and operational goals of Oracle Clusterware

• Clarify the mechanisms of Oracle Clusterware fencing

• Implement cluster time synchronization protocols

• Demonstrate effective network resource management techniques

• Identify the operating system requirements necessary for Oracle Clusterware deployment

Oracle Database 19c operates as a multi-model database, delivering comprehensive support for both relational and non-relational data workloads.

This instructor-led live training program, available online or on-site, targets intermediate-level system and database administrators. The curriculum focuses on the administration, monitoring, security, backup, and recovery of Oracle Database 19c in Standard Edition 2 environments. It also provides a structured approach for planning the migration from Oracle 11g to 19c.

Upon completion, participants will be equipped to:

• Prepare the infrastructure and execute clean installations and configurations of Oracle Database 19c Standard Edition 2.
• Articulate the functions of Oracle infrastructure components, including the SGA, PGA, Shared Pool, Database Buffer Cache, and Redo mechanisms.
• Utilize administrative tools, such as Enterprise Manager Express and SQL Developer, to manage daily operational tasks.
• Apply storage management best practices regarding tablespaces, datafiles, and segment space allocation.
• Enforce database security standards by managing users, roles, privileges, profiles, and auditing trails.
• Formulate and implement RMAN-based backup and recovery strategies that align with defined RTO/RPO objectives.
• Monitor and resolve performance issues through dynamic performance views, SQL tracing, and execution plan analysis.
• Plan and execute the transition from Oracle 11g to 19c, utilizing officially supported upgrade paths and tools.

Instructional Delivery Model

• Interactive lecture sessions combined with facilitated discussions.
• Extensive practical exercises and skill reinforcement activities.
• Live laboratory environments for hands-on implementation and application.

Customization Options for Government Training Programs

• Agencies may request tailored training modules for this course by contacting the provider to arrange specific curriculum adjustments.

This instructor-led, live training program, conducted in US (either online or onsite), is designed for system administrators seeking proficiency in the administration, monitoring, and support of Oracle database environments for government operations.

Upon completion of this curriculum, participants will possess the capability to:

• Comprehend the principal feature enhancements and architectural modifications in Oracle database systems.
• Administer and monitor Oracle database instances effectively.
• Optimize the performance metrics of Oracle database deployments.

This instructor-led, live training in US (online or on-site) is tailored for entry-level database administrators responsible for managing data protection and restoration tasks in Oracle Database 19c. It is designed to support robust data governance for government applications.

Upon completion, participants will be capable of:

• Understanding core data protection concepts in Oracle Database 19c, including system architecture and failure typologies.
• Gaining practical experience in configuring protection settings, including the RMAN environment and Fast Recovery Area.
• Developing skills in executing various backup and restoration operations, such as full, incremental, and point-in-time recovery.
• Leveraging Oracle Flashback technology for effective restoration and managing disaster recovery scenarios.
• Applying best practices for data protection and disaster recovery to ensure high availability and reduce downtime in Oracle Database 19c environments.

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

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

• Comprehend the architecture and strategic benefits of Oracle Data Guard for disaster recovery and high availability.
• Acquire hands-on proficiency in configuring and managing physical and logical standby databases, including the Data Guard broker.
• Develop practical competencies in monitoring, troubleshooting, and optimizing Data Guard environments to ensure optimal performance.
• Master advanced features such as Active Data Guard, Data Guard integration with RAC, and securing Data Guard communications.
• Apply best practices for disaster recovery planning, maintaining data consistency, and automating Data Guard operations for government contexts.

This instructor-led, live training session in US (online or on-site) is tailored for entry-level database administrators aiming to ensure they are adequately prepared to manage and optimize Oracle environments for government systems.

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

• Understanding the core features and architecture of Oracle Database 19c, including system requirements and installation procedures.
• Gaining practical proficiency in installing Oracle Database 19c and Oracle Grid Infrastructure, including the configuration of network, storage, and security parameters.
• Learning the full scope of the upgrade process to Oracle Database 19c, from preliminary planning to post-upgrade verification.
• Developing troubleshooting competencies to address typical issues during installation and upgrade activities.
• Applying industry best practices for Oracle Database installation and upgrading to ensure efficient and successful deployment for government purposes.

This instructor-led, live training in US (delivered online or onsite) is tailored for intermediate-level database administrators tasked with managing and optimizing multitenant infrastructure.

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

• Analyzing the fundamental components and strategic benefits of Oracle Database 19c’s multitenant architecture, specifically regarding CDBs and PDBs.
• Executing the installation, configuration, and administration of container databases (CDBs) and pluggable databases (PDBs).
• Deploying security controls, backup and recovery protocols, and performance tuning measures within multitenant contexts.
• Managing high availability and disaster recovery mechanisms, including the configuration of Data Guard and Oracle RAC in multitenant settings.
• Utilizing diagnostic techniques and established best practices to ensure the integrity, efficiency, and reliability of multitenant database operations.

This instructor-led, live training in US (online or onsite) is intended for intermediate-level database administrators and IT professionals aiming 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.

This instructor-led, live training in US (online or on-site) is designed for intermediate-level database administrators who need to manage and optimize complex, high-availability Oracle database environments, particularly those critical for government operations.

Upon completion of this training, participants will be capable of:

• Acquiring a thorough understanding of Oracle RAC architecture and Grid Infrastructure, including deployment, configuration, and ongoing management.
• Developing practical proficiency in managing Automatic Storage Management (ASM), including disk group administration, instance tuning, and backup/recovery procedures.
• Mastering advanced RAC performance tuning techniques, disaster recovery configurations, and high-availability best practices.
• Gaining troubleshooting and diagnostic expertise to resolve issues within RAC and Grid Infrastructure environments.
• Understanding the procedures for patching and upgrading Oracle RAC and Grid Infrastructure while minimizing service interruption and maintaining system stability.

SQL Server Analysis Services (SSAS) is a Microsoft SQL Server component designed for Online Analytical Processing (OLAP) and data mining. It facilitates the analysis of data spanning multiple databases, tables, or files. The semantic data models generated by SSAS serve client applications, including Power BI, Excel, Reporting Services, and other data visualization tools, to support informed decision-making for government

In this instructor-led training (available onsite or remote), participants will acquire the skills necessary to utilize SSAS for analyzing extensive data volumes within databases and data warehouses.

Upon completion of this training, participants will be proficient in:

• Installing and configuring SSAS
• Comprehending the interoperability between SSAS, SSIS, and SSRS
• Applying multidimensional data modeling to derive business insights from data
• Designing OLAP (Online Analytical Processing) cubes
• Querying and manipulating multidimensional data via the MDX (Multidimensional Expressions) query language
• Deploying enterprise-grade BI solutions using SSAS

Target Audience

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

Course Format

• Interactive instruction and facilitation
• Extensive exercises and practical application
• Hands-on implementation in a live laboratory environment

Customization Options

• This curriculum is aligned with the latest versions of Microsoft SQL Server and SSAS.
• To arrange customized training tailored to specific needs, please contact the course provider.

This instructor-led, live training in US (delivered online or onsite) is intended for entry-level data professionals seeking to develop proficiency in designing, implementing, and managing SSIS packages for data integration and transformation tasks for government.

Upon completion of this training, participants will be proficient in:

• Understanding the architectural structure and components of SSIS.
• Designing and executing ETL processes utilizing SSIS.
• Utilizing SSIS tools to develop, deploy, and oversee data integration solutions.
• Diagnosing and optimizing SSIS packages to ensure performance and reliability.

SQL Server Integration Services (SSIS) constitutes a core component of Microsoft SQL Server, establishing the foundation for data integration and workflow automation. This technology facilitates critical operations in data migration, warehousing, and transformation for government applications.

This instructor-led, live training module (delivered online or onsite) is specifically tailored for intermediate-level data professionals and developers. The curriculum emphasizes the design of advanced SSIS data flows, transformation logic, and the management of Slowly Changing Dimensions (SCD) within data warehousing contexts for government systems.

Upon successful completion of this training, participants will demonstrate the ability to:

• Design and deploy resilient data flow architectures using SSIS.
• Effectively interface with diverse data sources, targets, and transformation components.
• Implement Slowly Changing Dimensions (SCD) to manage historical data revisions.
• Execute, deploy, and resolve technical issues with SSIS packages effectively.

Course Format

• Interactive instruction and facilitated discussion.
• Extensive practical exercises and scenario-based practice.
• Hands-on implementation within a live-lab environment.

Customization Options

• To arrange tailored training for this curriculum, please contact our team for scheduling and alignment.