Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
Backend development for Java graduates
·
Module 6
Advanced Database Operations & Transactions
1
Understanding ACID Properties and Database Transactions
Explain the ACID properties and the role of database transactions.
2
Declarative Transactions with @Transactional
Manage database transactions declaratively using the @Transactional annotation.
3
Pagination and Sorting with Pageable and Sort
Implement pagination and sorting of query results using Pageable and Sort.
4
Flyway for Database Migrations
Implement database schema migration and versioning using Flyway.
5
Solving N+1 Queries with Fetch Joins
Explain the N+1 query problem and solve it using fetch joins.
6
Native SQL with @Query for Complex Scenarios
Use native SQL queries with @Query(nativeQuery = true) for complex scenarios.
7
Database Connection Pooling: Role and Benefits
Describe the role and benefits of database connection pooling (e.g., HikariCP).
8
In-Memory Databases for Testing
Set up and use an in-memory database (like H2) for testing purposes.
Previous module
Database Integration with Spring Data JPA
Next module
Securing APIs with Spring Security