Dorli, India
Student | Data Analysis | Excel | SQL | Eager to Learn
Local Time - 09:04 PM
About Me
I have worked on a mini project called Online Bookstore Database Management System using PostgreSQL. The main objective of this project was to design and manage a database for an online bookstore where books, customers, and their orders could be tracked efficiently. I created three main tables—Books, Customers, and Orders—where Books stored details like title, author, genre, price, and stock; Customers stored name, email, and location; and Orders recorded purchase transactions by linking each order to a customer and a book through foreign keys. After importing sample data from CSV files, I wrote SQL queries to answer business questions such as finding the most expensive book, calculating total revenue, identifying top selling genres, listing high value customers, and checking stock availability. This project helped me practice database design, normalization, and optimized query writing using JOINs, GROUP BY, HAVING, aggregate functions, and subqueries.
My Expertise
Explore & Appreciate my Work
Krushna Kadlag has not added any portfolio
My Project History & Feedbacks
My Endorsements
Krushna Kadlag hasn't been endorsed yet
My Education
Work Experience
Certifications
$3/hr
Total Earnings
$ 0
Projects Completed
0
Services Delivered
0
Buyer worked with
0
Feedbacks
0
Followers
Total Refund
0
Contest Completed
0
Member since
My Articles
No Articles Posted
Top Freelancers by city
Copyright © 2025 | Truelancer.com