jOOQ Masterclass (Packt)
Monday, 05 September 2022

This book, subtitled "A practical guide for Java developers to write SQL queries for complex database interactions" covers jOOQ from beginner to expert level using examples for MySQL, PostgreSQL, SQL Server, and Oracle that show you how jOOQ is a mature and complete solution for implementing the persistence layer. Anghel Leonard shows how to use the jOOQ query builder framework to emulate database-specific SQL statements using a fluent, intuitive, and flexible DSL API.


The book shows how to use jOOQ in Spring Boot apps as a replacement for SpringTemplate and Spring Data JPA, and how to use jOOQ type-safe queries and CRUD operations via jOOQ's records, converters, bindings, types, mappers, multi-tenancy, logging, and testing. Later, the book shows how to use jOOQ to use SQL features such as UDTs, embeddable types and embedded keys.

Author: Anghel Leonard
Publisher: Packt Publishing
Date: August 2022
Pages: 764
ISBN: 978-1800566897
Print: 1800566891
Kindle: B09XHTBDJY
Audience: Java and database developers
Level: Intermediate
Category: Database and Java


  • Enable the jOOQ Code Generator in any combination of Java and Kotlin, Maven and Gradle
  • Generate jOOQ artifacts directly from database schema, or without touching the real database
  • Use jOOQ DSL to write and execute a wide range of queries for different databases
  • Understand jOOQ type-safe queries, CRUD operations, converters, bindings, and mappers
  • Implement advanced SQL concepts such as stored procedures, derived tables, CTEs, window functions, and database views
  • Implement jOOQ multi-tenancy, tuning, jOOQ SPI, logging, and testing



For recommendations of Java books see Java Books For Beginners, Java Books For Going Further and Advanced Java - Books Outside the Core in our Programmer's Bookshelf section.


For more Book Watch just click.

Book Watch is I Programmer's listing of new books and is compiled using publishers' publicity material. It is not to be read as a review where we provide an independent assessment. Some, but by no means all, of the books in Book Watch are eventually reviewed.

To have new titles included in Book Watch contact

Follow @bookwatchiprog on Twitter or subscribe to I Programmer's Books RSS feed for each day's new addition to Book Watch and for new reviews.




SQL Query Design Patterns and Best Practices

Author: Steve Hughes et al
Publisher: Packt Publishing
Pages: 270
ISBN: 978-1837633289
Print: 1837633282
Kindle: B0BWRD7HQ7
Audience: Query writers
Rating: 2.5
Reviewer: Ian Stirk

This book aims to improve your SQL queries using design patterns, how does it fare? 

Beginning Programming All-in-One For Dummies

Author: Wallace Wang
Publisher: For Dummies
Pages: 800
ISBN: 978-1119884408
Print: 1119884403
Kindle: B0B1BLY87B
Audience: Novice programmers
Rating: 3
Reviewer: Kay Ewbank

This is a collection of seven shorter books introducing key aspects of programming, but it fails through trying to cover too [ ... ]

More Reviews