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.

<ASIN:1800566891>

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  BookWatch@i-programmer.info

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.