Just published: Murach's Oracle SQL and PL/SQL

Mike Murach & Associates has just published a new book for developers entitled Murach's Oracle SQL and PL/SQL . It teaches how to write efficient SQL statements to extract and update the data in an Oracle database. It teaches how to design and create database tables, giving insight into performance and security issues. It teaches how to use Oracle's procedural language, PL/SQL, to take advantage of powerful features like stored procedures, functions, and triggers.

Beyond that, this book has several features that make it different from other Oracle SQL books.

#1: It shows how to take advantage of the Oracle SQL Developer tool

SQL Developer is a free tool for working with database objects and SQL statements. Its graphical interface makes it more intuitive and easier to use than older command-line tools like SQL*Plus. It can boost productivity as developers use it to write and run queries, to work with database objects, or to debug stored procedures.

#2: It starts off with how to query a database, not how to design one

This book is written for application developers, and the first thing an application developer needs to know is how to write queries. So that's what's covered in the first 8 chapters of this book. It starts with simple queries, then moves on to complex inner and outer joins, summary queries, and subqueries that do more of the database processing so that your applications can do less.

Once a developer is comfortable with querying databases, this book shows how to design a database and how to create database tables. Having this background can help developers query a database more effectively. And it provides a solid introduction to DBA skills for developers who are interested in that career path.

#3: It covers both SQL and PL/SQL

PL/SQL allows you to write complex scripts, stored procedures, functions, and triggers, all essential skills for most application developers. So along with SQL, this book covers the PL/SQL that developers use most of the time; there's no need to buy a second book to learn PL/SQL.

#4: It gives coding examples for everyday business applications

One key to mastering SQL is to have plenty of coding examples that show how the features you're learning work and what problems you may run into as you use them on your own. So this book provides dozens of SQL statements and PL/SQL scripts for various jobs that are routine in business applications. These examples can be downloaded for free from the Murach web site.

#5: The paired-pages format lets developers set their own pace

Murach books have a distinctive format, where each two-page spread presents a single topic. Both beginning and experienced developers find that this format makes it easy to focus on the information they need, whether they're using the book for training or reference.

Murach's Oracle SQL and PL/SQL is available directly from the publisher at www.murach.com and from all major retail outlets.


FOR REVIEW COPIES, a cover image, a sample chapter, or more information:

Cyndi Vasquez
Mike Murach and Associates
4340 N. Knoll
Fresno, CA 93722-7825
Phone: (800) 221-5528, Ext. 18

Murach's Oracle SQL and PL/SQL
Author: Joel Murach
Pages: 627        ISBN: 978-1-890774-50-9        Price: $52.50