OR-425: Oracle 11g: Administration Workshop I

Course Overview:

Students will gain a conceptual and practical understanding of the Oracle database architecture and how its components work and interact with one another. Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices.

Attendees to OR-425: Oracle 11g: Administration Workshop I will receive TechNow approved course materials and expert instruction.

Dates/Locations:

Date/Time	Event
08/13/2012 - 08/17/2012 08:00 -16:00	Oracle 11g: Administration Workshop I TechNow - San Antonio, TX, San Antonio TX

Duration: 5 Days

Course Objectives:

Manage Users, Privileges, Roles, and Resources
Identify Oracle 10g Architecture Components
Proactive Maintenance and Performance Monitoring
Create an Operational Oracle Database
Startup and Shutdown an Oracle Database
Describe how a User Interfaces with the Oracle Database to Process Information
Create and Manage Oracle Objects:
Control Files
Data Files
Redo Log Files
Oracle Database and Instance
Locally Managed and Dictionary Managed Tablespaces
Tables
Indexes
Views
Rollback Segments
Undo Tablespace
Oracle Managed Files
Segments
Extents
Blocks
Oracle Net Overview
Backup and Recovery Non-RMAN
Loading Data – Export/Import-Transportable Tablespaces-Data Pump SQL*Loader

Prerequisites:

Before attending this course, students must have relational database basic concepts.

Comments

Latest comments from students

Facilities comments: Our room at the Hilton Airport was evidently directly below the laundry room with very loud washing machines. This proved to be a big distraction.