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.
Duration 2 hours
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
- Particularities of Oracle APEX compared to other frameworks
- Compatibility of CI/CD practices between APEX 19 and later versions
- Defining environments: DEV, QA, UAT, PROD
Module 2: Versioning of APEX Applications
- What to version in an APEX project?
- Versioning applications, pages, and components
- Managing 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 across environments
- Managing credentials and sensitive parameters
- Best practices for reusable scripts
Module 4: Integration with Version Control (Git)
- Structuring repositories for APEX projects
- Versioning exported applications
- Managing branches for APEX
- Collaborative work strategies
- Resolving common conflicts
- Recommendations for teams migrating from manual schemes
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
- Deployment checklist for APEX
- Recommendations for evolving to APEX 23+ without redoing the pipeline
Requirements
Requirements
- Basic knowledge of Oracle APEX.
- Prior experience developing or administering APEX applications.
- Basic knowledge of Oracle databases (SQL).
- No prior 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
Testimonials (1)
Getting the hands on experience I needed Oracle Apex, learning how everything works, actually implementing and seeing how the applications work, the workflow etc.
