SQL (Structured Query Language) is a standard database programming language used for accessing and manipulating data in a database.
For handling database and database-related programming, programmers need to have some medium, or you can say interface to particularize a set of commands or codes to deal with a database or to access database's data. In this chapter, you have a brief introduction of those terminologies that you will study during the journey towards learning SQL.
What Will You Learn from SQL
SQL gives unique learning and database handling techniques on Structured Query language and will help you make better command over the SQL queries and to deal with these codes efficiently. Since SQL helps you to include database creation, database or table deletion, fetching row data and modifying those data, etc., in parallel SQL makes things automatic and smooth for end users to access and deal with that application's data efficiently.
What is SQL?
- SQL is Structured Query Language which was originally developed by IBM.
- SQL is pronounced as "sequel".
- SQL is a computer language for storing, manipulating and retrieving data in a relational database.
- SQL is the standard language for Relation Database System.
History of SQL
- SQL was developed In 1970 by Donald D. Chamberlin and Raymond F. Boyce at IBM.
- First, developed version is initially called SEQUEL(Structured English Query Language).
- Relational software released a first commercial product called System/R in 1979.
- The SEQUEL acronym was later changed to SQL due to trademark conflict issue.
- Later IBM starts developing commercial products on SQL based on the prototype of System/R.
The SQL Can Do
- SQL can CREATE new databases and its objects like (table, index, views, store procedure, functions, and triggers).
- SQL can ALTER the structure of the existing databases.
- SQL can DROP(delete) objects from the database.
- SQL can TRUNCATE(remove) all records from the tables.
- SQL can COMMENT to the data dictionary.
- SQL can RENAME an object.
- SQL can SELECT(retrieve) data from the database.
- SQL can INSERT data into a table.
- SQL can UPDATE existing data within a table.
- SQL can DELETE records from a database table.
- SQL can set GRANT and REVOKE privileges of users in a database.