Hands On Training

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

Pluralsight

Course Features

Duration

64 minutes

Delivery Method

Online

Available on

Downloadable Courses

Accessibility

Mobile, Desktop, Laptop

Language

English

Subtitles

English

Level

Advanced

Teaching Type

Self Paced

Video Content

64 minutes

Course Description

This course, Oracle Database Program with PL/SQL Exam number: 1Z0-149 Working with Packages, is designed to help you prepare for the PL/SQL Certification exam. The focus of this course is on working within packages in PL/SQL. You will learn how to use package variables and constants in your PL/SQL codes to maintain the session state. Additionally, you will explore the use of package constants and SQL functions.

One important aspect covered in this course is the ACCESSIBLE BY clause, which allows you to limit access to package subprograms. Understanding how to effectively use this clause is crucial for passing the Oracle Database Program with PL/SQL section 1Z0-149.

By the end of this course, you will have a solid understanding of Oracle PL/SQL packages and be well-prepared to take the certification exam. This course provides comprehensive coverage of the topics necessary to pass the exam, including package variables, constants, SQL functions, and the ACCESSIBLE BY clause.

Whether you are new to PL/SQL or looking to expand your skills and knowledge, this course will provide you with the necessary tools and techniques to succeed. With a focus on both theory and practical application, you will gain a thorough understanding of working with packages in Oracle PL/SQL.

By enrolling in this course, you will not only be prepared for the PL/SQL Certification exam but also gain valuable skills that can be applied in real-world scenarios. Don't miss out on this opportunity to enhance your expertise in Oracle PL/SQL and boost your career prospects.

Course Overview

International Faculty

Post Course Interactions

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

What You Will Learn

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

Course Content

Expand all sections

Module 1: Introduction

Module 2: Use Package Types and Variables

Module 3: Use Package Constants and Functions in SQL

Module 4: Use ACCESSIBLE BY to Restrict Access to Package Subprograms

Course Instructors

Pankaj Jain

Instructor

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...