What is an SQL Database?
An SQL database is a relational database that uses Structured Query Language (SQL) to store, manage, and retrieve data. Common SQL databases include:
-
MySQL
-
PostgreSQL
-
SQLite
-
Microsoft SQL Server
-
Oracle Database
🔹 Common SQL Commands
🛠️ Create Table
CREATE TABLE users (
id INT PRIMARY KEY,
name VARCHAR(100),
email VARCHAR(100) UNIQUE
);
📥 Insert Data
INSERT INTO users (id, name, email)
VALUES (1, 'Alice', 'alice@example.com');
🔍 Select Data
SELECT * FROM users;