أوراكل
Oracle Certified Professional Developer (OCPD) طباعة

اهداف الدورة :

   

  1. تأهيل المهندسين والمبرمجين والمختصين للتقدم لنيل الشهادات المرخصة من  ORACLE والمعترف بها عالميا،ً والتي تؤهل حاملها للحصول على فرصة عمل مرموقة.

  2. رفد السوقين المحلي والخارجي بالكفاءات المدربة والمؤهلة لتصميم وتطوير

   Windows And  Web Application التي يحتاجها الطلاب في اعداد مشاريعهم ويحتاجها سوق العمل في الشركات الصغيرة والكبيرة.

.3 مواكبة التقنيات والتطورات المتسارعة في عالم تكنولوجيا المعلومات ولغات البرمجة الحديثة .

وصف الدورة:

اسم الدورة

مدة الدورة

الامتحان

الشهادة

المتطلب

السابق

Oracle Database

SQL Fundamentals

30

ساعة

Introduction to Oracle9i SQL
1Z0-007

OR
Introduction to Oracle: SQL and PL/SQL
1Z0-001

Oracle PL/SQL Developer Certified Associate

يوجد

Oracle Database:

Develop PL-SQL Program Units

25

ساعة

Program with PL/SQL 1Z0-147

الدورة

الاولى

Oracle Forms Developer:

Build Internet Applications

50

ساعة

Oracle Forms: Build Internet Applications
1Z0-141

Oracle Forms Developer Certified Professional

الدورة

الثانية

Oracle Reports Developer:

Build Reports

15

ساعة

 

 

الدورة

الثالثة

Total

120

ساعة

 

 

 

 

For More Information Please See The Link below:

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=48&p_org_id=1001&lang=US#2

المحتويات:

1.Oracle Database: SQL Fundamentals:

( Course Aim): Enable the candidate to understand the client requirements and design the ER(entity relationships) Model and the  Database Schema which satisfy these requirements, and  enable the student to write the required  DDL(Data Definition Language Statements) and the DML(Data Manipulation Language Statements) ,and the basics and advanced  SQL(Structured Query Language Statements) to retrieve data.

(Course Duration):

    (30 Credit Hour) which are given in (2 weeks)

 (Course Topics): the course covers the following subjects:

Introduction

·         Describing the Life Cycle Development Phases

·         Defining a Relational Database

·         Discussing the Theoretical, Conceptual, and Physical Aspects of a Relational Database

·         Describing How a Relational Database Management System (RDBMS) Is Used to Manage a Relational Database

·         Describing the Oracle Implementation of Both the RDBMS and the Object Relational Database Management System (ORDBMS)

·         Describing How SQL Is Used in the Oracle Product Set

Writing a Basic SQL Statement

·         Describing the SQL Select Capabilities

·         Executing a Basic Select Statement with the Mandatory Clauses

·         Differentiating Between SQL and iSQL*Plus Commands

Restricting and Sorting Data

·         Limiting the Rows Retrieved by a Query

·         Sorting the Rows Retrieved by a Query

Single Row Functions

·         Describing Various Types of Functions Available in SQL

·         Using a Variety of Character, Number, and Date Functions in SELECT Statements

·         Explaining What the Conversion Functions Are and How They Are Used

·         Using Control Statements

Displaying Data from Multiple Tables

·         Writing SELECT Statements to Access Data from More Than One Table

·         Describing the Cartesian Product

·         Describing and Using the Different Types of Joins

·         Writing Joins Using the Tips Provided

Aggregating Data by Using Group Functions

·         Identifying the Different Group Functions Available

·         Explaining the Use of Group Functions

·         Grouping Data by Using the GROUP BY Clause

Writing Subqueries

·         Describing the Types of Problems That Subqueries Can Solve

·         Describing Subqueries

·         Listing the Types of Subqueries

·         Writing Single-Row and Multi-Row Subqueries

·         Describing and Explaining the Behavior of Subqueries When NULL Values Are Retrieved

Producing Readable Output with iSQL*Plus

·         Producing Queries That Require an Input Variable

·         Customizing the iSQL*Plus Environment

·         Producing More Readable Output

·         Creating and Executing Script Files

Manipulating Data

·         Describing Each Data Manipulation Language (DML) Command

·         Inserting Rows into a Table

·         Updating Rows in a Table

·         Deleting Rows from a Table

·         Merging Rows into a Table

·         Controlling Transactions

·         Describing Transaction Processing

·         Describing Read Consistency and Implicit and Explicit Locking

Creating and Managing Tables

·         Describing the Main Database Objects

·         Creating Tables

·         Describing the Oracle Data Types

·         Altering Table Definitions

·         Dropping, Renaming, and Truncating Tables

Including Constraints

·         Describing Constraints

·         Creating and Maintaining Constraints

Creating Views

·         Describing Views and Their Uses

·         Creating a View

·         Retrieving Data by Means of a View

·         Inserting, Updating, and Deleting Data Through Views

·         Dropping Views

·         Altering the Definition of a View

·         Inline Views

·         Top 'N' Analysis

Other Database Objects

·         Creating, Maintaining, and Using Sequences

·         Creating and Maintaining Indexes

·         Creating Private and Public Synonyms

Controlling User Access

·         Understanding the Concepts of Users, Roles, and Privileges

·         Granting and Revoking Object Privileges

·         Creating Roles and Granting Privileges to Roles

·         Creating Synonyms for Ease of Table Access

SQL Workshop

·         Applying Techniques Learned in This Course

·         Preparing for Future Oracle Courses

2. Oracle Database: Develop PL-SQL Program Units:

 

(Course Aim): students will learn  how to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications, and how design and develop the subprograms (Procedures, Functions and Packages), and create the Database Triggers to improve the Transaction performance.

(Course Duration):

    (25 Credit Hour) which are given in ( 2 weeks)

 (Course Topics): the course cover the following subjects :

Introduction

·         Describing PL/SQL

·         Describing the Use of PL/SQL for the Developer and the Database Administrator

·         Explaining the Benefits of PL/SQL

·         PL/SQL program constructs

·         PL/SQL anonymous block structure

·         Subprogram block structure

·         Course objectives and overview

Declaring Variables

·         Recognizing the Basic PL/SQL Block and Its Sections

·         Describing the Significance of Variables in PL/SQL

·         Distinguishing Between PL/SQL and Non-PL/SQL Variables

·         Declaring Variables and Constants

·         Executing a PL/SQL Block

Writing Executable Statements

·         Recognizing the Significance of the Executable Section

·         Writing Statements Within the Executable Section

·         Describing the Rules of Nested Blocks

·         Executing and Testing a PL/SQL Block

·         Using Coding Conventions

Interacting with the Oracle Server

·         Writing a Successful SELECT Statement in PL/SQL

·         Declaring the Data type and Size of a PL/SQL Variable Dynamically

·         Writing Data Manipulation Language (DML) Statements in PL/SQL

·         Controlling Transactions in PL/SQL

·         Determining the Outcome of SQL DML Statements

Writing Control Structures

·         Identifying the Uses and Types of Control Structures

·         Constructing an IF Statement

·         Constructing and Identifying Different Loop Statements

·         Controlling Block Flow Using Nested Loops and Labels

·         Using Logic Tables

Working with Composite Data types

·         Creating User-Defined PL/SQL Records

·         Creating a PL/SQL Table

·         Creating a PL/SQL Table of Records

·         Differentiating Among Records, Tables, and Tables of Records

Writing Explicit Cursors

·         Using a PL/SQL Record Variable

·         Distinguishing Between the Implicit and Explicit Cursor

·         Writing a Cursor FOR Loop

Advanced Explicit Cursor Concepts

·         Writing a Cursor that Uses Parameters

·         Determining When a FOR UPDATE Clause in a Cursor Is Required

·         Using a PL/SQL Table Variable

·         Using a PL/SQL Table of Records

Handling Exceptions

·         Defining PL/SQL Exceptions

·         Recognizing Unhandled Exceptions

·         Listing and Using Different Types of PL/SQL Exception Handlers

·         Trapping Unanticipated Errors

·         Describing the Effect of Exception Propagation in Nested Blocks

·         Customizing PL/SQL Exception Messages

Creating Procedures

·         Describe the uses of procedures

·         Create procedures

·         Create procedures with arguments

·         Invoke a procedure

·         Remove a procedure

Creating Functions

·         Describe the uses of functions

·         Create a function

·         Invoke a function

·         Remove a function

·         Differentiate between a procedure and a function

Managing Subprograms

·         Describe system privilege requirements

·         Describe object privilege requirements

·         Query the relevant data dictionary views

·         Debug subprograms

Creating Packages

·         Describe packages and list their possible components

·         Create packages that include public and private subprograms, as well as global and local variables

·         Invoke objects in a package

·         Remove packages

More Package Concepts

·         Write packages that use the overloading feature of PL/SQL

·         Avoid errors with mutually referential subprograms

·         Initialize variables with a one-time-only procedure

·         Specify the purity level of packaged functions

·         Describe the persistent state of packaged variables, cursors, tables, and records

·         Query the relevant data dictionary views

Using Oracle-Supplied Packages

·         Overview of Oracle-supplied packages

·         View examples of some supplied packages

·         Write dynamic SQL

Creating Database Triggers

·         Describe different types of triggers

·         Describe database triggers and their use

·         Create database triggers

·         Describe database trigger firing rules

·         Drop database triggers

More Trigger Concepts

·         Create triggers that fire when certain database actions occur

·         List some of the limitations of database triggers

·         Determine when to use database triggers or Oracle Server features

·         Create triggers by using alternative events (notINSERT/UPDATE/DELETE)

·         Create triggers by using alternative levels (not STATEMENT/ROW)

·         Query the relevant data dictionary views

Managing Dependencies

·         Overview of object dependencies

·         Manage PL/SQL objects for recompilation

Manipulating Large Objects

·         Compare and contrast LONG/RAW/LONG RAW with large objects (LOBs)

·         Understand LOBs

·         Manage binary large file objects (BFILEs)

·         Use PL/SQL with an LOB

·         Create a table with LOB columns

·         Manipulate LOBs

·         Use DBMS_LOB Oracle-supplied packages

·         Create a temporary LOB

3. Oracle Forms Developer: Build Internet Applications:

(Course Aim): This course teaches the student how to develop and deploy Internet applications using Oracle9i Forms. Working in a rapid development environment, participants learn how to customize forms through user input items and how to control data access by creating event-related triggers. In this practical course, you also learn how to test and debug your Web applications through the Forms environment.

(Course Duration):

    (50 Credit Hour) which are given in ( 3 weeks)

  (Course Topics):the course cover the following subjects :

Introduction to Oracle Forms Developer and Oracle Forms Services

·         Internet Computing Solutions

·         What Is the Oracle9i Internet Platform?

·         Oracle9iAS Architecture and Components

·         Forms Services Architecture

·         Oracle9iDS Components

·         Oracle9i Forms Developer Key Features

·         Forms Builder Components

·         Navigating the Forms Builder Interface

Running a Forms Developer Application

·         Running a Form

·         Web Form Tester

·         Starting a Run Time Session

·         What are the Forms Servlet and Listener Servlet?

·         What Is the Forms Client?

·         Defining Forms Environment Variables

·         What You See at Run Time

·         Identifying the Data Elements

Working in the Forms Developer Environment

·         Forms Builder Key Features

·         Forms Developer Executables

·         Forms Builder, Forms Compiler

·         Invoking Forms Executables

·         Forms Builder Module Types

·         Forms Builder Module Object Hierarchy

·         Testing a Form with the Run Form button

·         Starting OC4J

Creating a Basic Form Module

·         Creating a New Form Module

·         Creating and modifying a New Data Block

·         Modifying the Layout

·         Template Forms

·         Saving and Compiling a Form Module

·         Deploying a Form Module

·         Moving the Form to the Middle Tier

·         Generating on the Middle Tier

Working with Data Blocks and Frames

·         Managing Object Properties

·         Re-entrant Wizards

·         Layout Editor

·         Property Palette

·         Controlling the Behavior of Data Blocks

·         Setting Navigation and Database Properties

·         Controlling the Appearance of Data Blocks

·         Setting Record, Scrollbar and Frame Properties

Working with Text Items

·         Creating a Text Item

·         Modifying Appearance

·         Controlling the Data of a Text Item

·         Altering the Navigational Behavior of a Text Item

·         Enhancing the Relationship between Text Item and Database

·         Adding Functionality

·         Displaying Helpful Messages

Creating LOVs and Editors

·         LOVs and Record Groups

·         Creating an LOV

·         LOV Properties

·         Creating an Editor

·         Setting Editor Properties

·         Associating an Editor with a Text Item

Creating Additional Input Items

·         Creating a Check Box

·         Setting Check Box Properties

·         Creating a List Item

·         Setting List Item Properties

·         Creating a Radio Group

·         Setting Radio Group Properties

Creating Noninput Items

·         Creating a Display Item

·         Creating an Image Item

·         Setting Image Item Properties

·         Creating a Push Button

·         Setting Button Properties

·         Creating a Calculated Item

·         Setting Calculated Item Properties

·         Creating a Hierarchical Tree Item

Creating Windows and Content Canvases

·         What Are Windows and Canvases?

·         Relationship between Windows and Content Canvases

·         Displaying a Form Module in Multiple Windows

·         Creating a Window

·         Setting Window Properties

·         Displaying a Form Module on Multiple Layouts

·         Creating a New Content Canvas

·         Setting Content Canvas Properties

Working with Other Canvas Types

·         Overview of Canvas Types

·         Creating a Stacked Canvas

·         Setting Stacked Canvas Properties

·         Setting Toolbar Properties

·         Creating a Toolbar Canvas

·         Creating a Tab Canvas

·         Setting Tab Canvas Properties

Introduction to Triggers

·         Trigger Components

·         Type, Code and Scope

·         Trigger Execution Hierarchy

Producing Triggers

·         Creating Triggers

·         Setting Trigger Properties

·         PL/SQL Editor Features

·         Database Trigger Editor Features

·         Writing Trigger Code

·         Adding Functionality with Built-in Subprograms

·         Using Triggers

Debugging Triggers

·         The Debugging Process

·         The Debug Console

·         Call Stack

·         Variables

·         Watch List

·         Form Values

·         PL/SQL Packages

·         Global/System Variables

Adding Functionality to Items

·         Item Interaction Triggers

·         Defining Functionality for Input Items

·         Interacting with Check Boxes

·         Changing List Items at Run Time

·         Defining Functionality for Noninput Items

·         Displaying LOVs from Buttons

·         Populating Image Items

·         Populating Hierarchical Trees

Runtime Messages and Alerts

·         Runtime Messages and Alerts Overview

·         Built-Ins and Handling Errors

·         Controlling System Messages

·         The FORM_TRIGGER_FAILURE Exception

·         Triggers for Intercepting System Messages

·         Creating and Controlling Alerts

·         Handling Errors Raised by the Oracle Database Server

Query Triggers

·         Query Processing Overview

·         SELECT Statements Issued During Query Processing

·         WHERE and ORDER BY clauses

·         The ONETIME_WHERE property

·         Writing Query Triggers

·         Query Array Processing

·         Coding Triggers for Enter-Query Mode

·         Overriding Default Query Processing

Validation

·         Validation Process

·         Controlling Validation Using Properties

·         Form-level Properties

·         Block-level Properties

·         Item-level Properties

·         Controlling Validation Using Triggers

·         When-Validate-Item Trigger

·         When-Validate-Record Trigger

Navigation

·         Navigation Overview

·         Understanding Internal Navigation

·         Controlling Navigation Using Object Properties

·         Writing Navigation Triggers

·         Using Pre- and Post- Triggers

·         Using When-New-<object>-Instance Triggers

·         The Navigation Trap

·         Using Navigation Built-Ins in Triggers

Transaction Processing

·         Transaction Processing Overview

·         The Commit Sequence of Events

·         Characteristics of Commit Triggers

·         Common Uses of Commit Triggers

·         The Life of an Update

·         Delete Validation

·         Assigning Sequence Numbers

·         Keeping an Audit Trail

Writing Flexible Code

·         Using System Variables for Flexible Coding

·         Using Built-in Subprograms for Flexible Coding

·         Referencing Objects by Internal ID

·         Referencing Items Indirectly

Sharing Objects and Code

·         Benefits of Reusable Objects and Code

·         What Are Property Classes?

·         Creating a Property Class

·         Inheriting from a Property Classes

·         What Are Object Groups?

·         Creating and Using Object Groups

·         Copying and Subclassing Objects and Code

·         What is an Object Library

4. Oracle Reports Developer: Build Reports:

 (Course Aim): Enable the Candidate to Design and Develop reliable and robust Windows and Web Applications Reports  using Oracle Reports Developer Technology.  

 (Course Duration):

    (15 Credit Hour) which are given in ( 1 week)

 (Course Description): the course cover the following subjects :

                 

Lesson 1:Introduction to  Report Developer

Overview 1-3

What Is Developer/2000?1-5

Introducing the Developer/2000 Components 1-11

Common Builder Components 1-15

Getting Started in the Developer/2000 Interface 1-19

Navigating Around the Developer/2000 Main Menu 1-21

Customizing Your Developer/2000 Session 1-23

Developer/2000 Environment Variables 1-27

Invoking Online Help Facilities 1-29

Introducing the Course Application 1-31

Lesson 2:Designing and Running Reports

Overview 2-3

Designing Reports 2-5

Design Considerations 2-7

Retrieving and Sharing Data 2-15

Running a Report 2-17

Viewing the Report Output 2-19

Lesson 3:Report Builder Concepts

Overview 3-3

Report Executables 3-5

Report Builder Components 3-9

Object Categories 3-13

Lesson 4:Creating Reports Using the Report Wizard

Overview 4-3

Invoking Report Builder and the Report Wizard 4-5

Creating a Tabular Report Using the Wizard 4-7

Creating Other Report Styles 4-23

Lesson 5:Enhancing Reports in the Live Previewer

Overview 5-3

What Is the Live Previewer?5-5

Modifying a Report in the Live Previewer 5-7

Lesson 6:Managing Report Templates

Overview 6-3

Using the Report Templates 6-5

Modifying a Template 6-7

Predefining Your Own Templates 6-13

Lesson 7:Creating and Using Report Parameters

Overview 12-3

Creating User Parameters 12-5

Referencing Parameters in a Report Query 12-7

Hints and Tips for Referencing Parameters 12-13

Creating a List of Values 12-15

Referencing System Parameters 12-19

Building a Parameter Form 12-23

 

 


اتصل بنا

جامعة اليرموك
 مركز الملكة رانيا للدراسات الأردنية وخدمة المجتمع
 إربــد – الأردن
 هاتف: 7211111 – (02) فرعي: 6351  أو 6350
 فاكس: 7211146
 البريد الإلكتروني:  qr_cen@yu.edu.jo 

 أو التفضل بزيارة المركز بجامعة اليرموك