Most often, Java developers are very skilled when it comes to programming languages, design patterns, frameworks and everything that's related to their programming language of choice. However, the database is still uncharted territory, usually treated as a black box that we throw queries at and expect it to respond in no time. With this training, I want to get Java developers get to know more about RDBMS so that they can design their application data access layer accordingly.
In this workshop, we are going through various data access performance optimizations that are relevant for a great variety of Java Persistence frameworks.
Therefore, we are going to discuss:
- The best way to do database schema migrations.
- Effective JDBC logging.
- How to assert the automatically generated SQL statements during testing.
- How to monitor database connection usage and provision connection pools.
- How to use JDBC batching and speed up write operations.
- How to use Statement caching efficiently to speed up read operations.
- Fetching best practices.
All in all, after attending this workshop, you'll know all sorts of tips that you can readily apply to your current enterprise project.
As prerequisites, you need a laptop, Java 1.8, Maven, PostgreSQL, and an Internet connection.
I've done this workshop both on-site and as a conference workshop (e.g. Voxxed Days Zurich), and I got very good feedback