Oracle database 11g PLSQL Fundamentals


Oracle Database 11g PL/SQL Fundamentals Release 2

در این دوره دانش آموزان با زبان قوی برنامه نویسی در سمت پایگاه داده اوراکل آشنا می شوند.

دانش آموزان موارد زیر را یاد می گیرند:

۱-ایجاد بلوکهای PL/SQL نا شناخته

۲- ایجاد رویه و توابع ذخیره شده در پایگاه داده اوراکل

۳-تعریف متغییر های, آرایه ها , بردارها

۴-نحوه به دام انداختن exception ها


Oracle Database 11g: SQL Fundamentals I & II

سر فصل دوره بعدی Oralce 11g PLSQL Program Units

سرفصلها این دوره:


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

Using Associative Arrays (INDEX BY Tables)

Examining INDEX BY Table Methods

Using 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


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


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