SQL Cheat Sheet 📘

This repository is a comprehensive collection of SQL syntax, statements, and commands.
It’s designed to be a quick reference for developers, students, and database administrators working with Oracle Database.

✍️ Written by: JaberAlJ

---

🚀 Getting Started

Browse the 📂 Cheat Sheets folder and open any .md file to view commands.
Each section is self-contained and focuses on a specific SQL topic.

---

📝 Table of Contents

Navigate to the specific SQL cheat sheets using the links below:

• Advanced 🔑

  • Advanced SQL concepts and techniques for querying, optimizing, and managing data efficiently.

• Basics 🔑

  • Quick reference to fundamental SQL concepts, operators, data types, and built-in functions.

• SQL Clauses 📑

  • Commands used to filter, group, and sort data in SQL.

• DCL (Data Control Language) 🔐

  • Commands used to control access and permissions in the database.

• DDL (Data Definition Language) 🏗️

  • Commands for creating, altering, dropping, and managing database objects.

• DML (Data Manipulation Language) ✍️

  • Commands for inserting, updating, deleting, and managing data inside tables.

• DQL (Data Query Language) 🔍

  • Commands for retrieving data using selecting, filtering, sorting, and grouping.

• Extras 🔍

  • additional resources to help you write better, faster, and more reliable SQL.

• SQL Joins 📌

  • Commands used to combine rows from two or more tables based on related columns.

• TCL (Transaction Control Language) 🔄

  • Commands for managing transactions: commit, rollback, savepoint.

---

⭐ Support

If you find this project helpful, please give it a star ⭐ on GitHub — it helps others discover it!

👋 Contribution

Contributions are always welcome! If you find any commands that are missing, incorrect, or could be improved, please feel free to:

1. Open an Issue: Report a bug, suggest an enhancement, or ask a question.
2. Submit a Pull Request: Make changes directly and submit them for review.

---

📂 Repository Structure

The repository is organized into logical sections to make it easy to find the SQL statements you need.
Each topic has its own dedicated Markdown file (.md) inside the Cheat Sheets/ directory.

├── 📁 Cheat Sheets/
│   ├── 📁 Advanced/
│   │   ├── 📖 README.md
│   │   ├── 📝 analytic-functions.md
│   │   ├── 📝 hierarchical-queries.md
│   │   ├── 📝 indexing.md
│   │   ├── 📝 sequences.md
│   │   ├── 📝 set-operators.md
│   │   ├── 📝 subqueries.md
│   │   ├── 📝 synonyms.md
│   │   └── 📝 views.md
│   ├── 📁 Basics/
│   │   ├── 📖 README.md
│   │   ├── 📝 data-types.md
│   │   ├── 📝 functions.md
│   │   └── 📝 operators.md
│   ├── 📁 Clauses/
│   │   ├── 📖 README.md
│   │   ├── 📝 between-in-like.md
│   │   ├── 📝 distinct.md
│   │   ├── 📝 group-by.md
│   │   ├── 📝 having.md
│   │   ├── 📝 order-by.md
│   │   └── 📝 where.md
│   ├── 📁 DCL/
│   │   ├── 📖 README.md
│   │   ├── 📝 grant.md
│   │   └── 📝 revoke.md
│   ├── 📁 DDL/
│   │   ├── 📖 README.md
│   │   ├── 📝 alter.md
│   │   ├── 📝 create.md
│   │   ├── 📝 drop.md
│   │   └── 📝 truncate.md
│   ├── 📁 DML/
│   │   ├── 📖 README.md
│   │   ├── 📝 delete.md
│   │   ├── 📝 insert.md
│   │   ├── 📝 merge.md
│   │   └── 📝 update.md
│   ├── 📁 DQL/
│   │   ├── 📖 README.md
│   │   ├── 📝 filter.md
│   │   ├── 📝 group.md
│   │   ├── 📝 select.md
│   │   └── 📝 sort.md
│   ├── 📁 Extras/
│   │   ├── 📖 README.md
│   │   ├── 📝 best-practices.md
│   │   ├── 📝 common-errors.md
│   │   ├── 📝 performance-tips.md
│   │   └── 📝 shortcuts.md
│   ├── 📁 Joins/
│   │   ├── 📖 README.md
│   │   ├── 📝 cross-join.md
│   │   ├── 📝 inner-join.md
│   │   ├── 📝 outer-join.md
│   │   └── 📝 self-join.md
│   └── 📁 TCL/
│       ├── 📖 README.md
│       ├── 📝 commit.md
│       ├── 📝 rollback.md
│       └── 📝 savepoint.md
└── 📖 README.md