Teach Yourself Pl/SQL in 21 Days (Sams Teach Yourself)
Tom Luers,Timothy Atwood,Jonathan Gennick | 1900-01-01 00:00:00 | Sams | 646 | Database Management Systems
Sams Teach Yourself PL/SQL in 21 Days is the ultimate hands-on guide that teaches you how to take full advantage of Oracle's powerful database systems, including Web-based J/SQL implementations. In addition, you will learn to streamline client/server communications and queries and use a variety of enhancements, such as triggers and packages, which make Oracle application development much smoother.Whether you are a beginning programmer or an accomplished Oracle user, Sams Teach Yourself PL/SQL in 21 Days will help you establish yourself as an Oracle programmer, ready for advancement in this premium database marketplace. By walking you through each element of the PL/SQL language extension, this book helps you to understand the basics of using new and existing Oracle8 objects, as well as complex processing issues. This guide also teaches you to implement PL/SQL in a comprehensive, real-world system.
If you are starting out in Oracle PL/SQL, this book and their online help HTML/PDF is the only source you are going to need. All other books out in the bookshelves are garbage. This is one of the best books out of shelf-full of bad books on PL/SQL. Index on the back of the book is incomplete to say the least. I believe any good programming book should have extensive index, since nobody has the time to go through the whole book, and we need to refer to index for different things as we work on a project. So far, of all the books, and I have a collection now, this book is the most comprehensive book, if you can find what page to look.
I've found this book very helpfu
If you're totally new to pl/sql programming, this is a good book. The explainations are simple and easier to understand than other books that I assume expects you to have some experience. This book gives you some good samples for starters but after finishing this book, I recommend you get a more hardcore book. You could follow the next book you buy with ease and learn a little more. One problem is that this book mentions things that are covered in later chapters, so you might have to go back to the index and jump around a litte (other books do this butthey do it more often).
For the novice user, chapters 1 through 8 give a good description of the language. I was able to understand how the language works and do the exercises. From chapter 9 until the end, I guess the authors assume that the debugging chapter was enough to start debugging their examples. Even some the examples on the CD-ROM did not execute.
Week 3 is the worst if you do not have the Oracle software listed in chapter 1, but it is worth the read. At least you can impress the interviewer at your next interview.
If you want to learn a little about Oracle and have some Visual Basic experience, try Nick Snowden's Oracle with Visual Basic. It is mainly SQL, but I got a better view of how Oracle operates.
I used the 21-Day Book for Visual Basic 5 and learned a lot (first time I had ever used VB). I was expecting the same level of learning from this book and was highly disappointed.
As for a good PL/SQL book, I am still looking.
I started learning pl/sql a couple of weeks ago. I am halfway through the book(i am not doing a chapter a day:). I find it very easy to comprehend ,even by a novice. I think it is a really good start if you know some sql. There are a few small flaws(typo errors) which are no problem.
Download this book!
Free Ebooks Download