Hibernate and Spring Data JPA: Beginner to Guru

Dive into spring data jpa with an example by creating an entity and a repository, persisting data in an in-memory h2 database auto-configured by spring boot, and later introduce mysql.

Create a book domain object, turn it into a jpa entity with @Entity and @Id/@GeneratedValue(auto), and ensure a no-arg constructor for Hibernate with title, ISBN, and publisher.

Learn how Hibernate uses id-based equality for persistent entities, implement equals and hashCode, and handle null IDs before database assignment to ensure correct persistence behavior.

Define a repository by extending JpaRepository for a domain type Book with a long ID. Spring Data JPA then provides an implementation and supports CRUD operations.

Initialize sample data with Spring by using a data initializer to save two books via a repository into an H2 in-memory database, powered by Spring Data JPA and Hibernate.

Enable spring data jpa show sql to log the actual sql statements. Format the output and enable trace to see bind parameters for troubleshooting and understanding sql injection prevention.

Explore how a database organizes related data, defines data types, and supports data manipulation, retrieval, and administration through a DBMS, including flat file, relational, hierarchical, NoSQL, and cloud databases.

Explore what a relational database management system (RDBMS) is and how it uses ANSI SQL, DDL, and DML to define, manipulate, and retrieve data with ACID, security, and schema.

Create a minimal-access service account and a dedicated schema for Spring Boot, using two MySQL 8 users: bookadmin with ddl privileges and bookuser with dml access in bookdb.

Demonstrates how database transactions are managed in tests, including implicit transactions, commit and rollback, and how test method order and transactional context shape data state.

Configure Hibernate to connect Spring Boot tests to MySQL and balance in-memory and real database testing with initialized data for Spring Data JPA.

Explore Hibernate DDL and the Hbm2ddl auto configuration to generate, update, or drop schema from JPA entities, and learn when to use it versus Flyway for migrations.

configure hibernate to initialize the database from a classpath schema sql file, creating the book table and sequences, with id generation aligned to new naming strategies.

Initialize data with Liquibase by using XML descriptors or SQL change types in a Spring Boot project, setting up changeSets, including files, and inserting initial values into the Hibernate sequence.

Explore Flyway for database migrations, including commands like migrate, clean, info, validate, baseline, and repair, and learn how Spring Boot integrates Flyway to manage schema changes.

Configure Spring Boot to run Flyway migrations by adding the flyway-core dependency and using the bookadmin datasource for migrations.

configure a Spring Boot dev setup to clean and rebuild the database with Flyway: enable the Flyway clean goal via a clean profile and corresponding properties, then migrate.

Explore Hibernate primary keys and mapping, comparing surrogate key options (integer, long, UUID) with legacy natural keys, while the course uses Flyway and Liquibase for migrations and introduces DAO patterns.

Create an author DAO with a get by id method and its spring component, then test under a local profile while addressing test context scanning with component scan and import.

Save a new author via the DAO and return the saved author with its id. Learn binding parameters, performing the insert, and retrieving the last insert id with MySQL.

Implement and test updating an existing author in a transactional integration test, using a custom DAO update, update SQL, and a get-by-id check to verify changes.

Implement delete author by id using JDBC with a proper where clause, and understand how Spring transactional context affects test rollback versus plain JDBC.