mobile menu icon
Continuous Delivery with Databases

The objective of this course is for students to learn how to evolve a database continuously and securely. In addition, we will cover different testing techniques, particularly useful in environments with databases that accumulate a lot of logic.

Through examples and katas, we will learn about refactoring techniques and how to evolve the database. Also, we will cover some smells and tools to deal with complex environments.

teaching logo Information

16 hours
On-site or remote
600€ / person
(V.A.T. not included)
For open dates 50% discount for underrepresented groups in technology
I'm interested!
// Contents
Day One
1. Challenges and principles
2. State-based & migration-based approaches
3. Further exploring the migration-based approach
Tools (SQL & DSLs)
Migration Implementation
Drifts
Conflicts
Handling numerous migrations
Rollback vs Forward

Day Two
4. Smells in Databases
5. Refactoring concept and flow
6. Refactors
7. Database Testing
8. TDD in Databases
// Languages

In the examples we will use SQL and any editor you are comfortable with, although we will look at some examples of DSLs in PHP and Java.

As for the database engine (Oracle, SQLServer...), most exercises are standalone but certain aspects may depend on it. Contact us to see how we can adapt it to your daily needs.

// Requirements
We will send you an email telling you everything you need to install before the course.
// Who is it intended for?

Mainly for programmers or DBAs who want to know more about how to evolve the database and have an array of automatic tests. It is especially useful for complex environments (multiple consumers, db logic, etc).

// In-house

The course will be conducted in-house (closed to the company that contracts it).

Please note that in-house courses are held once the client hires us. We will need to know the date one month in advance in order to be able to schedule them.

teaching logo Information

16 hours
On-site or remote
600€ / person
(V.A.T. not included)
For open dates 50% discount for underrepresented groups in technology
I'm interested!
¡OK! I am interested in taking the Continuous Delivery with Databases Course

If you wish to apply or if you still have any questions about this course, please contact us at contact@codesai.com or fill out the contact form.

We will try to get back to you as soon as possible!

Send Message