Oracle 9i Developer OCA Oracle Certified Associate
 Netwind Learning center offers one of the most extensive lines of
training courses for Oracle Database 9i. 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 Oracle 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 Oracle Database 10g. It is also the first step toward becoming an Oracle Forms Developer Certified Professional. Course required: Oracle Database 9i:
Introduction to SQL Exam 1Z0-007 and Oracle Database 9i: Program with PL/SQL Exam 1Z0-147
Oracle 9i Certification Certified Associate Track
Included with this training program:
- Interactive Multi-Media Training with Audio Track
- Practice simulated lab exercises
- Training Time: Over 30 hours of training
- 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 Training for the Oracle SQL and PL/SQL Exams
- This series is targeted at application developers and Oracle support engineers. This series targets Oracle Application Developers, Application Programmers, and IT staff interested in building form based
internet applications.
Live Oracle 7 Day Boot Camp
|
CD-ROM Oracle 9i Developer OCA Oracle Certified Associate
|
norc9gca
|
$399.00
|
|
|
Online Oracle 9i Developer OCA Oracle Certified Associate
One Year Access
|
norc9gon
|
$399.00
|
|
Oracle 9i OCA Certification SQL PL/SQL Training Contains the Following
Oracle Training 9i SQL: Basic SELECT Statements Training
 This training course covers relational database principles and Oracle
concepts; writing basic SQL statements; restricting and sorting data; and using single-row functions. Additionally, this course provides an introduction to relational database concepts and the use of SQL for
storing, retrieving, and manipulating data in a relational database.
Learn To
- Identify the components of the relational model.
- Match the structural elements of a relational database table with their descriptions.
- Sequence the phases of the system development life cycle training.
- Match the types of SQL statements with their descriptions.
- Match the capabilities of SQL SELECT statements with their functions.
- Identify the guidelines for constructing basic SQL SELECT statement.
- Write a query that restricts rows returned by using the WHERE clause.
- Write a WHERE clause to accommodate different datatypes.
- Use comparison operators with the WHERE clause.
- Identify the different categories of datatypes.
- Match the character datatypes with their descriptions.
- Train to Identify the features of the NUMBER datatype.
Data Retrieval Techniques Training
This course covers joins, group functions, subqueries, and the iSQL*Plus report variables. Additionally, this course shows students how to access data from multiple table using joins, aggregate data using group
functions, create subqueries, and use iSQL*Plus commands to create customized queries.
Learn To
- Train to Identify the four Oracle join types used to display data from more than one table.
- Identify a Cartesian product.
- Retrieve rows from two tables by using an equijoin.
- Identify the features of a group function.
- Write SQL statements that contain common group functions.
- Manage null values when using group functions in a SQL statement.
- Identify the requirements for using subqueries.
- Identify the characteristics of each subquery type.
- Write a single-row subquery to return one row in the WHERE clause of a SELECT statement.
- Identify the characteristics of substitution variables.
- Prompt the user for a number value at run time by using a substitution variable.
- Prompt the user for a character value at run time by using a substitution variable.
DML and DDL Training
The Oracle SQL DML and DDL course is the third in a three-part series covering the Data Manipulation and Data Definition language statements supported by Oracle9i. This course introduces the participants to various
objects in a database. The participants learn to create, update, and delete the database objects. The participants also learn to add rows, update, and delete existing rows from a table. The course also explains
the use of external tables and how to create the external tables.
Learn To
- Identify the data structures in an Oracle server
- Identify the rules for naming tables in a database.
- Identify the DML and transaction control statements.
- Insert rows in a table by using the INSERT statement.
- Add a column to a table in an Oracle database.
- Change the table structure by modifying the characteristics of an existing column.
- Identify the features of an Oracle sequence.
- Create a sequence by using the CREATE SEQUENCE statement.
- Identify the properties of views.
- Match the clauses of the CREATE VIEW statement with their functions.
- Create a public synonym by using the CREATE PUBLIC SYNONYM statement.
- Remove a synonym by using the DROP PUBLIC SYNONYM statement.
- Identify the features of Oracle database security.
- Create users in an Oracle database.
- Match the types of multitable INSERT statements with their uses.
- Insert rows into multiple tables by using the INSERT INTO statement unconditionally.
Basics Training
Learn To
- Identify the features of PL/SQL.
- Identify the benefits of PL/SQL.
- Select the actions by which a PL/SQL engine processes a block of code.
- Identify the functions of PL/SQL variables.
- Identify the guidelines for declaring PL/SQL variables.
- Match the PL/SQL datatypes with their descriptions.
- Retrieve data from a table by using the SELECT statement.
- Identify the conditions in which various SELECT exceptions are raised.
- Write the code to add rows to a table by using the INSERT statement.
- Write PL/SQL code using the IF-THEN-ELSE statement.
- Write PL/SQL code using the IF-THEN-ELSIF statement.
- Write PL/SQL code using the CASE expression.
- Declare a PL/SQL record by using the RECORD datatype.
- Reference a PL/SQL record by using the dot notation.
- Declare PL/SQL records with %ROWTYPE.
- Identify the declaration methods of cursors, both implicit and explicit.
- Sequence the steps for controlling explicit cursors.
- Write the code to declare a cursor by using the CURSOR statement.
- Match the types of exceptions with their properties.
- Match some common predefined Oracle server exceptions with their descriptions.
- Identify the guidelines to trap exceptions.
Total Learning Time
6 to 8 hours
Procedures Functions and Packages Training
Course Overview
This course introduces users to the basics of PL/SQL subprograms. Users will learn how to build and invoke
procedures and functions. This course also covers debugging PL/SQL subprograms using Procedure Builder. Additionally, users will learn how to trap and handle errors in a PL/SQL block. This course also covers the
basics of packages and how to create and use them.
Learn To
- Match the various sections of a subprogram with their contents.
- Identify the benefits of the PL/SQL subprograms.
- Identify the features of the development environments.
- Identify the features of a function.
- Match the clauses of the CREATE FUNCTION statement with their descriptions.
- Create a function by using iSQL*Plus.
- Identify the features of packages.
- Identify the features of package components.
- Identify the advantages of using packages.
- Identify the features of overloaded subprograms.
- Overload a procedure by using iSQL*Plus.
Identify the guidelines that you follow to call private procedures within a package.
Total Learning Time
6 to 8 hours
Database Programming
Course Overview
This course discusses the features of stored subprograms and packages. Participants will learn how to create
and invoke stored procedures and functions as well as how to create stored packages. This course also discusses built-in server-side packages and their use in debugging stored subprograms. Participants will learn
how to manage stored subprograms and packages. This course also introduces participants to database triggers: how to create them and their application to complement the capabilities of the Oracle base product.
Learn To
- Sequence the steps used to create stored subprograms by using iSQL*Plus.
- Identify the effects of storing code separately on the server and on the client.
- Perform the steps needed to create a stored procedure using iSQL*Plus.
- Match the Oracle server supplied packages with their uses.
- Identify the correct combinations of DBMS_PIPE subprograms and their uses.
- Identify the uses of the DBMS_DDL package.
- Identify the guidelines for using privileges that are related to a stored subprogram.
- Grant privileges on a stored subprogram by using SQL commands.
- Match the facilities available to manage stored subprograms with their application.
- Match the components of a database trigger with their descriptions. \
- Identify the guidelines for designing triggers.
- Create a statement
- level database trigger by using iSQL*Plus.
Total Learning Time
6 to 8 hours
|
