Anghel Leonard - jOOQ Masterclass: A practical guide for Java developers to write SQL queries for complex database interactions
Here you can read online Anghel Leonard - jOOQ Masterclass: A practical guide for Java developers to write SQL queries for complex database interactions full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. year: 2022, publisher: Packt Publishing, genre: Computer. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:
Romance novel
Science fiction
Adventure
Detective
Science
History
Home and family
Prose
Art
Politics
Computer
Non-fiction
Religion
Business
Children
Humor
Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.
- Book:jOOQ Masterclass: A practical guide for Java developers to write SQL queries for complex database interactions
- Author:
- Publisher:Packt Publishing
- Genre:
- Year:2022
- Rating:5 / 5
- Favourites:Add to favourites
- Your mark:
jOOQ Masterclass: A practical guide for Java developers to write SQL queries for complex database interactions: summary, description and annotation
We offer to read an annotation, description, summary or preface (depends on what the author of the book "jOOQ Masterclass: A practical guide for Java developers to write SQL queries for complex database interactions" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.
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
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. Youll learn how to use jOOQ in Spring Boot apps as a replacement for SpringTemplate and Spring Data JPA. Next, youll unleash jOOQ type-safe queries and CRUD operations via jOOQs 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, youll 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, youll 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
This book is for Java developers who write applications that interact with databases via SQL. No prior experience with jOOQ is assumed.
Table of Contents- Starting jOOQ and Spring Boot
- Customizing the jOOQ Level of Involvement
- jOOQ Core Concepts
- Building a DAO Layer (Evolving the Generated DAO Layer)
- Tackling Different Kinds of SELECT, INSERT, UPDATE, DELETE, and MERGE Statements.
- Tackling Different Kinds of JOIN Statements
- Types, Converters, and Binding
- Fetching and Mapping
- CRUD, Transactions, and Locking
- Exporting, Batching, Bulking, and Loading
- jOOQ Keys
- Pagination and Dynamic Queries
- Exploiting SQL Functions
- Derived Tables, CTEs, and Views
- Calling and Creating Stored Functions and Procedures
- Tackling Aliases and SQL Templating
- Multitenancy in jOOQ
- jOOQ SPI (Providers and Listeners)
- Logging and Testing
Anghel Leonard: author's other books
Who wrote jOOQ Masterclass: A practical guide for Java developers to write SQL queries for complex database interactions? Find out the surname, the name of the author of the book and a list of all author's works by series.
![Michael Müller [Michael Müller] - Practical JSF in Java EE 8 : Web Applications ​in Java for the Enterprise](/uploads/posts/book/124065/thumbs/michael-mg-ller-michael-mg-ller-practical.jpg)
jOOQ Masterclass: A practical guide for Java developers to write SQL queries for complex database interactions — read online for free the complete book (whole text) full work
Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "jOOQ Masterclass: A practical guide for Java developers to write SQL queries for complex database interactions" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.
Font size:
Interval:
Bookmark:
A practical guide for Java developers to write SQL queries for complex database interactions
Anghel Leonard
BIRMINGHAMMUMBAI
Copyright 2022 Packt Publishing
All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.
Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, nor Packt Publishing or its dealers and distributors, will be held liable for any damages caused or alleged to have been caused directly or indirectly by this book.
Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.
Assistant Group Product Manager: Alok Dhuri
Senior Editor: Kinnari Chohan
Technical Editor: Maran Fernandes
Copy Editor: Safis Editing
Project Coordinator: Manisha Singh
Proofreader: Safis Editing
Indexer: Tejal Daruwale Soni
Production Designer: Aparna Bhagat
Marketing Coordinator: Sonakshi Bubbar
First published: July 2022
Production reference: 2110822
Published by Packt Publishing Ltd.
Livery Place
35 Livery Street
Birmingham
B3 2PB, UK.
ISBN 978-1-80056-689-7
www.packt.com
It has been a great pleasure reviewing Anghel's book over the past year.
Anghel is very knowledgeable about databases in general, as well as SQL specifically and the various popular persistence technologies in the Java ecosystem. This shows in his examples, which are suitable both for beginners and for SQL gurus, who will use at least two window functions in every query.
jOOQ Masterclass is very well structured, both for jOOQ rookies who wish to learn about how to put jOOQ to best use and advanced jOOQ users who wish to have a reference for almost any use case that jOOQ supports. Anghel has a vast number of examples, which are both intuitive and powerful.
With this book at your disposal, your next jOOQ application will be a breeze.
Lukas Eder, Founder and CEO of Data Geekery, the company behind jOOQ
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.
I want to thank Lukas Eder who has guided me while writing this book and who has always been quick to answer my questions, suggestions, and so on.
Matthew Cachia has a bachelor's degree in computer science and has been working in the payments space for more than 14 years. He is currently the technical architect of Weavr.io.
He is into static-type languages most notably, Java, Scala, and Kotlin. He has become increasingly fascinated by compilers, transpilers, and languages overall a field he regrets not picking up when reading his degree.
In his free time, he likes playing role-playing games and spending time with his family Georgiana, Thomas, and Alex.
Lukas Eder is the founder and CEO of Data Geekery, the company behind jOOQ.
The last decade has constantly changed how we think and write applications including the persistence layer, which must face new challenges such as working in microservice architectures and cloud environments. Flexibility, versatility, dialect agnostic, rock-solid SQL support, small learning curve, and high performance are just a few of the attributes that makes jOOQ the most appealing persistence technology for modern applications.
Being part of the modern technology stack, jOOQ is the new persistence trend that respects all standards of a mature, robust, and well-documented technology. This book covers jOOQ in detail, so it prepares you to become a jOOQ power-user and an upgraded version of yourself ready to handle the future of the persistence layer. Don't think of jOOQ as just another piece of technology; think of it as part of your mindset, your straightforward road to exploiting SQL instead of abstracting it, and your approach to doing things right in your organization.
This book is for Java developers who write applications that interact with databases via SQL. No prior experience with jOOQ is assumed.
, Starting jOOQ and Spring Boot, shows how to create a kickoff application that involves jOOQ and Spring Boot in Java/Kotlin under Maven/Gradle.
, Customizing the jOOQ Level of Involvement, covers the configurations (declarative and programmatic) needed for employing jOOQ as a type-safe query builder and executor. Moreover, we set up jOOQ to generate POJOs and DAOs on our behalf. We use Java/Kotlin under Maven/Gradle.
Chapter 3, jOOQ Core Concepts, discusses jOOQ core concepts such as fluent API, SQL syntax correctness, emulating missing syntax/logic, jOOQ result set, jOOQ records, type safety, CRUD binding, and inlining parameters.
, Building a DAO Layer (Evolving the Generated DAO Layer), shows how implementing a DAO layer can be done in several ways/templates. We tackle an approach for evolving the DAO layer generated by jOOQ.
, Tackling Different Kinds of SELECT, INSERT, UPDATE, DELETE, and MERGE Statements, covers different kinds of SELECT, INSERT,UPDATE, DELETE, and MERGE queries. For example, we cover nested SELECT, INSERT...DEFAULT VALUES, INSERT...SET queries, and so on.
, Tackling Different Kinds of JOIN Statements, tackles different kinds of JOIN. jOOQ excels on standard and non-standard JOIN. We cover INNER, LEFT, RIGHT, , CROSS, NATURAL, and LATERALJOIN.
, Types, Converters, and Bindings, covers the custom data types, conversion, and binding.
, Fetching and Mapping, being one of the most comprehensive chapters, covers a wide range of jOOQ fetching and mapping techniques, including JSON/SQL, XML/SQL, and MULTISET features.
, CRUD, Transactions, and Locking, covers jOOQ CRUD support next to Spring/jOOQ transactions and optimistic/pessimistic locking.
Font size:
Interval:
Bookmark:
Similar books «jOOQ Masterclass: A practical guide for Java developers to write SQL queries for complex database interactions»
Look at similar books to jOOQ Masterclass: A practical guide for Java developers to write SQL queries for complex database interactions. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.
Discussion, reviews of the book jOOQ Masterclass: A practical guide for Java developers to write SQL queries for complex database interactions and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.