November 30, 2005 at 11:38 am
Hello,
I need to learn how to write sql queries to query a relational database. I know the basics. I need to find a book that discusses sql queries from a Set theory approach. Not a procedural approach. Can anyone recommend a good book. I have heard of Joe Celko's book SQL for smarties. Is this the only one that exists or possibly the best one that exists?
Thanks in advance, William
December 1, 2005 at 10:03 am
The book I use for teaching includes indepth set theory approach to SQL and relational systems and relational algebra. THis may be too academic a book for what you are looking for but once you understand this everything else is easy and you can objectively compare different database systems.
Ramez Elmasri, Shamkant B. Navathe, “ Fundamentals of Database Systems”
December 2, 2005 at 4:54 am
Alternatively, SQL Queries for Mere Mortals (Michael J. Hernandez, John L. Viescas) ISBN 0-201-43336-2
This was recommended by tutors as a foundation prior to undertaking MCDBA cert.
December 2, 2005 at 8:51 am
You mean there's a book on a procedural approach to SQL Queries? Something like "Cursors for Dummies"?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply