Free Oracle Database 11g PL/SQL Programming Workbook (Oracle Press) Ebooks Online

                
              
Free 
Oracle Database 11g PL/SQL Programming Workbook (Oracle Press) Ebooks Online
Ramp Up Your PL/SQL Programming Skills Master PL/SQL through the hands-on exercises, extensive examples, and real-world projects inside this Oracle Press guide. Filled with best practices, Oracle Database 11g PL/SQL Programming Workbook covers all the latest features and enhancements of the language. Mastery checks at the end of each chapter reinforce the material covered, and sample code from the book is available for download. Even experienced Oracle professionals will benefit from this practical resource. Understand the Oracle development architecture and the mechanics of connections Work with data types, structures, blocks, cursors, and PL/SQL semantics Write, deploy, and use functions, procedures, and packages Manage transactions and more Use dynamic SQL statements in real-world applications Support online transaction processing and data warehousing applications with external tables Find syntax samples and best practices to solve problems Write, deploy, and use object types For a complete list of Oracle Press titles, visit www.OraclePressBooks.com
Series: Oracle Press
Paperback: 512 pages
Publisher: McGraw-Hill Education; 1 edition (February 10, 2010)
Language: English
ISBN-10: 0071493697
ISBN-13: 978-0071493697
Product Dimensions:  7.4 x 1 x 9.1 inches
Shipping Weight: 2 pounds (View shipping rates and policies)
Average Customer Review:  4.1 out of 5 stars  See all reviews (15 customer reviews)
Best Sellers Rank: #361,476 in Books (See Top 100 in Books)   #22 in Books > Computers & Technology > Certification > Oracle   #68 in Books > Computers & Technology > Databases & Big Data > Oracle   #81 in Books > Computers & Technology > Software > Databases
This book has the same issues for programming newbies as other books of this type (yes, even in the 'for Dummies' books).The issues are as follows.1. New terminology/functions is introduced without being fully explained in the text nor is there a reference to where this information can be found.2. Code samples contain code that has not been covered yet or contains exceptions to the rules being taught.3. As new information is taught, the sample code for that particular section contains too many differneces from the code used in the sample code from the immediately preceeding section.The first one is frustrating but a quick search on-line can usually give a more thorough definition of a term or the syntax for a funtion (c.f. try to find "guard-on-entry loop").The last two are the more trying because the sample code is not really searchable. Samples code should build on previous examples and only introduce the new coding currently being covered. Too many new and unexplained functions, clauses, or statements confuse the newbie.
I'll echo some comments of other reviewers. For a novice, I would NOT highly recommend the book, only because it feels like the author feels that you should have a good grasp of basic programming and of PL/SQL. The one thing that if I were a novice (which I'm not - Senior Oracle Developer with 17+yrs experience) is that topics that are discuss reference topics in upcoming chapters which he says you should reference. To me that's not good. Every chapter should build on the previous chapter. In one chapter he does this perfectly when reference coding examples (chapter on Triggers).Other than that, I do like Oracle Press Books and I bought this workbook as I'm studying for my Oracle PL/SQL Developer Certified Associate certification and I liked the practice questions/answers at the end of each chapter. This helps reinforce concepts I already know and highlight other concepts I was unaware of or had misconceptions about.
This was a valuable resource to me as I am just learning oracle. It is important to understand where this will fit into your learning. The text is not difficult to understand, but you should some have some base experience in some kind of programming language. This book is very good at just telling you exactly and simply how to write PL/SQL. There are 12 chapters with topics like 'functions,' 'objects,' 'error management,' etc... so you shouldn't really expect to get lost anywhere.That is really why I enjoyed this book, it was very straighforward. Chapter, concept, example, summary, exercises. By the end of the book you will be able to at least read and understand any code you come accross and write a few dandy procedures. This was my experience.The thing with learning SQL is just if you try to learn just through google you will find a ton of resources on MySQL and only some on Oracle by comparison. And a lot of the oracle stuff you find will just be MySQL solutions ported over on forums which post WRONG 'guessed' code. And within that the help you will find on PL/SQL is sparse at best. Yes I know there is always the full documentation on oracle.com(ZZZzzzzzzzz).I bought oracles other DBA handbook before this and also have SQL books from MS and o reilly. This book is my favorite so far when comparing format and easyness of reading.
This book is essential for Oracle veteran and beginner alike. It wraps all the best practices and new features into an easy to read, example laden, treasure of insight into PL/SQL on 11g. A must for all. It is like having a friend who is ready when you need him to point out the new, give you an example, and teach you the pit falls and best practices that you may not think of otherwise.
Great book! I have been an Oracle DBA for years and always find it refreshing to get new ideas and concepts from others. I found the chapters on application security very useful. It's always nice when a book applies to real world applications. This book is spot on.
This is a great guide for those who have some databases knowledge. It refers basic vocabulary that a DBA should have in order to understand the basic concepts. It contains examples and tips that show you how to create a queries. It will also be a good exercise if you work along with his web site, you will be able to clarify your doubts.
This book is an excellent resource for anyone studying PL/SQL or desiring to improve their skills in PL/SQL. The author is very knowledgeable on the topic and explains it in a fairly straightforward fashion allowing for relatively quick understanding of the topic. As always it requires effort to develop skills but this book makes doing so much easier then any other book of this type. I recommend this book heavily for the use of students and professionals.
The book is very thorough and the examples and exercises are extremely helpful. I liked the approach of having two examples span the whole book, plus lots of exercises at the end of chapters to reinforce what was learned in each chapter.
Oracle Database 11g PL/SQL Programming Workbook (Oracle Press) Oracle Database 11g PL/SQL Programming (Oracle Press) OCA Oracle Database 11g SQL Fundamentals I Exam Guide: Exam 1Z0-051 (Oracle Press) Study Guide for 1Z0-051: Oracle Database 11g: SQL Fundamentals I: Oracle Certification Prep Study Guide for 1Z0-144: Oracle Database 11g: Program with PL/SQL: Oracle Certification Prep Study Guide for 1Z0-146: Oracle Database 11g: Advanced PL/SQL (Oracle Certification Prep) Study Guide for 1Z0-117: Oracle Database 11g Release 2: SQL Tuning (Oracle Certification Prep) OCP Oracle Database 11g New Features for Administrators Exam Guide (Exam 1Z0-050) (Oracle Press) OCP Oracle Database 11g Administration II Exam Guide: Exam 1Z0-053 (Oracle Press) Study Guide for 1Z0-052: Oracle Database 11g: Administration I: Oracle Certification Prep Study Guide for 1Z0-053: Oracle Database 11g: Administration II (Oracle Certification Prep) Study Guide for 1Z0-067: Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP: Oracle Certification Prep Oracle Database Administration for Microsoft SQL Server DBAs (Oracle Press) OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) (Oracle Press) Beginning SQL 2012 Joes 2 Pros Volume 1: The SQL Queries 2012 Hands-On Tutorial for Beginners (SQL Exam Prep Series 70-461 Volume 1 Of 5) (SQL Queries 2012 Joes 2 Pros) Oracle 11g: PL/SQL Programming Quick Start Guide to Oracle Fusion Development: Oracle JDeveloper and Oracle ADF (Oracle Press) Study Guide for 1Z0-071: Oracle Database 12c SQL: Oracle Certification Prep Study Guide for 1Z0-061: Oracle Database 12c: SQL Fundamentals (Oracle Certification Prep) OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052) 