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
Course Program
Module 1: Introduction to CI/CD in Oracle APEX
- Key concepts of CI/CD applied to APEX
- Common challenges in manual deployments
- Particularities of Oracle APEX compared to other frameworks
- Compatibility of CI/CD practices between APEX 19 and later versions
- Definition of environments: DEV, QA, UAT, PROD
Module 2: Version Management for APEX Applications
- What to version in an APEX project?
- Versioning of applications, pages, and components
- Handling structural and functional changes
- Versioning strategies (semantic and practical)
- Change traceability and auditing
Module 3: Using SQLcl for APEX
- Introduction to SQLcl and its role in CI/CD
- Exporting APEX applications
- Exporting associated objects (tables, packages, views)
- Controlled import between environments
- Managing credentials and sensitive parameters
- Best practices for reusable scripts
Module 4: Integration with Version Control (Git)
- Repository structure for APEX projects
- Versioning of exported applications
- Managing branches for APEX
- Collaborative work strategies
- Resolving common conflicts
- Recommendations for teams migrating from manual schemes
Module 5: Deployment Strategies Between Environments
- Designing deployment pipelines for APEX
- Manual vs automated deployment
- Pre-deployment validations
- Change control and approvals
- Error handling and rollback
- Specific considerations for production environments
Module 6: Deployment Automation and Best Practices
- Introduction to APEX deployment automation
- Integrating SQLcl with CI/CD pipelines (conceptual and practical)
- Best practices for repeatable deployments
- Security in automated processes
- Deployment checklist for APEX
- Recommendations for evolving to APEX 23+ without rebuilding the pipeline
Requirements
Requirements
- Basic knowledge of Oracle APEX.
- Previous experience developing or administering APEX applications.
- Basic knowledge of Oracle databases (SQL).
- No previous experience in CI/CD is required (recommended but not mandatory).
Target Audience
- Oracle APEX Developers
- APEX Application Administrators
- DevOps Engineers interacting with Oracle environments
- Technical Leaders responsible for deployments and change control
2 Hours
Testimonials (2)
It was one on one so I could show him my existing environment and discuss my real issues
Virendra Miglani - Westfraser Mills
Course - Developing Applications with Oracle Application Express (APEX)
Workflow and Task Definition
