Study Guide for 1Z0-144: Oracle Database 11g: Program with PL/SQL: Oracle Certification Prep - Softcover

Morris, Matthew

Softcover

ISBN 10: 1478217995 ISBN 13: 9781478217992

Publisher: CreateSpace Independent Publishing Platform, 2012

Synopsis

This Study Guide is targeted at IT professionals who are working towards becoming an Oracle Certified Associate in the PL/SQL developer track. The book provides information covering all of the exam topics for the Oracle certification exam: "1Z0-144: Oracle Database 11g: Program with PL/SQL". The books in the Oracle Certificaton Prep series are built in lockstep with the test topics provided by Oracle Education's certification program. Each book is intended to provide the information that will be tested in a clean and concise format. The guides introduce the subject you'll be tested on, follow that with the information you'll need to know for it, and then move on to the next topic. They contain no drills or unrealistic self-tests to bump the page count without adding value. The series is intended to provide a concentrated source of exam information that is compact enough to be read through multiple times. This series is ideal for experienced Oracle professionals that are familiar with the topic being tested, but want a means to rapidly reinforce their existing skills and bridge any gaps in their knowledge. It is also an excellent option as a second source of information for candidates pursuing certification.

About this title

About the Author

Matthew Morris has worked with the Oracle database since 1996 when he worked in the RDBMS support team for Oracle Support Services. Employed by Oracle for over eleven years in support and development positions, Matthew was an early adopter of the Oracle Certified Professional program. He was one of the first one hundred Oracle Certified Database Administrators (version 7.3) and was also in the first hundred to become an Oracle Certified Forms Developer. In the years since, he has upgraded his Database Administrator certification for releases 8i, 9i, 10G and 11G, added the Application Express and the Oracle SQL Expert certifications and is an Oracle Advanced PL/SQL Developer Certified Professional. Outside of Oracle, he has CompTIA certifications in Linux+ and Security+. Matthew is an experienced Database Administrator and PL/SQL developer and has been creating Web applications with Oracle Application Express since the early days of its release. He is currently employed as a Database Engineer with Computer Sciences Corporation developing enterprise applications.

From the Back Cover

This is the affordable solution with the information you need to complete your self-study for 1Z0-144. The study guides in the Oracle Certification Prep series were developed to provide Oracle certification candidates a means to rapidly polish their skills for the exam. The information presented is clear and to the point.

The 1Z0-144 guide covers all of the key exam topics:

• Introduction to PL/SQL
• Declaring PL/SQL Variables
• Writing Executable Statements
• Interacting with the Oracle Database Server
• Writing Control Structures
• Working with Composite Data Types
• Using Explicit Cursors
• Handling Exceptions
• Creating Procedures
• Creating Functions
• Creating Packages
• Working with Packages
• Using Oracle-Supplied Packages in Application Development
• Using Dynamic SQL
• Design Considerations for PL/SQL Code
• Creating Triggers
• Creating Compound, DDL, and Event Database Triggers
• Using the PL/SQL Compiler
• Managing PL/SQL Code
• Managing Dependencies

Edition details

• Publisher: CreateSpace Independent Publishing Platform
• Publication date: 2012
• ISBN 10: 1478217995
• ISBN 13: 9781478217992
• Binding: Paperback
• Language: English
• Number of pages: 178