sqlcase-study

This repository contains a collection of MySQL database projects showcasing various database design and management techniques. Each project demonstrates practical applications of MySQL in different contexts, including data modeling, query optimization, and relational database management.

SQL case study analyzing an 8,800-row B2B CRM sales pipeline — deal performance, agent productivity, revenue trends, and product success, using SELECT, GROUP BY, CASE, and subqueries.

This case study focuses on using subscription style digital data to answer important business questions on customer journey, payments, and business performances.

Case study "8-Week SQL Challenge"

End-to-end retail sales analytics project using SQL, Power BI, and PostgreSQL. Features automated reporting, interactive dashboards, and actionable business insights for merchandising decisions.