Advanced

Liquibase Pro (LB301)


Description
For new and existing Liquibase users who wish to learn more about Liquibase Pro. Course topics include provisioning Pro capabilities in automation, which rollbacks to use for hotfixes, using native executors, and how to build quality gates into automation using quality checks.

Estimated time for completion is 45 minutes.

Content
  • Introduction
  • Course Introduction
  • Learning Environment
  • Liquibase Help Resources
  • Environment Variables
  • Working with Liquibase Environment Variables
  • Benefits of Environment Variables
  • Using Liquibase Environment Variables
  • Setting Liquibase Environment Variables
  • Demonstrating Setting Liquibase Environment Variables
  • Liquibase Pro Environment Variables Best Practices
  • Quality Checks
  • Liquibase Quality Checks
  • How Quality Checks Work
  • Using Quality Checks
  • Configuring Quality Checks
  • Demonstrating Quality Checks in the SDLC
  • Stored Logic
  • What is Stored Logic?
  • Demonstrating Using Stored Logic with Liquibase Pro
  • Stored Logic Versioning
  • Stored Logic and Database Drift
  • Targeted Rollbacks
  • Liquibase Pro Targeted Rollback Commands
  • Targeted Rollback Commands
  • The Rollback-One-Update Command
  • The Rollback-One-Changeset Command
  • Demonstrating the rollback-one-changeset Command
  • Native Executors
  • Introduction to Native Executors
  • Benefits of Using Native Executors
  • SQL Plus, SQLCMD, and PSQL Integrations
  • Demonstrating Using SQL Plus and SQLCMD
  • Native Executor Best Practices
  • Course Survey
  • Liquibase Pro Course Survey
Completion rules
  • All units must be completed
  • Leads to a certificate with a duration: Forever