|
Oracle Database 10g Administrator Certified Professional
(3228508) |
|
Return to Search Results | Request More Information | View Comments | Recommend this Course | Purchase Course |
 |
Summary:
This set is comprised of 10 courses:
Oracle Database 10g: Monitoring and Managing Memory and the Database
Oracle Database 10g: Monitoring and Managing Performance and Storage
Oracle Database 10g: Getting Started
Oracle Database 10g: Managing Logical and Physical Structure
Oracle Database 10g: Backing Up, Restoring, and Recovering Data
Oracle Database 10g: Managing Users, Security, and System Performance
Oracle Database 10g: Using RMAN
Oracle Database 10g: Loading, Unloading, and Managing Undo Data
Oracle Database 10g: Automation and Globalization
Oracle Database 10g: Performing Backups, and Restore and Recovery Operations |
|
Course Offered By:
Element K
500 Canal View Boulevard
Rochester, New York 14623
Phone: 585-240-7500
Courses by this Learning Provider |
|
 | | Over the past 25 years, Element K has been committed to helping the world's most prestigious companies improve their business with learning and development. |
|
|
|
Course Cost:
$599.00 (Purchase Course)
|
Promotions:
We offer 15% discount to Dice Learning members. Please add coupon code DICESPECIAL15 to your checkout on this site.
Purchase any Element K web-based course and get one month FREE Dice Advantage service with your first purchase. A $29 value! Contact us for details.
|
Course Duration:
43 Hours, 26 Minutes
|
Course Type:
Self Paced
|
|
|
Description:
The following 10 courses are included:
Oracle Database 10g: Monitoring and Managing Memory and the Database
Description:
In this course, you will monitor and manage memory and database use in Oracle Database 10g. Properly managing and keeping track of these crucial components helps to eliminate performance bottlenecks and database downtime.
Objectives:
In this course, you will monitor and manage memory and database use, and improve listener process security.
Duration: 1 Hours, 39 Minutes
Oracle Database 10g: Monitoring and Managing Performance and Storage
Description:
In this course, you will manage and monitor database performance using a variety of utilities that manage resources, analyze database objects, and monitor space usage and consumption.
Objectives:
In this course, you will monitor and manage database storage and performance.
Duration: 2 Hours, 9 Minutes
Oracle Database 10g: Getting Started
Description:
In this course, you will gain knowledge of Oracle Database 10g installation techniques. You will also examine how to create a database and identify how to properly configure network connectivity through Oracle Net services. You will then examine how to interact with the system and make complex queries and modifications to databases using SQL and PL/SQL.
Objectives:
In this course, you will determine server requirements for your network system to help you plan your network. You will then examine installation features and performance capabilities, as well as instance configuration. You will identify file types, object types, and database processes. You will also describe the user connection process and resources available to the DBA. You will then follow the necessary steps to create a database and configure Oracle Net Services in order to allow users to connect to your database. Finally, you will use SQL and PL/SQL to interact with the data contained within the database.
Duration: 7 Hours, 31 Minutes
Oracle Database 10g: Managing Logical and Physical Structure
Description:
This course provides students with the skills to perform key administrative tasks in Oracle Database 10g. These tasks include managing database objects such as tablespaces, tables, views, indexes, datafiles, and more.
Objectives:
In this course, you will perform key administrative tasks in Oracle Database 10g. These tasks include managing database objects such as tablespaces, tables, views, indexes, datafiles, and more.
Duration: 5 Hours, 11 Minutes
Oracle Database 10g: Backing Up, Restoring, and Recovering Data
Description:
In this course, you will back up, restore, and recover database data, which can be lost due to a variety of circumstances. You will use Oracle Flashback technology to recover database components and entire databases, and perform incomplete recovery of specific database components using specialized methods and utilities.
Objectives:
In this course, you will backup, restore, and recover database data.
Duration: 2 Hours, 52 Minutes
Oracle Database 10g: Managing Users, Security, and System Performance
Description:
Proper management of user accounts is a key part of securing your database. The DBA needs to be able to identify, restrict, and audit user activity to make sure that all user actions are appropriate and not threatening the security of your system. Oracle has several features that enable database administrators to manage the performance of their system. By monitoring how the system is operating, a database administrator will be ready to make any necessary adjustments to ensure optimal performance. In this course, you will manage users and security by working with user accounts, privileges, roles, passwords, resource limits, and the audit trail and use these tools to monitor the performance of databases.
Objectives:
In this course, you will manage users and security by working with user accounts, privileges, roles, passwords, resource limits, the audit trail and you will use these tools to monitor the performance of databases.
Duration: 6 Hours, 44 Minutes
Oracle Database 10g: Using RMAN
Description:
Oracle's Recovery Manager (RMAN) comprises a powerful suite of tools that can be used to expedite and simplify the tasks necessary to back up, restore, and recover an Oracle database and its objects. In this course, you will learn about RMAN, how to configure it to best suit your database environment, and how to perform RMAN back-up and recovery operations.
Objectives:
In this course, you will configure the Recovery Manager (RMAN), and then use RMAN to perform back-up and recovery operations on a database.
Duration: 3 Hours, 26 Minutes
Oracle Database 10g: Loading, Unloading, and Managing Undo Data
Description:
In this course, you will use several features in Oracle Database 10g that enable the DBA to quickly move data from one location to another. You will also examine how the DBA can quickly recover data if a failure occurs, such as a statement failure or session failure, and how to manage and size the unique tablespace that is dedicated to this type of recovery.
Objectives:
In this course, you will In this course, you will use utilities to load data into and unload data from a database. You will also manage undo data.
Duration: 6 Hours, 44 Minutes
Oracle Database 10g: Automation and Globalization
Description:
Oracle includes utilities and parameters to aid in automating administrative tasks and in customizing the database environment to suit multiple locales and languages. In this course, you will use the Oracle Scheduler and Automatic Storage Management utilities to automate data storage and scheduling tasks, and set Oracle's globalization parameters to customize the environment to different locations.
Objectives:
In this course, you will customize globalization parameters to suit different locales, and use the Oracle Scheduler and Automatic Storage Management features to automate administrative and storage tasks.
Duration: 3 Hours, 54 Minutes
Oracle Database 10g: Performing Backups, and Restore and Recovery Operations
Description:
In this course, you will manage the online redo log and control files, and perform user- and server-managed backups. You will also examine different recovery methods and tune these methods to meet your specific system requirements
Objectives:
In this course, you will describe the purpose of redo log files, redo log groups, and control files, and perform backups. You will also perform recovery operations.
Duration: 3 Hours, 16 Minutes
|
|
Applicable Vendor Technologies:
Oracle
|
|
Associated Disciplines:
Databases
|
|
RECOMMEND THIS COURSE
You must be logged in as a Candidate to recommend courses
|
|
|
|
|
|
|
|
|
 |
Related Certification Test Prep |
|
 |
 |
|
|
|
|
