New Techno

                     This is the second part of Relational database post. We talk about create and delete database and  tables in last post. So, in this post I ‘ll hope to give knowledge relevant  operations inside tables . Okey , let’s start.                          First I would like to mentions that what are the kind of operations we can do inside table. You know them. They are insert data, select and get data, delete data, update data as well as join tables , create views and index like wise.   Lets refer those things as below. After create database and tables very first we should insert data. Because we don’t do any other operations without any data.   So, let’s start from insert data Insert data         INSERT INTO table_name( column_names) VALUES (values); Ex-:   ...

Relational Database (SQL) 1 First   I should thanks for everyone who viewed my first and second post. This is my third blog post. In here I talk about relational database. Before that lets see what is a database. Lots of time we can hear this name,   when we create a website or when we create a system   and lots of   time   when we dealing with computer system. Sometimes you have heard that Someone say    “it is a database problem ” or ”it is difficult to connect with database” likewise. So, lots of time   in industry you can hear   this word   “database”. Database is an organized collection of data Think , we have lots of data relevant students details and their marks for subjects. So, we organize that data according to a method which we can manipulate data easily. We can say it is a database. Generally we store and access database electrically from a computer system .     You may be heard relational database and...