If 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 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 toolSQL 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 oneThis 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 you're comfortable with querying databases, this book shows how to design a database and how to create database tables. Having this background can help you query a database more effectively. And it provides a solid introduction to DBA skills if you're interested in that career path.

#3: You get 2 books in 1: A SQL book and a PL/SQL bookPL/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 you'll use most of the time; there's no need to buy a second book to learn PL/SQL.

#4: Complete applications show you how all the pieces interactOne 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. Download the examples for free from our website and use them as starting points for your own SQL routines.

#5: The paired-pages format lets you set your own paceDepending on what you already know about Oracle SQL and how fast you want to go, you can read every page and study each example...skim through the headings for topics you don't know...scan through the righthand pages for development details you might have missed in the past...or turn to any two-page spread when you need reference information. The paired-pages format makes it easy and fast for you to use the book the way you want to.

(If you aren't familiar with how the paired pages work, please be sure to download a sample chapter from our website)

"synopsis" may belong to another edition of this title.

Product Description:

If 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 toolSQL 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 oneThis 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 you're comfortable with querying databases, this book shows how to design a database and how to create database tables. Having this background can help you query a database more effectively. And it provides a solid introduction to DBA skills if you're interested in that career path.

#3: You get 2 books in 1: A SQL book and a PL/SQL bookPL/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 you'll use most of the time; there's no need to buy a second book to learn PL/SQL.

#4: Complete applications show you how all the pieces interactOne 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. Download the examples for free from our website and use them as starting points for your own SQL routines.

#5: The paired-pages format lets you set your own paceDepending on what you already know about Oracle SQL and how fast you want to go, you can read every page and study each example...skim through the headings for topics you don't know...scan through the righthand pages for development details you might have missed in the past...or turn to any two-page spread when you need reference information. The paired-pages format makes it easy and fast for you to use the book the way you want to.

(If you aren't familiar with how the paired pages work, please be sure to download a sample chapter from our website)

About the Author:

Joel Murach has a background in software training and is a specialist in developing business applications, particularly web applications. In the past 5 years, he has written and edited books on Java, ASP.NET, and C# that have helped thousands of developers become proficient at creating the kind of applications that businesses rely on every day.

Book Description Book Condition: New. This is an International Edition Brand New Paperback Same Title Author and Edition as listed. ISBN and Cover design differs. Similar Contents as U.S Edition. Standard Delivery within 6-14 business days ACROSS THE GLOBE. We can ship to PO Box address in US. International Edition Textbooks may bear a label "Not for sale in the U.S. or Canada" or "For sale in Asia only" or similar restrictions- printed only to discourage students from obtaining an affordable copy. US Court has asserted your right to buy and use International edition. Access code/CD may not provided with these editions. We may ship the books from multiple warehouses across the globe including Asia depending upon the availability of inventory. Printed in English. Customer satisfaction guaranteed. Bookseller Inventory # NU3_9788184045888

Book Description Mike Murach & Associates. Book Condition: New. 1890774502 This is an International Edition. Brand New, Paperback, Delivery within 6-14 business days, Similar Contents as U.S Edition, ISBN and Cover design may differ, printed in Black & White. Choose Expedited shipping for delivery within 3-8 business days. We do not ship to PO Box, APO , FPO Address. In some instances, subjects such as Management, Accounting, Finance may have different end chapter case studies and exercises. International Edition Textbooks may bear a label "Not for sale in the U.S. or Canada" and "Content may different from U.S. Edition" - printed only to discourage U.S. students from obtaining an affordable copy. The U.S. Supreme Court has asserted your right to purchase international editions, and ruled on this issue. Access code/CD is not provided with these editions , unless specified. We may ship the books from multiple warehouses across the globe, including India depending upon the availability of inventory storage. Customer satisfaction guaranteed. Bookseller Inventory # UM9781890774509

Book Description 2008. Soft cover. Book Condition: New. This book is BRAND NEW Soft cover International edition with black and white printing. ISBN number & cover page may be different but contents identical to the US edition word by word. Book is in English language. Bookseller Inventory # UN-SHRO-790

Book Description Mike Murach & Associates Inc. Paperback. Book Condition: new. BRAND NEW, Murach's Oracle SQL and PL/SQL, Joel Murach, If you are developing applications that access Oracle databases, you can save time and work by having SQL do more of the data handling for you -- this 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. Bookseller Inventory # B9781890774509

Book Description Mike Murach Associates Inc., United States, 2008. Paperback. Book Condition: New. 254 x 203 mm. Language: English . Brand New Book. If you are developing applications that access Oracle databases, you can save time and work by having SQL do more of the data handling for you -- this 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. Bookseller Inventory # AAG9781890774509

Book Description Mike Murach Associates Inc., United States, 2008. Paperback. Book Condition: New. 254 x 203 mm. Language: English . Brand New Book. If you are developing applications that access Oracle databases, you can save time and work by having SQL do more of the data handling for you -- this 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. Bookseller Inventory # AAG9781890774509