Hands-on SQL portfolio of 105 real-world problems showcasing analytical precision, performance tuning, and query mastery.
-
Updated
Nov 8, 2025 - PLpgSQL
Hands-on SQL portfolio of 105 real-world problems showcasing analytical precision, performance tuning, and query mastery.
A solid grasp of SQL, including joins, subqueries, window functions, CTE's, and data aggregation. Skilled at solving complex problems with a focus on query optimization and advanced techniques.
vet-clinic-database is a postgreSQL database project that stores details of animals in a veterinary clinic and also generates specific reports using SQL queries.
Solutions for the DBMS Project: Ship Positions Analysis, featuring PostgreSQL queries, performance optimization (indexing, partitioning), and memory management for analyzing real-world ship and vessel data from the Piraeus area.
A fully normalized Hotel Booking System Database designed using PostgreSQL, following 3rd Normal Form (3NF) principles. This project demonstrates real-world database design, indexing, stored procedures, and query optimization.
Add a description, image, and links to the query-optimization topic page so that developers can more easily learn about it.
To associate your repository with the query-optimization topic, visit your repo's landing page and select "manage topics."