HN Books @HNBooksMonth

The database course I took covered that a bit. We used https://www.amazon.com/Database-Management-Systems-Raghu-Ram.... It's not the most up-to-date text (although it was when I was in school), but it's probably still the best source for the basics of relational database theory and implementation.

https://www.amazon.com/Database-Management-Systems-Raghu-Ram...

⬐ harlanji

I used this in a grad class. It was a progression from intuition to theory to implementation. I already had DB exp, and it aligned with the operators and index types that we found in PG 9 for the class project including batch and streaming implementations as discussed. No point of comparison to other works.

for databases this is pretty good:

http://www.amazon.com/Database-Management-Systems-3rd-Editio...

for Oses http://williamstallings.com/OS/OS6e.html

cheers

I don't think this is true at all ... you use the same query irrespective of the size of the data in the tables. So the size of the datasets is irrelevant except for surfacing performance problems.

In the example you gave you shouldn't have problems if you put the right index on the table.

What really causes the opacity is either (a) the complexity of the query or (b) the guy writing the clearly doesn't know how to write declarative code, so he tries to write eg procedural code in SQL, with cursors and triggers and other horrors.

If you are in scenario (a) and you really do need to do something complex, I'd pick SQL over VB to do it in any day - the non-declarative style leads to huge code with side effects are more opportunities for bugs to creep in.

If you are in scenario (b), the guy writing the queries really needs to read this: http://www.amazon.com/Database-Management-Systems-Raghu-Rama...