What experience level is required for Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Using PL/SQL Subprograms?

This course is aimed at the Intermediate level. Having some basic understanding of the topic will help you get the most out of the curriculum.

Is this course more theory-focused or project-focused?

This course provides a strong mix of conceptual theory and practical application to ensure a comprehensive understanding of the subject matter.

Software Development

Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Using PL/SQL Subprograms

Name: Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Using PL/SQL Subprograms
Availability: InStock

Subprograms are a fundamental concept in PL/SQL. This course will teach you how to create and use subprograms, and why they are important in an application. It will improve your coding skills and help you become an Oracle Certified Professional.

radio_button_checked

Core Tech

₹10,563/yr

radio_button_unchecked

Core Tech

₹1,254/mo

Pluralsight Teams₹4,166.75 per user/month, billed annually

₹50,004

CompleteBilled Monthly

₹2,370/mo

Why choose Core Tech?

check

3,900+ Courses

check

Software Development

check

IT Operations

check

Product & UX

check

Business Skills

Compare all plansarrow_forward

verifiedGet this course for free with the Coursera Plus subscription.

✓ Compare courses before making a decision

Check Latest Price →

Price may vary. Check latest price on provider site.

Course Insight

Suitable for intermediate learners. Works well as a continuation after mastering Software Development fundamentals. It bridges the gap toward advanced, production-level engineering.

Intermediate FriendlySelf-Paced Learning

SKILLS TO
MASTER

Software Development Basics

Fundamental principles and concepts

Practical Application

Real-world project implementation

Best Practices

Industry standard workflows and guidelines

Problem Solving

Core Concepts

Implementation

Workflow Integration

Optimization

Careers:Relevant for professionals pursuing roles within Software Development.

Quick Facts

49 minutes

Below sections are verified from last major sync. For real-time updates and today's latest lectures, Check official page here.

What You’ll Learn

Course Overview : 1min.
Anonymous Blocks : 12mins.
Subprograms : 24mins.
Compare Anonymous Blocks with Subprograms : 11mins.

See side-by-side differences in what you’ll learn

Description

Subprograms are fundamental concepts in PL/SQL because they are the small and reusable parts of applications. In this course, Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Using PL/SQL Subprograms, you’ll learn how to create and use PL/SQL subprograms. First, you’ll explore the most basic type of code, the anonymous blocks. Next, you’ll discover the subprograms and the benefits of using them in applications. Finally, you’ll learn the similarities and differences between anonymous blocks and subprograms. When you’ve finished with this course, you’ll have the skills and knowledge to create and to use PL/SQL subprograms and you will be ready for taking the subprograms section in the 1Z0-149 exam to become an Oracle Certified Professional in PL/SQL programming.

See how this course compares with alternatives