Oracle 10G OCA Certified Associate DBA Certification Training Courses
 The demand for Oracle technical professionals is growing fast. 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 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 both the Certified Associate (OCA) and Professional (OCP) 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 but includes global mentoring. Global mentoring allows you access online to ask question to trainers 24 x 7. Online training access is for one year.
|
Oracle 10G DBA OCA Certification Training
|
n67110D
|
$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.
- Identify features of schemas.
- Identify options used to grant privileges to a user.
- Identify options you can configure when creating a user.
- Identify features of database user accounts and profiles in 10g.
- Identify guidelines for restricting dictionary and directory access.
- Identify advantages of revoking unnecessary privileges from the user group PUBLIC.
- Identify security practices and principles that are implemented .
- Identify key concepts of tuning instance recovery.
- Identify 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.
- Identify 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).
Identify features of a Relational Database Management System (RDBMS).
Identify tasks.
Identify prerequisites for installing the 10g software.
Identify the steps to create a database using the Database Configuration Assistant (DBCA).
Identify features of a tablespace structure in 10g.
Identify features of memory structures associated with an Oracle instance.
Match background processes in Oracle with their functions.
Identify uses of Database Control.
Identify features of tools that enable you to interact with an database using SQL.
Identify features of SQL*Plus and iSQL* Plus.
Identify the uses of SQL statements.
Identify features of a PL/SQL block.
Identify features of APIs.
Identify features of Database Control. x
Identify features of 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.
Identify options you can configure when creating a user.
Identify options used to grant privileges to a user.
Identify features of quotas assigned to users.
Identify the features of roles assigned to users.
Identify features of schemas.
Identify rules for naming database objects.
Match data types .
Identify options for creating and modifying a table.
Identify data integrity constraints used to impose restrictions on data stored in columns.
Identify actions that you can perform on a table using Enterprise Manager.
Identify features of views.
Identify 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.
Identify features of SQL*loader.
Identify features of SQL* Loader control files.
Identify features of SQL*Loader data files.
Distinguish between the direct and conventional path loads.
Identify features of PL/SQL.
Identify features of PL/SQL objects. .
Identify security practices and principles that are implemented.
Identify advantages of revoking unnecessary privileges from the user group PUBLIC.
Identify 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.
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.
Identify 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.
Identify 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.
Match the data dictionary views related to shared servers with their descriptions.
Match the different performance monitoring types with their features.
Identify features of data dictionary metrics.
Identify features of optimizer statistics.
Identify 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).
Identify features of Automatic Database Diagnostics Monitor (ADDM).
Identify benefits of undo data.
Identify features of undo segments.
Identify undo management tasks that a DBA should perform to use Undo efficiently.
Identify features of undo retention.
Identify the options that you can configure to size the undo tablespace.
Identify features of locks.
Identify features of lock conflicts.
2 | Unit 2: Backup and Recovery
Match database failures with their possible causes.
Identify features of instance recovery.
Identify 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.
Identify features of backups.
Identify features of Recovery Manager (RMAN).
Identify options used to configure backup settings.
Identify options that you can specify when scheduling backups.
Identify features of control file trace backups.
Identify options for managing existing backups.
Identify 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.
Identify steps involved in recovering from the loss of a data file.
Identify enhancements for recovering dropped objects without performing recovery on the database.
|
