Oracle 10G Developer Training OCA Oracle Certified Associate Course Online
This course is part of our Oracle KnowledgeCenter
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 Course
 Interactive Multi-Media Training
Training Time: Over 40 hours
Practice simulated lab exercises
Interactive Review questions
Practice Exam questions
Co-developed training with Oracle. Guarantees that your training will cover 100% of the certification's exam objectives.
Live Oracle 7 Day Boot Camp
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.
|
