YoVDO

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

Offered By: Pluralsight

Tags

PL/SQL Courses Relational Databases Courses Oracle Database Courses

Course Description

Overview

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.

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.

Syllabus

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

Taught by

Lucian Lazar

Related Courses

Oracle Database Foundations
LearnQuest via Coursera
Lessons Learned: Migrating Oracle to Amazon Aurora
Amazon Web Services via AWS Skill Builder
Learning Oracle Database 19c
LinkedIn Learning
Oracle 12c Database: Administration
LinkedIn Learning
Oracle Database 12c: Backup and Recovery
LinkedIn Learning