Oracle Database Administrator

Part 1:  Oracle introduction 
              

• Write efficient SQL statement
• Restricting and sorting data
• Single row, multiple row and group functions
• Display data from multiple table using join function.
• Subquery and output with SQLPLUS
• Manipulating data
• Create database objects such as table, index, constraint, and view.
• Controlling user access
• Oracle 10g date time and set operation.
• Advance subquery and hierarchical retrieval
• Oracle 9I extensions and DML and DDL statement

• Introduction PL/SQL

Part 2: Oracle database administration Workshop I

• Oracle architectural components
• Operation for database server startup and shutdown.
• Managing oracle instance and create database
• Data dictionary contents and usage
• Maintaining the control file, redo log file, data file and tablespace
• Storage structure and relationship in system management and local management.
• Managing undo data and temp data
• Managing table, indexes, constraints, password security and resources
• Managing user, privilege and role.
• Globalization Support.

Part 3: Oracle database administration
          Workshop II 

• Basic oracle network architecture
• Oracle net server-side configuration
• Oracle net client-side configuration
• Usage and configure of Oracle shared server
• Instance and media recovery structure
• Configuring DB archive mode
• Oracle recovery management overview and configure.
• User managed backup
• RMAN backup
• User managed/RMAN completed recovery
• User managed/RMAN incomplete recovery
• RMAN recovery catalog creation and maintenance.
• Transporting data between databases.
• Loading data into database

Part 4: Performance tuning Oracle
                database  

• Performance tuning step and tools
• Database configuration and I/O issues
• Sizing share pool, buffer cache and other SGA structure
• Tuning oracle shared server (MTS)
• Tuning undo segments
• Tuning SQL statement and application tuning
• Managing statistics
• Using materialized views
• Monitoring and detecting lock contention
• Using source manage and tuning OS