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 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
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.
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.
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.
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."