| QL stands for Structured Query Language, a | | | | components of both queries and statements, the |
| computer programming language. This is a specialized | | | | whitespace that is used for formatting the SQL |
| type of language that is often used to retrieve data | | | | code, and the semicolon statement that is a part of |
| from RDDMS, or a relational database management | | | | the SQL grammar. |
| system. Because of this, it is also used as a standard | | | | Among these elements, the most common queries |
| language to update or gather data from an existing | | | | to an SQL database is the SELECT declarative |
| information database. | | | | keyword. This keyword is used to retrieve data from |
| Unlike the C programming language and the Beginner's | | | | tables and various SQL database sources. However, |
| All-purpose Symbolic Instruction Code or BASIC | | | | this keyword does not have any standard effect on |
| programming language, SQL is a set-based language. | | | | stored data. |
| It is also a declarative query language with additional | | | | The only problem that most critics think of SQL is |
| extensions. The extensions make the standard SQL | | | | that it is not that easy to configure on other |
| more functional. | | | | operating systems. This is probably the reason why |
| SQL is further divided into different language | | | | some systems do not use this type of database, |
| elements. These include the statements that have an | | | | aside from it being quite complex and large in its file |
| effect on both the data and the schema, the queries | | | | size. In spite of those criticisms, SQL still remains to |
| that have the ability to retrieve the data, the | | | | be one of the popular databases management |
| expressions that are designed to produce tables or | | | | systems being used today. Its flexibility and |
| scalar values, the predicates that are used to specify | | | | manageability in handling data is very efficient too. |
| the conditions, the clauses that are the main | | | | |