SQL Case Studies solved using Microsoft SQL Server and PostreSQL
Answering ad-hoc business questions about Rockbuster’s film inventory, customer data, and payment records to support their transition to an online video rental service.
A SQL project to analyze music store data. Find the results of given data with the help of answering the questions using queries.
This project involved analyzing data for Rockbuster Stealth LLC, a fictional movie rental company transitioning to an online video rental service.
This project analyzes e-commerce order fulfillment using Advanced SQL Techniques and Python-based visualization to uncover insights on sales trends, customer segmentation, shipping cost optimization, and payment preferences.
A Tableau dashboard showing the best hotel prices for places with ratings of 7.0 or greater.
Built a Data Model, Implemented Basic to Advanced SQL Queries
data-modeling-analysis-sql
Explores an E-Commerce dataset and generate various analytics and insights from customers' past purchase behavior.
A comprehensive IMDB dataset analysis using SQL. Includes database setup, advanced queries, and actionable insights. Organized with files for database creation, queries, and solutions. Features an Entity-Relationship Diagram (ERD), executive summary, and SQL scripts. Perfect for SQL workflows and business intelligence in the film industry.
This project documentation was developed as a free project, as a data analyst from the fictional company Sell Boardgames would do in his daily work.
LeetCode SQL 50
Add a description, image, and links to the common-table-expressions topic page so that developers can more easily learn about it.
To associate your repository with the common-table-expressions topic, visit your repo's landing page and select "manage topics."