Expanded Library

Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Design Considerations for PL/SQL Code

by Pankaj Jain

This course will help you acquire certification for the exam 1Z0-149: Oracle Database Program with PL/SQL. It will cover the exam objectives of design considerations for PL/SQL code.

What you'll learn

It is important to design your PL/SQL code to optimize execution, follow standard conventions, and be secure. In this course, Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Design Considerations for PL/SQL Code, you will learn about some useful database features and best practices that will help you better design your PL/SQL code. First, you will learn how to create local subprograms, what limits the scope of where they can be used, and standard constants and exceptions which keep your code consistent and easy to maintain. Next, you will see how to control the run-time privileges of a subprogram to enhance your application’s security, and understand the uses and implications of nocopy, parallel enable hints, and deterministic clauses. Then, you will look at bulk binding and returning clauses with DML statements, which can significantly help improve the performance of your code. Finally, you will explore autonomous transactions, which allow Oracle to suspend the current transaction and initiate a fully independent transaction - a very useful feature for use cases like logging. When you’re finished with this course, you’ll have the skills and knowledge to effectively design your PL/SQL code, which can help you ace that section of the exam - 1Z0-149: Oracle Database Program with PL/SQL.

About the author

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 technologies, with focus on Oracle at the database layer and Java at the web tier. He is a certified Oracle 11g DBA. He lives in Seattle with his wife Simita and boys Ronit and Rohak. When he is not playing with technology, he likes spending time with his kids, travelling and doing photography.

Ready to upskill? Get started