OR-425: Oracle 11g: Administration Workshop I

Dates/Locations:

• OR-425: Oracle 10g: Administration Workshop I | 03/26/2012 - 03/30/2012 | San Antonio

Duration: 5 Days

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.

Course Objectives:

• SQL*Plus / ANSI SQL / PL/SQL
• Manage Users, Privileges, Roles, and Resources
• Identify Oracle 10g Architecture Components
• Proactive Maintenance and Performance Monitoring
• Create an Operation 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.

Related posts:

1. OR-415: Oracle Systems Administration or Unit Level TBCMS Administrators
2. L-245: Linux System Administration I
3. OR-411: Learn Oracle SQL 11g
4. OR-415A: Oracle 11g: SQL & PL/SQL Programming
5. OR-412: Learn Oracle PL/SQL