Relational Database

🛍E-commerce SQL project with schema, data, queries & ER diagram - built for learning SQL!

This project acted as practice for basics of creating queries using SQLite syntax

This repository contains a collection of basic SQL queries for working with MySQL.

A beginner-friendly project showing how to use SQL with Python for querying, updating, and visualizing data in Jupyter Notebook.

This repository contains a collection of cybersecurity project exemplars. Each project includes a problem statement that outlines the objective and a corresponding solution or analysis. The projects cover a range of cybersecurity domains, including risk management, incident response, network analysis, and vulnerability assessment.

This repository contains solutions to the first 50 SQL problems on LeetCode. Each problem is solved using SQL queries, with detailed explanations and efficient approaches. These solutions aim to help users improve their SQL skills and understanding of database concepts while providing clear and well-documented code for reference.

A comprehensive SQL repository with queries organized by industry sectors, including banking, healthcare, energy, manufacturing, and transportation. Designed to solve real-world problems with optimized and scalable solutions, this repository is ideal for learning and tackling industry-specific challenges.

This project explores factors affecting airfare pricing in the Indian domestic flight market. Using a real-world dataset of airline ticket prices, we apply data cleaning, exploratory data analysis (EDA), statistical methods, and SQL queries

A hands-on SQL project simulating data analysis using fact and dimension tables, covering trends over time, cumulative metrics, performance breakdowns, segmentation, and reporting via SQL.

Welcome to the HackerRank SQL Problems repository! This collection features a variety of SQL challenges from HackerRank, designed to help you sharpen your SQL skills. Whether you're a beginner or an experienced developer, you'll find solutions and explanations for everything from basic queries to advanced data manipulation.

This lab provides hands-on exercises for writing SQL queries that utilize various types of JOINs to extract, analyze, and combine data from multiple related tables.

Few more basic additional MS-SQL queries in addition to my previous repository to help beginners understand the concepts more deeply.Here we make use of readily available database 'WideWorldImportersDW-Full.bak' to perform our SQL queries.

ostgreSQL database analysis project solving community council queries using advanced SQL techniques including JOINs, aggregations, and window functions

Project: Deforestation Exploration (SQL) leadership team members are looking to understand which countries and regions around the world seem to have forests that have been shrinking in size, and also which countries and regions have the most significant forest area, both in terms of amount and percent of total area.

SQLite project working with data from a "resort"

Performed operational metrices analysis for a web application.

A comprehensive repository for Data Analytics learning and projects. It includes MySQL, Python, Power BI, Tableau, and Excel. The goal is to analyze data, generate insights, and create compelling visualizations for real-world datasets.

5 different datasets' scenarios and +50 SQL queries