WHAT IS SQL ? Structured Query Language

in #training7 years ago

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.

table sql.JPG

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

select.JPG

Capture.JPG

Capturwe.JPG

1-WRITES: Reads consists of the following information

insert.JPG

update.JPG

delete.JPG

However, what's been eplained in this gaphic is SQL's most basic structure..

Coin Marketplace

STEEM 0.21
TRX 0.25
JST 0.039
BTC 95276.42
ETH 3297.99
USDT 1.00
SBD 3.16