Software Development Basics
Fundamental principles and concepts
Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Managing PL/SQL Code
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.
Pluralsight Teams₹4,166.75 per user/month, billed annually
₹50,004
CompleteBilled Monthly
₹2,370/mo
Why choose Core Tech?
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
Practical ApplicationTrending
Real-world project implementationBest Practices
Industry standard workflows and guidelinesCareers:Relevant for professionals pursuing roles within Software Development.
Quick Facts
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.
- 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.
See side-by-side differences in what you’ll learn
Description
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.
See how this course compares with alternatives
FAQs
Top Alternatives
Highly-rated courses worth your attention
⭐ 0(0+ learners)