SQL - Structured Query Language
SQL - Structured Query Language
SQL is a standard database computer language designed for accessing and manipulating the data in a database. It is used to manage data in a relational database model. It was first designed in IBM with the version name SEQUEL
It follows an ANSI (American National standards institute) standard. SQL can perform many tasks over a database. It can retrieve data from database and execute queries.
It has many functions like insert records, update records, delete records, create new database, create new tables and set permissions on tables, procedures, and views. There are many versions of SQL although it is a standard. Whenever we build a database we need a place to store data so SQL can act as a location to store information.
Structured query language is divided into different language elements like clauses, expressions, queries and statements. Let us consider the term Queries which is the most common operation in structured query language
Query is performed with the declarative SELECT statement. SELECT performs the task of retrieving data from one or more tables. There are many optional keywords and clauses in SQL like FROM, WHERE, GROUP BY, HAVING and ORDER BY etc.
SQL can be divided into two types Data Manipulation Language (DML) and Data Definition Language (DDL). The DML part of the SQL has queried and update commands like SELECT, UPDATE, DELETE and INSERT INTO.
And the DDL part of database is used to create and delete data; it has statements like CREATE DATABASE, ALTER DATABASE, CREATE TABLE, ALTER TABLE, DROP TABLE etc. Therefore due to its great capabilities on working upon data it has become very famous server scripting language
Thank you
Deepti !
Like it on Facebook, Tweet it or share this article on other bookmarking websites.