What is SQL
SQL is a very simple, intuitive and self-explanatory data reading and modification language like typical English sentence formations.
SQL stands for Structured Query Language and is a standard term for such purposes
SQL lets you access and manipulate databases (read and modify)
SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987
With SQL, one can
Read data from a database (SELECT)
Insert new data or rows in a database (INSERT)
Update/modify existing rows in a database (UPDATE)
Delete rows from a database (DELETE)
Create new databases
Create new tables in database
Create view, procedures and other types of objects in a database
Change the structure of tables/indexes/other objects (ALTER)
Set permissions on tables/procedures/views and other objects
Syntax of a basic SELECT SQL statement:
SELECT field1, field2,...fieldN [FROM table_name1, table_name2...] [WHERE Clause]
SQL statements are run against a database and few or all columns are selected from a table stored in database files.
We will study more about database and database management systems in this series.
Taking you to the next exercise in seconds...