Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Overview of Database Modernization Initiatives
- Rationale for transitioning from proprietary systems to open-source platforms
- Comparative analysis of architecture between Oracle/SQL Server and PostgreSQL
- Identification of prevalent migration risks and determinants of project success
- Survey of established migration frameworks and methodologies
Pre-Migration Assessment and Strategic Planning
- Comprehensive database inventory and dependency mapping
- Evaluation of schema complexity and structural requirements
- Assessment of application compatibility with target systems
- Development of a structured migration roadmap and implementation timeline
Schema Conversion Methodologies
- Transformation of Oracle data types for PostgreSQL compatibility
- Translation of SQL Server data types to open-source equivalents
- Conversion of relational table structures
- Mapping of indexes and database constraints
Migration of Database Objects: Stored Procedures and Functions
- Translation of PL/SQL logic to PL/pgSQL
- Techniques for T-SQL code conversion
- Identification of equivalent built-in functions
- Restructuring of packages and procedural logic for the target environment
Data Migration Tools and Operational Techniques
- Utilization of standard utilities such as pg_dump and pg_restore
- Employment of Oracle Foreign Data Wrappers (FDW) for migration support
- Use of SQL Server Integration Services for data transfer
- Strategies for the efficient handling of large-scale datasets
Application Code Adaptation
- Differentiation between JDBC and ODBC driver implementations
- Required modifications to connection strings
- Addressing disparities in SQL dialects within application logic
- Management of proprietary features to ensure functional parity
Testing, Validation, and Quality Assurance
- Verification of data integrity across migrated systems
- Implementation of comprehensive functional testing protocols
- Performance benchmarking against established baselines
- Planning for parallel operations and final cutover procedures
Post-Migration Optimization and Maintenance
- Query performance tuning specific to PostgreSQL environments
- Configuration adjustments to support migrated workloads for government operations
- Establishment of monitoring frameworks and alerting mechanisms
- Guidelines for ongoing system maintenance and lifecycle management
Troubleshooting Common Migration Challenges
- Analytical review: Case studies of Oracle migration complexities
- Analytical review: Case studies of SQL Server migration complexities
- Development and execution of rollback strategies
- Documentation of lessons learned and adherence to best practices
Practical Migration Workshop
- Step-by-step migration of a representative schema
- Exercises in data extraction and loading procedures
- Hands-on practice in code conversion techniques
- Validation and verification drills to ensure system readiness
Requirements
**Prerequisite Knowledge**
* Foundational comprehension of relational database architectures.
* Proficiency in Structured Query Language (SQL).
* Awareness of core principles governing database administration and management.
**Target Audience**
This curriculum is designed for government personnel, including:
* Database Administrators responsible for data infrastructure.
* Application Developers building compliant software solutions.
* IT Architects tasked with enterprise system design and integration.
14 Hours
Testimonials (2)
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
