Databases

Databases are an intricate part of many programs. It is essential for a programmer to learn about databases. Databases are used to store and manage large volumes of data. When it comes to business applications a database is a must.

Choosing a database software depends on your application. A simple data driven application such as an Address Book can be completed using Access. But when it comes to handling data with larger volume and complexity you will have to turn to an enterprise level database.

When it comes to enterprise level databases there are many database software that can be used. Following are a few of them.


Microsoft SQL Server





This is one of the databases that most of programmers use due to its ease of use. SQL Server has several versions to suit the need of the programmer. And there is also a Free SQL server 2005 Express Edition that can be downloaded from SQL Server official site.



Oracle



One of the most powerful database software that is available. And also one of the most expensive. And configuration can be a bit difficult unless you are an Oracle DBA. Oracle Enterprise Manager is not that user friendly either.

You can use a third party software to manage Oracle.






MySQL



This is the most affordable database for all users. It's free. MySQL is great to work with PHP to create web enabled applications and web sites.

There are also several third party tools to manage the database.