|
Oracle Database 10g - Administration I
(25458582) |
|
Return to Search Results | Request More Information | Pre-Register | View Comments | Recommend this Course |
 |
Summary:
In this course, students will perform key administrative tasks in Oracle Database 10g, such as creating and controlling databases, administering users, implementing security features, monitoring performance, and performing backup and recovery. |
|
Course Offered By:
New Horizons Computer Learning Centers
5300 International Blvd.
Bldg C Suite 203
Charleston, South Carolina 29418
Courses by this Learning Provider |
|
 | | Since 1982, New Horizons Computer Learning Centers has grown to become the largest independent IT training company worldwide. |
|
|
|
Course Cost:
$4,000.00
|
Promotions:
Dice Learning users - take any SQL Server training course from New Horizons and receive a fully-licensed copy of SQL Server 2008 Standard Edition with 1 CAL License—FREE ($850 Value)! See http://www.newhorizons.com/FreeSQL2008.aspx for details.
|
Start Date - End Date:
11/09/2009 - 11/11/2009 (More dates) (More dates at this location)
|
Start Time - End Time:
8:30 am - 4:30 pm
|
Classroom Type:
Physical Classroom
|
Geographic Location:
Charleston, South Carolina 29418
|
|
Description:
Core Vendor Technology: Oracle
Content Category: Oracle |
|
Objectives:
Lesson 1: Installing Oracle Database 10g
Install Oracle Database 10g
Lesson 2: Exploring the Oracle Database 10g Architecture
Understand Database Architecture
Identify Database Object Types
Recognize the Oracle Instance
Understand the User Connection Process
Identify Resources for the DBA
Lesson 3: Creating a Database
Create, Configure, and Delete a Database Using the DBCA
Use Client and Administration Tools
Lesson 4: Configuring Oracle Net Services
Examine Oracle Net Services
Perform Basic Oracle Net Server-Side Configuration
Perform Basic Oracle Net Client-Side Configuration
Configure Oracle Shared Server
Configure Connect-Time Failover
Lesson 5: Using SQL and PL/SQL
Write Simple SQL SELECT Statements
Filter and Sort Data
Work with SQL Functions
Work with Multiple Tables
Modify Data
Control Database Transactions
Explore PL/SQL
Lesson 6: Managing the Database Instance
Obtain Instance Information
Manage the Database Instance
Organize Database Objects
Describe Database Objects and Their Storage
Lesson 7: Managing Tablespaces and Datafiles
Manage Tablespaces
Find Tablespace and Datafile Information
Resize and Drop Tablespaces
Configure Oracle Managed Files
Lesson 8: Managing Tables and Indexes
Create Tables
Gather and Analyze Table Information
Create Indexes
Implement Integrity Constraints
Maintain Integrity Constraints
Lesson 9: Creating Views and Sequences
Create Views
Create Sequences
Lesson 10: Managing Users and Security
Manage Users
Manage Privileges and Roles
Manage Passwords and Resource Limits
Audit Database Usage
Lesson 11: Monitoring Performance
Manage Locks
Gather and Use Tuning and Troubleshooting Information
Lesson 12: Loading and Unloading Data
Manage Data Using the Data Pump
Move Tablespaces
Load Data Using SQL*Loader
Create and Access External Tables
Lesson 13: Managing Undo Data
Configure Undo Segments and Tablespaces
Understand Automatic Undo Retention
Lesson 14: Administering and Performing Backups
Create Redo Log Groups and Members
Plan and Configure the Online Redo Log Group
Manage and Maintain Control Files
Back Up the Database
Examine Recovery Manager Concepts
Lesson 15: Administering and Performing Recovery Operations
Manage Recovery
Employ User-Managed and RMAN Recovery
Tune Database Recovery
|
|
Applicable Vendor Technologies:
Oracle
|
|
Associated Disciplines:
Databases
|
|
RECOMMEND THIS COURSE
You must be logged in as a Candidate to recommend courses
|
|
|
|
