SQL Introduction

So a lot about SQL, what exactly it is?

Its a Structured Query Language, It works on the basis of Query with a Database and accessing the contents, that helps to manipulate some desired output or display.


The previous answer leads to another question, What is a Database?

Database is a server or a place where data is stored. and data is any information related to any organization or business.


SQL helps us to extract the data from a Database. with SQL we can delete, add, append, sort, update, create, set permissions, insert and execute commands to a Database.


Now, how is a Databased Structured?

Well you cannot see the physical structure of a database, but logically, A Database consists of one or more Tables, and each table consists of one or more records.


Each Table in a Database is identified by a specific name, hence in a Database, no two tables can have the same name. And Records in a Table are made of rows and columns, each column is identified by a specific name, two different tables can have same column name, but in one table two columns cannot have same column name. Rows are where data resides, Thus making a full blown Table ready to be played with.


Hope this is informative, and yes I know some of you might be aware of this, but its for some noobs out there cribbing with SQL Tools and abusing web admins and speaking shit about security.


Thank You!