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.
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.
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).
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.