SQL (Structured Query Language) is the language used to interact with relational databases. It allows you to create, retrieve, update, and delete data in your database.
Basic SQL Commands:
SELECT
: Retrieve data from a table.INSERT
: Add new data to a table.UPDATE
: Modify existing data in a table.DELETE
: Remove data from a table.Example Query:
SELECT Name, Age FROM Customers WHERE Age > 25;
This query retrieves the names and ages of customers who are older than 25.
CREATE TABLE Customers ( CustomerID INT PRIMARY KEY, Name VARCHAR(50), Email VARCHAR(100) );
This command creates a "Customers" table with fields for CustomerID, Name, and Email.