Sebastopol, CA--SQL is the key to getting things done with the Oracle database. And the fully updated Mastering Oracle SQL, Second Edition (O'Reilly, US $39.95) is the key to putting SQL to work. "Mastery over the SQL language is one of the most vital requirements of a database developer or database administrator," according to authors Sanjay Mishra and Alan Beaulieu. "Knowing the power and flexibility of SQL will improve your productivity, allowing you to get more done in less time, and with increased certainty that the SQL statements you write are indeed correct."
Those who use Oracle SQL on a regular basis want to access the full power of SQL to write queries in an Oracle environment. They want a solid understanding of what's possible with Oracle SQL, creative techniques for writing effective and accurate queries, and the kind of hands-on information that leads to true mastery of the language. They want useful, expert best practices that can be put to work immediately. And Mishra and Beaulieu don't disappoint.
Fully revised and updated, this new edition covers all the most important and useful of Oracle's SQL features--including all the new SQL features and updates, large and small, introduced in Oracle Database 10g--and shows readers how to apply them to solve their specific problems and meet their particular needs. It includes real-world examples and the practical, useful elements readers need to tap into the unparalleled richness of SQL functionality that Oracle provides.
Readers will learn new tools, strategies, and techniques for using complex
SQL features (including outer joins, correlated subqueries, hierarchical
queries, grouping operations, and analytical queries); using DECODE and
CASE to implement conditional logic in their SQL queries; writing SQL
statements that operate against partitions, objects, and collections (such
as nested tables and variable arrays); and using best practices to write
efficient, maintainable SQL queries. And they'll learn about the following
areas in which Oracle truly excels:
For any administrator, developer, or programmer who works with Oracle, Mastering Oracle SQL, Second Edition is the essential guide to harnessing the untapped (and often overlooked) power of Oracle SQL.
- Chapter 7, "Set Operations"
- More information about the book, including table of contents, index, author bios, and samples
- A cover graphic in JPEG format
O’Reilly Media spreads the knowledge of innovators through its books, online services, magazines, and conferences. Since 1978, O’Reilly Media has been a chronicler and catalyst of cutting-edge development, homing in on the technology trends that really matter and spurring their adoption by amplifying “faint signals” from the alpha geeks who are creating the future. An active participant in the technology community, the company has a long history of advocacy, meme-making, and evangelism.