|
Oracle Database 10g Administrator Certified Associate
(3228507) |
|
Return to Search Results | Request More Information | View Comments | Recommend this Course | Purchase Course |
 |
Summary: This set is comprised of 5 courses: Oracle Database 10g: Getting Started Oracle Database 10g: Managing Logical and Physical Structure Oracle Database 10g: Managing Users, Security, and System Performance Oracle Database 10g: Loading, Unloading, and Managing Undo Data 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: $399.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: 29 Hours, 26 Minutes
|
Course Type: Self Paced
|
 |
|
Description: The following 5 courses are included:
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: 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: 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: 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 |
|
 |
 |
|
|
|
|