 |
 |
 |
|
 |
 |
 |
 |
 |
 |
 |
|
|
|
|
|
|
 |
 |
 |
 |
 |
 |
 |
|
|
|
 |
 |
 |
 |
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
| |
Oracle Certified Application Developer
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.
OCP
Application Developer tasks:
A developer's responsibilities generally include but are not limited to
the following:
- 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.
- Tuning the application during development.
- 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: 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
Copyright
© 2006 Cyber Networks (ICT) Ltd. All Rights Reserved.
Cyber Technologies and the Cyber logo are registered trademarks of Cyber
Networks (ICT) Ltd. All brand names mentioned herein are used for identification
purposes only and are trademarks of their respective organizations.