Oracle 10G Certification Training for OCP Certified Professional Database Administrator DBA
 Netwind Learning center offers one of the most extensive lines of
training course curriculums for Oracle 10G certification training. 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. Our 10G Certification Course covers the requirements for both the OCA and OCP (Oracle Certified Professional and Associate) for database administrator.
Oracle DBAs manage the industry's most advanced information systems and command some of the highest salaries. This credential is your first step toward success as an OCP and demonstrates your
firm foundation in the basic administration of the Database.
To earn an OCA certification credential, candidates must pass a computer-based examination based upon content related to the skillset and job role of an entry-level database administrator operating Database 10g.
The exam is taken in a proctored environment.
Certification Training Tracks for Certified Professional DBA
- Administrator Certified Associate (OCA): A single exam -- Database: Administration Workshop I (1Z0-042) -- is all that's required to get started down this track.
- Database Administrator Certified Professional (OCP): Candidates must first earn OCA status, but need only take one more exam -- (Oracle Database 10g: Administration Workshop II (1Z0-043) -- and
meet online training requirements to qualify for this credential.
- Database Administrator Certified Master (OCM): Candidates must first earn OCP status, complete two online training courses, and pass an intensive two-day hands-on exam to qualify for this premier credential.
- What's interesting about the new slate of certifications for 10g is that the number of exams required is substantially reduced. OCAs for 9i had to take two exams; for 10g, they need only one. Certified
professional's requirements are likewise reduced (and because OCP is required for OCM, it too requires fewer exams overall). It's rare that programs cut back on requirements, but Oracle's apparent
belief is that the new version requires less training and testing to certify competency than did previous versions.
- ****Students can do the 9i OCP DBA Courses with the upgrade course 10g: New Features for
Administrators: 1Z0-040 as alternative training
Our Course includes
- Training for both the Certified Associate (OCA) and Professional (OCP) for Database Administrator,Oracle 10G Database: Administration Workshop 1 Training (Certification Exam 1Z0-042)
and Oracle 10G Database: Administration Workshop 2 Training (Exam 1Z0-043)
- Complete course material in interactive multi-media format with audio track
- Simulates Lab Exercises
- Review Questions to test ones skills
- Practice Exam Quizzers for preparation of the Certification Exams
- Course Time over 50 hours
- Training available CD-ROM based Training or Online Version. Online training access is for one year.
Live Oracle 7 Day Boot Camp
|
CD-ROM Oracle 10G DBA OCA/OCP Course
Workshop I & II
|
norc10gcd
|
$499.00
|
|
|
Online Oracle 10G DBA OCA/OCP Course
Workshop I & II One Year Access
|
norc10gon
|
$499.00
|
|
|
CD-ROM Oracle OCP Course Administration Workshop II Only
|
n67210DCD
|
$349.00
|
|
|
Online Oracle OCP Course Administration Workshop II Only One Year Access
|
n67210DON
|
$349.00
|
|
|
Oracle Application Server 10g Administration Workshop 1 Covers the following
Audience
Data Administrators, Technical consultants Support Engineers, and Sales Consultants.
Training Time
16 Hours
 Course Overview
Workshop I is the first database designed for enterprise grid computing, the most flexible and cost-effective way to manage enterprise information.
This course covers salient aspects of Oracle 10g such as user and data management. The basic aspects of database management such as database integrity constraints, transferring data, and defining tables and
schemas has been discussed at length. Attention has been paid to DML and also to PL/SQL code, which is Oracle's proprietary fourth generation programming language that enables applications to interact over different
operating systems and hardware platforms. Also covered are Database security, Listener and Services and database architecture.
Participants will learn
- Identify tasks .
- Match the different types of integrity constraints with their features.
- Identify features of a Relational Database Management System (RDBMS).
- Match data types in 10g with their features.
- Identify rules for naming database objects.
- Features of schemas.
- Options used to grant privileges to a user.
- Identify options you can configure when creating a user.
- Features of database user accounts and profiles in 10g.
- Guidelines for restricting dictionary and directory access.
- Identify advantages of revoking unnecessary privileges from the user group PUBLIC.
- Security practices and principles that are implemented .
- Identify key concepts of tuning instance recovery.
- Features of instance recovery.
- Match database failures with their possible causes.
- Identify undo management tasks that a DBA should perform to use Undo efficiently.
- Identify features of undo segments.
- Benefits of undo data.
Course Outline
- Match the different types of integrity constraints with their features.
- Identify the steps to install 10g using Oracle Universal Installer (OUI).
- Relational Database Management System (RDBMS).
- Identify tasks.
- Prerequisites for installing the software.
- Steps to create a database using the Database Configuration Assistant (DBCA).
- Tablespace structure.
- Identify features of memory structures associated with an Oracle instance.
- Match background processes in Oracle with their functions.
- Identify uses of Database Control.
- Tools that enable you to interact with an database using SQL.
- Features of SQL*Plus and iSQL* Plus.
- Uses of SQL statements.
- Features of a PL/SQL block.
- Features of APIs.
- Identify features of Database Control. x
- Database Control.
- Identify database management tasks that can be performed by using the Database home page.
- Identify features of tablespaces.
- Sequence the steps to create a tablespace. x
- Sequence the steps to create a tablespace.
- Identify features of storage allocation in locally managed tablespaces.
- Identify properties of tablespaces that can be altered using the Enterprise Manager (EM).
- Identify the actions that can be performed on a tablespace by using the Tablespaces page of the Enterprise Manager (EM).
- Identify features of Optimal Flexible Architecture (OFA).
- Match the files that constitute an Oracle database with their descriptionsIdentify features of database user accounts and profiles in Oracle Database 10g.
- Options you can configure when creating a user.
- Options used to grant privileges to a user.
- Identify features of quotas assigned to users.
- Features of roles assigned to users.
- Identify features of schemas.
- Identify rules for naming database objects.
- Match data types .
- Options for creating and modifying a table.
- Data integrity constraints used to impose restrictions on data stored in columns.
- Actions that you can perform on a table using Enterprise Manager.
- Identify features of views.
- Features of sequences.
- Identify features of SQL statements used in data manipulation.
- Identify tasks for exporting data using the Data Pump utility.
- Identify features of data import using the Data Pump utility.
- SQL*loader.
- SQL* Loader control files.
- SQL*Loader data files.
- Distinguish between the direct and conventional path loads.
- Identify features of PL/SQL.
- PL/SQL objects.
- Security practices and principles that are implemented.
- Identify advantages of revoking unnecessary privileges from the user group PUBLIC.
- Restricting dictionary and directory access.
- Identify guidelines for restricting administrative privileges and remote authentication for users.
- Match the parameters used for implementing password security with their features.
- Identify options to create a password profile and assign it to a user by using the Enterprise Manager (EM).
- Differentiate between the auditing types .
- Match the dictionary views for standard database auditing with their descriptions.
- Identify features of FGA policy.
- Identify guidelines for creating a new Fine-grained Auditing (FGA) policy.
- Match Fine-Grained Auditing (FGA) dictionary views with their contents.
- Oracle Net services and listeners.
- Identify options to create, configure, and register an Oracle listener.
- Identify features of the Listener control utility.
- Match the name resolution methods used by Oracle Net with their descriptions.
- Advanced connection options.
- Oracle Net Manager.
- Identify activities involved in establishing a user session that uses a dedicated server process.
- Sequence the steps to process a request using shared servers.
- Match the different initialization parameters used to configure Oracle Shared Server with their usage.
- Match the data dictionary views related to shared servers with their descriptions.
- Match the different performance monitoring types with their features.
- Features of data dictionary metrics.
- Identify features of optimizer statistics.
- Features of dynamic performance views.
- Identify options for viewing metrics and performance information by using Enterprise Manager (EM).
- Identify features of server generated alerts and thresholds.
- Identify the steps to create and apply a baseline.
- Match the tuning and diagnostic advisors with their descriptions.
- Identify features of the Automatic Workload Repository (AWR).
- Features of Automatic Database Diagnostics Monitor (ADDM).
- Benefits of undo data.
- Features of undo segments.
- Identify undo management tasks that a DBA should perform to use Undo efficiently.
- Features of undo retention.
- Identify the options that you can configure to size the undo tablespace.
- Identify features of locks.
- Features of lock conflicts.
- Match database failures with their possible causes.
- Features of instance recovery.
- Identify key concepts of tuning instance recovery.
- Steps that are required for configuring a database to ARCHIVELOG mode.
- Tasks you should perform to configure a database for maximum recoverability.
- Features of backups.
- Identify features of Recovery Manager (RMAN).
- Ooptions used to configure backup settings.
- Options that you can specify when scheduling backups.
- Identify features of control file trace backups.
- Options for managing existing backups.
- Features of database startup statuses for recovery.
- Identify the steps to recover from the loss of a single control file.
- Identify the steps to recover from loss of redo files.
- Steps involved in recovering from the loss of a data file.
- Enhancements for recovering dropped objects without performing recovery on the database.
|
