SQL is a databases interaction language that allows you to add, retrieve, edit and delete information stroded in databases.
It is designed to be Simple or Flexible !
Databases from the foundation of countries websites and applications, and most data centric apps use relational databases.
Almost every relational databases in the world supports SQ, whick makes it a crucial tool for progmmers
HOW DOES IT WORK ?
Let's start with how databases are set up
Databaes are made up of hundreds or thousands of tables and each table is made up rowsand columns.
Databaes of essentially a heap of infromation.
The way you query the data with SQL allows you to:
ORDER,ORGANIZE AND RETRIEVE IT according to your preferences.
SQL primarly works with two types of operations to query data:
1-READS: which can find and retrieve data | READS
2-WRITES: which can create modify or delete data | INSERT UPDATE DELETE
1-READS: Reads consists of the select command which has three common clauses
1-WRITES: Reads consists of the following information
However, what's been eplained in this gaphic is SQL's most basic structure..