Mastering Oracle SQL 2e by Mishra, Sanjay

Description: 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. Sanjay Mishra has more than 12 years of experience working with Oracle systems. His key areas of interest include database architecture, database administration, performance management, scalability, software development and data modelling for mission-critical and decision support applications. He holds a Bachelor of Science degree in Electrical Engineering, and a Master of Engineering degree in Systems Science and Automation. He is the co-author of the books Oracle Parallel Processing and Oracle SQL Loader: The Definitive Guide (both published by O'Reilly Media, Inc.). Sanjay has published several technical papers in Oracle Magazine and SELECT Journal, and has presented many technical papers at various regional, national and international conferences. Preface Chapter 1: Introduction to SQL Chapter 2: The WHERE Clause Chapter 3: Joins Chapter 4: Group Operations Chapter 5: Subqueries Chapter 6: Handling Temporal Data Chapter 7: Set Operations Chapter 8: Hierarchical Queries Chapter 9: DECODE and CASE Chapter 10: Partitioning Chapter 11: PL/SQL Chapter 12: Objects and Collections Chapter 13: Advanced Group Operations Chapter 14: Advanced Analytic SQL Chapter 15: SQL Best Practices Chapter 16: XML Chapter 17: Regular Expressions Chapter 18: Model Queries Appendix A: Oracle's Old Join Syntax Colophon

Price: 40.63 USD

Location: East Hanover, New Jersey

End Time: 2024-11-06T12:11:10.000Z

Shipping Cost: 0 USD