Software Development Basics
Fundamental principles and concepts
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.
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 beginner learners. This course serves as an entry point into Software Development, building foundational knowledge before moving on to advanced frameworks or specialized paths.
Beginner FriendlySelf-Paced Learning
SKILLS TO
MASTER
Practical ApplicationTrending
Real-world project implementationBest Practices
Industry standard workflows and guidelinesCareers:Backend Developer, Software Engineer, API Developer.
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.
- 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.
See side-by-side differences in what you’ll learn
Description
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.
See how this course compares with alternatives
FAQs
Top Alternatives
Highly-rated courses worth your attention
⭐ 0(0+ learners)