Data Base Skills Brushup.


Data base is a collection of information in a sequential way in rows and colums so that it can be retrived easily. Datas in a database can be viewed in form of tables and reports. The simplest form of a table may contain a row and a column. Giant database are also been built with 1000s of rows and colums for applications like flight ticket reservation, hotel maintenance .

Interner is fastly growing, every website stores tons and tons of datas stored for the visitors. These database are performance tuned every then and there so that the data viewers need not wait for a long time for the information they want to view. Suppose you are visiting a share related website, we need to access the information about a particular share, where is the information stored obviously it is been stored in databases like Oracle, Mysql, DB2, Sql Server etc.when we enter a search parameter in the search box the informations are been retrived from these databases and displayed to us.

Web applications are developed on either JAVA or ASP.NET and they are connected to the database using application like ODBC , JDBC .

What ever the database may be they all understand a unique languege called Structure Query Language (SQL). While developing any database driven applications we should know SQL . A simple SQL query is like Select * from tab;

Selects all the tables in the database. If you would like to have more information on databases then you can visit www.databaseguides.com a good site with lot of database related informations.

0 comments:

Post a Comment