Oracle Database: PL/SQL Fundamentals

Total time
Logo Oracle University

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

This Oracle Database: PL/SQL Fundamentals training introduces you to PL/SQL and explains the benefits of this programming language. You'll learn how to create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.

Learn To:

  • Conditionally control code flow (loops, control structures).
  • Use explicit cursors.
  • Handle runtime errors.
  • Describe stored procedures and functions.
  • Work with composite data types.
  • Declare PL/SQL variables.
  • Create anonymous PL/SQL blocks, stored procedures and functions.
  • Declare identifiers and trap exceptions.

Benefits to You

Enrolling in this course will teach you how to extend the functionality of the SQL lang…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Oracle, Database Management, PL/SQL, CompTIA A+ / Network+ / Security+, and IT Security.

This Oracle Database: PL/SQL Fundamentals training introduces you to PL/SQL and explains the benefits of this programming language. You'll learn how to create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.

Learn To:

  • Conditionally control code flow (loops, control structures).
  • Use explicit cursors.
  • Handle runtime errors.
  • Describe stored procedures and functions.
  • Work with composite data types.
  • Declare PL/SQL variables.
  • Create anonymous PL/SQL blocks, stored procedures and functions.
  • Declare identifiers and trap exceptions.

Benefits to You

Enrolling in this course will teach you how to extend the functionality of the SQL language with PL/SQL language to write application code. Your organization can then realize the full benefit of utilizing Oracle best practices.

Participate in Hands-On Exercises

Demonstrations and hands-on exercises reinforce the fundamental concepts you'll learn in this course, which is designed for a 10g and 11g audience (there are minor changes between 10g and 11g features). You'll use Oracle SQL Developer to develop these program units. SQL*Plus and JDeveloper are available as optional tools.


Audience
  • System Analysts
  • Technical Consultant
  • Forms Developer
  • Portal Developer
  • PL/SQL Developer

Course Topics Introduction
  • Course Objectives
  • Course Agenda
  • Human Resources (HR) Schema
  • Introduction to SQL Developer
Introduction to PL/SQL
  • PL/SQL Overview
  • Benefits of PL/SQL Subprograms
  • Overview of the Types of PL/SQL blocks
  • Create a Simple Anonymous Block
  • Generate Output from a PL/SQL Block
PL/SQL Identifiers
  • List the different Types of Identifiers in a PL/SQL subprogram
  • Usage of the Declarative Section to define Identifiers
  • Use variables to store data
  • Identify Scalar Data Types
  • The %TYPE Attribute
  • What are Bind Variables?
  • Sequences in PL/SQL Expressions
Write Executable Statements
  • Describe Basic PL/SQL Block Syntax Guidelines
  • Comment Code
  • Deployment of SQL Functions in PL/SQL
  • How to convert Data Types?
  • Nested Blocks
  • Identify the Operators in PL/SQL
Interaction with the Oracle Server
  • Invoke SELECT Statements in PL/SQL to Retrieve data
  • Data Manipulation in the Server Using PL/SQL
  • SQL Cursor concept
  • Usage of SQL Cursor Attributes to Obtain Feedback on DML
  • Save and Discard Transactions
Control Structures
  • Conditional processing Using IF Statements
  • Conditional processing Using CASE Statements
  • Use simple Loop Statement
  • Use While Loop Statement
  • Use For Loop Statement
  • Describe the Continue Statement
Composite Data Types
  • Use PL/SQL Records
  • The %ROWTYPE Attribute
  • Insert and Update with PL/SQL Records
  • Associative Arrays (INDEX BY Tables)
  • Examine INDEX BY Table Methods
  • Use INDEX BY Table of Records
Explicit Cursors
  • What are Explicit Cursors?
  • Declare the Cursor
  • Open the Cursor
  • Fetch data from the Cursor
  • Close the Cursor
  • Cursor FOR loop
  • Explicit Cursor Attributes
  • FOR UPDATE Clause and WHERE CURRENT Clause
Exception Handling
  • Understand Exceptions
  • Handle Exceptions with PL/SQL
  • Trap Predefined Oracle Server Errors
  • Trap Non-Predefined Oracle Server Errors
  • Trap User-Defined Exceptions
  • Propagate Exceptions
  • RAISE_APPLICATION_ERROR Procedure
Stored Procedures and Functions
  • Understand Stored Procedures and Functions
  • Differentiate between anonymous blocks and subprograms
  • Create a Simple Procedure
  • Create a Simple Procedure with IN parameter
  • Create a Simple Function
  • Execute a Simple Procedure
  • Execute a Simple Function

Course Objectives
  • Handle runtime errors
  • Describe stored procedures and functions
  • Use cursors to process rows
  • Design PL/SQL anonymous block that execute efficiently
  • Describe the features and syntax of PL/SQL
  • Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.