Welcome to the O'Reilly Press Room
oreilly.comO'Reilly Network
ConferencesInternationalSafari: Books Online

Arrow Search
Arrow Book List
Arrow Press Room
Arrow Jobs
Resource
Centers

Arrow
Perl
Java
Web & Internet
Open Source
XML
Linux
Unix
Python
Macintosh
Windows
.NET
Oracle
Security
Sys/Network Admin
C/C++ Programming
Design & Graphics
Visual Basic
Special
Interest

Arrow
Ask Tim
tim.oreilly.com
Open Books
Letters
elists
Events
Palm OS
Missing Manual
User Groups
Catalog Request
Write for Us
O'Reilly



June 4, 2002

New Book Helps Oracle DBAs Write Better SQL Queries: "Mastering Oracle SQL" Released by O'Reilly

Sebastopol, CA--Mastery of the SQL language is one of the most important skills a database developer or database administrator can possess, say Sanjay Mishra and Alan Beaulieu, authors of Mastering Oracle SQL (O'Reilly, US $34.95). "SQL is the key to everything you do with your database," they tell us. "It's important to know how to get the most out of that interface." SQL, which stands for Structured Query Language, is the language for accessing a relational database. It allows you to create database structures, such as tables, views and indexes. It allows you to insert data into your database and to retrieve that data in a desired format. And finally, SQL allows you to modify, delete, and otherwise manipulate your stored data. In short, proficiency in writing SQL statements determines how much value you'll draw from the data in your database.

"Mastering Oracle SQL" goes beyond other books on writing SQL queries to help database professionals to harness the power of Oracle SQL to the maximum extent possible. Drawing on their many years' experience with Oracle databases, the authors have written a practical book focused squarely on Oracle's version of SQL. Mishra and Beaulieu not only cover the most important and useful of Oracle's SQL features, but also show ways to apply them to solve specific problems. Readers will learn to:

  • Understand the features and capabilities of the SQL language as implemented by Oracle
  • Use complex SQL features such as outer joins, correlated subqueries, hierarchical queries, grouping operations, analytical queries, etc.
  • Use DECODE and CASE to implement conditional logic in SQL queries
  • Write SQL statements that operate against partitions, objects, and collections such as nested tables and variable arrays
  • Use the new SQL features introduced in Oracle9i, such as new date and time features, ANSI-compliant joins, and new grouping and analytical functions
  • Use best practices to write efficient, maintainable SQL queries

Not just a manual, "Mastering Oracle SQL" is about creative techniques for writing effective and accurate queries. Whether readers are new to the world of databases or seasoned professionals, they will find this book to be a valuable tool. Knowing the power and flexibility of SQL will improve productivity, allowing database developers and administrators to get more done in less time, and with increased certainty that the SQL statements they write are indeed correct.

Additional resources:

Mastering Oracle SQL
By Sanjay Mishra & Alan Beaulieu
ISBN 0-596-00129-0, 321 pages, $34.95 (US), $54.95 (CAN)
order@oreilly.com
1-800-998-9938; 1-707-827-7000

About O'Reilly

O'Reilly & Associates is the premier information source for leading-edge computer technologies. The company's books, conferences, and web sites bring to light the knowledge of technology innovators. O'Reilly books, known for the animals on their covers, occupy a treasured place on the shelves of the developers building the next generation of software. O'Reilly conferences and summits bring alpha geeks and forward-thinking business leaders together to shape the revolutionary ideas that spark new industries. From the Internet to XML, open source, .NET, Java, and web services, O'Reilly puts technologies on the map.

Return to the: O'Reilly Press Room

Contacts:
CUSTOMER INQUIRIES
Sales/Customer Service
(707) 829-0515
order@oreilly.com

PRESS QUERIES ONLY
Contact Kathryn Barrett
(707) 827-7094
kathrynb@oreilly.com


oreilly.com Home | O'Reilly Bookstores | How to Order | O'Reilly Contacts
International | About O'Reilly | Affiliated Companies | Privacy Policy

© 2001, O'Reilly & Associates, Inc.
webmaster@oreilly.com