Hands On Training

Oracle PL/SQL Fundamentals - Part 2

Pluralsight

Course Features

Duration

5.15 hours

Delivery Method

Online

Available on

Downloadable Courses

Accessibility

Mobile, Desktop, Laptop

Language

English

Subtitles

English

Level

Intermediate

Effort

5 hours per week

Teaching Type

Self Paced

Video Content

5.15 hours

Course Description

This course will teach you how to create, compile and execute Procedures and Functions. Packages are program units, which are pre-compiled and stored within the database. These powerful programming constructs increase the reusability and efficiency of code. We'll also discuss how to pass parameters between these subprograms. Along with the authid clause, we will talk about roles and privileges when compiling or executing subprograms. We'll also discuss local subprograms, and calling functions from SQL statements. These concepts are essential and will allow you to write high-performing PL/SQL codes.

Course Overview

International Faculty

Case Based Learning

Post Course Interactions

Case Studies,Instructor-Moderated Discussions

Case Studies, Captstone Projects

Skills You Will Gain

What You Will Learn

Procedures

Functions

Parameters in Procedures & Functions

Local Subprograms

Package Specification

Package Body

Calling Functions from SQL

Roles & Privileges With Subprograms

Course Content

Expand all sections

Module 1: Overview

Module 2: Procedures

Module 3: Functions

Module 4: Parameters in Procedures and Functions

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