You're reading from jOOQ Masterclass A practical guide for Java developers to write SQL queries for complex database interactions

Product type Paperback

Published in Aug 2022

Publisher Packt

ISBN-13 9781800566897

Length 764 pages

Edition 1st Edition

Languages

Java

Tools

Spring

Concepts

Database Programming

Author (1):

Anghel Leonard

View More author details

Table of Contents (26) Chapters

Preface

1. Part 1: jOOQ as a Query Builder, SQL Executor, and Code Generator

2. Chapter 1: Starting jOOQ and Spring Boot FREE CHAPTER

3. Chapter 2: Customizing the jOOQ Level of Involvement

4. Part 2: jOOQ and Queries

5. Chapter 3: jOOQ Core Concepts

6. Chapter 4: Building a DAO Layer (Evolving the Generated DAO Layer)

7. Chapter 5: Tackling Different Kinds of SELECT, INSERT, UPDATE, DELETE, and MERGE

8. Chapter 6: Tackling Different Kinds of JOINs

9. Chapter 7: Types, Converters, and Bindings

10. Chapter 8: Fetching and Mapping

11. Part 3: jOOQ and More Queries

12. Chapter 9: CRUD, Transactions, and Locking

13. Chapter 10: Exporting, Batching, Bulking, and Loading

14. Chapter 11: jOOQ Keys

15. Chapter 12: Pagination and Dynamic Queries

16. Part 4: jOOQ and Advanced SQL

17. Chapter 13: Exploiting SQL Functions

18. Chapter 14: Derived Tables, CTEs, and Views

19. Chapter 15: Calling and Creating Stored Functions and Procedures

20. Chapter 16: Tackling Aliases and SQL Templating

21. Chapter 17: Multitenancy in jOOQ

22. Part 5: Fine-tuning jOOQ, Logging, and Testing

23. Chapter 18: jOOQ SPI (Providers and Listeners)

24. Chapter 19: Logging and Testing

25. Other Books You May Enjoy

Chapter 6: Tackling Different Kinds of JOINs

The SQL JOIN clause represents one of the most used SQL features. From the well-known INNER and OUTER JOIN clauses, the fictional Semi and Anti Join, to the fancy LATERAL join, this chapter is a comprehensive set of examples meant to help you practice a wide range of JOIN clauses via the jOOQ DSL API.

The topics of this chapter include the following:

Practicing the most popular types of JOINs (CROSS, INNER, and OUTER)
The SQL USING and jOOQ onKey() shortcuts
Practicing more types of JOINs (Implicit, Self, NATURAL, STRAIGHT, Semi, Anti, and LATERAL)

Let's get started!

The rest of the chapter is locked

You're reading from jOOQ Masterclass A practical guide for Java developers to write SQL queries for complex database interactions

Table of Contents (26) Chapters

Chapter 6: Tackling Different Kinds of JOINs

Authors (1)

Personalised recommendations for you

You're reading from jOOQ Masterclass A practical guide for Java developers to write SQL queries for complex database interactions

Table of Contents (26) Chapters

Chapter 6: Tackling Different Kinds of JOINs

Unlock this book and the full library FREE for 7 days

Authors (1)

Personalised recommendations for you