Java and Databases: A Practical Guide

The book "Java and Databases: A Practical Guide" is a full-fledged tutorial for developers who want to master working with relational databases in the Java ecosystem. The author consistently guides the reader from basic JDBC concepts to modern ORM frameworks and data access patterns.

What is this book about?

This is not just a reference, but a practical guide built on real-world examples. You will learn:

• How to install and configure popular DBMS (MySQL, PostgreSQL, H2);
• How to work with JDBC: connections, PreparedStatement, CallableStatement, batch operations;
• How to design a database schema and write efficient SQL queries;
• How to use connection pools (HikariCP, Tomcat JDBC);
• How to implement JPA and Hibernate: entity mapping, relationships, inheritance, caching;
• How to work with Spring Data JPA and Spring JDBC Template;
• How to manage transactions (ACID, isolation levels, @Transactional);
• How to optimize performance: indexes, explain, N+1 problem, lazy loading;
• How to migrate databases using Flyway and Liquibase;
• How to test code with databases (Testcontainers, H2 in-memory).

Who is this book for?

• Junior Java developers who want to fill gaps in working with data;
• Middle developers seeking to deepen their knowledge of Hibernate and optimization