This Database Program with PL/SQL training shows you how to develop stored procedures, functions, packages and database triggers. You'll learn to manage PL/SQL program units and dependencies, while using some of the Oracle-supplied packages.

Learn To

This Oracle Database: Program with PL/SQL training starts with an introduction to PL/SQL and then explores the benefits of this powerful programming language. Through hands-on instruction from expert Oracle instructors, you'll learn to develop stored procedures, functions, packages and more.

• Conditionally control code flow (loops, control structures).

• Create stored procedures and functions.

• Use PL/SQL packages to group and contain related constructs.

• Create triggers to solve business challenges.

• Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.

• Create custom packages for applications.

• Write Dynamic SQL code for applications.

Audience

• Database Administrator

• Implementer

• Developer

• Systems Administrator

Course Objectives

• Use conditional compilation to customize the functionality in a PL/SQL application

• without removing any source code

• Design PL/SQL packages to group related constructs

• Create overloaded package subprograms for more flexibility

• Design PL/SQL anonymous blocks that execute efficiently

• Use the Oracle supplied PL/SQL packages to generate screen output, file output and

• mail output

• Write dynamic SQL for more coding flexibility

• Describe the features and syntax of PL/SQL

• Create and debug stored procedures and functions

• Use PL/SQL programming constructs and conditionally control code flow (loops, control

• structures, and explicit cursors)

• Manage dependencies between PL/SQL subprograms

• Handle runtime errors

• Create triggers to solve business challenges

• Display data from multiple tables using the ANSI SQL 99 JOIN syntax

• Manage objects with data dictionary views

• Write multiple-column sub-queries

• Employ SQL functions to retrieve customized data

• Use scalar and correlated sub-queries

• Create reports of sorted and restricted data

Course Topics

Introduction

• Course Objectives

• Course Agenda

• Describe the Human Resources (HR) Schema

• PL/SQL development environments available in this course

• Introduction to SQL Developer

Introduction to PL/SQL

• Overview of PL/SQL

• Identify the benefits of PL/SQL Subprograms

• Overview of the types of PL/SQL blocks

• Create a Simple Anonymous Block

• How to generate output from a PL/SQL Block?

Declare 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

• about:blank

• 2 of 4 10/23/2019, 2:11 PM

• Identify Scalar Data Types