Beginning jOOQ: Learn to Write Efficient and Effective Java-Based SQL Database Operations

Table of Contents
About the Author
About the Technical Reviewer
Chapter 1: Welcome to jOOQ
	Database Operations in Java: The Good Parts
	Database Operations in Java: The…Not So Good Parts
		You Have Got to Be jOOQing
	jOOQ Feature Tour
		Database Aware
		Code Generation
		Type Safety
		Domain-Specific Language
		Tooling Support
		JVM Languages
Chapter 2: Getting Started with jOOQ
	Eden Auto Mart
	Setting Up jOOQ
		Install Dependencies for Commercial-Licensed jOOQ
	CRUD with jOOQ
		Your SQL Dialect and You
		Tools of CRUD in jOOQ
		Select Statements
			The SELECT DSL
			With the WHERE DSL
				Conditions
			Subqueries
			Conditional Logic in Queries
			With the… WITH Clause
			With the GROUP BY DSL
				With the HAVING DSL
			With the ORDER BY DSL
				ORDER BY CASE
			ORDER BY NULL
			Paginate Query Results
		Insert Statements
			With Multiple Rows
			With Sequences
			With Select
		Update Statements
		Delete Statements
			Tuple Syntax
		Alternative Data Access Modes
			Streaming Access
			Lazy Access
	Transactions
		With Locking
	Configuration
		Connection Management
		Schema, Catalog, and Multi-tenant Deployment
		Query Management
		Query Lifecycle Integration
Chapter 3: Working with jOOQ
	Generating Code
		Tools of jOOQ Code Generation
			Configure jOOQ for Code Generation
			Generate Code with Maven
			Generate Code from the Command Line
			Generate Code Programmatically
			Results of Code Generation
				Tables
				Global Artifacts
			Add Custom Code to Generated Code
	Working with Generated Code
		CRUD with Generated Code
			Enhancements from UpdatableRecord
				Formatting
			Optimistic Locking
	Advanced Database Operations
		Joins
			Non-SQL Grouping
		Batch Operations
			Explicit Batching
			Batch Import
		Advanced Query Syntax
			Merge and Upsert
			Window Functions
Chapter 4: Integrating with jOOQ
	Java Persistence API with jOOQ
		Generate JPA Entities
		Generate from JPA Entities
		Generate SQL Queries
	Spring Boot and jOOQ
		Configure jOOQ in Spring Boot
			With Custom SQL
			jOOQ Spring Boot Starter
	Quarkus and jOOQ
Chapter 5: Packaging and Testing jOOQ
	Package Code with jOOQ
		When You Don’t Need Code Generation
		When You Don’t Have an Active Database Connection
		When Your Schema Needs to Incrementally Evolve
			Recipe for a Self-Sufficient Database Project
	Testing with jOOQ
		Tools of the (SQL) Testing Trade
		Unit Testing with jOOQ
			Using Mockito
			With SQL Parsing
		Integration Testing with Docker and TestContainers
			With Spring Boot
Index