Database Concepts -Part I(Brief Introduction) 

To gather/collect information of same entity/things in systematic way in the form of rows and columns

and extract the information from the rows on the basis of columns. For example to store the details of 

students of particular school/collage we arrange the information in the form of columns(user defined)

then store rows of data of different students. Let us further expand that to define attributes of students

such as Admission No,, Name ,Gender, Date of Birth, Class/Grade, Section, Religion, address, city, State, Country , Father's Name, Mother's Name, occupation etc. These are Columns and each & every students must have all or some information to store that makes rows. One thing is important is that for each and every student Admission No.is must and is unique & can not be blank(null) so as to identify the one particular student. So we make Admission No. Primary key .

This arrangement of rows and columns is called TABLE in database terminology. Further to it,

all major operations (Insert, Update/Edit, Delete, Query) operates upon Table and are called DML

(Data Manipulation Language).

To define or create a Table or DML in Database by some sort of commands, SQL is used it is called

Structured Query Language. One must use it to define DML or DDL(Data Defination Language)and 

many other tasks.  

In next Blog I define some useful concepts related to Database and Some Basic SQL commands.

Till then HAPPY Learning!!!