1. Creating a Table: Creating a table in SQL involves defining its structure, including the columns and their data types. Let’s consider an example of creating a simple table to store information about employees:

CREATE TABLE Employees (
EmployeeID INT PRIMARY KEY,
FirstName VARCHAR(50),
LastName VARCHAR(50),
Department VARCHAR(50),
Salary DECIMAL(10,2)
);

In this example, we create a table named “Employees” with columns for EmployeeID, FirstName, LastName, Department, and Salary. The data types (INT, VARCHAR, DECIMAL) define the kind of data each column can hold.
2. Inserting Data: Once a table is created, data can be inserted using the INSERT INTO statement:

INSERT INTO Employees (EmployeeID, FirstName, LastName, Department, Salary)
VALUES (1, 'John', 'Doe', 'IT', 60000.00);

This adds a new record to the Employees table with the specified values for each column.

3. Querying Data:

SQL’s SELECT statement is used to retrieve data from a table. For instance, to fetch all employees from the IT department:

SELECT * FROM Employees WHERE Department = 'IT';
This query returns all columns for records where the Department is 'IT'.

4. Updating and Deleting Data:

SQL provides UPDATE and DELETE statements for modifying existing records. For example, to increase John Doe’s salary:

UPDATE Employees SET Salary = 65000.00 WHERE EmployeeID = 1;

To remove an employee from the table:

DELETE FROM Employees WHERE EmployeeID = 1;

These statements enable users to maintain the accuracy and relevance of data within a table.