Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Writing Executable Statements
Companies rely on the backend developers in meeting the SLAs with the customer. This course will teach you how to write efficient nested blocks and expressions using the built-in function provided by PL/SQL.
Learning Journey Context
This course serves as an entry point into Software Development, building foundational knowledge before moving on to advanced frameworks or specialized paths.
Relevant for: Backend Developer, Software Engineer, API Developer.
Quick Facts
What Youâll Learn
Writing high-performing database code is one of the key ingredients to maintain and improve customer satisfaction. In this course, Writing Executable Statements, youâll learn to apply the guidelines and recommendations offered by Oracle in structuring your PL/SQL program and writing maintainable code. First, youâll explore the lexical units that make up a PL/SQL program. Next, youâll discover the operator precedence in building expressions using built-in functions. Finally, youâll learn how to write nested blocks and understand the scope and visibility of the variables. When youâre finished with this course, youâll have the skills and knowledge of writing an effective PL/SQL program needed to create a fast performing backend.
Outcomes
- Course Overview : 1min.
- Identifying Components in a PL/SQL Program : 17mins.
- Developing PL/SQL programs Using Expressions and Built-in Functions : 24mins.
- Simplifying a PL/SQL Program Using Nested Blocks : 15mins.
FAQs
Top Alternatives
Highly-rated courses worth your attention
