The Oracle Certification Professional Program (OCP) is a valuable, industry-recognized credential that signifies a proven level of knowledge and ability. An OCP Certification demonstrates that you have a solid understanding of a job role and the Oracle products used in that role. Being a Certified Professional can help raise your visibility and increase your access to the industry’s most challenging opportunities.

The Oracle Certified Professional (OCP) Program helps the IT industry make the distinction by establishing a standard of competence in specific job roles. An Oracle Certification is a valuable, industry-recognized credential that signifies a proven level of knowledge and ability.

There are 2 specific training and certification programs offered by Cybernetworks with respect to Oracle:

• OCP Application Developer.
• OCP Database Administrator.

• Designing and developing the database application.
• Designing the database structure for an application.
• Estimating storage requirements for an application.
• Specifying modifications of the database structure for an application.
• Relaying the above information to a database administrator.
• Establishing an application's security measures during development.

Courses delivered:
The courses taught at CyberNetworks that lead to the Oracle OCP Application Developer Certification include:

Introduction to Oracle 9i/SQL.

• Oracle 9i:Programming with PL/SQL.
• Oracle 9i IDS Forms: Build Internet Applications I.
• Oracle 9i IDS Forms: Build Internet Applications II.
• Oracle 9i IDS Reports: Build Internet Reports.
• Introduction to Oracle: SQL and PL/SQL (35 hours)

What you will learn:
This course offers students an extensive introduction to data server technology. The class covers the concepts of both relational and object relational databases and the powerful SQL programming language. Students are taught to create and maintain database objects and to store, retrieve, and manipulate data. Students learn to retrieve data by using advanced techniques such as ROLLUP, CUBE, set operators, and hierarchical retrieval. They also learn to write SQL and SQL*Plus script files using the iSQL*Plus tool to generate report-like output. Demonstrations and hands-on practice reinforce the fundamental concepts.

Audience:

• Technical Support Professionals
• Database Administrators
• System Analysts
• Applications Developer

Prerequisites:

Familiarity with data processing concepts and techniques
Ability to use a graphical user interface (GUI)

Course Topics:

1. Introduction
2. Writing a Basic SQL Statement
3. Restricting and Sorting Data
4. Single Row Functions
5. Displaying Data from Multiple Tables
6. Writing Subqueries
7. Producing Readable Output with iSQL*Plus
8. Manipulating Data
9. Creating and Managing Tables
10. Including Constraints
11. Describing Constraints
12. Creating and Maintaining Constraints
13. Creating Views
14. SQL Workshop
15. Using Set Operators
16. Oracle9i Single Row Functions
17. Enhancements to the GROUP BY Clause
18. Advanced Subqueries
19. Hierarchical Retrieval
20. Extensions to DDL and DML Statements
21. Writing Scripts to Generate Scripts
    
    

Oracle 9i IDS Forms: Build Internet Applications I (35 hours).

Oracle 9i IDS Forms: Build Internet Applications II (35 hours).

Oracle 9i IDS Reports: Build Internet Reports (35 hours).