SQL Notes

📖 Overview

This repository contains my structured notes and exercises for learning and practicing SQL. It is designed as both a reference guide and a hands-on lab environment.

🗂 Contents

• notes/ → Markdown summaries of SQL concepts
• scripts/ → Sample SQL queries and scripts
• data/ → Example datasets for practice (SQLite/MySQL compatible)

🔑 Key Topics

• Basic SQL syntax (SELECT, INSERT, UPDATE, DELETE)
• Filtering and sorting with WHERE, ORDER BY, LIMIT
• Joins: INNER, LEFT, RIGHT, FULL
• Aggregations: GROUP BY, HAVING
• Subqueries and nested queries
• Views, indexes, and performance optimization

🚀 Usage

You can run the scripts with any SQL engine:

# SQLite
sqlite3 sample.db < scripts/example.sql

# MySQL
mysql -u root -p < scripts/example.sql

🎯 Goal

Build a strong foundation in SQL for data analysis, business intelligence, and backend integration.