[Allophyl]

I was wondering if anyone could suggest any good books for learning database design (both beginning and advanced), as well as books on any other database topics which would be relevant to a software engineer.

[russian]

Allophyl, on 17 August 2010 - 05:12 PM, said:

I was wondering if anyone could suggest any good books for learning database design (both beginning and advanced), as well as books on any other database topics which would be relevant to a software engineer.

C++ for dummies is a good book that explains you in a really good format. It keeps all the codes clear and understandable...

Hope this helps

[MentalFloss]

Start here: http://en.wikipedia....Database_design

[Allophyl]

russian, on 17 August 2010 - 10:11 PM, said:

Allophyl, on 17 August 2010 - 05:12 PM, said:

I was wondering if anyone could suggest any good books for learning database design (both beginning and advanced), as well as books on any other database topics which would be relevant to a software engineer.

C++ for dummies is a good book that explains you in a really good format. It keeps all the codes clear and understandable...

Hope this helps

Is that a joke?

MentalFloss, on 19 August 2010 - 03:32 AM, said:

Start here: http://en.wikipedia....Database_design

Wikipedia doesn't provide anywhere near the depth required to properly learn a subject like database design. Like I said, I'm looking for *books*. Ones that can actually teach me what I need to know about the subject so that I can actually use that knowledge to get a job. Not just some brief overview of it like wikipedia gives.

[MentalFloss]

Quote

Wikipedia doesn't provide anywhere near the depth required to properly learn a subject like database design. Like I said, I'm looking for *books*. Ones that can actually teach me what I need to know about the subject so that I can actually use that knowledge to get a job. Not just some brief overview of it like wikipedia gives.

No. I said start there. As in read the page and see what aspects of it there are.

Then, go to a store. Find a book that talks in depth about those concepts you saw on wikipedia.

There isn't going to just be one book teaching this. Like programming languages, paradigms for best db design are popping up every year... it's a process that doesn't end.

However, learning the normalizations is a huge step forward. From that, try to actually just design a database.

See, it takes practice in that regard. Let me give you an idea of the process:

First, have a reason for a database. Create it and populate it.

Next, create an application that interfaces with that database. It should use the tables and any stored procedures etc that you have a need for.

Next, profile the database's performance. Ensure that for what the program is designed to do, there is not a unacceptable performance review.

With your performance review in an unacceptable status, fine-tune the database to suit the true needs.

With your fine-tuning, go back to your application code and change it so that it continues to work.

With that done, profile the database's performance. Yes, again... you do it over and over until it is acceptable.

There, I saved you the need for a book. Design must meet functionality.

[macosxnerd101]

See my blog entry how to find a programming resource. Also, you can download some of the tutorials in the Database Tutorials sections.