1Z0-149-Oracle Database PL/SQL Developer Certified Professional Certification Training

Course Content

Declaring PL/SQL Variables

Recognize valid and invalid identifiers
List the uses of variables, declare and initialize variables, use bind variables
List and describe various data types using the %TYPE and %ROWTYPE attributes

Writing Executable Statements

Writing SQL in PL/SQL

Writing Control Structures

Working with Composite Data Types

Using Explicit Cursors

Handling Exceptions

Using PL/SQL Subprograms

Creating Procedures and Using Parameters

Creating Functions

Creating Packages

Working with Packages

Using Dynamic SQL

Design Considerations for PL/SQL Code

Creating Compound, DDL, and Event Database Triggers

Using the PL/SQL Compiler

Managing PL/SQL Code

Managing Dependencies

About Course

The 1Z0-149 certification, known as Oracle Database PL/SQL Developer Certified Professional, validates skills in developing and implementing PL/SQL applications in Oracle Database environments. It covers advanced PL/SQL concepts, SQL optimization techniques, and security measures. Holders of 1Z0-149 demonstrate proficiency in database programming, improving application performance, and ensuring secure data management. This certification enhances career opportunities by confirming expertise in Oracle PL/SQL development, supporting database-driven applications, and optimizing data handling processes for organizations across various sectors, including finance, healthcare, and IT services.

Enrollment validity: 180 days

All Levels
0 Total Enrolled
40 hours Duration
July 29, 2024 Last Updated
Certificate of completion

Live Trainer Classes

All Courses

Business Analysis

Cloud Computing

CyberSecurity

Database

Management

Self Learning Courses

Art

Culture

Human Resource

Literature

Networking

Software Development

Let Me Study

Search My One on One Tutor

Find your desired course

Select Your Favourite Category And Start Learning.

Live Trainer Classes

All Courses

Business Analysis

Cloud Computing

CyberSecurity

Database

Management

Self Learning Courses

Art

Culture

Human Resource

Literature

Networking

Software Development

1Z0-149-Oracle Database PL/SQL Developer Certified Professional Certification Training

All Levels

40h

62

Course Content

Declaring PL/SQL Variables

Recognize valid and invalid identifiers

List the uses of variables, declare and initialize variables, use bind variables

List and describe various data types using the %TYPE and %ROWTYPE attributes

Writing Executable Statements

Identify lexical units in a PL/SQL block

Use built-in SQL functions in PL/SQL and sequences in PL/SQL expressions

Describe when implicit conversions take place and when explicit conversions have to be dealt with

Write nested blocks and qualify variables with labels

Write readable code with appropriate indentation

Writing SQL in PL/SQL

Create PL/SQL executable blocks using DML and transaction control statements

Make use of the INTO clause to hold the values returned by a SQL statement

Writing Control Structures

Identify the uses and types of control structures (IF, CASE statements and expressions)

Construct and identify loop statements

Use EXIT and CONTINUE statements inside loops

Working with Composite Data Types

Create user-defined PL/SQL records

Create a record with the %ROWTYPE attribute

Create an INDEX BY table and INDEX BY table of records

Describe the differences among records, collections, and collections of records

Initialize collections and records

Using Explicit Cursors

Distinguish between implicit and explicit cursors and use SQL cursor attributes

Declare and control explicit cursors, use simple loops and cursor FOR loops to fetch data

Declare and use cursors with parameters

Lock rows with the FOR UPDATE clause and reference the current row with the WHERE CURRENT OF clause

Handling Exceptions

Define PL/SQL exceptions

Recognize unhandled exceptions

Handle different types of exceptions (internally defined exceptions, predefined exceptions and user-defined exceptions)

Propagate exceptions

Using PL/SQL Subprograms

Differentiate between anonymous blocks and subprograms

Create a simple procedure and invoke it from an anonymous block

Identify benefits of subprograms

Creating Procedures and Using Parameters

Create a procedure with parameterrs

Use named notation

Work with procedures (create, invoke and remove procedures)

Handle exceptions in procedures and display a procedure’s information

Creating Functions

Select Your Favourite
Category And Start Learning.