MISSION

supervised and delivers only the official training programs for more than 3000 Courses and 480 Certificates, through 30 dedicated Learning Centers in Egypt, Kuwait, and UAE.....

Read more   

learning process

partner of the most world's technology leaders such as: Microsoft, Cisco, Math-Works, CompTia, WiMax, CWNP, Oracle, EC-Council, CIW, Symantec, ETS, Parametric, PearsonVUE, and more ...

Read more   

Warm welcome

WE aimed to improve and develop the human resources to be qualified for job Opportunities. By assure quality through the four basic elements of learning process (Official curriculum, Expert Teaching Staff, Hand-ON labs, Suitable Environment)...

Read more   

Quality assurance

our quality control and montoring system is added value, allow our customers watching the secure cams 24/7, performance and evaluate the training progress. ...

Read more   
Nada Youssef
Date: 2012-11-10
nice site... More...
Ahmed Ali
Date: 2012-11-10
I like the site design, it's sweet .. simple ... well organized. Hope to see next projects... More...
Maha el Said
Date: 2012-11-11
Very Helpful and very organized company...it opens its doors for people who are willing to learn and develop their designing abilities.... More...
mohamed saad
Date: 2012-11-28
it\'s very nice website go ahead..... More...

  • Category: Microsoft Office
    Date: 2012-11-12
                                    Play

  • Category: Adobe
    Date: 2012-11-12
                                    Play

  • Category: Adobe
    Date: 2012-11-12
                                    Play

  • Category: Entercaps Traning Center
    Date: 2012-11-11
                                    Play
  • Photoshop CS5-The Missing Manual
    Photoshop CS5-The Missing Manual
    DOWNLOAD
  • Photoshop CS6 For Dummies
    A dobe Photoshop is one of the most impo
    DOWNLOAD
  • Pro .NET Best Practices
    Pro .NET Best Practices
    DOWNLOAD
  • Hardening Cisco Routers
    Hardening Cisco Routers
    DOWNLOAD
   OCA: Oracle PL/SQL Developer Certified Associate

Admission

Database Administrators. Forms Developer. Portal Developer. Business Intelligence Developer. Application Developers. PL/SQL Developer. Technical Consultant. Database Designers.


OCA: Oracle PL/SQL Developer Certified Associate
     Professional Group
  Oracle Database 10g: Introduction to SQL   42
  Oracle Database 10g: Program with PL/SQL   42
Exam # Duration Language Level Type Classroom Code Fees
-- 84 English Professional Course Classroom Cs397 0 LE
Description :

This package offers students an introduction to Oracle Database 10g database technology. In this class students learn the concepts of relational databases and the powerful SQL programming language. This package provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, create database objects, and query meta data. In addition, the advanced features of SQL in order to query and manipulate data within the database are taught. Advanced querying and reporting techniques are explained. Schema objects that are useful for data warehousing and other application areas are discussed in detail. Students learn about manipulating large data sets and storing and retrieving dates according to different time zones. This package introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications.



Objectives :
  • Retrieve row and column data from tables with the SELECT statement.
  • Employ SQL functions to generate and retrieve customized data.
  • Run data manipulation statements (DML) to update data in the Oracle Database 10g.
  • Control user access and manage schema objects.
  • Search data using advanced sub queries.
  • Design PL/SQL anonymous blocks that execute efficiently.
  • Write PL/SQL code to interface with the database.
  • Describe the features and syntax of PL/SQL.
  • Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors).
  • Handle runtime errors.
  • Create simple procedures and functions.
  • Design PL/SQL packages to group and contain related constructs.
  • Categorize and Use the Oracle supplied PL/SQL packages to generate screen output, file output, web output, and mail output.
  • Schedule PL/SQL jobs to run independently.
  • Write dynamic SQL for more coding flexibility.
  • Create triggers to solve business challenges.
  • Manage dependencies between PL/SQL subprograms.


Topics :




Recommended Knowledge :

Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI).

Recommended Course(s) :

Windows Vista Core

 Database Concepts


Training Materials :

Oracle Press


Labs :

This package includes several labs to ensure you will gain the targeted skills and experience.


Credential :

This package is necessary to pass ORACLE10g Forms Developer Certified Professional (OCP).

Category :
Programming


The Instructor: