CI/CD Tools for Database Development
The database is one of the most critical components of just about any application. Unfortunately, it is also often overlooked when it comes to automating the development process. Too often database changes simply take the form of "a bunch of scripts we hope work". The good news is that there are a lot of tools available to help automate and test database changes, many of them are open source. In this hands-on workshop, experience Open Source tools you can use to help integrate your Database application development into your CI/CD pipeline. Begin by using a schema migration tool to manage changes to your database schema. Generate SQL statements, deploy and rollback changes to your database schema, and automatically generate documentation. When your database supports code that is run internally, you need to be able to test that code. In this workshop, learn to write and execute tests for code that has been deployed inside the database and generate reports from the results. Finally, learn how to integrate these tools into a CI/CD pipeline allowing you to include the database component of you applications into your automated work-flow.