Intermediate

Liquibase Commands for Troubleshooting (LB201)


Description
For users who wish to gain a deeper understanding of all the available Liquibase commands and their practical application for troubleshooting purposes. It includes topics such as using commands for preventing and recovering from common errors, monitoring your deployments, and database migrations.
To begin, select the " Liquibase Commands for Troubleshooting welcome video" under the Welcome section.

Content
  • Welcome
  • Liquibase Commands for Troubleshooting Welcome Video
  • Purpose of this Course
  • Course Requirements - Technical Environment
  • Course Requirements - Learner Knowledge
  • Module 1: Using Fundamental Commands
  • Module 1: Overview and Learning Objectives
  • Module 1 Tutorial: The Liquibase Project Directory and Source Control Systems
  • Module 1 Tutorial: Running Commands in your CLI
  • Module 1 Video: Configuring Liquibase
  • Module 1 Tutorial: The Liquibase Properties File
  • Module 1 Video: The Liquibase Developer Workflow
  • Module 1 Tutorial: SQL Command Best Practices & Information
  • Module 1 Tutorial: Using the update Command
  • Activity 1: Verification of Database Changes
  • Activity 2: Deployment of Database Changes
  • Module 1 Video: Rollback Overview
  • Module 1 Tutorial: Rollback Commands Review
  • Activity 3: Rolling Back Changes
  • Module 1 Tutorial: Use Cases for Using the snapshot Command
  • Module 1 Tutorial: Using the snapshot Command
  • Activity 4: Generate a Snapshot
  • Module 1 Video: Overview of the diff & diffChangeLog Commands
  • Module 1 Tutorial: Use Cases for Using the diff & diffChangeLog Commands
  • Module 1 Tutorial: Using the diff Command
  • Module 1 Tutorial: Comparing Snapshots to a Database
  • Module 1 Tutorial: Using the diffChangeLog Command
  • Activity 5: Performing Database Comparisons
  • Module 1: Knowledge Check
  • Module 2: Preventing Common Errors
  • Module 2: Overview and Learning Objectives
  • Module 2 Tutorial: Types of Common Changelog Errors
  • Module 2 Tutorial: Using the validate Command
  • Activity 6: 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 updateTestingRollback Command
  • Module 2 Tutorial: Using the futureRollbackSQL Command
  • Activity 7: Validating the SQL for Future Rollbacks
  • Activity 8: Testing a Rollback
  • Module 2: Knowledge Check
  • Module 3: Recovering from Common Errors
  • Module 3: Overview and Learning Objectives
  • Module 3 Tutorial: Databasechangeloglock & Databasechangelog Overview
  • Module 3 Tutorial: Use Cases for Managing Locks
  • Module 3 Tutorial: Using the listLocks command
  • Module 3 Tutorial: Using the releaseLocks command
  • Module 3 Video: What is a Checksum?
  • Module 3 Tutorial: Resolving Errors with Checksums
  • Module 3 Tutorial: Using the clearCheckSums Command
  • Activity 9: Recover from an MD5Sum Check Failure
  • Module 3 Tutorial: Use Cases for Marking Changesets as Ran
  • Module 3 Tutorial: Using markNextChangeSetRan & markNextChangeSetRanSQL
  • Activity 10: Mark a Bad Changeset as nextChangeSetRan
  • Module 3: Knowledge Check
  • Module 4: Monitoring your Deployments
  • Module 4: Overview and Learning Objectives
  • 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 11: Checking the Status of Pending Changesets
  • Module 4 Tutorial: Use Cases for Checking your Deployment History
  • Module 4 Tutorial: Using the History Command
  • Activity 12: Checking your Deployment History
  • Module 4 Tutorial: Use Cases for Identifying Unexpected Changesets
  • Module 4 Tutorial: Using the unexpectedChangeSets Command
  • Activity 13: Identifying Unexpected Changesets
  • Module 4 Tutorial: Use Cases for Generating Database Change Documents
  • Module 4 Tutorial: Using the dbDoc Command
  • Activity 14: Generating Database Change Documents
  • Module 4: Knowledge Check
  • Module 5: Database Migrations
  • Module 5: Overview and Learning Objectives
  • Module 5 Video: Implementing Version-based Database Migrations
  • Module 5 Tutorial: Databasechangeloglock & Databasechangelog Overview
  • Module 5 Tutorial: Use Cases for Setting Tags
  • Module 5 Tutorial: Using Tags
  • Module 5 Tutorial: Using the Rollback by Tag Command
  • Activity 15: Adding a Tag to your DATABASECHANGELOG Table and Erasing changesets
  • Module 5 Tutorial: Using the updateToTag Command
  • Activity 16: Running updateToTag to Deploy changesets to the Tag
  • 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: 1 year