SQL Case Studies solved using Microsoft SQL Server and PostreSQL
-
Updated
Jan 23, 2024
SQL Case Studies solved using Microsoft SQL Server and PostreSQL
A Tableau dashboard showing the best hotel prices for places with ratings of 7.0 or greater.
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.
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.
Built a Data Model, Implemented Basic to Advanced SQL Queries
data-modeling-analysis-sql
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.
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.
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."