Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
Possible Duplicate:
Must-read Books for DBA
I'm already reading a book on Introduction to SQL (RDMS). But that only teaches SQL and commands and I feel like my knowledge lacks in database management. Can you recommend me a good book to Database management which teaches about managing the databases instead of just using the queries to get something done?
It really depends on which flavor of RDBMS you're working with. Oracle database management is significantly different from SQL Server database management, for instance.
I answered a similar question recently here, but one of the best (Oracle) DBA books that I've read is Darl Kuhn's Pro Oracle Database Administration. I used it as a textbook in graduate school, and it covers everything from install, config, backups, partitioning, etc, as well as common real-life problems and their solutions.
I wouldn't classify it as being for "beginners", but I had never had any database management before either, and I did ok.
There are some generic books out there that may teach you general database design and such. If you want to get into the administration of it you will need to select a RDBMS to work with. The components of each RDBMS are different and require different methodologies for managing them.
If you want to get familar with database design (which I think and DBA should know) there is a self-paced and free online course that Stanford professors are offering on their own time. You can find that here.
As I work with SQL Server I can only suggest books dealing with that RDBMS but a few I would suggest: Buck Woody's Administrator's Guide to SQL Server 2005 (older version but still applies) Thomas LaRock's DBA Survivor (Multiple Authors) Beginning SQL Server 2008 Administration Learning SQL Server in a Month of Lunches (this book is still in the process of completion but Manning publishing lets you get chapters as they are finished, then when it is done you get a complete copy of it)
