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.
SQL is applicable in:
Syntax of a basic SELECT SQL statement:
%%sql
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...
Want to create exercises like this yourself? Click here.
No hints are availble for this assesment
Answer is not availble for this assesment
Loading comments...