Oracle 10G OCA Certified Associate DBA Certification Training Courses
 Netwind Learning Center certification training course for Oracle 10G OCA will prepare you for the growing demand for Oracle technical professionals.
Experienced or new to the profession, you need to know what skills make you more attractive to employers. Employers are looking for individuals with a solid
foundation of skills needed for effective performance. Netwind Learning Center's training course on Oracle 10g will provide the necessary knowledge base so you can begin building your foundation with Oracle 10g.
Oracle DBAs manage the industry's most advanced information systems and command some of the highest salaries. An Oracle Certified Associate (OCA)
demonstrates a solid foundation of skills for an apprentice or entry-level job role. By earning your OCA you greatly improve your opportunities to achieving your
goals. The Oracle Certified Associate is the first step to becoming an OCP. It's designed to provide a foundation in Oracle Database 10g.
By earning your Oracle Certification from Netwind Learning Center you will be one step closer to gaining access to better career opportunities.
Our Course includes
- Training for the Certified Associate for Database Administrator, Oracle 10G Database: Administration Workshop 1 Training (Certification Exam 1Z0-042)
- 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 16 hours
- Training available CD-ROM based Training or Online Version- same training as the CD-ROM based course.Online training access is for one year 24 x 7.
|
CD-ROM Oracle 10G DBA OCA Certification Training
Workshop 1
|
n67110DC
|
$299.00
|
|
|
Online Oracle 10G DBA OCA Certification Training
Workshop I One Year Access
|
n67110ON
|
$299.00
|
|
Oracle Application Server 10g Administration Workshop 1 DBA OCA Certi fication
Audience
Data Administrators, Technical consultants Support Engineers, and Sales Consultants.
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.
- Options you can configure when creating a user.
- Features of database user accounts and profiles in 10g.
- Guidelines for restricting dictionary and directory access.
- Advantages of revoking unnecessary privileges from the user group PUBLIC.
- Identify security practices and principles that are implemented .
- 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.
- Features of undo segments.
- Identify benefits of undo data.
Course Outline
- Match the different types of integrity constraints with their features.
- The steps to install 10g using Oracle Universal Installer (OUI).
- Identify features of a Relational Database Management System (RDBMS).
- Tasks.
- Prerequisites for installing the 10g software.
- Steps to create a database using the Database Configuration Assistant (DBCA).
- Identify features of a tablespace structure in 10g.
- Features of memory structures associated with an Oracle instance.
- Match background processes in Oracle with their functions.
- Uses of Database Control.
- Identify features of tools that enable you to interact with an database using SQL.
- SQL*Plus and iSQL* Plus.
- SQL statements.
- Identify features of a PL/SQL block.
- Features of APIs.
- Features of Database Control. x
- Identify features of Database Control.
- Identify database management tasks that can be performed by using the Database home page.
- 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.
- 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.
- Identify options used to grant privileges to a user.
- Features of quotas assigned to users.
- The 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.
- Identify actions that you can perform on a table using Enterprise Manager.
- Features of views.
- Identify features of sequences.
- Features of SQL statements used in data manipulation.
- Identify tasks for exporting data using the Data Pump utility.
- Sata import using the Data Pump utility.
- SQL*loader.
- Identify features of SQL* Loader control files.
- Features of SQL*Loader data files.
- Distinguish between the direct and conventional path loads.
- Features of PL/SQL.
- Identify features of PL/SQL objects.
- Identify security practices and principles that are implemented.
- Advantages of revoking unnecessary privileges from the user group PUBLIC.
- Guidelines for 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.
- 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.
- Features of 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.
- Identify features of advanced connection options.
- Features of 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.
- 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).
- 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).
- Identify features of Automatic Database Diagnostics Monitor (ADDM).
- Benefits of undo data.
- Identify features of undo segments.
- Undo management tasks that a DBA should perform to use Undo efficiently.
- Identify features of undo retention.
- 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.
- Identify features of instance recovery.
- Key concepts of tuning instance recovery.
- Identify the steps that are required for configuring a database to ARCHIVELOG mode.
- Identify tasks you should perform to configure a database for maximum recoverability.
- Features of backups.
- Identify features of Recovery Manager (RMAN).
- Options used to configure backup settings.
- Identify options that you can specify when scheduling backups.
- Features of control file trace backups.
- Options for managing existing backups.
- Identify features of database startup statuses for recovery.
- Steps to recover from the loss of a single control file.
- Steps to recover from loss of redo files.
- Identify steps involved in recovering from the loss of a data file.
- Identify enhancements for recovering dropped objects without performing recovery on the database.
|
