basic-sql

This repository is a curated collection of SQL queries and interview questions designed to help developers, data analysts, and database enthusiasts prepare for SQL-related technical interviews. It covers a wide range of SQL topics categorized by difficulty levels: Basic (L0), Intermediate (L1), and Advanced (L2).

This project leverages advanced SQL queries to analyze and optimize an e-commerce platform's supply chain operations. It addresses key challenges like transaction analysis, customer segmentation, shipping efficiency, and order cancellation trends, providing actionable insights for enhancing operational performance and customer satisfaction.

Analysis using SQL

SQL project analyzing pizza sales data to uncover insights on revenue, customer behavior, and product performance.

A Django CRUD App

A collection of essential SQL practice queries, covering key concepts from basic CRUD operations to joins, subqueries, and functions. Ideal for beginners and those reviewing core SQL skills.

Learn how to execute core SQL commands to define, select, manipulate, control access, aggregate, and join data and data tables. Understand when and how to use subqueries, several window functions, and partitions to complete complex tasks. Clean data, optimize SQL queries and write select advanced JOINs to enhance analysis performance.