ERP Products Other Products Virtual Classroom

Search

paypal verified
paypal cartes de crédit

Oracle Database 11g: PL/SQL Fundamentals


Oracle Database 11g: PL/SQL Fundamentals

Now you can study at home by your self and
get certified.

These set teach you everything you need to know to become an Oracle 11g Certified Professional.

The tests are based directly from the information from these books

Database 11g PL/SQL Fundamentals

What you will learn:

This course introduces students to PL/SQL and explains the benefits of this powerful programming language. Students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students also learn to create anonymous PL/SQL blocks and are introduced to stored procedures and functions. Students learn about declaring identifiers and trapping exceptions. Demonstrations and hands-on practice reinforce the fundamental concepts.

Students use Oracle SQL Developer to develop these program units. SQL*Plus and JDeveloper are introduced as optional tools.

Learn to:

Declaring PL/SQL Variables
Working with Composite Data Types
Conditionally control code flow (loops, control structures)
Explicit cursors
Handle runtime errors
Describe stored procedures and functions


Course Objectives:


Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
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


Course Topics:



Introduction
Course Objectives
Course Agenda
Describing the Human Resources (HR) Schema
PL/SQL development environments Available in this course
Introduction to SQL Developer
Introduction to PL/SQL
PL/SQL Overview
Benefits of PL/SQL Subprograms
Overview of the Types of PL/SQL blocks
Creating and Executing a Simple Anonymous Block
Generating Output from a PL/SQL Block
Declaring PL/SQL Identifiers
Different Types of Identifiers in a PL/SQL subprogram
Using the Declarative Section to Define Identifiers
Storing Data in Variables
Scalar Data Types
%TYPE Attribute
Bind Variables
Using Sequences in PL/SQL Expressions
Writing Executable Statements
Describing Basic PL/SQL Block Syntax Guidelines
Commenting Code
SQL Functions in PL/SQL
Data Type Conversion
Nested Blocks
Operators in PL/SQL
Interacting with the Oracle Server
Including SELECT Statements in PL/SQL to Retrieve data
Manipulating Data in the Server Using PL/SQL
The SQL Cursor concept
Using SQL Cursor Attributes to Obtain Feedback on DML
Saving and Discarding Transactions
Writing Control Structures
Conditional processing Using IF Statements
Conditional processing Using CASE Statements
Simple Loop Statement
While Loop Statement
For Loop Statement
The Continue Statement
Working with Composite Data Types
Using PL/SQL Records
Using the %ROWTYPE Attribute
Inserting and Updating with PL/SQL Records
INDEX BY Tables
INDEX BY Table Methods
INDEX BY Table of Records
Using Explicit Cursors
Understanding Explicit Cursors
Declaring the Cursor
Opening the Cursor
Fetching data from the Cursor
Closing the Cursor
Cursor FOR loop
Explicit Cursor Attributes
FOR UPDATE Clause and WHERE CURRENT Clause
Handling Exceptions
Understanding Exceptions
Handling Exceptions with PL/SQL
Trapping Predefined Oracle Server Errors
Trapping Non-Predefined Oracle Server Errors
Trapping User-Defined Exceptions
Propagate Exceptions
RAISE_APPLICATION_ERROR Procedure
Creating Stored Procedures and Functions
Understanding 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


                     Shipping

Shipping is free IMMEDIATE DOWNLOAD AFTER PAYMENT .Receive a direct download link in your email in 1 - 3 minutes.

[Do NOT forget to check the junk or Spam mails of your email box]



29.99 $



Enter promotionnal code:







Terms & Policy

Website hosting and design by Zedimage.com       admin