 | | |
| Murach's Oracle SQL and PL/SQL (Training & Reference) | 
| Author: Joel Murach
Publisher: Mike Murach & Associates
Category: Book
List Price: $52.50
Buy New: $30.00
You Save: $22.50 (43%)
Buy New/Used from $25.77
Avg. Customer Rating:  (5 reviews)
Sales Rank: 315837
Languages: English (Original Language), English (Unknown), English (Published)
Media: Paperback
Number Of Items: 1
Pages: 600
Shipping Weight (lbs): 3.3
Dimensions (in): 9.8 x 7.8 x 1.8
ISBN: 1890774502
Dewey Decimal Number: 005.133
EAN: 9781890774509
ASIN: 1890774502
Publication Date: August 1, 2008
Availability: Usually ships in 1-2 business days
|
| Similar Items:
|
| Editorial Reviews:
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 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.
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 book
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 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 interact
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. 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 pace
Depending 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)
|
| Customer Reviews:
 A life saver!! November 2, 2008
3 out of 3 found this review helpful
Got stuck on one of my Oracle 9i assignments and it took just one look in this book and I was all set and ready to take on this other assignments. It is really a reliable reference book. One you should always have at your fingertips if you use the Oracle database system or if you are learning about the system. I wish I had this book as a backup to my textbook when I first bagan the class or even before I begin. Save the stress and don't fall into my misfortune of stressing over something that could be solved easily with this book.
More than just the basics September 17, 2008
2 out of 2 found this review helpful
Murach books have a reputation for accessibility to the novice user. Murach's Oracle SQL and PL/SQL is just as accessible to the novice, but also contains plenty to assist other Oracle users.
The first section is truly non-threatening and is possibly too basic to be of real use in the context of the whole book. It is a short introduction to databases and the Oracle tools but doesn't contain much depth. The second section digs deeper into interacting with databases and is primarily aimed at standard and Oracle-specific SQL syntax. Section 3 introduces good (and essential) database practices such as normalisation, user and role management, indexes, foreign keys and other aspects of database design. Section 4 covers some PL/SQL basics and finally Section 5 covers the more complicated data types.
I mention all of that since I found the name of the book slightly misleading, but in a good way. The focus of the book is on building and maintaining the skills required for running Oracle SQL and PL/SQL and while Sections 3 and 5 could have been omitted, the book is better because of the inclusion.
Sections 2 and 4 are the main sections and both are well written for both teaching and reference resources, and Section 2 in particular highlights the important information for each piece of knowledge.
The result is a book that is great for Oracle novices, although possibly not if you are a complete database novice, but also great for intermediate users casual users like myself. Personally I use the database dictated by clients, so I look forward to having this on hand when making the next switch back to the Oracle database. It won't get you an Oracle DBA job, but it will help you get more out of your database.
 Murach ROCKS! September 16, 2008
Excellent product. These guys at Murach know how to write technical computer books. Bottom Line. I have multiple titles from them.
The most complete and comprehensive manuals on the subject. September 6, 2008
1 out of 1 found this review helpful
For the past quarter of a century and then some, Murach has been bringing programmers the most complete and comprehensive manuals on the subject. "Murach's Oracle SQL and PL/SQL: Training and Reference" lives up to that banner of quality perfectly well, giving programmers all the knowledge and tolls they need to master SQL statements and create truly effective and efficient databases for themselves and their companies to use. "Murach's Oracle SQL and PL/SQL" is almost a must for anyone looking to master the topics discussed within.
Great book with examples August 31, 2008
2 out of 2 found this review helpful
I gave 4 stars only because I haven't completely read this book. I may give it 5 stars after I finish reading this boo. It is an excellent resource for those that are trying to learn or solidify their Oracle PL/SQL skills. The author does an excellent job of explaining Oracle SQL with clear examples.
|
|
|
Powered by: Dknc, inc. and Amazon.com | | 
For your safety and security, orders are processed through amazon.com
|
|
|
|
