Intermediate

Liquibase Commands for Troubleshooting (LB201)


Description
For users who wish to learn more about available Liquibase commands beyond the basics. Includes commands such as listlocks, snapshot, and clear-checksums.
The commands are grouped into functional areas such as preventing and recovering from common errors, monitoring your deployments, and database migrations.

The course includes various practice activities, learning videos, and knowledge checks to help gauge your understanding of the course content. Estimated course length: 4 hours.

Content
  • Welcome
  • Liquibase Commands for Troubleshooting Welcome Video
  • Welcome to the Liquibase Commands for Troubleshooting Course
  • Technical Environment
  • Learner Knowledge
  • Module 1: Liquibase Review
  • Module 1 Tutorial: The Liquibase Project
  • Module 1 Tutorial: The Command Line Interface (CLI)
  • Module 1 Tutorial: The Liquibase Properties File
  • Module 1 Tutorial: Using Liquibase SQL Commands
  • Module 1: Knowledge Check
  • Module 2: Preventing Common Errors
  • Module 2 Tutorial: Types of Common Changelog Errors
  • Module 2 Tutorial: Using the validate Command
  • Activity: Validate a Changelog
  • Module 2 Tutorial: Why You Should Validate Rollbacks
  • Module 2 Tutorial: Auto-generated vs Custom Rollbacks
  • Module 2 Video: Rolling back vs Rolling Forward
  • Module 2 Tutorial: Using the update-testing-rollback Command
  • Module 2 Tutorial: Using the future-rollback-sql Command
  • Activity: Validating the SQL for Future Rollbacks
  • Activity: Testing a Rollback
  • Module 2: Knowledge Check
  • Module 3: Recovering from Common Errors
  • Module 3 Tutorial: Use Cases for Managing Locks
  • Module 3 Tutorial: Using the list-locks command
  • Module 3 Tutorial: Using the release-locks command
  • Module 3 Video: What is a Checksum?
  • Module 3 Tutorial: Resolving Errors with Checksums
  • Module 3 Tutorial: Using the clear-checksums Command
  • Activity: Recover from an MD5Sum Check Failure
  • Module 3 Tutorial: Use Cases for Marking Changesets as Ran
  • Module 3 Tutorial: Using the mark-next-changeset-ran Command
  • Activity: Mark a Bad Changeset as nextChangeSetRan
  • Module 3: Knowledge Check
  • Module 4: Monitoring your Deployments
  • Module 4 Video: Monitoring Deployments
  • Module 4 Tutorial: Use Cases for Checking the Status of Pending Changesets
  • Module 4 Tutorial: Using the status Command
  • Activity: Checking the Status of Pending Changesets
  • Module 4 Tutorial: Use Cases for Checking Deployment History
  • Module 4 Tutorial: Using the history Command
  • Activity: Checking your Deployment History
  • Module 4 Tutorial: Use Cases for Identifying Unexpected Changesets
  • Module 4 Tutorial: Using the unexpected-changesets Command
  • Activity: Identifying Unexpected Changesets
  • Module 4 Tutorial: Use Cases for Generating Database Change Documents
  • Module 4 Tutorial: Using the db-doc Command
  • Module 4: Knowledge Check
  • Module 5: Database Migrations
  • Module 5 Video: Implementing Version-based Database Migrations
  • Module 5 Tutorial: Use Cases for Setting Tags
  • Module 5 Tutorial: Using Tags
  • Module 5 Tutorial: Using the Rollback by Tag Command
  • Activity: Add a Tag to your DATABASECHANGELOG Table and Remove Changesets
  • Module 5 Tutorial: Using the update-to-tag Command
  • Module 5: Knowledge Check
  • Course Evaluation
  • Liquibase Commands for Troubleshooting Course Evaluation
Completion rules
  • All units must be completed
  • Leads to a certification with a duration: Forever