1Z0-149
Coming Soon
Expected availability announced soon
This course is in active development. Preview the scope below and create a free account to be notified the moment it goes live.
DB PLSQL Developer
The Oracle Database PL/SQL Developer Professional certification course teaches core PL/SQL fundamentals, stored programs, triggers, error handling, collections, dynamic SQL, and advanced techniques, enabling candidates to design robust, high‑performance database applications.
90
Minutes
60
Questions
65
Passing Score
$245
Exam Cost
Who Should Take This
It is intended for database developers, analysts, and architects who have at least two years of PL/SQL experience and seek to validate their expertise. Learners aim to deepen their knowledge of advanced PL/SQL constructs, improve code reliability, and qualify for senior‑level roles in Oracle‑centric environments.
What's Covered
1
PL/SQL Fundamentals
2
Stored Programs
3
Triggers and Error Handling
4
Collections and Dynamic SQL
5
Advanced PL/SQL
What's Included in AccelaStudy® AI
Adaptive Knowledge Graph
Practice Questions
Lesson Modules
Console Simulator Labs
Exam Tips & Strategy
20 Activity Formats
Course Outline
62 learning goals
1
PL/SQL Fundamentals
2 topics
PL/SQL Basics
- Implement PL/SQL blocks with DECLARE, BEGIN, EXCEPTION, and END sections for procedural database programming.
- Configure PL/SQL variables, constants, %TYPE, %ROWTYPE, and user-defined subtypes for type-safe programming.
- Design conditional logic with IF-THEN-ELSE, CASE expressions, and CASE statements for business rule implementation.
- Analyze PL/SQL code to identify logic errors, performance issues, and recommend refactoring improvements.
- Configure PL/SQL Basics with appropriate settings and parameters for a production deployment scenario in Oracle Database PL/SQL Developer Professional.
- Assess PL/SQL Basics implementations against best practices to identify gaps and recommend improvements.
- Architect PL/SQL Basics solutions with scalability patterns and capacity planning for long-term sustainability.
Cursors and Loops
- Implement explicit cursors with OPEN, FETCH, CLOSE operations and cursor attributes for row-by-row processing.
- Configure cursor FOR loops, implicit cursors, and BULK COLLECT with FORALL for efficient data processing.
- Design cursor variable (REF CURSOR) implementations for dynamic SQL result set handling and pipelining.
- Evaluate cursor usage patterns to recommend bulk operations, LIMIT clauses, and cursor sharing for performance.
- Evaluate Cursors and Loops alternatives and tradeoffs to recommend the optimal approach for given constraints.
- Formulate Cursors and Loops governance frameworks with policies, standards, and compliance monitoring.
- Explain how to troubleshoot common issues with Cursors and Loops including error messages and diagnostic procedures.
2
Stored Programs
2 topics
Procedures and Functions
- Implement stored procedures with IN, OUT, and IN OUT parameters for modular database logic.
- Design stored function implementations with deterministic declaration, result cache, and purity levels for SQL integration.
- Configure procedure and function overloading within packages for polymorphic interface design.
- Analyze stored program designs to identify code reuse opportunities, parameter optimization, and dependency management.
- Design enterprise-grade Procedures and Functions architectures incorporating HA, DR, and security requirements.
- Apply Procedures and Functions configuration patterns to meet specific business requirements including compliance needs.
Packages
- Design package specifications and bodies with encapsulation, information hiding, and package state management.
- Implement package initialization, persistent state variables, and forward declarations for complex business logic.
- Configure package constants, subtypes, cursor variables, and associative arrays in package specifications.
- Evaluate package architectures to identify coupling issues, recommend refactoring, and improve maintainability.
- Implement Packages following best practices for security, performance, and reliability.
- Diagnose Packages issues by analyzing metrics, logs, and configuration to determine root causes.
3
Triggers and Error Handling
2 topics
Triggers
- Implement DML triggers (BEFORE, AFTER, INSTEAD OF) with row-level and statement-level granularity.
- Design compound triggers with timing point sections for handling mutating table issues and complex logic.
- Configure DDL triggers and database event triggers for schema change auditing and logon/logoff tracking.
- Analyze trigger designs to identify performance impacts, cascading effects, and recommend alternatives.
- Analyze Triggers configurations to identify security vulnerabilities, bottlenecks, and optimization opportunities.
- Recommend Triggers optimization strategies balancing performance, cost, and operational complexity.
Exception Handling
- Implement exception handling with predefined, user-defined, and PRAGMA EXCEPTION_INIT exceptions.
- Design exception propagation strategies with nested blocks, RAISE_APPLICATION_ERROR, and centralized error logging.
- Configure autonomous transactions for exception logging that persists regardless of main transaction rollback.
- Evaluate error handling patterns to ensure comprehensive coverage, meaningful error messages, and recovery logic.
- Architect Exception Handling solutions with scalability patterns and capacity planning for long-term sustainability.
- Configure Exception Handling with appropriate settings and parameters for a production deployment scenario in Oracle Database PL/SQL Developer Professional.
4
Collections and Dynamic SQL
2 topics
Collections
- Implement PL/SQL collection types: associative arrays, nested tables, and VARRAYs for in-memory data structures.
- Design BULK COLLECT and FORALL operations with SAVE EXCEPTIONS for high-performance batch processing.
- Configure collection methods (COUNT, FIRST, LAST, NEXT, PRIOR, EXTEND, TRIM) for dynamic collection manipulation.
- Evaluate collection usage patterns to select appropriate types and optimize memory consumption for large datasets.
- Explain how to troubleshoot common issues with Collections including error messages and diagnostic procedures.
- Evaluate Collections alternatives and tradeoffs to recommend the optimal approach for given constraints.
Dynamic SQL
- Implement native dynamic SQL with EXECUTE IMMEDIATE for runtime SQL construction and execution.
- Design DBMS_SQL package usage for complex dynamic SQL with unknown column counts and bind variable management.
- Configure dynamic PL/SQL with DBMS_DDL, dynamic package invocation, and runtime code generation patterns.
- Analyze dynamic SQL for SQL injection vulnerabilities and recommend parameterization and validation approaches.
- Compare Dynamic SQL deployment patterns to determine the best architecture for availability and scalability needs.
- Design enterprise-grade Dynamic SQL architectures incorporating HA, DR, and security requirements.
5
Advanced PL/SQL
2 topics
Advanced Features
- Design pipelined table functions with PIPE ROW for streaming result sets to SQL queries.
- Implement object types with methods, inheritance, and MAP/ORDER functions for object-relational programming.
- Configure fine-grained dependency tracking and conditional compilation for PL/SQL code management.
- Evaluate advanced PL/SQL features to recommend appropriate patterns for complex data processing requirements.
- Plan Advanced Features migration and modernization strategies with phased rollout and rollback procedures.
- Implement Advanced Features following best practices for security, performance, and reliability.
Performance and Debugging
- Implement PL/SQL profiling with DBMS_PROFILER and DBMS_HPROF for identifying performance bottlenecks.
- Design PL/SQL unit testing frameworks with utPLSQL for test-driven development of database logic.
- Configure PL/SQL compiler optimization with PLSQL_OPTIMIZE_LEVEL and PLSQL_CODE_TYPE for runtime performance.
- Analyze PL/SQL performance using profiling data to identify slow operations, excessive context switches, and optimization targets.
- Deploy Performance and Debugging with integration to monitoring, logging, and alerting services for operational visibility.
- Analyze Performance and Debugging configurations to identify security vulnerabilities, bottlenecks, and optimization opportunities.
Scope
Included Topics
- All domains in the Oracle Database PL/SQL Developer Professional certification exam guide.
- Core topics: PL/SQL Programming, Stored Procedures, Functions, Packages, Triggers, Collections, Dynamic SQL, Error Handling.
- Oracle services, tools, and best practices relevant to this certification.
- Scenario-based problem solving at the professional level.
Not Covered
- Topics outside the official exam guide scope.
- Programming language specifics beyond the exam requirements.
- Specific pricing values that change over time.
- Third-party products beyond basic integration awareness.
Official Exam Page
Learn more at Oracle
1Z0-149 is coming soon
Adaptive learning that maps your knowledge and closes your gaps.
Create Free Account to Be Notified