Database Creation Using ZOHO and SQL

Posted on February 17, 2008. Filed under: Iron and Steel Industry |

(B)

These are the list of steps which one follows to make their own database and manage your operation in an instant through SQL.
1) You need to log on to db.zoho.com where you have to make 1 user id. Here you can face problem if you are using internet explorer, as it is a Microsoft product it might not support zoho operation. So it is preferable to use Mozila.
2) After making your id, log on and then make database which you can give any name.
3) Then you need to make few tables which you can upload from excel or any other place. If you have your data in excel, you can directly upload that data in your database else you have to enter it. You just need to select Import from excel….
4) It’s so easy; you are now done with your formulation of database without any cost and loss of time. Your all data is now on web which you can access from anywhere.
5) All major work is done. Now you will get all data in your own pattern of arrangement, you just need to enter a query by selecting it from new option which is mentioned at the top of the above produced table.
6) One example will be given to you, when you will open that page. Here you just need to type your query in that particular manner according to your requirement and you will get all data in arranged pattern. There is an option at the side of that page which will help you in making query. It has all functions as well as table content. It is very user friendly; it will take some time to understand on passing the query but after that wow……
7) These were simple, but remember after making your query doesn’t forget to save it for your future reference. Also after making each query, open a new query from new option at the top.
Over- yes it’s done. You had made your own database in few hours and that too free. Isn’t it great? So go ahead and make your database now.