Oracle 9i DBA Certification Training
 Our 9i DBA with 10G Upgrade training includes
- DBA Oracle Certified Associate (OCA)
- DBA Oracle Certified Professional (OCP)
- Oracle Associate for Developer (OCA)
- Complete course material in interactive format.
- Simulates Lab Exercises
- Review Questions to test ones skills
- Practice Exam Quizzers for preparation of the Certification Exams
- Includes the following courses:
Introduction to Oracle Certification 9i - SQL Training Curriculum (Exam 1Z0-007 & Exam 1Z0-001)
Database Administration: Oracle Certification Fundamentals I Curriculum (Exam 1Z0-031)
Database Administration: Oracle Certification Fundamentals II Curriculum (Exam 1Z0-032)
Oracle Certification 9i Training Performance Tuning (Exam 1Z0-033)
Upgrade Course to 10G
We now offer our training in two formats:
- CD-ROM based
- Online Version- same training as the CD-ROM. Online training access is for one year 24 x 7.
|
CD-ROM Complete Oracle Certification 9i Course
|
n61131d
|
$499.00
|
|
|
Online Complete Oracle Certification 9i Course
One Year Access
|
n61131do
|
$499.00
|
|
Live Boot Camp Certification Classes 10G
Oracle 9i DBA SQL Training Course contains the following
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
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
The Oracle SQL DML and DDL certification course is the third in a three-part training 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.
PL/SQL: Basics
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.
PL/SQL: Procedures Functions and Packages
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.
PL/SQL: 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.
|
