SQL

• SQL is an acrynom for (Structured Query Language).
• It is basically a language to speak and communicate with databases, asking for certain data and information.
• It is used to get data, manipulate it and transform it according to the needs.
• Note:

  There are many popular SQL databases including SQLite, MySQL, Postgres, Oracle and Microsoft SQL Server. All of them support the common SQL language standard.

Relational databases

• are databases that consists of related tables, such that data repition is avoided.

SQL Statements:

• SELECT - FROM (select query)
• to select specified data conditions are used:

  • WHERE condition AND/OR another_condition AND/OR …;

• to sort the data:

  • ORDER BY column ASC/DESC;