Course Outline
Course Outline
Module 1: Introduction to CI/CD in Oracle APEX
- Key CI/CD concepts applied to APEX
- Common challenges in manual deployments
- Specificities 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: Managing APEX Application Versions
- What to version in an APEX project?
- Versioning 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 imports between environments
- Handling credentials and sensitive parameters
- Best practices for reusable scripts
Module 4: Integration with Version Control (Git)
- Repository structuring for APEX projects
- Versioning exported applications
- Managing branches for APEX
- Collaborative work strategies
- Resolving common conflicts
- Recommendations for teams migrating from manual processes
Module 5: Deployment Strategies Across 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
- APEX deployment checklist
- 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 prior CI/CD experience required (recommended, but not mandatory).
Target Audience
- Oracle APEX Developers
- APEX Application Administrators
- DevOps Engineers working with Oracle environments
- Technical leaders responsible for deployments and change management
Testimonials (3)
The trainer was extremely well informed about the topic, and was easily able to problem solve issues that we encountered.
David Hummel - Honeywell Federal Manufacturing & Technologies, LLC.
Course - Low-Code Enterprise Application Development with Oracle APEX
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
