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

Focused View

Pankaj Jain

1:04:49

12 View

01. Course Overview

01. Course Overview.mp4

01:39

02. Introduction

02. Module Overview.mp4

01:46

03. Audience.mp4

00:18

04. Tools.mp4

01:26

05. Prerequisites.mp4

02:15

06. Summary.mp4

00:32

03. Use Package Types and Variables

07. Module Overview.mp4

01:05

08. Package Types and Variables.mp4

02:41

09. Demo-Setup.mp4

04:33

10. Demo-Package Types and Variables.mp4

03:30

11. Session Persistence.mp4

01:28

12. Demo-Session Persistence.mp4

03:06

13. SERIALLY REUSABLE.mp4

02:32

14. Demo-SERIALLY REUSABLE.mp4

03:43

15. Package State.mp4

01:31

16. Demo-Package State.mp4

03:01

17. Summary.mp4

00:59

04. Use Package Constants and Functions in SQL

18. Module Overview.mp4

00:50

19. Using Package Constants in SQL.mp4

01:01

20. Demo-Using Package Constants in SQL.mp4

01:31

21. Using Package Functions in SQL and Understanding Restrictions.mp4

03:23

22. Demo-Using Package Functions in SQL.mp4

04:51

23. Summary.mp4

00:47

05. Use ACCESSIBLE BY to Restrict Access to Package Subprograms

24. Module Overview.mp4

00:46

25. Purpose of ACCESSIBLE BY Clause.mp4

06:32

26. Usage Considerations for ACCESSIBLE BY Clause.mp4

01:35

27. Demo-ACCESSIBLE BY Clause.mp4

06:29

28. Summary.mp4

00:59

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 working with 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 working with packages in PL/SQL. In this course, Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Working with Packages, you’ll learn how to effectively use packages in your PL/SQL code. First, you’ll look at how we can use package variables and constants in other programs and how we can use them to maintain the session state. Next, you’ll see how we can use the package constants and functions in SQL. Finally, you’ll explore the ACCESSIBLE BY clause which is used to restrict access to the package subprograms by other PL/SQL units. When you’re finished with this course, you’ll have a good knowledge of working with 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.