sql-joins

🚀 Comprehensive Rust systems programming portfolio featuring 10 high-performance projects: Redis-compatible database, web framework, Kafka message queue, P2P file sharing, search engine, compiler/interpreter, Docker container runtime, Git VCS, TensorFlow ML library & graph database with SQL joins

An ode to how Oracle SQL got me interested in the world of DBMS.

🧠 Structured SQL Learning Repository | Beginner to Advanced Topics + Real Projects 🎯 Covers core SQL skills, window functions, performance tuning, and hands-on data warehousing/EDA projects

Step-by-step SQL tutorials and practical examples covering queries, constraints, transactions, and more. Ideal for beginners, interview prep, and anyone looking to master SQL—from basics to advanced.

SQL Company Database Analysis using MySQL & PostgreSQL | Joins, Subqueries, Aggregations & Database Design

In this project I queried Chinook database by extracting, aggregating, and analyzing data. By competing my analysis, I was able to make suggestions on business optimization practices.

SQL-based KPI Analysis to track business performance, analyze key metrics, identify trends, and generate data-driven insights using SQL queries and aggregations.

E commerce DB - 4 Table Normalized Database with Joins, PK/FK, many to many

FlowLog is a lightweight, terminal-based inventory management system built with Python and MySQL.

Repository for managing SQL queries using concepts of Joins, Procedures and Triggers

This project is done as part of Codebasics Data Analyst Bootcamp

SQL-based Sales & Customer Analysis using MySQL to uncover revenue, profit, customer behavior and sales trends.

A comprehensive SQL practice repository covering database fundamentals, joins, subqueries, transactions, indexing, performance optimization, and security.

Applied MySQL to solve business problems.

The Chinook database is a relational database that models a digital music store. It stores information about artists, albums, tracks, media types, genres, customers, employees, invoices, and playlists. The schema supports realistic business operations such as music purchases, customer billing, playlist creation, and employee support management.

This repository contains structured SQL notes, practice queries, and interview questions. Covers DDL, DML, Joins, Subqueries, Constraints, Views, and more. Ideal for beginners, students, and developers to learn, practice, and revise SQL with real-world examples and sample database schemas.

A 4-table relational rideshare database analysis using multi-table JOINs, LEFT JOIN chaining, and CTEs to prevent fan-out and optimize driver supply.

A relational database project built in MySQL to manage products, categories, and suppliers.

An Express and SQLite API for authors and books, built on SQL joins.

Using SQL joins to combine data from multiple tables, such as inner, outer, left, right or self-joins. Ironhack Data Analytics Bootcamp.