SQL (Structured Query Language) is a standardized programming language used to manage and manipulate relational databases. It allows users to perform various operations on the data stored in a database, such as querying data, inserting new data, updating existing data, deleting data, and creating or modifying database structures (like tables and indexes).
OR
SQL stands for Structured Query Language. SQL is used to access and manipulate the RDBMS database. RDBMS stands for Relational Database Management System. RDBMS is a transactional database that includes Oracle, MySQL, SQL Server, etc.
Key Features of SQL:
1. Data Retrieval (Querying): SQL allows you to retrieve data from a database using commands like SELECT.
2. Data Manipulation: You can add, modify, or delete data using SQL commands such as:
INSERT INTO: Adds new data.
UPDATE: Modifies existing data.
DELETE: Removes data.
3. Data Definition: SQL lets you define and modify database structure (tables, relationships, etc.) using commands like:
CREATE: Creates a new database or database object (table, view, index).
ALTER: Modifies an existing database object.
DROP: Deletes a database object.
4. Data Control: SQL provides commands to control access to the data, such as:
GRANT: Grants permissions to users.
REVOKE: Removes permissions from users.
SQL is used for other operations also.
1) Users can create a view.
2) The user can create a store procedure.
3) Users can create Triggers.
4) Users can create functions.