What Is SQL?
- SQL is a standard language for accessing and manipulating databases.
- SQL is an ANSI (American National Standards Institute) standard.
- SQL can execute queries against a database.
- SQL can retrieve data from a database.
- SQL can insert records in a database.
- SQL can update records in a database.
- SQL can delete records from a database.
- SQL can create new databases.
- SQL can create new tables in a database.
- SQL can create stored procedures in a database.
- SQL can create views in a database.
- SQL can set permissions on tables, procedures, and views.
Although SQL is an ANSI standard, there are many different versions of the SQL language. To be compliant with the ANSI standard, they all support at least the major commands in a similar manner, but most of the SQL databases also have their own proprietary extensions.
Demonstration
Below is an SQL test area from W3Schools, which uses the well-known Northwind sample database. The tables here are for read only because of the problem of embedding the scripts. For a fully working example, check this by using Chrome.
|
Result:
|
The Database includes:
|
|
The Database includes:
|