📊 Introduction to SQL

Welcome to the Introduction to SQL repository! This guide is designed for beginners who want to learn how to use SQL (Structured Query Language) to manage and interact with relational databases.

📚 What is SQL?

SQL (Structured Query Language) is the standard language used to communicate with relational databases. With SQL, you can:

• Create and manage databases and tables
• Insert, update, and delete data
• Retrieve data with queries
• Control access and security
• Perform advanced operations like joins, aggregation, and subqueries

🚀 Topics Covered

This repository includes the basics and some intermediate concepts of SQL:

1. Database & Tables
   • CREATE DATABASE
   • CREATE TABLE
   • ALTER TABLE
   • DROP TABLE
2. Basic Queries
   • SELECT
   • WHERE
   • ORDER BY
   • LIMIT
3. Data Manipulation
   • INSERT INTO
   • UPDATE
   • DELETE
4. Filtering & Aggregation
   • DISTINCT
   • COUNT, SUM, AVG, MIN, MAX
   • GROUP BY
   • HAVING
5. Joins
   • INNER JOIN
   • LEFT JOIN
   • RIGHT JOIN
   • FULL JOIN
6. Subqueries & Aliases
   • Subqueries in SELECT, WHERE
   • Table and Column Aliases
7. Indexes & Constraints
   • PRIMARY KEY, FOREIGN KEY
   • NOT NULL, UNIQUE, CHECK
   • INDEX