Simple play icon Course
Skills

Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Creating Packages

by Pankaj Jain

This course will help you acquire certification for the Oracle Database Program with PL/SQL exam number 1Z0-149. It will cover the exam objectives of creating packages in Oracle PL/SQL.

What you'll learn

This course will help you prepare for your PL/SQL certification by making you proficient with the exam objective of creating packages in PL/SQL. In this course, Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Creating Packages, you’ll learn the benefits of using packages and their components. First, you’ll look at the package specification which allows you to create public components and methods other programs can use. Next, you’ll learn about the package body, which allows you to define implementation for those public methods as well as create private methods if needed. Finally, you’ll discover how to work with packages, invoke and overload subprograms, display package information, and delete the packages if needed.

When you’re finished with this course, you’ll have a good knowledge of creating packages in Oracle PL/SQL, which should help you ace that section of the Oracle Database Program with PL/SQL exam number 1Z0-149.

About the author

Pankaj Jain is an experienced technologist, with expertise in various aspects of software development lifecycle, architecting software solutions and software development. He has worked on an array of technologies, with focus on Oracle at the database layer and Java at the web tier. He is a certified Oracle 11g DBA. He lives in Seattle with his wife Simita and boys Ronit and Rohak. When he is not playing with technology, he likes spending time with his kids, travelling and doing photography.

Ready to upskill? Get started