SQL Basics - Definition & Concepts
-
Definition: SQL - Structured Query Language, is a database computer language designed
for managing data in relational database
management systems (RDBMS), and originally based upon Relational Algebra
[Origin: Wikipedia.]
-
Its scope includes data query and update, schema creation and modification, and data access control.
-
SQL is used to communicate with a database.
-
Common language for all rational databases.
-
ANSI standard for the language.
However there are variations that extend the ANSI subset. Most common are:
-
T-SQL – Microsoft extensions running on MS-SQL servers.
-
PL-SQL – Oracle extensions running on Oracle databases.
-
Others such as: Sybase, MS-Access, Ingres, PostgreSQL, MySQL etc.
|