Hi, everyone. I am quite new to database programming, I don't know which database system should I choose to practice and which one is most marketable used. There exits several choices as: Oracle, mySQL, MS SQL Server (is it also syBase?), MS Access and DB2. Could someone give me some advice or just tell me about the difference of these systems. Thanks in advance.
Joined: Jan 23, 2002
The products you mentioned are the most commonly used in commercial projects, I believe. However, for learning purposes I would go with MySQL because it's freely available, lightweight (you don't need to buy 2GB RAM to run), and has the most important features in place. The biggest differences among relational database products are (not in any particular order): - price - tools (GUI vs. command-line, reporting tools, etc.) - performance - enterprise features (clustering, replication, etc.) - standards compliancy (e.g. SQL-92 datatypes) - weight (how much h/w do you need to run a private development environment)