SQL stands
for Structured
Query Language
and is a scripting language used to interact (store and retrieve data) with
SQL relational
database
management systems (RDMS). This provides a universal scripting format to work
with these databases, no matter which server or platform you use. However, due
to commercial points of difference, unfortunately this is not the case and
usually you have to learn the nuances of the language in reference to each
individual SQL
server. Currently popular commercial
SQL servers
include; ORACLE and
Microsoft
SQL server as
well as
Open Source alternatives such as MySQL and PostgreSQL.
SQL commonly
consists of a SELECT statement for selecting a dataset, a FROM statement to
define the table or location that the dataset will be derived from, as well as
any other commands or functions to further filter the dataset. |