SQL Introduction

Before we talk about SQL we will know some terminology like
1-RDBMS :Relational Database Management System .
The data inRDBMS is stored in database objects called tables.
2-Table :is a collection of related data entries and it consists of columns(called also fields) and rows(called also records).
from this we can reach that objects that stored inside database must have relations between each other so it is called relational databases.

SQL is a standard language for accessing and manipulating databases.
SQL stands for Structured Query Language.
What SQL can do?

SQL can execute queries against a database

SQL can retrieve data from a database

SQL can insert records in a database

SQL can update records in a database

SQL can delete records from a database

SQL can create new databases

SQL can create new tables in a database

SQL can create stored procedures in a database

SQL can create views in a database

SQL can set permissions on tables, procedures, and views

So inside SQL server we can define many databases and everyone contains many tables.
Each table consist of many columns and rows(you can imagine that table is like an object which contain many attributes(columns in this case) ,This columns can describe your entity(table)

thanks we will continue in another post 😀