Get started with PL/SQL, the built-in language that every Oracle developer and database administrator must know, in Beginning PL/SQL, a fast-paced and example-filled tutorial. Learn from author Don Bales extensive experience to discover the most commonly used aspects of PL/SQL without wasting time with obscure and obsolete features.
Author Don Bales takes his 20+ years of experience and a wealth of statistics he's gathered on PL/SQL usage over those years and applies the 80/20 rule &emdash; cover whats most needed and used by PL/SQL professionals and avoid whats not necessary! The result is a book that covers all the key features of PL/SQL without wasting your time discussing esoteric and obsolete parts of the language. Learn what really matters, so that you can get to work feeling confident with what you know about PL/SQL.
Discover the 20% of PL/SQL that gives you 80% of the bangkey topics covered include variables and datatypes, executing statements, working with cursors, real-world objects, debugging, testing, and more.
Learn how to write production-level, object-oriented PL/SQLyoull explore relational PL/SQL, but unlike most other books on the subject, Don Bales emphasizes the use of PL/SQLs object-oriented features as well.
Work through real examples of using of PL/SQLyoull learn PL/SQL by applying it to real-world business problems, not by heavy theory.
What youll learn
How important SQL is in PL/SQL
How to use PL/SQL in both a relational and object-relational setting
How to create maintainable, modular, and reusable PL/SQL program units
The importance of testing as you go, and of building a permanent test plan for each module
The importance of building debugging capabilities into your code and building a permanent debug facility for each module
The importance of documenting as you go, and in the process building a permanent documentation set for your reusable modules
How to apply modular PL/SQL to solve real-world problems
Who is this book for?
Anyone who wants to learn how to create stored procedures against an Oracle database using PL/SQL. Programmers developing applications to be deployed against an Oracle database will need PL/SQL to take full advantage of the power Oracle has to offer. Database administrators who wish to implement functionality exposed only via PL/SQL package interfaces will also find this book useful.
About the Apress Beginning Series
The Beginning series from Apress is the right choice to get the information you need to land that crucial entry-level job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from "novice to professional." Youll start your journey by seeing what you need to knowbut without needless theory and filler. Youll build your skill set by learning how to put together real-world projects step by step. So whether your goal is your next career challenge or a new learning opportunity, the Beginning series from Apress will take you thereit is your trusted guide through unfamiliar territory!
Customer Reviews:
Avg. Customer Rating: 5.0 / 5.0
Buy It, I am not kidding:
This is really a good book to learn PL/SQL. I had intermediate skills on SQL and was able to grasp the Pl/Sql quickly reading the book. The author explains the sample Pl / Sql code in nice, relaxed and organized way. I have one small advice for the author as well, `If possible please give the chapter name related to the contents'. After reading the book I was able to write some good Pl / Sql code with Package, Body and Stored Procedures. Author was successful to communicate with the reader in `Easy Mode'. I... more info
A deep, thorough and quite enjoyable book on PL/SQL...:
As an Oracle developer for over 10 years, I have read many Oracle books on a variety of topics, and this book is definitely one of those that stands heads above the others. As the title suggests, Beginning PL/SQL: From Novice to Professional covers a range of PL/SQL topics, both foundational and advanced. From the fundamentals such as triggers, procedures, packages, the book moves into the more advanced operations of Bulk Collection, Objects and even one of the more neglected but no less important areas in... more info
A friendly and well-written book recommended for anyone ready to learn PL/SQL.:
A friendly and well-written book recommended for anyone ready to learn PL/SQL. This Beggining PL/SQL well-written and well-organized introduction to the PL/SQL programming language. It uses a careful, example-based, easy to understand approach.
Thank you
Excellent PL/SQL resource:
The author did an excellent job covering novice PL/SQL concepts and building those concepts into more advanced topics such as information modeling and object orientation. Each chapter is filled with easy to follow, step-by-step coding examples. Each chapters also contains exercises where you create and execute code. I found this most useful. There is no better way to learn than actually doing it yourself. One thing that impressed me is how the author stressed the importance of testing code during the... more info
