Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Managing PL/SQL Code

via Pluralsight

Overview

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 managing PL/SQL code in the Oracle database.

It is important to write high-quality PL/SQL code, but it is equally important to manage it effectively - to ensure it functions per our requirements. In this course, Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Managing PL/SQL Code, you’ll learn how to conditionally execute your PL/SQL code, which is useful for debugging and testing as well as providing database-version-specific features. First, you'll discover how to achieve fine-grained access control using the code based access control feature of Oracle PL/SQL. Next, you'll explore the ACCESSIBLE BY clause which is used to whitelist access to the subprograms by other PL/SQL units. Finally, you'll understand how to deprecate pieces of PL/SQL code, to indicate that the program unit is still valid but is now superseded by a better option. When you’re finished with this course, you’ll have the skills and knowledge to effectively manage your PL/SQL code, which can help you ace the Managing PL/SQL Code section of the Oracle Database Program with PL/SQL exam number: 1Z0-149.

Syllabus

  • Course Overview 1min
  • Introduction 6mins
  • Describe and Use Conditional Compilation 31mins
  • Code Based Access Control 17mins
  • Whitelist Code Access with the ACCESSIBLE BY Clause 11mins
  • Mark Code as Deprecated 18mins

Taught by

Pankaj Jain

Reviews

Start your review of Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Managing PL/SQL Code

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.