The SQL has proved to be a language that can be used by both casual users as well as skilled programmers. It offers a variety of processing capabilities, simpler ones of which maybe used by the former and the more complex by the latter class of users.
Processing capabilities are as follows:
- Data definition language (DDL) : The SQL DDL provides commands for defining relation schemas, deleting relations, creating indexes and modifying relation schemas
- Interactive data manipulation language : The SQL DML includes a query language based on both the relational algebra and the tuple relational calculus. It includes also commands to insert, delete, and modify tuples in the database.
- Embedded data manipulation language : The embedded form of SQL is designed for use within general purpose programming languages such as PL/1 COBOL, Fortran, Pascal and C, C++ etc.
- View Definition : The SQL DDL also includes command for defining views.
- Authorization : The SQL DDL includes commands for specifying access rights to relations and views.
- Integrity : The SQL provide Limited forms of integrity checking future products and Standards of SQL are likely to include enhanced features for integrity checking.
- Transaction Control : SQL includes commands for specifying the beginning and ending of the transaction along with commands to have a control over transaction processing.
Coding Blogs 