Oracle DBA Tutorial for beginners pdf free download

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

6. USEFUL SCRIPTS FOR DBAS

 => TO SHOW PRIMARY/FOREIGN KEY RELATIONSHIPS OF ALL TABLES AND VIEWS IN A GIVEN SCHEMA=> TO SEE ALL OBJECTS IN A TABLE SPACE FILE=> WHICH USER EXECUTING WHAT TYPE OF COMMAND=> GET OUTPUT OF A QUERY TO A TEXT FILE FROM SQL PLUS=> TO SEE SIZE OF YOUR TABLES AND INDEXES=> TO SEE FREE SPACES IN TABLE SPACES