i want to know which database is best to learn as a new comer
access 2003 or sql 2005. which one is easy to understand.
2006-10-29 23:18:26 · 7 answers · asked by mw_7009 1 in Computers & Internet ➔ Programming & Design
first of all its upto you. both are microsoft products. now from your point of view. you can choose access 2003 for few days as a starting and basic just to wash your hand with database. once you are familiar with database design like what is rows tables quaries relations etc. then u can jump upto sql. Sql is good specially when u r matching it with VB 2005. as a backhand.
2006-10-30 04:14:36 · answer #1 · answered by GLADIATOR 3 · 0⤊ 0⤋
To Learn about database, you must find a Database system that support :
- Transactions
- Stored Procedure
- Trigger
MySql version 5.0 , Microsoft SQL server 2005, Interbase, Firebird, fit all the minimum requirement for the complete database.
http://dev.mysql.com/doc/refman/5.0/en/index.html
http://www.microsoft.com/sql/
if you have to choose between MsAccess and Ms Sql Server, choose Microsoft SQL Server 2005.
Microsoft Access 2003 ??? don't ever think about it.
2006-10-30 01:46:23 · answer #2 · answered by Manzana verde 5 · 0⤊ 0⤋
2003
2006-10-29 23:25:22 · answer #3 · answered by Thanks for the Yahoo Jacket 7 · 0⤊ 0⤋
stay away from microsoft stuff as much as you can, if you want to learn something you can use in the future.
Get mysql or postresql - they are both free and standard compliant. Knowing either of those will make you comfortable with any database engine.
Knowing microsoft crap will (in the best case) let you work with that particular version... unli they retrofit a patch into it.
Just look at this board ... see how many questions are flying around "how I do this..." in access, "how i do that..", "how do I write this query..." in access etc... and how almost noone is answering them?
There is a reason for that.
2006-10-29 23:39:42 · answer #4 · answered by n0body 4 · 0⤊ 0⤋
Start with the basics. Learn SQL first then pick a specific database brand: http://www.w3schools.com/sql/default.asp
Oracle
MS SQL
mySQL
2006-10-29 23:26:38 · answer #5 · answered by Anonymous · 0⤊ 0⤋
sql server it contain all the concept of database programming.n it follow the maximum rules of database .
2006-10-29 23:25:18 · answer #6 · answered by Vinita T 1 · 0⤊ 1⤋
Access is so old,slow and there is no enough job dealing with.
SQL server and Oracle are the best and more job dealing with them .
Both of them are easy to learn
2006-10-30 04:14:45 · answer #7 · answered by Moein 3 · 0⤊ 0⤋