Agile + DevOps West 2020 Tutorial: CI/CD Tools for Database Development


Tuesday, June 9, 2020 - 9:00am to 12:30pm

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.

Blaine Carter

Blaine Carter is the Oracle developer advocate for open source. He applies his exploratory eye and tinkering inclinations to the intersection of open source and Oracle Database. He helps database developers improve their workflow using open source tools and promotes the use of open source inside and outside of Oracle. Blaine started programming in 1995. For most of his career, he has used Oracle tools to build applications. Blaine has worked with Oracle Forms and Oracle Reports and even created a framework to generate web applications using PL/SQL similar to Oracle Application Express. He has done a little Java, both inside and outside the database, and of course a whole bunch of SQL and PL/SQL. Blaine is a firm believer in learning by doing, failing, figuring it out, and then sharing.