Back To Oracle Training Courses

Oracle 9i DBA Certification Training CBT

Price: $499.00

CBT Course Overview:

This powerful relational database management system (RDBMS) features a high-security Internet platform for managing enterprise applications, web sites, Java programs, multimedia content and Internet files.

With this Oracle9i DBA certification training you will learn the skills and knowledge to effectively design and manage an Oracle9i database management system. These specialized skills will open the door to challenging and lucrative job opportunities, as well as financial rewards.

Total Training Duration:

30 hours

CBT Course Modules:

• Introduction to Oracle9i: SQL CBT Training Exam 1Z1-007
• Oracle9i Database: Fundamentals I CBT Training Exam 1Z1-031
• Oracle9i Database: Fundamentals II CBT Training Exam 1Z1-032
• Oracle9i Database: Performance Tuning CBT Training Exam 1Z1-033

Training Course Topics:

• Learn 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.
• Match the types of SQL statements with their descriptions.
• Match the capabilities of SQL SELECT statements with their functions.
• Learn 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.
• Learn the different categories of datatypes.
• Match the character datatypes with their descriptions.
• Learn the features of the NUMBER datatype.
• Learn the four Oracle join types used to display data from more than one table.
• Learn a Cartesian product.
• Retrieve rows from two tables by using an equijoin.
• Learn 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.
• Learn the requirements for using subqueries.
• Learn the data structures in an Oracle server.
• Learn the memory structures of the SGA and the information stored in the database and nondatabase files.
• Learn the connection procedures and the processes generated during database connection.
• Learn the stages in processing a query and the memory structures used in query processing.
• Learn the steps of DML processing and the memory structures involved in DML processing.
• Learn the uses of SCN and the features of a process commit.
• Learn the tasks of a DBA and the Oracle Enterprise Manager tools used by a DBA.
• Learn the OEM console components, steps to set up these components, and the functions of the OEM DBA tools.
• Learn the default DBA user accounts and set up authentication methods to validate users.
• Discuss the guidelines for creating an OFA structure and the information in the ORACLE_HOME subdirectories.
• Learn the requirements and factors considered while creating a database, the guidelines for planning the physical database design, the registry entries that must be specified for proper database functionality, and create a password file.
• Learn the types of parameter files, create a parameter file by editing settings in the init.ora file, and start an instance in the NOMOUNT mode.
• Learn the factors to consider when defining a backup and recovery strategy.
• Multiplex control files by copying them with an operating system utility.
• Place a log member from two log groups in a specific directory.
• Learn the implications of operating an Oracle database in NOARCHIVELOG mode.
• Change the state of an archiving location using the Enterprise Manager Console.
• Learn the files to be restored for a database in the NOARCHIVELOG mode.
• Store the archived logs in a new location using the ALTER SYSTEM command.
• Perform a offline database recovery.
• Much more.