Providing the best solutions to Oracle customers, this comprehensive manual answers some of SQL's most exciting challenges. Covering all the elements of an Oracle query—including new features from Oracle versions 9i, 10g, and 11g—this guide will help information technology managers and programmers alike to gain new insight into complex queries, advanced aggregation, and analytics techniques. Introducing Model and XML as new ways to retrieve data out of the database, this sourcebook culminates as a perfect companion for advanced programmers and Oracle experts.
Kurzbeschreibung
Produktinformation
|
Mehr über den Autor
Entdecken Sie Bücher, lesen Sie über Autoren und mehr
Produktbeschreibungen
Synopsis
Providing the best solutions to Oracle customers, this comprehensive manual answers some of SQL's most exciting challenges. Covering all the elements of an Oracle query including new features from Oracle versions 9i, 10g, and 11g this guide will help information technology managers and programmers alike to gain new insight into complex queries, advanced aggregation, and analytics techniques. Introducing Model and XML as new ways to retrieve data out of the database, this sourcebook culminates as a perfect companion for advanced programmers and Oracle experts.
Über den Autor
Laurent Schneider is an Oracle Certified Master with more than 10 years of experience with Oracle and UNIX. He has written many articles about Oracle technologies and has provided thousands of answers on online technical forums. He is currently a management system engineer at LC Systems Engineering.
Donald Burleson is one of the world’s top Oracle Database experts with more than 20 years of full-time DBA experience. He has written 30 books, including Oracle Data Mining and Oracle Shell Scripting, and serves as editor-in-chief of Rampant TechPress.
Eine digitale Version dieses Buchs im Kindle-Shop verkaufen
Wenn Sie ein Verleger oder Autor sind und die digitalen Rechte an einem Buch haben, können Sie die digitale Version des Buchs in unserem Kindle-Shop verkaufen.
Weitere Informationen
Kundenrezensionen
Die hilfreichsten Kundenrezensionen
4 von 6 Kunden fanden die folgende Rezension hilfreich
Von H. S.
Format:Taschenbuch
Obwohl der Titel "Advanced Oracle SQL Programming: The Expert Guide to Writing Complex Queries" lautet, beginnt das Buch bei Adam und Eva, d.h. bei SELECT und FROM. Auch der Rest des Buches kann bestenfalls als Referenz verwendet werden. Denn es werden nurmehr einzelne Syntaxelemente für SQL-SELECTs und Funktionen anhand eines Beispiels und vielleicht maximal drei Sätzen "vorgestellt". Mehr nicht.
Es geht aber noch schlimmer. Zu Anfang des Buches sind seitenweise INSERT-Statements für die Beispieldatenbank abgedruckt. Gleichfalls abgedruckt sind die Ergebnisse für sämtliche SQL-Anweisungen, wie sie in der Konsolenansicht erscheinen.
Mit "Advanced Oracle SQL Programming" hat dies alles nichts zu tun.
Es geht aber noch schlimmer. Zu Anfang des Buches sind seitenweise INSERT-Statements für die Beispieldatenbank abgedruckt. Gleichfalls abgedruckt sind die Ergebnisse für sämtliche SQL-Anweisungen, wie sie in der Konsolenansicht erscheinen.
Mit "Advanced Oracle SQL Programming" hat dies alles nichts zu tun.
Die hilfreichsten Kundenrezensionen auf Amazon.com (beta)
Amazon.com:
2.8 von 5 Sternen
5 Rezensionen
10 von 10 Kunden fanden die folgende Rezension hilfreich
3.0 von 5 Sternen
Decent book on advanced SQL but much to be desired
22. Februar 2009
Von Harsha N. Hegde
- Veröffentlicht auf Amazon.com
Format:Taschenbuch
I am an ardent reader of Laurent Schneider's blog: [...] His deep understanding of databases is unparalleled. The tips he provides are very practical and handy. That's probably what raised my expectations from his book: "Advanced Oracle SQL Programming". I have just finished reading through this book and I can clearly say that I am a bit disappointed with the book.
- It feels more like a collection of Laurent's notes on various Oracle SQL topics.
- There is a disconnect between one topic and the next one.
- Topics are very brief, often not exceeding 3-4 sentences. Much more detailed discussion/analysis of each concept would have made the book more readable.
- More tips/tricks (like the ones in boxes with an explosive symbol) would have made me go back to this book often.
- This may sound trivial, but the formatting of the code unnecessarily takes up too much space. e.g, in the first chapter itself, all the "INSERT" statements run to 8 pages! They could have easily been arranged 2 columns/page. They are not even required because it is available for download anyway at the book's website.
Nice things I found in the book:
- Exercise problems are really good, will make you think.
- Explanation on Joins, Subquery and Hierarchical queries are so far the best I have read.
- It feels more like a collection of Laurent's notes on various Oracle SQL topics.
- There is a disconnect between one topic and the next one.
- Topics are very brief, often not exceeding 3-4 sentences. Much more detailed discussion/analysis of each concept would have made the book more readable.
- More tips/tricks (like the ones in boxes with an explosive symbol) would have made me go back to this book often.
- This may sound trivial, but the formatting of the code unnecessarily takes up too much space. e.g, in the first chapter itself, all the "INSERT" statements run to 8 pages! They could have easily been arranged 2 columns/page. They are not even required because it is available for download anyway at the book's website.
Nice things I found in the book:
- Exercise problems are really good, will make you think.
- Explanation on Joins, Subquery and Hierarchical queries are so far the best I have read.
5 von 6 Kunden fanden die folgende Rezension hilfreich
3.0 von 5 Sternen
Advanced Oracal SQL
13. November 2009
Von Richard John
- Veröffentlicht auf Amazon.com
Format:Taschenbuch|Von Amazon bestätigter Kauf
I found most of the book to be a rehash of other material Oracle published. Most of the SQL I would not consider advanced. I felt if a intermediate at best. I bought this book about 6 months ago and after reading I have only used it once or twice as reference. There is some stuff in one of the middle chapters, but overall I was disappointed.
3 von 4 Kunden fanden die folgende Rezension hilfreich
1.0 von 5 Sternen
Poorly written, and confusing
12. April 2010
Von Joshua E. Emery
- Veröffentlicht auf Amazon.com
Format:Taschenbuch
Probably the worst Technical book I have ever read. It is poorly formatted, and some paragraphs just do not make sense. Examples are weak, and not explained leaving you to toil over it to figure what the writter is trying to accomplish. I highly recommend avoiding this book. Do not make the costly mistake I did.
›
Gehen Sie zu Amazon.com, um alle 5 Rezensionen zu sehen
2.8 von 5 Sternen
Waren diese Rezensionen hilfreich?
Wir wollen von Ihnen hören.
Kunden diskutieren
|
Das Forum zu diesem Produkt
Fragen stellen, Meinungen austauschen, Einblicke gewinnen Aktive Diskussionen in ähnlichen Foren
Kundendiskussionen durchsuchen
|
Ähnliche Foren
|
||||||||||||||||||||||||||||||||||
Lieblingslisten
Ähnliche Artikel finden
Ihr Kommentar
Möchten Sie die Produktinformationen aktualisieren oder Feedback zu den Produktabbildungen geben?
|
