- Paperback: 372 pages
- Publisher: O'Reilly Media; 1 edition (March 1, 2006)
- Language: English
- ISBN-10: 0596008945
- ISBN-13: 978-0596008949
- Product Dimensions: 7 x 0.9 x 9.2 inches
- Shipping Weight: 1.3 pounds (View shipping rates and policies)
- Average Customer Review: 26 customer reviews
- Amazon Best Sellers Rank: #454,302 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
The Art of SQL 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Frequently bought together
Customers who bought this item also bought
About the Author
Stephane Faroult first discovered relational databases and the SQL language back in 1983. He joined Oracle France in their early days (after a brief spell with IBM and a bout of teaching at the University of Ottawa) and soon developed an interest in performance and tuning topics. After leaving Oracle in 1988, he briefly tried to reform and did a bit of operational research, but after one year, he succumbed again to relational databases. He has been continuously performing database consultancy since then, and founded RoughSea Ltd in 1998.
Graduated in geology from Durham University (1968), then taught at Edinburgh University, obtaining an M.Phil in geology 1975. Worked in Greece as a geologist (1973,74), and then in University of Newcastle specialising in geological databases.Joined the British Geological Survey 1980, and has steered the organisations' use of database ever since, as data architect and database administrator. Has worked with databases since 1977, relational databases since 1981, and Oracle since 1985. He has lectured widely in the UK on geological aspects of database and has specialised on aspects of the SQL system as well as data modelling from the corporate architecture down to the departmental level. He has presented at various Oracle database conferences both in the UK, Europe and North America. Currently a director on the board of the UK Oracle Users Group.
Top customer reviews
The writing is wonderful, and stunningly clear. A word of caution is necessary, though. Faroult is obviously a brilliant and experienced expert. Some of his work reflected in the corpus of this text is what we could rightly call deep and heavy. It requires serious and thoughtful contemplation. This is not a book to be read quickly. Rather, it is an important work to be studied carefully and referred to often.
There were many aspects of this excellent book that I enjoyed a great deal. His initial chapter on "Laying Plans", Designing Databases for Performance, is one of the best single chapters I've ever read in a technical book. And his final chapter, "Employment of Spies", Monitoring for Performance, was also great. I personally savored Faroult's sage teaching that a sound relational design was the factor most dispositive of success in making modern databases work as described in the first chapter. But I was absolutely delighted that Faroult both headed his final chapter with a quote from the Gospel according to Saint John and included the value of syllogistic logic in his excellent arguments in this final chapter.
In short, the book is great. Faroult is much to be applauded for this excellent work. His book should occupy an honored place in the library of any professional seriously involved in SQL development and design. God bless.
This book handily fills in those gaps. It assumes a moderate to advanced foundation in SQL and DBMS, and then takes off from there.
It is mostly prose with some code and SQL sprinkled throughout, but if you have a foundation, you can flesh out the technique. It is like listening to a graduate level lecture. It is distilled wisdom more than How To, and the more you bring to the material, the more you will get from it. And every page is rich with information. I don't feel like I have wasted my time on any one page, as I often do in the how to manuals.
Definitely an advanced piece.
It is also written with the database programmer in mind, rather than the database administrator. There are not many books written for us, and I'm really pleased that one of them is a book this excellent.