SQL DataBase

Definition :

SQL (Structured Query Language) is a standard interactive and programming language for getting information from and updating a database. Although SQL is both an ANSI and an ISO standard, many database products support SQL with proprietary extensions to the standard language.

Explanation :

Stands for “Structured Query Language,” and can be pronounced as either “sequel” or “S-Q-L.” It is a query language used for accessing and modifying information in a database. Some common SQL commands include “insert,” “update,” and “delete.” The language was first created by IBM in 1975 and was called SEQUEL for “Structured English Query Language.” Since then, it has undergone a number of changes, many coming from Oracle products.

Today, SQL is commonly used for Web database development and management. Though SQL is now considered to be a standard language, there are still a number of variations of it, such as mSQL and mySQL. By using a scripting language like PHP, SQL commands can be executed when a Web page loads. This makes it possible to create dynamic Web pages that can display different information each time they load.

 SQL can do :

•  execute queries against a database
• retrieve data from a database
• insert records in a database
• update records in a database
• delete records from a database
• create new databases
• create new tables in a database
• create stored procedures in a database
• create views in a database
• set permissions on tables, procedures, and views