Oracle 10G Developer Training OCA Oracle Certified Associate
 Netwind Learning center offers one of the most extensive lines of training
courses for Oracle Database Developer 10G OCA. Our training is co-developed with Oracle and contains everything that is required for your
training. All training CDs have full audio sound tracks, interactive exercises, lab exercises and post review questions.
Oracle Developer OCA
The PL/SQL Developer Certified Associate understands how to use this powerful programming language. This credential demonstrates the Developer's
expertise in building database centric Internet applications for both Oracle 9i and Database 10g. It is also the first step toward becoming an Oracle Forms Developer Certified Professional.
Included with this training program:
- Interactive Multi-Media Training with Audio Track
- Training Time: Over 40 hours
- Practice simulated lab exercises
- Interactive Review questions
- Practice Exam questions
- Available in CD-ROM or Online formats
- Co-developed training with Oracle. Guarantees that your training will cover 100% of the certification's exam objectives.
- Includes both the Oracle 10G: Program with PL/SQL Training (Exam 1Z0-147) and Oracle 10G Program with SQL (Exam 1Z0-007)
Live Oracle 7 Day Boot Camp
|
CD-ROM Oracle 10G Certification Training Course OCA for Developer
|
norc10gcd
|
$399.00
|
|
|
Online Oracle 10G Certification Training Course with Global Mentoring OCA for Developer
One Year Access
|
norc10gon
|
$399.00
|
|
Oracle Developer 10g training with SQL Course
Training Course Overview
In this course, learners will be introduced to the concepts of relational databases and the Oracle Database 10g database technology. Additionally, the learners will be introduced to the powerful SQL programming language and its features. Learn how to use the
advanced features of SQL, such as advanced querying and reporting, schema objects, manipulating large data sets, and storing and retrieving dates
according to different time zones. The learner will also learn the concepts of controlling access and privileges for schema objects and using advanced
subqueries.This training course will show you how to write and use anonymous PL/SQL blocks, program constructs, simple and composite
PL/SQL data types, programming guidelines, and accessing and manipulating data using PL/SQL. Additionally, the learner will also learn how to write and
use PL/SQL program units, such as stored functions, stored procedures, and packages along with some standard Oracle supplied packages and exception handling techniques in PL/SQL
Learn To
- Match the different phases of system development life cycle (SDLC) with their features.
- Features of an Entity Relationship (ER) model training.
- Identify features of Relational Database Management System (RDBMS) training.
- SQL statement to retrieve data from tables.
- Identify arithmetic expressions used to perform operations on data.
- IOperators used to format results in SQL statements.
- Identify features of single-row functions.
- Match the character functions with their uses.
- Match the number functions with their purpose.
- Identify the use of natural joins to retrieve data from multiple tables.
- Use of an equijoin to retrieve data from multiple tables.
- Use of self-join to retrieve data from a table.
- Identify the code for using the INSERT statement training.
- Code for using the UPDATE statement.
- Code for using the DELETE statement.
- Identify tasks to be performed for granting system privileges.
- Tasks to be performed for granting object privileges.
- Syntax for performing various tasks for maintaining columns.
- Identify the code for retrieving data hierarchically from a table.
- Code for formatting hierarchical reports.
- Identify features of regular expression functions.
Oracle Database 10g Programming training with PL/SQL Course
Course Overview
In this course, the learner will get familiar with the procedural language to access Oracle database. The learner will learn how to write and use anonymous PL/SQL blocks, program constructs, simple and composite
PL/SQL data types, programming guidelines, and accessing and manipulating data using PL/SQL. Additionally, the learner will also learn how to write and use PL/SQL program units, such as stored functions,
stored procedures, and packages along with some standard Oracle supplied packages and exception handling techniques in PL/SQL. Students will learn to create anonymous PL/SQL blocks. They learn to declare
variables and trapping exceptions, develop stored procedures, functions, packages and database triggers. Learn to manage PL/SQL program units manage dependencies, manipulate large objects, and use some of
the Oracle-supplied packages. You will also learn about the compilation tools and their options.
Learn To
- Identify features of PL/SQL.
- Identify features of PL/SQL blocks.
- Ieatures of PL/SQL blocks within a subprogram.
- Match types of PL/SQL named blocks with their descriptions training.
- Match types of PL/SQL environments with their descriptions.
- Identify features of PL/SQL packages.
- Sequence steps for developing PL/SQL packages.
- Identify the syntax for creating a PL/SQL package.
- Features of triggers.
- Code to create a Data Manipulation Language (DML) trigger training.
- Code to create a Data Manipulation Language (DML) row trigger.
- Match the stages in the execution of SQL statements with their descriptions.
- Identify features of dynamic SQL training.
- IFeatures of the DBMS_SQL package.
- Guidelines for standardizing constants and exceptions.
- Identify benefits of using local subprograms.
- Sort the characteristics of the rights models according to their category.
- Identify features of native compilation.
- Settings to be specified for native compilation training.
- Sequence the steps to enable native compilation of PL/SQL code.
|
