1. ORACLE SERVER – AN OVERVIEW
=> LOGICAL STRUCTURE=> ORACLE MEMORY STRUCTURE
=> BACKGROUND PROCESSES
=> INSTALLING AND MANAGING ORACLE DATABASE
=> ORACLE MANAGED FILES (OMF)
=> CREATING A NEW DATABASE
=> STARTING UP DATABASE INSTANCE
=> SHUTTING DOWN DATABASE INSTANCE
=> CONTROL FILE
=> REDO LOG FILES
=> TABLE SPACES
=> SEGMENT AND STORAGE STRUCTURES
=> TABLES
=> INDEXES
=> CONSTRAINTS
=> USERS AND SECURITY
2. BACKUP AND RECOVERY
=> INTRODUCTION=> BACKUP AND RECOVERY IN NO ARCHIVE LOG MODE
=> BACKUP IN ARCHIVE LOG MODE
=> USER MANAGED COMPLETE RECOVERY
=> USER MANAGED INCOMPLETE RECOVERY
=> LOGICAL BACKUP – EXPORT/IMPORT AND DATA PUMP
=> SQL LOADER
=> NETWORKING FUNDAMENTALS
=> LOG MINER
=> REAL APPLICATION CLUSTERS (RAC)
=> STANDBY DATABASE (ALSO ORACLE DATA GUARD)
=> REPLICATION
3. PERFORMANCE TUNING
=> TUNING DEVELOPMENT AND PRODUCTION SYSTEMS=> SOURCES OF TUNING INFORMATION
=> COLLECTING STATISTICS
=> ORACLE SUPPLIED GUI TUNING TOOLS
=> SQL APPLICATION TUNING AND DESIGN
=> OPTIMIZER
=> TUNING SHARED POOL
=> TUNING DATABASE BUFFER CACHE
=> SHARED SERVER
=> LARGE POOL AND JAVA POOL
4. SQL AND PL/SQL
=> COMPILING PACKAGES=> RECORDS AND TABLES
=> CURSOR
=> MERGE, MULTI – TABLE INSERT AND PIVOT INSERT
=> SQL JOINS=> USEFUL SQL FUNCTIONS => DYNAMIC PL/SQL=> NESTED TABLE
=> TYPES OF JOINS=> EXTERNAL TABLES
5. DBMS PACKAGES
=> DBMS_JOB=> UTL_FILE
