jOOQ Masterclass
jOOQ Masterclass

Author: Anghel Leonard

Publisher: Packt Publishing Ltd

Published: 2022-08-19

Total Pages: 764

ISBN-13: 1800564864

DOWNLOAD EBOOK

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.

Java Coding Problems
Java Coding Problems

Author: Anghel Leonard

Publisher: Packt Publishing Ltd

Published: 2024-03-19

Total Pages: 799

ISBN-13: 183763761X

DOWNLOAD EBOOK

Stay on top of the new Java features (up to JDK 21) and find efficient solutions for your programming woes. With over 250 problems and solutions, you'll learn new ways to deal with real-world coding tasks and answers to common interview questions. Purchase of the print or Kindle book includes a free PDF eBook Key Features Solve Java programming challenges and get interview-ready with the power of modern Java 21 Test your Java skills using language features, algorithms, data structures, and design patterns Explore tons of examples, all fully refreshed for this edition, meant to help you accommodate JDK 12 to JDK 21 Book DescriptionThe super-fast evolution of the JDK between versions 12 and 21 has made the learning curve of modern Java steeper, and increased the time needed to learn it. This book will make your learning journey quicker and increase your willingness to try Java’s new features by explaining the correct practices and decisions related to complexity, performance, readability, and more. Java Coding Problems takes you through Java’s latest features but doesn’t always advocate the use of new solutions — instead, it focuses on revealing the trade-offs involved in deciding what the best solution is for a certain problem. There are more than two hundred brand new and carefully selected problems in this second edition, chosen to highlight and cover the core everyday challenges of a Java programmer. Apart from providing a comprehensive compendium of problem solutions based on real-world examples, this book will also give you the confidence to answer questions relating to matching particular streams and methods to various problems. By the end of this book you will have gained a strong understanding of Java’s new features and have the confidence to develop and choose the right solutions to your problems.What you will learn Adopt the latest JDK 21 features in your applications Explore Records, Record Patterns, Record serialization and so on Work with Sealed Classes and Interfaces for increasing encapsulation Learn how to exploit Context-Specific Deserialization Filters Solve problems relating to collections and esoteric data structures Learn advanced techniques for extending the Java functional API Explore the brand-new Socket API and Simple Web Server Tackle modern Garbage Collectors and Dynamic CDS Archives Who this book is for If you are a Java developer who wants to level-up by solving real-world problems, then this book is for you. Working knowledge of the Java programming language is required to get the most out of this book

High-Performance Java Persistence
High-Performance Java Persistence

Author: Vlad Mihalcea

Publisher: Vlad Mihalcea

Published: 2016-10-12

Total Pages:

ISBN-13: 9789730228236

DOWNLOAD EBOOK

A high-performance data access layer must resonate with the underlying database system. Knowing the inner workings of a relational database and the data access frameworks in use can make the difference between a high-performance enterprise application and one that barely crawls. This book is a journey into Java data access performance tuning. From connection management, to batch updates, fetch sizes and concurrency control mechanisms, it unravels the inner workings of the most common Java data access frameworks. The first part aims to reduce the gap between application developers and database administrators. For this reason, it covers both JDBC and the database fundamentals that are of paramount importance when reducing transaction response times. In this first part, you'll learn about connection management, batch updates, statement caching, result set fetching and database transactions. The second part demonstrates how you can take advantage of JPA and Hibernate without compromising application performance. In this second part, you'll learn about the most efficient Hibernate mappings (basic types, associations, inheritance), fetching best practices, caching and concurrency control mechanisms. The third part is dedicated to jOOQ and its powerful type-safe querying capabilities, like window functions, common table expressions, upsert, stored procedures and database functions.

JDBC
JDBC

Author: Gregory D. Speegle

Publisher: Morgan Kaufmann

Published: 2002

Total Pages: 130

ISBN-13: 1558607366

DOWNLOAD EBOOK

1 -- Introduction to JDBC -- 2 -- Presenting Information to Users -- 3 -- Querying the Database -- 4 -- Updating the Database -- 5 -- Advanced JDBC Topics -- 6 -- An eCommerce Example -- 7 -- How to Stay Current with JDBC -- 8 -- Appendix.

Spring Boot Persistence Best Practices
Spring Boot Persistence Best Practices

Author: Anghel Leonard

Publisher: Apress

Published: 2020-04-29

Total Pages: 1043

ISBN-13: 1484256263

DOWNLOAD EBOOK

This book is a collection of developer code recipes and best practices for persisting data using Spring, particularly Spring Boot. The book is structured around practical recipes, where each recipe discusses a performance case or performance-related case, and almost every recipe has one or more applications. Mainly, when we try to accomplish something (e.g., read some data from the database), there are several approaches to do it, and, in order to choose the best way, you have to know the implied trades-off from a performance perspective. You’ll see that in the end, all these penalties slow down the application. Besides presenting the arguments that favor a certain choice, the application is written in Spring Boot style which is quite different than plain Hibernate. Persistence is an important set of techniques and technologies for accessing and using data, and this book demonstrates that data is mobile regardless of specific applications and contexts. In Java development, persistence is a key factor in enterprise, ecommerce, cloud and other transaction-oriented applications. After reading and using this book, you'll have the fundamentals to apply these persistence solutions into your own mission-critical enterprise Java applications that you build using Spring. What You Will Learn Shape *-to-many associations for best performancesEffectively exploit Spring Projections (DTO) Learn best practices for batching inserts, updates and deletes Effectively fetch parent and association in a single SELECTLearn how to inspect Persistent Context contentDissect pagination techniques (offset and keyset)Handle queries, locking, schemas, Hibernate types, and more Who This Book Is For Any Spring and Spring Boot developer that wants to squeeze the persistence layer performances.

Beginning jOOQ
Beginning jOOQ

Author: Tayo Koleoso

Publisher: Apress

Published: 2021-10-28

Total Pages: 214

ISBN-13: 9781484274309

DOWNLOAD EBOOK

Learn to use the jOOQ library to manage SQL database operations in Java and JVM applications. This book walks you through what JOOQ is, how to install and get started with it, and then gets you working with it. Practical examples and case studies demonstrate how jOOQ offers a more efficient and versatile alternative to Object-Relational Mapping frameworks like Hibernate and JPA, while providing a natural, native-SQL feeling for the developer. You'll see how to maximize the full potential of your SQL database with advanced query syntax and functions with this lightweight, SQL-friendly framework. Come see how you can use high performance approaches like reactive, data streaming and cloud-native programming to get data from SQL tables. Never write another incorrect SQL statement again and protect your application from SQL injection with the strong typing and inbuilt controls in jOOQ. Learn how to add jOOQ to your existing Hibernate, Spring Boot or Quarkus applications. When you’ve completed this book, you will be able to take the knowledge you’ve gained, along with the freely available source code, and directly apply them to your own work. What You Will Learn Comparing equivalent features between Hibernate, JPA and jOOQ Unlock the power of your SQL database with high performing, flexible and typesafe SQL queries Seamlessly work with many different SQL database vendors without changing your code Effortlessly generate Java code based on the content of your database Write reactive SQL database access code with R2DBC Integrating jOOQ into popular frameworks and platforms like Hibernate, Spring boot and Quarkus tools like IDEs Testing jOOQ-based code with modern integration testing frameworks like TestContainers and Docker Learn how to safely handle data access code within frameworks like the Java Persistence API (JPA) Who This Book Is For Intermediate Java programmers new to jOOQ. Some prior experience with SQL may be helpful but not required.

The The Complete Coding Interview Guide in Java
The The Complete Coding Interview Guide in Java

Author: Anghel Leonard

Publisher: Packt Publishing Ltd

Published: 2020-08-28

Total Pages: 788

ISBN-13: 1839219173

DOWNLOAD EBOOK

Explore a wide variety of popular interview questions and learn various techniques for breaking down tricky bits of code and algorithms into manageable chunks Key FeaturesDiscover over 200 coding interview problems and their solutions to help you secure a job as a Java developerWork on overcoming coding challenges faced in a wide array of topics such as time complexity, OOP, and recursionGet to grips with the nuances of writing good code with the help of step-by-step coding solutionsBook Description Java is one of the most sought-after programming languages in the job market, but cracking the coding interview in this challenging economy might not be easy. This comprehensive guide will help you to tackle various challenges faced in a coding job interview and avoid common interview mistakes, and will ultimately guide you toward landing your job as a Java developer. This book contains two crucial elements of coding interviews - a brief section that will take you through non-technical interview questions, while the more comprehensive part covers over 200 coding interview problems along with their hands-on solutions. This book will help you to develop skills in data structures and algorithms, which technical interviewers look for in a candidate, by solving various problems based on these topics covering a wide range of concepts such as arrays, strings, maps, linked lists, sorting, and searching. You'll find out how to approach a coding interview problem in a structured way that produces faster results. Toward the final chapters, you'll learn to solve tricky questions about concurrency, functional programming, and system scalability. By the end of this book, you'll have learned how to solve Java coding problems commonly used in interviews, and will have developed the confidence to secure your Java-centric dream job. What you will learnSolve the most popular Java coding problems efficientlyTackle challenging algorithms that will help you develop robust and fast logicPractice answering commonly asked non-technical interview questions that can make the difference between a pass and a failGet an overall picture of prospective employers' expectations from a Java developerSolve various concurrent programming, functional programming, and unit testing problemsWho this book is for This book is for students, programmers, and employees who want to be invited to and pass interviews given by top companies. The book assumes high school mathematics and basic programming knowledge.

Spring Data
Spring Data

Author: Petri Kainulainen

Publisher: Packt Pub Limited

Published: 2012

Total Pages: 160

ISBN-13: 9781849519045

DOWNLOAD EBOOK

This book is a standard tutorial which provides step-by-step instructions and a lot of code examples that are easy to follow and help you to get started from page one. This book is suited for developers who are working with Spring-powered applications, and are looking for an easier way to write data access code that uses relational databases. Also, if you are interested in learning how you can utilize Redis in your applications, this is the book for you. This book assumes that you have got some experience with the Spring Framework and the Java Persistence API. No previous experience with Redis is required.

SQL Tuning
SQL Tuning

Author: Dan Tow

Publisher: "O'Reilly Media, Inc."

Published: 2003-11-19

Total Pages: 338

ISBN-13: 059655236X

DOWNLOAD EBOOK

A poorly performing database application not only costs users time, but also has an impact on other applications running on the same computer or the same network. SQL Tuning provides an essential next step for SQL developers and database administrators who want to extend their SQL tuning expertise and get the most from their database applications.There are two basic issues to focus on when tuning SQL: how to find and interpret the execution plan of an SQL statement and how to change SQL to get a specific alternate execution plan. SQL Tuning provides answers to these questions and addresses a third issue that's even more important: how to find the optimal execution plan for the query to use.Author Dan Tow outlines a timesaving method he's developed for finding the optimum execution plan--rapidly and systematically--regardless of the complexity of the SQL or the database platform being used. You'll learn how to understand and control SQL execution plans and how to diagram SQL queries to deduce the best execution plan for a query. Key chapters in the book include exercises to reinforce the concepts you've learned. SQL Tuning concludes by addressing special concerns and unique solutions to "unsolvable problems."Whether you are a programmer who develops SQL-based applications or a database administrator or other who troubleshoots poorly tuned applications, SQL Tuning will arm you with a reliable and deterministic method for tuning your SQL queries to gain optimal performance.

The The SQL Workshop
The The SQL Workshop

Author: Frank Solomon

Publisher: Packt Publishing Ltd

Published: 2019-12-30

Total Pages: 287

ISBN-13: 1838649085

DOWNLOAD EBOOK

Get to grips with SQL fundamentals and learn how to efficiently create, read and update information stored in databases Key FeaturesUnderstand the features and syntax of SQL and use them to query databasesLearn how to create databases and tables and manipulate the data within themCreate advanced queries and apply them on realistic databases with hands-on activitiesBook Description Many software applications are backed by powerful relational database systems, meaning that the skills to be able to maintain a SQL database and reliably retrieve data are in high demand. With its simple syntax and effective data manipulation capabilities, SQL enables you to manage relational databases with ease. The SQL Workshop will help you progress from basic to advanced-level SQL queries in order to create and manage databases successfully. This Workshop begins with an introduction to basic CRUD commands and gives you an overview of the different data types in SQL. You'll use commands for narrowing down the search results within a database and learn about data retrieval from single and multiple tables in a single query. As you advance, you'll use aggregate functions to perform calculations on a set of values, and implement process automation using stored procedures, functions, and triggers. Finally, you'll secure your database against potential threats and use access control to keep your data safe. Throughout this Workshop, you'll use your skills on a realistic database for an online shop, preparing you for solving data problems in the real world. By the end of this book, you'll have built the knowledge, skills and confidence to creatively solve real-world data problems with SQL. What you will learnCreate databases and insert data into themUse SQL queries to create, read, update, and delete dataMaintain data integrity and consistency through normalizationCustomize your basic SQL queries to get the desired outputRefine your database search using the WHERE and HAVING clausesUse joins to fetch data from multiple tables and create custom reportsImprove web application performance by automating processesSecure a database with GRANT and REVOKE privilegesWho this book is for This Workshop is suitable for anyone who wants to learn how to use SQL to work with databases. No prior SQL or database experience is necessary. Whether you're an aspiring software developer, database engineer, data scientist, or systems administrator, this Workshop will quickly get you up and running.