Prerequisite:

basic concepts of computer science, what is a database, especially the basics of RDBMS and associated concepts.

What is SQL

Structured query language

database computer language designed for the retrieval and management of data in a relational databases

A Brief History of SQL

• 1970 − Dr. Edgar F. "Ted" Codd of IBM is known as the father of relational databases. He described a relational model for databases.
• 1974 − Structured Query Language (SQL) appeared.
• 1978 − IBM worked to develop Codd's ideas and released a product named System/R.
• 1986 − IBM developed the first prototype of relational database and standardized by ANSI. The first relational database was released by Relational Software which later came to be known as Oracle.
• 1987 − SQL became the part of the International Organization for Standardization (ISO).

A Relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd in 1970.

Database table structure.

data in an RDBMS is stored in database objects known as tables

Field - columns.