Application code has run through pipelines for years, database changes are often still deployed by hand. The workshop shows how schema, PL/SQL, APEX and ORDS are versioned, tested and rolled out automatically.
Audience
Developers, DBAs and platform teams who want to automate database deployments.
Modules
The modules are building blocks. You choose and weight them, and we agree on the agenda together beforehand.
- Versioning: database objects in Git, project structure, branching
- SQLcl Projects: capturing changes, building releases, generating deployments
- Liquibase: changelogs, rollbacks, environments
- Tests: utPLSQL, test data, code coverage
- Code quality: linting, conventions, reviews
- Pipelines: GitLab CI/CD or Azure DevOps, environments, approvals
- Infrastructure: provisioning databases with Terraform and Ansible
Outcome
A pipeline that takes changes to your schema reproducibly from development to production.
Preview
For a first look: the talks on this topic give you an overview, and the talk pages include the slides.
- Automatically Deploy Schema Changes with Ansible and Liquibase RMOUG Training Days 2022
- Automate Database Deployments with SQLcl ODTUG Learn from Home 2020
What every workshop includes
- Duration
- Base length 2 × 8 hours. Every workshop is also available as a one-day overview or as a 3 to 4 day deep dive.
- Tailored
- Built around your requirements. You pick the modules and decide how much time we spend on each.
- Materials
- All slides, sample scripts and other materials are handed over to you.
- Price
- Fixed workshop fee, independent of the number of participants.
- Location
- On site, remote or a mix of both.
- Schedule
- In one block or spread across several dates.
Interested in this workshop?
Tell me which topics matter to you. We will then agree on modules, scope and dates together.
Request a workshop