new to dbms, need advice 1

[pandigunta]

hi everybody,
i am new to dbms area.i would like to be strong in dbms, need help regarding where to start ,what links to follow, books etc..,Advices are welcome!!!

Thanks
pandigunta

 

[Terpsfan]

Welcome to the world of databases! It's a lot of fun and it's always challenging. I would suggest starting off with a popular database, Microsoft Access 97. It's easy to use and very simple on the surface. The best book I've seen on Access 97 is Special Edition Using Microsoft Access by Roger Jennings. It's written in a way that anyone can understand and when you're done with the book, you'll have a very comprehensive knowledge of Access and databases in general. Access' appeal is that you don't have to be a database expert to create tables, queries, forms and reports and they have wizards to help you through it. After that I'd suggest learning Visual Basic 6. You can create databases and distribute them in Visual Basic. Then I'd suggest learning either SQL Server or Oracle.

 

[pandigunta]

Omega36
Thanx for the info!!!

 

[2ffat]

There is a tutorial at O'Reilly & Associates network (

http://www.oreillynet.com

) about SQL. This tutorial is generic enough to work on any DB that supports SQL. One of the DB mentioned is MySQL which is free.

IMHO, SQL is a definite must to learn for DB. Almost all popular DBs support SQL in one way or another. Even report writers use SQL to get the data to produce reports.


James P. Cottingham

http://www.ivcusa.com