Introduction to SQL

SQL (Structured Query Language) is the standard language for managing relational databases.

Key Concepts:

• Tables: Store data in rows and columns
• Queries: Retrieve data from tables
• CRUD: Create, Read, Update, Delete

Basic Commands:

-- Select all data
SELECT * FROM users;

-- Select specific columns
SELECT name, email FROM users;

-- Filter with WHERE
SELECT * FROM users WHERE age > 18;

-- Order results
SELECT * FROM users ORDER BY name ASC;

Creating Tables:

CREATE TABLE users (
  id INT PRIMARY KEY,
  name VARCHAR(100),
  email VARCHAR(100),
  age INT
);