SQL and its features

Structured Query Language (SQL) is the standard language used for writing queries in databases. It was approved by ISO (International Standard Organization) and ANSI(American National Standards Institute).

SQL contains some important features and they are:

Data Definition Language (DDL):
It contains commands which define the data. The commands are:
create: It is used to create a table.
Syntax:

create table
table name(attribute1 datatype…attribute datatype);
drop: It is used to delete the table including all the attributes.
Syntax:
drop table tablename;
alter: alter is a reserve word which modifies the structure of the table.
Syntax:

alter table
tablename add(new column1 datatype…new columnx datatype);
rename: A table name can be changed using the reserver ‘rename’
Syntax:

rename old table name to new table name;
Data Manipulation Language (DML):
Data Manipulation Language contains commands used to manipulate the data.
The commands are:
insert: This command is generally used after the create command to insert a set of values into the table.
Syntax:

insert into tablename values(attribute1 datatype);
:
:
:
insert into tablename values (attributen datatype);
delete: A command used to delete particular tuples or rows or cardinality from the table.
Syntax:

delete from table name where condition;
update: It updates the supplies in a table.
Syntax:

update table name set tupplename=‘attributename’;
Triggers:
Triggers are actions performed when certain conditions are met on the data.
A trigger contains three parts.
(i). event – The change in the database that activates the trigger is event.
(ii). condition – A query or test that is run when the trigger is activated.
(iii). action – A procedure that is executed when trigger is activated and the condition met is true.
Client server execution and remote database access:
Client server technology maintains a many to one relationship of clients(many) and server(one). We have commands in SQL that control how a client application can access the database over a network.
Security and authentication:
SQL provides a mechanism to control the database meaning it makes sure that only the particular details of the database is to be shown the user and the original database is secured by DBMS.
Embedded SQL:
SQL provides the feature of embedding host languages such as C, COBOL, Java for query from their language at runtime.
Transaction Control Language:
Transactions are an important element of DBMS and to control the transactions, TCL is used which has commands like commit, rollback and savepoint.
commit: It saves the database at any point whenever database is consistent.
Syntax:

commit;
rollback: It rollbacks/undo to the previous point of the transaction.
Syntax:

rollback;
savepoint: It goes back to the previous transaction without going back to the entire transaction.
Syntax:

savepoint;
Advanced SQL:
The current features include OOP ones like recursive queries, decision-supporting queries, and also query supporting areas like data mining, spatial data, and XML(Xtensible Markup Language).
I have posted it for someone having an interest in basic SQL please go through this post
I hope this post is helpful.

1 Like

Thx for the summary for SQL!