Oracle DBA Tutorial pdf for Beginners free download

TOP Oracle DBA Tutorial pdf for Beginners free download 
1. ORACLE SERVER – AN OVERVIEW
1.1. LOGICAL STRUCTURE
1.2. ORACLE MEMORY STRUCTURE 
1.3. BACKGROUND PROCESSES
1.4. INSTALLING AND MANAGING ORACLE DATABASE
1.5. ORACLE MANAGED FILES (OMF)
1.6. CREATING A NEW DATABASE 
1.7. STARTING UP DATABASE INSTANCE
1.8. SHUTTING DOWN DATABASE INSTANCE
1.9. CONTROL FILE
1.10. REDO LOG FILES 
1.11. TABLE SPACES
1.12. SEGMENT AND STORAGE STRUCTURES 
1.13. TABLES
1.14. INDEXES
1.15. CONSTRAINTS
1.16. USERS AND SECURITY

2. BACKUP AND RECOVERY
2.1. INTRODUCTION
2.2. BACKUP AND RECOVERY IN NO ARCHIVE LOG MODE
2.3. BACKUP IN ARCHIVE LOG MODE
2.4. USER MANAGED COMPLETE RECOVERY
2.5. USER MANAGED INCOMPLETE RECOVERY
2.6. LOGICAL BACKUP – EXPORT/IMPORT AND DATA PUMP
2.7. SQL LOADER
2.8. NETWORKING FUNDAMENTALS
2.9. LOG MINER
2.10. REAL APPLICATION CLUSTERS (RAC)
2.11. STANDBY DATABASE (ALSO ORACLE DATA GUARD)
2.12. REPLICATION 

3. PERFORMANCE TUNING
3.1. TUNING DEVELOPMENT AND PRODUCTION SYSTEMS 
3.2. SOURCES OF TUNING INFORMATION
3.3. COLLECTING STATISTICS
3.4. ORACLE SUPPLIED GUI TUNING TOOLS
3.5. SQL APPLICATION TUNING AND DESIGN
3.6. OPTIMIZER
3.7. TUNING SHARED POOL
3.8. TUNING DATABASE BUFFER CACHE
3.9. SHARED SERVER
3.10. LARGE POOL AND JAVA POOL
3.11. TUNING REDO
3.12. TUNING ARCHIVING OPERATIONS
3.13. TUNING DISK I/O
3.14. TUNING SORTS
3.15. TUNING ROLLBACK SEGMENTS
3.16. LOCKS
3.17. TUNING OPERATING SYSTEM
3.18. AUTOMATIC WORKLOAD REPOSITORY (AWR)
3.19. AUTOMATIC DATABASE DIAGNOSTIC MONITOR (ADDM) AND SQL TUNING ADVISOR

4. SQL AND PL/SQL
4.1. COMPILING PACKAGES
4.2. RECORDS AND TABLES
4.3. CURSOR
4.4. MERGE, MULTI – TABLE INSERT AND PIVOT INSERT
4.5. SQL JOINS 
4.6. USEFUL SQL FUNCTIONS
4.7. DYNAMIC PL/SQL
4.8. NESTED TABLE
4.9. EXTERNAL TABLES

5. DBMS PACKAGES
5.1. DBMS_JOB
5.2. UTL_FILE

6. USEFUL SCRIPTS FOR DBAS
6.1. TO SHOW PRIMARY/FOREIGN KEY RELATIONSHIPS OF ALL TABLES AND VIEWS IN A GIVEN SCHEMA
6.2. TO SEE ALL OBJECTS IN A TABLE SPACE FILE
6.3. WHICH USER EXECUTING WHAT TYPE OF COMMAND
6.4. GET OUTPUT OF A QUERY TO A TEXT FILE FROM SQL PLUS
6.5. TO SEE SIZE OF YOUR TABLES AND INDEXES
6.6. TO SEE FREE SPACES IN TABLE SPACES

7. NEW FEATURES OF 10/11G
7.1. WHAT IS G IN ORACLE'S GRID COMPUTING? 
7.2.WHAT ARE ORACLE FUSION MIDDLEWARE (OFM) AND SERVICE ORIENTED ARCHITECTURE (SOA)?

0 comments: