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

Focused View

Pankaj Jain

1:07:39

10 View

01. Course Overview

01. Course Overview.mp4

01:39

02. Introduction

02. Module Overview.mp4

01:46

03. Audience.mp4

00:17

04. Tools.mp4

01:26

05. Prerequisites.mp4

02:00

06. Summary.mp4

00:31

03. Benefits and Components of Packages

07. Module Overview.mp4

00:27

08. Benefits of Packages.mp4

02:57

09. Components of a Package.mp4

01:22

10. Summary.mp4

00:32

04. Work with Packages

11. Module Overview.mp4

00:36

12. Package Specification.mp4

05:19

13. Setup.mp4

01:38

14. Demo-Package Specification.mp4

02:35

15. Package Body.mp4

03:13

16. Demo-Package Body.mp4

09:13

17. Display and Execute Packages.mp4

02:42

18. Demo-Display and Execute Packages.mp4

03:42

19. Summary.mp4

00:48

05. Overload Package Subprograms and Forward Declarations

20. Module Overview.mp4

00:48

21. Overloading and Its Benefits.mp4

01:36

22. Overloading.mp4

07:49

23. Demo-Overloading.mp4

09:04

24. Forward Declaration.mp4

02:00

25. Demo-Forward Declaration.mp4

02:20

26. Summary.mp4

01:19

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Oracle Database

Oracle SQL

Pankaj Jain

Instructor's Courses

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.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.