SQL Structured Query Language Database Concepts
SQL Structured Query Language Database Concepts - The full form of SQL is structured Query language which is used in programming and designed for managing data held in a relational database management system (RDBMS). The SQL will access and manipulate databases. The SQL became an ANSI standard in 1986 and ISO certified in 1987. There are two main advantage of SQL. Firstly, it introduced the concept of accessing many records with a single command and secondly, it eliminates the need to specify how to reach a record. SQL is based on relational algebra and tuple relational calculus.
Who Developed SQL (Structured Query language)?
The SQL was developed by Donald D. Chamberlin and Raymond F. Boyce in early 1970 at IBM. The SQL was told as SEQUEL which was used to manipulate and retrieve data stored in quasi relational database management system.
What are the functions of SQL?
- It can execute queries from a database.
- It can retrieve data or information from a database.
- It can insert records in a database.
- It can update records in a database
- It can delete records in a database
- It can manipulate records in a database
- It can create new table in a database.
- It can create views in database
- It can create permissions on tables, procedures and views.
SQL language is subdivided into many elements. Some of them are clauses, expressions, predicates, queries, statements. Some of the important versions of SQL are SQL-86, SQL-89, SQL-92, SQL- 1999, SQL-2003, SQL- 2008 and SQL-2011 & SQL 2016.
What are the Characteristics of SQL language?
- SQL is an ANSI and ISO standard computer language for creating and manipulating databases.
- SQL is very simple and easy to learn.
- SQL works with database programs like DB2, Oracle, MS Access, Sybase, MS-SQL Server etc.
- SQL allows the user to create, update, delete and retrieve data from a database.