3 Review(s)

A practical workbook to help the readers strengthen their Oracle PL/SQL programming skills. Summary Of The Book PL/SQL, the - Oracle’s primary tool for manipulating the database. This proprietary version of SQL, designed and optimized for Oracle databases, is a powerful tool in interacting with the database and working with the data. This book covers the various new enhancements made to PL/SQL in Oracle Database 11g. It briefly covers the various features of PL/SQL and provides a lot of examples and exercises for further clarification and practice. Oracle Database 11g PL/SQL Programming Workbook is divided into four parts. The first part comprises of an overview of Oracle development architecture. It then covers PL/SQL basics, transaction scope add error management. The second part, PL/SQL Programming, covers functions, procedures, collections, triggers, packages, and objects, The third part covers advanced topics like dynamic SQL and external files. The fourth part has four five appendix sections, covering additional material. These cover Wrapping PL/SQL, PL/SQL hierarchical profiler, PL/Scope, and PL/SQL Built-In packages and types. The fifth appendix section provides answers to chapter exercises. Oracle Database 11g PL/SQL Programming Workbook shows how to work with PL/SQL data types, structures, cursors, and blocks  and how to create and use procedures and functions and packages. It also shows how to create and use object types, and how to use external tables to support online transaction processing and data warehousing. At the end of each chapter, a set of mastery exercises are given to reinforce the concepts covered. The answers to these mastery exercises are given in the final appendix. This comprehensive workbook from Oracle Press is designed to provide practical experience in developing PL/SQL programs, for all levels of users - from the novice to the seasoned PL/SQL programmer. About The Authors John Harper is an experienced database professional. He co-authored Oracle Database 11g PL/SQL Programming Workbook with Michael McLaughlin. John Harper has over ten years of experience working in the Oracle database environment. Currently, he is lead engineer at the Church of Jesus Christ of of Latter-Day Saints. Michael McLaughlin is a professor and a prolific writer of books related to computer science. Other books by this author - MySQL Workbench Data Modeling and Development, Oracle Database 11g and MySQL 5.6 Developer Handbook, and Oracle Database 11g PL/SQL Programming. His books explain the functionalities of different Database systems, mainly Oracle. Michael McLaughlin is a Professor in the Computer Science/Information Technology Department of Brigham Young University, Idaho. He has written numerous books on the Oracle Database and its various tools and components.