SQL,Structured Query Language
Structured Query Language is a language that is used to communicated with databases. Both ASP and CGI use it.
The actual management of the data is done by Relational DataBase Management System(RDBMS). With SQL we give orders to RDBMS.
There are 3 categories of SQL instructions: Data Manipulation Language (DML), Data Definition Language (DDL) and Data Control Language (DCL).
DML is used to select, add, change and delete contents of the database
DDL creates and manage databases, tables, views and indexes.
DCL is used to secure the database. Everyone may read, but only some persons can change the data.
- Select data
- Add/Change/delete data
- Management of tables and relations