UsefulLinks
Computer Science
Java Ecosystem
Hibernate
1. Introduction to Object-Relational Mapping
2. Hibernate Overview
3. Hibernate Architecture
4. Project Setup and Configuration
5. Entity Mapping Fundamentals
6. Association Mapping
7. Fetching Strategies
8. Cascade Operations
9. Entity Lifecycle and Persistence Context
10. CRUD Operations
11. Transaction Management
12. Querying with HQL
13. JPQL and Criteria API
14. Native SQL Queries
15. Inheritance Mapping
16. Caching Architecture
17. Advanced Hibernate Features
18. Performance Optimization
19. Best Practices and Common Patterns
12.
Querying with HQL
12.1.
HQL Fundamentals
12.1.1.
Query Language Overview
12.1.2.
Object-Oriented Queries
12.1.3.
HQL vs SQL Differences
12.2.
Basic HQL Syntax
12.2.1.
SELECT Statements
12.2.2.
FROM Clause
12.2.2.1.
Entity References
12.2.2.2.
Alias Usage
12.2.3.
WHERE Clause
12.2.3.1.
Conditional Expressions
12.2.3.2.
Comparison Operators
12.2.3.3.
Logical Operators
12.2.4.
Parameter Binding
12.2.4.1.
Positional Parameters
12.2.4.2.
Named Parameters
12.2.4.3.
Parameter Lists
12.3.
Advanced HQL Features
12.3.1.
Join Operations
12.3.1.1.
Inner Joins
12.3.1.2.
Left Outer Joins
12.3.1.3.
Right Outer Joins
12.3.1.4.
Fetch Joins
12.3.2.
Subqueries
12.3.2.1.
Correlated Subqueries
12.3.2.2.
EXISTS Expressions
12.3.2.3.
IN Expressions
12.3.3.
Aggregate Functions
12.3.3.1.
COUNT Function
12.3.3.2.
SUM Function
12.3.3.3.
AVG Function
12.3.3.4.
MIN and MAX Functions
12.3.4.
Grouping and Ordering
12.3.4.1.
GROUP BY Clause
12.3.4.2.
HAVING Clause
12.3.4.3.
ORDER BY Clause
12.4.
HQL Query Execution
12.4.1.
Query Object Creation
12.4.2.
Parameter Setting
12.4.3.
Result Retrieval
12.4.4.
Pagination Support
Previous
11. Transaction Management
Go to top
Next
13. JPQL and Criteria API