Mastering Oracle SQL

Putting Oracle SQL to Work

Nonfiction, Computers, Programming, Programming Languages, SQL, Advanced Computing, Data Modeling & Design, Database Management
Cover of the book Mastering Oracle SQL by Sanjay Mishra, Alan Beaulieu, O'Reilly Media
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Sanjay Mishra, Alan Beaulieu ISBN: 9780596552473
Publisher: O'Reilly Media Publication: February 9, 2009
Imprint: O'Reilly Media Language: English
Author: Sanjay Mishra, Alan Beaulieu
ISBN: 9780596552473
Publisher: O'Reilly Media
Publication: February 9, 2009
Imprint: O'Reilly Media
Language: English

The vast majority of Oracle SQL books discuss some syntax, provide the barest rudiments of using Oracle SQL, and perhaps include a few simple examples. It might be enough to pass a survey course, or give you some buzz words to drop in conversation with real Oracle DBAs. But if you use Oracle SQL on a regular basis, you want much more. You want to access the full power of SQL to write queries in an Oracle environment. You want a solid understanding of what's possible with Oracle SQL, creative techniques for writing effective and accurate queries, and the practical, hands-on information that leads to true mastery of the language. Simply put, you want useful, expert best practices that can be put to work immediately, not just non-vendor specific overview or theory.

Updated to cover the latest version of Oracle, Oracle 10g, this edition of the highly regarded Mastering Oracle SQL has a stronger focus on technique and on Oracle's implementation of SQL than any other book on the market. It covers Oracle s vast library of built-in functions, the full range of Oracle SQL query-writing features, regular expression support, new aggregate and analytic functions, subqueries in the SELECT and WITH clauses, multiset union operators, enhanced support for hierarchical queries: leaf and loop detection, and the CONNECT_BY_ROOT operator, new partitioning methods (some introduced in Oracle9i Release 2), and the native XML datatype, XMLType.

Mastering Oracle SQL, 2nd Edition fills the gap between the sometimes spotty vendor documentation, and other books on SQL that just don't explore the full depth of what is possible with Oracle-specific SQL. For those who want to harness the untapped (and often overlooked) power of Oracle SQL, this essential guide for putting Oracle SQL to work will prove invaluable.

View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

The vast majority of Oracle SQL books discuss some syntax, provide the barest rudiments of using Oracle SQL, and perhaps include a few simple examples. It might be enough to pass a survey course, or give you some buzz words to drop in conversation with real Oracle DBAs. But if you use Oracle SQL on a regular basis, you want much more. You want to access the full power of SQL to write queries in an Oracle environment. You want a solid understanding of what's possible with Oracle SQL, creative techniques for writing effective and accurate queries, and the practical, hands-on information that leads to true mastery of the language. Simply put, you want useful, expert best practices that can be put to work immediately, not just non-vendor specific overview or theory.

Updated to cover the latest version of Oracle, Oracle 10g, this edition of the highly regarded Mastering Oracle SQL has a stronger focus on technique and on Oracle's implementation of SQL than any other book on the market. It covers Oracle s vast library of built-in functions, the full range of Oracle SQL query-writing features, regular expression support, new aggregate and analytic functions, subqueries in the SELECT and WITH clauses, multiset union operators, enhanced support for hierarchical queries: leaf and loop detection, and the CONNECT_BY_ROOT operator, new partitioning methods (some introduced in Oracle9i Release 2), and the native XML datatype, XMLType.

Mastering Oracle SQL, 2nd Edition fills the gap between the sometimes spotty vendor documentation, and other books on SQL that just don't explore the full depth of what is possible with Oracle-specific SQL. For those who want to harness the untapped (and often overlooked) power of Oracle SQL, this essential guide for putting Oracle SQL to work will prove invaluable.

More books from O'Reilly Media

Cover of the book Programming Entity Framework: DbContext by Sanjay Mishra, Alan Beaulieu
Cover of the book Parallel and Concurrent Programming in Haskell by Sanjay Mishra, Alan Beaulieu
Cover of the book Web Site Cookbook by Sanjay Mishra, Alan Beaulieu
Cover of the book Oracle PL/SQL for DBAs by Sanjay Mishra, Alan Beaulieu
Cover of the book Data for the Public Good by Sanjay Mishra, Alan Beaulieu
Cover of the book Resilience and Reliability on AWS by Sanjay Mishra, Alan Beaulieu
Cover of the book C im 21. Jahrhundert by Sanjay Mishra, Alan Beaulieu
Cover of the book HTML5 kurz & gut by Sanjay Mishra, Alan Beaulieu
Cover of the book What is EPUB 3? by Sanjay Mishra, Alan Beaulieu
Cover of the book Mastering Algorithms with Perl by Sanjay Mishra, Alan Beaulieu
Cover of the book 97 Things Every Software Architect Should Know by Sanjay Mishra, Alan Beaulieu
Cover of the book Developing Web Components by Sanjay Mishra, Alan Beaulieu
Cover of the book Apache Cookbook by Sanjay Mishra, Alan Beaulieu
Cover of the book Machine Learning for Email by Sanjay Mishra, Alan Beaulieu
Cover of the book JavaServer Pages Pocket Reference by Sanjay Mishra, Alan Beaulieu
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy