abdallahalseddek / practical-web-database-design

Practical Web DataBase Design Book

• 📚 I'm currently reading Spring MicroServices In Action book.
• 🌱 I’m currently learning Spring Cloud and GraphGL
• 💬 Ask me about java, Spring Framework modules, Object-oriented design, Database Design

📕 My Latest Reading

• Spring Boot In Action
• Spring In Action, 5th edition
• Modern Java In Action.
• Practical Web DataBase Design.
• Object Oriented Analysis And Design textbook, 3rd edition.

Languages and Tools:

practical-web-database-design's Issues

suggest popular products

we need to write a SQL Query so that the customer can know what else we have he might be interested in, so when the customer is viewing a product, the system will suggest products from a similar category!

add code implementation using spring framework

Implement my hand-work example in Java and Spring Data Jpa

impl a sale history trigger

if the business wants to create a sale history for the customer after making an order, what is the SQL query equivalent for doing that!
Note: the history record may contain customer firstname and lastname, order products names, quantity, and the total order amount of money.

product transaction

if we need to lock quantity with a specific product, e.g., id=211 from being updated, how it would be as a transaction?
also what if I need to lock the row not an attribute, what is the sql query for doing that?