SQL

Structured Query Language (SQL) (pronounced S-Q-L; historically “sequel”) is a domain-specific language used to manage data, especially in a relational database management system (RDBMS).

Wikipedia / SQL

SQL is a standard adopted by the following organizations.

  • American National Standards Institute ( ANSI )
  • International Organization for Standardization ( ISO )

What can SQL do?

SQL can perform any of the following:

  • Execute queries against a database
  • Retrieve data from a database
  • Insert records in a database
  • Update records in a database
  • Delete records from a database
  • Create new databases
  • Create new tables in a database
  • Create stored procedures in a database
  • Create views in a database
  • Set permissions on tables, procedures, and views

Standard SQL commands

  • SELECT
  • UPDATE
  • DELETE
  • INSERT
  • WHERE

To build a website that shows data from a database, you need