February 26, 2015

Structured query language,SQL Query Processing

Structured query language

The common commands and methods used in it are grouped into the following categories: Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language (DCL), Logical Connectors, Comparison operators, Aggregate functions, Joins, Sub query, Relational operators, Where clause etc.

Data definition language covers SQL commands that create and destroy database tables.

Data manipulation language covers SQL commands that create, change or destroy the information in a database table or the structure of the table.

Data control language covers protection to the database such as granting access to the tables.

Comparison operators cover those operators that allow for comparison between two items.

Aggregate function deals with those standard SQL functions that allow programmers to narrow the search of a database.

Joins category covers those items that allow information from two or more tables to be related.

SQL Query Processing