I am a network admin with no db exp at all. I want to learn more about db's and see if it is something I might enjoy as the network admin field has become flooded (at least in my area) and I wish to pursue other options. I for all intensive purposes know nothing about db's. There are no classes close to me that I can take so I am at least for now starting with self education. A few people suggested I get started by learning Access and expanding from there. Any opionions on that advice would be great as well as what books are recommended to get started with my teaching. I am very green and will need something that is easy for a newb to understand. I appreciate any feedback. Thanks.
for developing Litwin and Getz Access Developer's handbook
I think Que books put out an Access Bible - though there are several books with that kind of title - the on where the data samples are from a Vetinarian hospital is the best in my opinion.
Also O'Reilly Press has a very good core of data base design and language called (I think) Access Database programming - something like that.
My advice is to start with a book about relational databases. Since all of the major databases (Access, SQL Server, Oracle, MySQL, etc.) use relational database theory to store and represent data.
It should cover topics like normalization, table relationships (one-to-many, many-to-many) and referential integrity.
You will also want to have a book that covers SQL syntax. That way you can create tables, add, delete and update table data.
Then finally you will want something that will help you create a useful application. You can use Access (forms, reports, etc) and VBA, Visual Basic, C#, or something similar to allow you to create the user interface (forms, reports, etc.).
It will take some time to get up to speed. Then once you are up to speed, staying up-to-date will be similar to staying up-to-date as a network admin.
One good thing for you is you can skip ahead and begin using the most recent languages, software, etc. If you are using Microsoft products, I would recommend C#, VB.NET, ADO.NET, SQL Server 2005, and Access 2007. If you are at the bookstore or online and you are not sure what technologies to target, anything .NET will be more current.
DC, thank you very much for the reply. That helps me a lot by just gettting a better grasp on some basic areas.
Ax, thanks for your recommendation. Can you elaborate just a bit more on which bible, when I search an Amazon i get multiple responses with mulitple authors. Can you mention which author you recommed. I noticed you mention Que, but I cannot tell if that is a publisher,author or something else. thanks again.