🌐 Языки / Languages

• 🇷🇺 Русский

🧪 TechTask — SQL and Hibernate Test with Orders and Users

This project is a simple technical assignment designed to assess skills in SQL, Hibernate, and basic backend architecture. It features a minimal data model with users and orders, allowing candidates to demonstrate query writing, ORM usage, and clean code structure.

---

⚙️ Functionality

• users table — stores user information
• orders table — stores orders linked to users
• SQL scripts — for creating and populating tables
• Hibernate — for entity mapping and database interaction
• Sample queries — showcasing joins, filters, and aggregations

---

🛠️ Technologies

• Java 17+
• Spring Boot
• Hibernate ORM
• PostgreSQL
• SQL (DDL + DML)
• Maven

---

🎯 Assignment Goals

• Evaluate SQL skills:
  • JOINs between tables
  • Grouping and aggregation
  • Filtering and sorting
• Demonstrate Hibernate usage:
  • Entity mapping
  • JPA repository usage
  • Transaction handling
• Assess architectural thinking and code clarity

---

🚀 Quick Start

1. Install PostgreSQL and create a database:

   CREATE DATABASE techtask;

2. Configure application.yml with your database credentials
3. Run the project from your IDE (e.g., IntelliJ)
4. Execute SQL scripts manually or let Hibernate generate the schema