SQL Case Studies solved using Microsoft SQL Server and PostreSQL
-
Updated
Jan 23, 2024
SQL Case Studies solved using Microsoft SQL Server and PostreSQL
This project involved analyzing data for Rockbuster Stealth LLC, a fictional movie rental company transitioning to an online video rental service.
A Tableau dashboard showing the best hotel prices for places with ratings of 7.0 or greater.
A SQL project to analyze music store data. Find the results of given data with the help of answering the questions using queries.
Built a Data Model, Implemented Basic to Advanced SQL Queries
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.
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."