SQL Basics: SELECT, INSERT, UPDATE, and DELETE Explained

Overview of SQL Commands

These four commands are the foundation of SQL:
SELECT: Retrieve data.
INSERT: Add new data.
UPDATE: Modify existing data.
DELETE: Remove data.

Examples:

SELECT Name, Email FROM users;
INSERT INTO users (Name, Email) VALUES ('Alice', 'alice@example.com');
UPDATE users SET Email = 'alice@newdomain.com' WHERE Name = 'Alice';
DELETE FROM users WHERE Name = 'Alice';

Challenge: Practice CRUD Operations

Use a sample products table to:
Add a new product.
Update its price.
Retrieve all products priced above $50.
Delete a product based on its ID.