SQL (Structured Query Language) is a language used to communicate with database to retrieve / manipulate data from it. Like how we are communicating each other.. likewise SQL also needs some language to communicate with. So they have introduced a language called SQL. If we need anything from database we must learn this language to communicate with database.
Retrieve means getting or fetching the already stored data from database.
Manipulate means changing the already stored data
What is DATABASE and its STRUCTURE
DATABASE is used to store information or data
A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS).
The structure of relational database consists of rows and columns. In the above image the horizontal arrangement called Rows and vertical arrangement called Columns. Due to this it can be easily accessed, managed, modified, updated, controlled, and organized. Most databases use structured query language (SQL) for writing and querying data.
How to Query DATA
In order to query or fetch the data from database we need to use below keywords…
1 2 3 4 5 6 7 8 | SELECT FROM WHERE GROUP BY HAVING ORDER BY |
Add a Comment