Sign-In
Cart
jOOQ Masterclass: A practical guide for Java developers to write SQL queries for complex database interactions
Paperback
ISBN13: 9781800566897
Publisher: Packt Pub
Published: Aug 19 2022
Pages: 764
Weight: 2.84
Height: 1.52 Width: 7.50 Depth: 9.25
Language: English
Learn the best way to write SQL in Java by taking control of SQL in your app via a type-safe, dynamic and versatile API that supports almost any type or feature compatible with a database and emphasizes SQL syntax correctness
Key Features:
- Write complex, type-safe, and dynamic SQL using the powerful jOOQ API
- Tackle complex persistence tasks, such as lazy fetching, R2DBC, transactions, and batching while sustaining high traffic in your modern Java applications
- Use a comprehensive SPI to shape and extend jOOQ according to your needs
Book Description:
jOOQ is an excellent query builder framework that allows you to emulate database-specific SQL statements using a fluent, intuitive, and flexible DSL API. jOOQ is fully capable of handling the most complex SQL in more than 30 different database dialects.
jOOQ Masterclass 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. You'll learn how to use jOOQ in Spring Boot apps as a replacement for SpringTemplate and Spring Data JPA. Next, you'll unleash jOOQ type-safe queries and CRUD operations via jOOQ's records, converters, bindings, types, mappers, multi-tenancy, logging, and testing. Later, the book shows you how to use jOOQ to exploit powerful SQL features such as UDTs, embeddable types, embedded keys, and more. As you progress, you'll cover trending topics such as identifiers, batching, lazy loading, pagination, and HTTP long conversations. For implementation purposes, the jOOQ examples explained in this book are written in the Spring Boot context for Maven/Gradle against MySQL, Postgres, SQL Server, and Oracle.
By the end of this book, you'll be a jOOQ power user capable of integrating jOOQ in the most modern and sophisticated apps including enterprise apps, microservices, and so on.
What You Will Learn:
- 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
Who this book is for:
This book is for Java developers who write applications that interact with databases via SQL. No prior experience with jOOQ is assumed.
Also from
Leonard, Anghel
Spring Boot Persistence Best Practices: Optimize Java Persistence Performance in Spring Boot Applications
Leonard, Anghel
Paperback
Mastering JavaServer Faces 2.2: Master the art of implementing user interfaces with JSF 2.2
Leonard, Anghel
Paperback
Also in
Programming
The Legend of Zelda(tm) Tears of the Kingdom - The Complete Official Guide: Collector's Edition
Piggyback
Hardcover
Cracking the Coding Interview: 189 Programming Questions and Solutions
McDowell, Gayle Laakmann
Paperback
The Legend of Zelda(tm) Tears of the Kingdom - The Complete Official Guide: Standard Edition
Piggyback
Paperback
Python Crash Course, 3rd Edition: A Hands-On, Project-Based Introduction to Programming
Matthes, Eric
Paperback
Accelerate: The Science of Lean Software and DevOps: Building and Scaling High Performing Technology Organizations
Kim, Gene
Forsgren Phd, Nicole
Humble, Jez
Paperback
Embedded Systems with ARM Cortex-M Microcontrollers in Assembly Language and C: Fourth Edition
Zhu, Yifeng
Paperback
SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL
Shields, Walter
Hardcover
The Pragmatic Programmer: Your Journey to Mastery, 20th Anniversary Edition
Thomas, David
Hunt, Andrew
Hardcover
The Manager's Path: A Guide for Tech Leaders Navigating Growth and Change
Fournier, Camille
Paperback
Learning Php, MySQL & JavaScript: A Step-By-Step Guide to Creating Dynamic Websites
Nixon, Robin
Paperback
The Staff Engineer's Path: A Guide for Individual Contributors Navigating Growth and Change
Reilly, Tanya
Paperback
Head First JavaScript Programming: A Learner's Guide to Modern JavaScript
Freeman, Eric
Robson, Elisabeth
Paperback
Automate the Boring Stuff with Python, 2nd Edition: Practical Programming for Total Beginners
Sweigart, Al
Paperback
The Official Raspberry Pi Handbook 2025: Projects, Tutorials, Interviews, and Reviews from the Magpi Magazine
Makers of the Magpi Magazine, The
Paperback
This Is Service Design Doing: Applying Service Design Thinking in the Real World
Hormess, Markus Edgar
Stickdorn, Marc
Lawrence, Adam
Paperback
The DevOps Handbook: How to Create World-Class Agility, Reliability, & Security in Technology Organizations
Humble, Jez
Debois, Patrick
Kim, Gene
Paperback
Learning Web Design: A Beginner's Guide to Html, Css, Javascript, and Web Graphics
Robbins, Jennifer
Paperback
Head First Design Patterns: Building Extensible and Maintainable Object-Oriented Software
Freeman, Eric
Robson, Elisabeth
Paperback
Spies, Lies, and Algorithms: The History and Future of American Intelligence
Zegart, Amy B.
Paperback
Pro C# 10 with .Net 6: Foundational Principles and Practices in Programming
Japikse, Phil
Troelsen, Andrew
Paperback
Design Patterns: Elements of Reusable Object-Oriented Software
Helm, Richard
Johnson, Ralph
Gamma, Erich
Hardcover
Head First C#: A Learner's Guide to Real-World Programming with C# and .Net
Stellman, Andrew
Greene, Jennifer
Paperback
Embedded Systems with Arm Cortex-M Microcontrollers in Assembly Language and C: Third Edition
Zhu, Yifeng
Paperback
Gestión práctica de proyectos con Scrum: Desarrollo de software ágil para el Scrum Master
Martel, Antonio
Paperback
Software Architecture: The Hard Parts: Modern Trade-Off Analyses for Distributed Architectures
Sadalage, Pramod
Ford, Neal
Richards, Mark
Paperback
Electronic Music and Sound Design - Theory and Practice with Max 8 - Volume 1 (Fourth Edition)
Cipriani, Alessandro
Giri, Maurizio
Paperback
Serious Cryptography, 2nd Edition: A Practical Introduction to Modern Encryption
Aumasson, Jean-Philippe
Paperback
Make: Electronics: Learning by Discovery: A Hands-On Primer for the New Electronics Enthusiast
Platt, Charles
Paperback
Learn OpenGL: Learn modern OpenGL graphics programming in a step-by-step fashion.
de Vries, Joey
Paperback
Dark Souls: Beyond the Grave Volume 1: Demon's Souls -- Dark Souls -- Dark Souls II
Mecheri, Damien
Romieu, Sylvain
Hardcover
Leading Quality: How Great Leaders Deliver High Quality Software and Accelerate Growth
Peer, Owais
Cummings -. John, Ronald
Paperback
Data Visualization with Microsoft Power Bi: How to Design Savvy Dashboards
Kolokolov, Alex
Zelensky, Maxim
Paperback
Video Game of the Year: A Year-By-Year Guide to the Best, Boldest, and Most Bizarre Games from Every Year Since 1977
Minor, Jordan
Paperback
Concrete Mathematics: A Foundation for Computer Science
Patashnik, Oren
Knuth, Donald
Graham, Ronald
Hardcover
Aprenda Visual Basic (Vba) Y Macros Para Excel: Más de 100 ejercicios resueltos, macros y juegos, para desarrollar tus habilidades de programación
Vidal Bosch, Josep Ramon
Paperback
Living a Jewish Life, Revised and Updated: Jewish Traditions, Customs, and Values for Today's Families
Diamant, Anita
Cooper, Howard
Paperback
Walk Through Combinatorics, A: An Introduction to Enumeration and Graph Theory (Fourth Edition)
Bona, Miklos
Hardcover
Computer Science Distilled: Learn the Art of Solving Computational Problems
Ferreira Filho, Wladston
Paperback
Electronic Music and Sound Design - Theory and Practice with Max 8 - volume 3
Giri, Maurizio
Cipriani, Alessandro
Paperback
The Digital Photography Book: The Step-By-Step Secrets for How to Make Your Photos Look Like the Pros'!
Kelby, Scott
Paperback
Modern Software Engineering: Doing What Works to Build Better Software Faster
Farley, David
Paperback
Javascript: The Definitive Guide: Master the World's Most-Used Programming Language
Flanagan, David
Paperback
Linux Basics for Hackers: Getting Started with Networking, Scripting, and Security in Kali
Occupytheweb
Paperback
JavaScript Crash Course: A Hands-On, Project-Based Introduction to Programming
Morgan, Nick
Paperback
Electronic Music and Sound Design - Theory and Practice with Max 8 - Volume 2 (Third Edition)
Cipriani, Alessandro
Giri, Maurizio
Paperback
Software Wasteland: How the Application-Centric Mindset is Hobbling our Enterprises
McComb, Dave
Paperback
Workday Gold: A Collection of Keith Bitikofer's #WorkdayTips Focused on Software Functionality 2021-2023
Bitikofer, Keith
Paperback
SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL
Shields, Walter
Paperback
Dark Souls: Beyond the Grave Volume 2: Bloodborne €" Dark Souls III
Romieu, Sylvain
Mecheri, Damien
Hardcover
Designing Distributed Systems: Patterns and Paradigms for Scalable, Reliable Systems Using Kubernetes
Burns, Brendan
Paperback
Python Basics: A Practical Introduction to Python 3
Bader, Dan
Jablonski, Joanna
Heisler, Fletcher
Paperback
Algorithms Illuminated (Part 3): Greedy Algorithms and Dynamic Programming
Roughgarden, Tim
Paperback
Simple SysML for Beginners: Using CATIA No Magic Products
Casse, Olivier
Braun, Frank
Hetherington, David
Paperback
Building AI-Powered Products: The Essential Guide to AI and Genai Product Management
Nika, Marily
Paperback
Blueprints Visual Scripting for Unreal Engine 5: Unleash the true power of Blueprints to create impressive games and applications in UE5
Romero, Marcos
Sewell, Brenden
Paperback
Python Machine Learning By Example - Fourth Edition: Unlock machine learning best practices with real-world use cases
Liu, Yuxi (Hayden)
Paperback