Murach J. Murach’s Oracle SQL and PL/SQL

Mike Murach & Associates, 2008. - 640 p. - ISBN: 978-1890774509If you’re developing applications that access Oracle databases, you can save time and work by having SQL do more of the data handling for you: This new book shows you how. It teaches you how to create effective SQL queries to extract and update the data in an Oracle database. It teaches you how to design and implement a database, giving you insight into performance and security issues. It teaches you how to use PL/SQL to take advantage of powerful features like stored procedures, functions, and triggers. In short, it teaches you to create the kind of efficient database applications that make you a more effective and valuable developer.Here are 5 of the ways that our book differs from the others
#1: You’ll see 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. I think you ll find it boosts your productivity as you use it to write and run queries, to work with database objects, or to debug stored procedures.#2: You’ll start 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.