SQL

Structured Query Language

Pronounced as either “ess queue ell” or “sequel“.

SQL is a language that can be used to create databases, search databases, and modify records.

There are several different versions of SQL – these notes use SQLite, which is suitable for small, portable databases.

SQLite 3

SQLite is a free version of SQL.

SQLite is the most widely deployed database in the world.

SQLite is found in:

  • every Android and iOS device,
  • every Mac and Windows10 machine,
  • every Firefox, Chrome, and Safari web browser
  • every instance of Skype, iTunes, Dropbox client, QuickBooks, PHP and Python
  • most television sets and set-top cable boxes, automotive multimedia systems,
  • and countless millions of other applications.