jOOQ Masterclass

This is the code repository for jOOQ Masterclass , published by Packt.

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

What is this book about?

jOOQ Masterclass will help you write the coolest SQL statements without working with JDBC or handling ORM complexity and performance issues. This practical guide to jOOQ provides a hands-on approach with a complete and versatile set of solutions for implementing the persistence layer to serve the most stressful environments.

This book covers the following exciting features:

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

If you feel this book is for you, get your copy today!

Instructions and Navigations

All of the code is organized into folders. For example, Chapter02.

The code will look like the following:

public List<Office> findOfficesInTerritory(
                    String territory) {
  List<Office> result = ctx.selectFrom(table("office"))
    .where(field("territory").eq(territory))
    .fetchInto(Office.class);
  return result;
}

Following is what you need for this book: This book is for Java developers who write applications that interact with databases via SQL. No prior experience with jOOQ is assumed.

With the following software and hardware list you can run all code files present in the book (Chapter 1-19).

Software and Hardware List

Chapter	Software required	OS required
1	MySql	Windows and Linux
1	Postgres	Windows and Linux
1	SQL Server	Windows and Linux
1	Oracle	Windows and Linux

We also provide a PDF file that has color images of the screenshots/diagrams used in this book. Click here to download it.

Get to Know the Author

Anghel Leonard is a chief technology strategist and independent consultant with 20+ years of experience in the Java ecosystem. In his daily work, he is focused on architecting and developing Java-distributed applications that empower robust architectures, clean code, and high performance. He is also passionate about coaching, mentoring, and technical leadership. He is the author of several books, videos, and dozens of articles related to Java technologies.

Other books by the authors

Java Coding Problems

Data Stream Development with Apache Spark, Kafka, and Spring Boot [Video]

The Complete Coding Interview Guide in Java

Link to the readme

https://github.com/PacktPublishing/jOOQ-Masterclass/blob/master/README.md

zutjmx / jooq-masterclass Goto Github PK