Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

new to database question

 
Yuan Ye
Ranch Hand
Posts: 172
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Lasse Koskela
author
Sheriff
Posts: 11962
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic