jOOQ Masterclass: A practical guide for Java developers to write SQL queries for complex database interactions

Table of Contents

1. Starting jOOQ and Spring Boot
2. Customizing the jOOQ Level of Involvement
3. jOOQ Core Concepts
4. Building a DAO Layer (Evolving the Generated DAO Layer)
5. Tackling Different Kinds of SELECT, INSERT, UPDATE, DELETE, and MERGE Statements.
6. Tackling Different Kinds of JOIN Statements
7. Types, Converters, and Binding
8. Fetching and Mapping
9. CRUD, Transactions, and Locking
10. Exporting, Batching, Bulking, and Loading
11. jOOQ Keys
12. Pagination and Dynamic Queries
13. Exploiting SQL Functions
14. Derived Tables, CTEs, and Views
15. Calling and Creating Stored Functions and Procedures
16. Tackling Aliases and SQL Templating
17. Multitenancy in jOOQ
18. jOOQ SPI (Providers and Listeners)
19. Logging and Testing