Skip to content

This repository contains a MySQL dataset obtained from Kaggle, a popular platform for data scientists and machine learning practitioners. The dataset consists of several tables and records, providing a valuable resource for practicing SQL queries, database management, and data analysis.

Notifications You must be signed in to change notification settings

vedantparmar12/MySQL_Case_Study

Repository files navigation

Welcome to my README file for a GitHub repository containing MySQL datasets from Kaggle related to case studies on topics like Shark Tank, data science jobs, Google Play Store, and Swiggy:

MySQL Case Study Datasets

This repository contains several MySQL datasets obtained from Kaggle, each focused on a different case study topic. These datasets provide valuable resources for practicing SQL queries, database management, and data analysis in various real-world contexts.

Dataset Overview

  1. Shark Tank Dataset

    • This dataset includes information related to the popular TV show Shark Tank, where entrepreneurs pitch their business ideas to investors (sharks).
    • Explore data on companies, products, entrepreneurs, deals, and investments.
  2. Data Science Jobs Dataset

    • This dataset contains job listings and descriptions for data science roles from various companies and industries.
    • Analyze job requirements, skills, locations, and salary ranges for data science positions.
  3. Google Play Store Dataset

    • This dataset provides information on apps available on the Google Play Store, including their descriptions, ratings, pricing, and more.
    • Investigate app categories, popularity, pricing strategies, and user reviews.
  4. Swiggy Dataset

    • This dataset covers data related to Swiggy, a popular food delivery platform in India.
    • Explore restaurant information, menu items, delivery areas, and customer order details.

Each dataset is organized into multiple tables, allowing you to practice joining, filtering, and querying data across different entities and relationships.

Getting Started

To get started with these datasets, follow these steps:

  1. Clone this repository to your local machine.
  2. Import the SQL files or use the provided scripts to create the necessary database and tables.
  3. Explore the data using SQL queries, joining tables, and performing various analyses based on the case study topics.

Contributing

Contributions to this repository are welcome! If you have any improvements, bug fixes, or additional case study datasets to share, please submit a pull request. Additionally, feel free to open issues for any questions, suggestions, or discussions related to the datasets or SQL queries.

Resources

  • SQL Tutorial - A comprehensive resource for learning SQL.
  • MySQL Documentation - Official documentation for the MySQL database management system.
  • Kaggle Datasets - Explore and download more datasets from Kaggle for practice and analysis.

Happy querying!

This README file provides an overview of the repository, describes the different datasets and their topics, and includes instructions for getting started and contributing. It also provides additional resources for learning SQL and MySQL. Feel free to modify or expand on this README as per your specific requirements.

About

This repository contains a MySQL dataset obtained from Kaggle, a popular platform for data scientists and machine learning practitioners. The dataset consists of several tables and records, providing a valuable resource for practicing SQL queries, database management, and data analysis.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published