SQL Programming Language Profile

SQL

Structured Query Language (SQL) is a specialized programming language originally developed by IBM in the early 1970s. The language is designed specifically for accessing and manipulating data held in a relational database management system (RDBMS).

Almost all database management systems have a SQL implementation. It is the most popular query language for database administrators, as it provides good functionality, power, and relative ease of use. It is widely used in both industry and academia, often for large, complex databases.

SQL was standardized by the American National Standards Institute (ANSI) in 1986 and has undergone many revisions. The language consists of a data definition language and a data manipulation language. The language is divided into a number of elements: clauses, expressions, predicates, queries, and statements. SQL is one of the easiest languages to learn and use.

FACTS

Type of Language: Declarative
Designed by: Donald D. Chamberlin, Raymond F. Boyce
Public Release: 1974
License: Open
Website: –

RECOMMENDED OPEN SOURCE BOOKS

OPEN SOURCE SOFTWARE FOR DEVELOPERS

HeidiSQL – A useful and reliable tool designed for web developers using the popular MySQL server, Microsoft SQL databases and PostgreSQL.
DbVisualizer – A universal database tool for developers, DBAs and analysts.

USEFUL RESOURCES

Vertabelo – Offers interactive SQL courses.

RECOMMENDED BOOK TO BUY