Mastering Oracle SQL by Sanjay Mishra
Look inside with Google Book Preview
Mastering Oracle SQL
By Sanjay Mishra

Mastering Oracle SQL

2nd Revised edition

By (author) See other recent books by Sanjay Mishra See other recent books by Alan Beaulieu
Format: Paperback

Normal Price: $79.69
Your Price: $71.72 AUD, inc. GST
Shipping: $7.95 per order
You Save: $7.97! (10% off normal price)
Plus...earn $3.59 in Boomerang Bucks
Availability: Available Available, ships in 8-11 days



Mastering Oracle SQL by Sanjay Mishra

Book 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.

Buy Mastering Oracle SQL book by Sanjay Mishra from Australia's Online Bookstore, Boomerang Books.


Book Details

ISBN: 9780596006327
ISBN-10: 0596006322
Format: Paperback
(234mm x 180mm x 25mm)
Pages: 492
Imprint: O'Reilly Media, Inc, USA
Publisher: O'Reilly Media, Inc, USA
Publish Date: 9-Jul-2004
Country of Publication: United States

Other Editions...


Books By Author Sanjay Mishra

Oracle Utilities Pocket Reference by Sanjay Mishra Oracle Utilities Pocket Reference, Paperback (December 2004)

'The Oracle Utilities Pocket Reference' is a quick-reference guide to the multitude of Oracle utilities that database administrators (DBAs) use every day. Packed with information in an easy-to-read format, this compact resource supplies the syntax and options for whatever utility a DBA needs to perform a given task.

Oracle SQL*Loader by Sanjay Mishra Oracle SQL*Loader, Paperback (May 2001)

This text describes all of SQL*Loader's functions, including how to construct the necessary control files, load different types of data, and get the best performance. It covers the newest SQL*Loader features for 2001.

» View all books by Sanjay Mishra

Reviews

» Have you read this book? We'd like to know what you think about it - write a review about Mastering Oracle SQL book by Sanjay Mishra and you'll earn 50c in Boomerang Bucks loyalty dollars (you must be a member - it's free to sign up!)

Write a book review


Author Biography - Sanjay Mishra

Alan Beaulieu has been designing, building, and implementing custom database applications for over 13 years. He currently runs his own consulting company that specializes in designing Oracle databases and supporting services in the fields of Financial Services and Telecommunications. In building large databases for both OLTP and OLAP environments, Alan utilizes such Oracle features as Parallel Query, Partitioning, and Parallel Server. Alan has a Bachelor of Science degree in Operations Research from the Cornell University School of Engineering. He lives in Massachusetts with his wife and two daughters and can be reached at albeau_mosql@ yahoo.com. Sanjay Mishra is a certified Oracle database administrator with more than ten years of IT experience. He has been involved in the design, architecture, and implementation of many mission-critical and decision support databases. He has worked extensively in the areas of database architecture, database management, backup / recovery, performance tuning, Oracle Parallel Server, and parallel execution. He has a Bachelor of Science degree in Electrical Engineering, and a Master of Engineering degree in Systems Science and Automation. He is the coauthor of Oracle Parallel Processing and Oracle SQL Loader: The Definitive Guide (both published by O'Reilly & Associates). Presently, he works as a database architect at Dallas Based i2 Technologies, and can be reached at sanjay_mishra@ i2.com.

Boomerang Bucks close

For every $20 you spend on books, you will receive $1 in Boomerang Bucks loyalty dollars. You can use your Boomerang Bucks as a credit towards a future purchase from Boomerang Books. Note that you must be a Member (free to sign up) and that conditions do apply.

Recent books by Sanjay Mishra close
Oracle Utilities Pocket Reference by Sanjay Mishra
Oracle SQL*Loader by Sanjay Mishra
»
Recent books by Alan Beaulieu close
Prosperity in the Age of Decline by Alan Beaulieu
Tommy's Secret Code by Alan Beaulieu
Learning SQL by Alan Beaulieu
Mastering Oracle SQL by Alan Beaulieu
»
BoomerangBooks.com.au close