Books for/about - Oracle programming

Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions

Publisher: Apress
Authors: Thomas Kyte

ISBN: 1590595300
List Price: $49.99
Amazon Price: $31.49
Usually ships in 24 hours

Buy this book
from amazon.com
or from
amazon.co.uk

Avg Cusomer Rating: 5
Reviews:
Summary: Expert Oracle Database Architecture Book review
This is the first book I have read from Tom Kyte. I use his web site often and appreciate all the work he does to maintain the "AskTom" site.

The book is excellent. Tom's approach to helping you understand the concepts are displayed well with code examples. You will read a passage and then see an example to really enforce the principle. The examples support the concepts and using both together helped me out a great deal.

The chapters on architecure and indexes I found to be really helpful. The architecure chapter goes in much needed detail as so many books just glance over the different Oracle processes. What the processes are used for and how they interact with each other is well documented. The index chapter helped me understand how indexes operate at a block level and also what indexes are best for a given situation. At the end of the index chapter Tom has a section on Myth's and this section should be required reading for all DBAs and developers.

Something else I got from the book are methods for writing SQL and tuning it. The SQL that the author puts together looks so easy and natural for him to write. He is a master of SQL*Plus and that is a side benefit to reading the book. The techniques I picked up from reading Toms examples will help me just as much or more so than content of the book. This book is an excellent addition to my Oracle collection of books and I highly recommend reading it.

Summary: Bridges gap between DBA and Developer- Tom's Best yet
I have all of Tom's earlier books and while he does recap some things I like the new features he mentions in 10g. Hands down the best overall reference for becoming an Oracle DBA and developer- I like the sections on partioning, indexes, tables and development. I also like the included CD that has the older editions which is nice for bringing to work or on the road.

Summary: Good book
This is a good book on ORACLE. For those who already have the previous 8i edition this is one of the two parts with some 9i/10g coverage. It is a shame that the Indian edition doesn't carry the CD.

Summary:

search for Oracle+programming at amazon.com, amazon.co.uk, google.com

Oracle PL/SQL Programming, 4th Edition

Publisher: O'Reilly Media
Authors: Steven Feuerstein Bill Pribyl

ISBN: 0596009771
List Price: $64.95
Amazon Price: $40.92
Usually ships in 24 hours

Buy this book
from amazon.com
or from
amazon.co.uk

Avg Cusomer Rating: 4
Reviews:
Summary: Very good
This is an easy to read book. Feuerstein presents a good overview and in-depth analysis of the PL/SQL language with practical examples. He includes several examples and recommendations that make this a solid book for PL/SQL programmers. Some print errors are commons in books of this type, they are obviously a problem for a newbie, but there is no perfect book at this world. For this reason I give only 4 stars.

Summary: A major programmer's reference
Steven Feuerstein and Bill Pribyl's ORACLE PL/SQL is a major reference for any already programming: it provides references to syntax, codes, and forms for developers and database administrators, adds new content to extend coverage for the latest Oracle Database 10g Release 2, and adds new chapters covering security encryption, email, and globalization. This isn't just an A-Z coverage: it provides questions, application issue analysis, details on whether usage is appropriate or worth the effort, and how to avoid common coding problems such as hardcoding literals.

Summary: THE ULTIMATE PL/SQL PROGRAMMING BOOK!!
Are you an application developer or database administrator? Well, you're in luck! Authors Steven Feuerstein and Bill Pribyl, have done an outstanding job of writing a 4th edition of a book that provides comprehensive useful coverage of the PL/SQL language.

Feuerstein and Pribyl, begin with an introduction to the PL/SQL language. Then, they show you how to get PL/SQL programs up and running as quickly as possible. The authors continue by reviewing the fundamentals of the PL/SQL language: what makes a PL/SQL statement, an introduction to the block structure, and how to write comments in PL/SQL. They also explore conditional and sequential control statements, loops, and exception handling in the PL/SQL language. They continue by looking at various types of program data you can define in PL/SQL, such as numbers, strings, records, and collections. In addition, the authors next address one of the most central elements of PL/SQL code construction: the connection to the underlying database, which takes place through the SQL language. They also show you the building blocks of applications, which include procedures, functions, triggers, and packages, and how to move information into and out of PL/SQL programs. Then, the authors explore the security-related challenges you face as you build PL/SQL programs. They continue by exploring the inside of PL/SQL, including PL/SQL's use of memory. In addition, the authors provide guidance for PL/SQL developers who need to address issues of globalization and localization. They also provide an in-depth guide to the object-oriented features of Oracle. Finally, they show you how to invoke Java and C code from your PL/SQL applications.

If you are new to PL/SQL, reading this excellent book from beginning to end should improve your PL/SQL skills and deepen your understanding of the language. Needless to say, if you're already a proficient PL/SQL programmer, you'll probably want to dip into the appropriate sections of this book to extract particular techniques for immediate application.

Summary:

search for Oracle+programming at amazon.com, amazon.co.uk, google.com

	SQL Cookbook (Cookbooks (O'Reilly)) Publisher: O'Reilly Media Authors: Anthony Molinaro
ISBN: 0596009763 List Price: $39.95 Amazon Price: $26.37 Usually ships in 24 hours Buy this book from amazon.com or from amazon.co.uk	Avg Cusomer Rating: 5 Reviews: Summary: "COOKING WITH SQL" Are you an SQL novice, journeyman, expert or a non-SQL programmer? If you are, then this book is for you! Author Anthony Molinaro, has done an outstanding job of writing a practical book that gives you the reader, a glimpse of what can be done using SQL outside of what is considered the typical SQL problem domain.. Molinaro, begins by introducing very simple queries. Then, the author introduces recipes for sorting query results. Next, he introduces recipes for combining data from multiple tables. The author then introduces recipes for inserting, updating, and deleting data, respectively. He continues by introducing recipes for getting at your database metadata. Then, the author introduces recipes for manipulating strings. Next, he introduces recipes for common number crunching. He also deals with data arithmetic. The author continues by showing you recipes for some of the most common date operations you will encounter in a typical work day. Then, he introduces recipes for identifying values in ranges, and for creating ranges of values. Next, the author introduces recipes that are crucial for everyday development and yet sometimes slip through the cracks. He also introduces queries typically used in warehousing or generating complex reports. The author continues by introducing you to hierarchical recipes. Finally, the author focuses on vendor-specific solutions. In this most excellent cookbook, you will find a collection of common SQL problems and their solutions that you'll find helpful in your day-to-day work. More importantly, this cookbook will help you take your SQL skills to the next level. Summary: Excellent desktop resource book! This book review was submitted by a Roanoke Valley SQL Server Users Group member as part of the Book Review Program. Reviewed by: Harold Buckner This is a great book to have available at your fingertips. The table of contents is structured quite nicely and allows you to find what you need very quickly. The book covers a number of topics for solving everyday problems. It will also help you come up with ideas on how to go about handling particular queries by describing the problems and then listing possible solutions. And in these solutions you can find techniques on how to expand on them to resolve other issues. The author Anthony Molinaro, included a chapter on Metadata Queries that would be great for the beginner DBA wanting to find information about the database schema as well as other chapters on String manipulation, working with numbers, dates, warehousing and hierarchical queries. The author includes solutions for various platforms that I thought were nice to see how the different platforms handled the solutions. I also thought the author did a great job expanding the solution to help you understand what was happening. Great job Anthony and I hope to see more structured like this one. Harold Buckner Summary: Love this cookbook This is definitely a fantastic book. As a web developer in Kansas City, I have great need for providing my clients with great programming. This book is an integral part of my library. My favorite topics in here are: - Retrieving Records Section-really like searching for patterns - Working with ranges..used this one with a client. - Reporting (Great need for online businesses) Thanks Anthony - Great book review from me! Sean Morelli RPG Designs, LLC - Kansas City Web Design firm Summary:

search for Oracle+programming at amazon.com, amazon.co.uk, google.com

Oracle Discoverer 10g Handbook (Oracle)

Publisher: McGraw-Hill Osborne Media
Authors: Darlene Armstrong-Smith Michael Armstrong-Smith

ISBN: 0072262141
List Price: $69.99
Amazon Price: $44.09
Usually ships in 24 hours

Buy this book
from amazon.com
or from
amazon.co.uk

Avg Cusomer Rating: 5
Reviews:
Summary: Loved it
This is THE book to get for Oracle Discoverer. What more can I say, it's well written, clear with good examples.

Summary: Complete, comprehensive coverage
Oracle Discoverer is a complex tool and much more than a single understanding of the functionality is required to use it effectively for business intelligence.

Armstrong-Smith has achieved this goal in a pragmatic book that not only shows the "how" but the "why", with simple illustrative examples from real-world systems.

Summary: Outstanding Resource!
I am a neophyte to Discoverer, having just accepted a position where the primary assignment is to learn discoverer and develop a library.

I think the true measure of this type of book is how well it takes someone who has little knowledge and walks them through the process of learning. Often times, this type of book slides into language or discourse that seems aimed at higher-end users or impressing people with the depth of knowledge, jargon and acronymns.

In particular, because Discoverer is a tool aimed at the end-user, who may or may not have a great deal of background with Oracle databases themselves (mine is limited), this book faces the challenge of addressing the needs of both the end-user without high-end technical savvy as well as the administrator who knows Oracle backward and forward.

I'm happy to say that I am rapidly gaining knowledge working through this book, as if I were sitting in a training class.

The progression of this book is as follows:

A. Getting Started with Discoverer

1. An Overview of Discoverer.
2. Users and Databases.
3. Getting Started in Discoverer.
4. The Workbook Wizard: The Essential Steps
5. The Workbook Wizard: The Optional Steps

B. Editing the Query

6. Formatting the Output in Discoverer Desktop and Plus
7. Using Graphs to Present Data
8. Turning a Discoverer Query into a Report
9. Using Discoverer to Analyze Data
10. Business Intelligence Discoverer Viewer 10g Release 2 (10.1.2)

C. Advanced Discoverer Techniques

11. Refining Items, Drilling, and Hyper-Drilling
12. Building Effective Conditions
13. Refining Parameters, Calculations, Sorting, and Percentages
14. Query Management
15. User Preferences, the Toolbar, and the Discoverer Administrator
16. Introducing Discoverer OLAP

D. Using the Discoverer Administration Edition

17. Getting Started in the Administration Edition
18. Editing the Business Area
19. Interacting with the End User
20. Configuring Discoverer
21. Setting Up Portal for Use with Discoverer
22. Summary Management

The appendicies are targetted and helpful.

All in all, I can't say enough good about this book. It filled the need exactly and efficiently.

Summary:

search for Oracle+programming at amazon.com, amazon.co.uk, google.com

Oracle Developer Advanced Forms and Reports

Publisher: McGraw-Hill Osborne Media
Authors: Peter Koletzke Paul Dorsey

ISBN: 0072120487
List Price: $59.99
Amazon Price: $59.99
Usually ships in 24 hours

Buy this book
from amazon.com
or from
amazon.co.uk

Avg Cusomer Rating: 1
Reviews:
Summary: pretty poor book
very poorly laid out and confusing presaentation of both forms and reports. some fairly good detailed examples (if you can find them) but the overall presentation is chaotic.

really not worth the bucks

Summary: Great for forms, not so much for reports
This is a solid reference book for those doing primarily Forms development, but it lacks quite a little in the Reports department. If you're buying it for Reports development, as I did, you'll be disappointed. I have yet to find a very good Reports reference. That said, this is probably the best one out there. The book contains something like 70% - 30% Forms info to Reports info (and that may be a little generous). It does have a few good examples and is an easy read.

Summary: Great Book
This book is a great tool for creating Visual Basic Applications

Summary:

search for Oracle+programming at amazon.com, amazon.co.uk, google.com

	Oracle SQL by Example, Third Edition Publisher: Prentice Hall PTR Authors: Alice Rischert
ISBN: 0131451316 List Price: $54.99 Amazon Price: $34.64 Usually ships in 24 hours Buy this book from amazon.com or from amazon.co.uk	Avg Cusomer Rating: 4 Reviews: Summary: Good coverage of Oracle SQL The content look deceptively simple. However upon further reading one finds that it covers many aspects or ORACLE SQL plus differences between ORACLE and ANSI standard. One does need to know some relational database theory before starting to read this book though. It does cover the basic of the relational database theory but not in a depth. However the ORACLE SQL statements and functions are very well presented and the book does cover details and use cases. Summary: Comprehensive on basics but weak on advanced features The book improves with each edition. The brief data modeling section is adequate but uses Information Engineering data models and should be updated to use UML. The treatment describing joins fails to adequately explain why you chose one over the other. There are a few errors here and there, like the default for the DATE format mask, which is 'DD-MON-RR' not 'DD-MON-YY'. Multiple table join coverage of ANSI SQL: 1999 standard is weak but there is currently no better treatment. Hierarchical queries in the Oracle 10gR1 release perform differently than in Oracle 9i and there is no coverage of differences. A future edition of the book should expand its treatment of recursive, or self-referencing, joins and hierarchical joins. Also, I would recommend she expand the: (a) discussion of inner, outer and full outer joins; (b) discussions and exercises to support multiple table joins; and (c) coverage of analytical SQL for data warehouses. Summary: This book is Awesome!! This book by Alice Rischert is one of the greatest Oracle SQL books ever written. I purchased the 1st edition of this book back in the day and it helped me pass the Oracle 8i OCP SQL exam. After reading the 1st edition, I was very much compelled to purchase the 3rd edition. The 3rd edition of the book is much better with all the errors from the previous versions corrected. This is the book they use for the students at Columbia University in New York. After you read this book and do all the exercises and test your thinking projects, you become a master of the subject. If you want to learn Oracle SQL, there is no greater learning tool than this book. Indeed, there is much time, effort, and loads of quality and research put into this book. The format of the book is reading and then hands-on labs which reinforce the topics you just read. After you read this book you should purchase the Oracle PL/SQL by Example third edition. It goes hand-in-hand with this book. AFterward, you'll know enough to go take the Oracle SQL and PL/SQL exam. Summary:

search for Oracle+programming at amazon.com, amazon.co.uk, google.com

Oracle Database 10g PL/SQL Programming

Publisher: McGraw-Hill Osborne Media
Authors: Scott Urman Ron Hardman Michael McLaughlin

ISBN: 0072230665
List Price: $54.99
Amazon Price: $34.64
Usually ships in 24 hours

Buy this book
from amazon.com
or from
amazon.co.uk

Avg Cusomer Rating: 5
Reviews:
Summary: Best PL/SQL book I have ever read
I have attempted to learn pl/sql for a few years now and have been unable to find a book that pulls it all together. This book gently introduces you to a topic and then then shows you how to apply it. The comical nature of the author also makes the book interesting and fun. I believe its a must read for anyone attempting to learning pl/sql.

Summary: Excellent Book
I am using it in the context of a text book under one of the authors. My only complaint with the book is that some of the topics seems to be shallow in content (for example records in chapter 5). As a person just learning PL/SQL I rather like the fact that it covers many topics, and takes the time to show example after example with explanations. The organization seems to be fairly uniform. I would recommend this book to anyone wanting to learn PL/SQL as it has helped me immensely. I have found the index to be rather lacking (hence the four stars).

Summary: A couple of bad chapters, but good for 1Z0-147
I bought this book hoping it would help me pass the 1Z0-147 Oracle PL/SQL certification test, and it did. First the bad news: chapters five and six are horrible. The person that wrote these two chapters writes in the most pedantic way possible. Pages upon pages are filled with highly repetitive code, with each example followed by a detailed analysis of every statement! Compare this to the coding examples in other chapters, where statements of interest are highlighted and then followed by descriptions of their significance. If you want a laugh, check out page 225, where the author of chapter six says, "A problem with programming books is that concepts need to be illustrated with an economy of space." Wow.

I read the first ten chapters of this book sequentially in order to prepare for the exam, and (with the obvious exception of chapters five and six) really enjoyed the material. I think the book is well written: the organization is excellent and the examples are very clear and concise. I especially liked the summaries comparing and contrasting one construct or approach to another. The book is addressed to individuals that have programming and SQL experience, but I think it could be used by a database beginner as well.

If you're studying for 1Z0-147, my advice is: read this book (chapters 1 - 10, 16) then read the Oracle Application Developer's Guide - Fundamentals, Part II: PL/SQL (Procedure & Packages, Dynamic SQL, and Triggers). Getting an online study guide helps as well as you can train for the exam is an environment virtually identical to the one in which the exam is given.

Summary:

search for Oracle+programming at amazon.com, amazon.co.uk, google.com

OCA/OCP: Introduction to Oracle9i SQL Study Guide

Publisher: Sybex
Authors: Chip Dawes Biju Thomas

ISBN: 0782140629
List Price: $49.99
Amazon Price: $31.49
Usually ships in 4 to 12 days

Buy this book
from amazon.com
or from
amazon.co.uk

Avg Cusomer Rating: 4
Reviews:
Summary: This book is very helpful

I just passed the 1z0-007 exam yesterday. I dont have a lot of experience with oracle, but this book helped me learn all the important concepts for the exam and helped me pass it in my first attempt.

I recommend this book to anyone who is looking to pass the exam. However, the usefulness of this book ends there. It is not very useful and the explanations are not detailed enough for learning more about the technology itself.

Summary: Good book - but independent test software needed to pass exam
Good book, very thorough, equally useful for study-reading and reference.
My one complaint was the end-of-chapter tests and practice tests, which were much more detailed and more difficult then the exam itself. I wasted time trying to perfect my knowledge until I purchased an 'Exam-Prep' software kit and found I was getting 90%+ on tests, instead of the 40 and 50%+ with the Sybex tests.
When I took the exam - sure enough 90%+
For the next exam I'm buying the Sybex book and 'Exam-Prep' software kit together!

Summary: Please help Me Guys
Hello I am Tulasiraj ,
I am doing my PL/SqL course now i am going to write oracle 9i exam
if any body has current this month model question please send me .
thanku

Summary:

search for Oracle+programming at amazon.com, amazon.co.uk, google.com

Computers and Electronics Books || Automotive Books || Misc Books

| home |