5 Days course
Language: English
This course is only available on request!!
| Oracle Database Administration
5 Days course Language: English This course is only available on request!! |
|
|
DESCRIPTION |
WHAT YOU WILL LEARN |
|
WHO SHOULD ATTEND: |
ASSUMED KNOWLEDGE |
OUTLINES
CHAPTER 1: AN OVERVIEWCHAPTER 2: INSTALL ORACLE SERVER
1) Prepare to Install Oracle
2) Overview of an Architecture
3) Pre-Installation Tasks
4) Install Oracle RDBMS and SQL*Net and related tools
5) Post-Installation Tasks
CHAPTER 3: CREATE ORACLE DATABASE
1) Considerations While Creating Database
2) Considerations in Choosing a Database Block Size
3) Create Database
4) Create Data Dictionary Views
5) Alter Initialization Parameters (init.ora)
CHAPTER 4: THE DATA DICTIONARY
1) The Data Dictionary
2) Data Dictionary Uses
CHAPTER 5: DATABASE STARTUP AND SHUTDOWN
1) Privileges Required
2) Database Startup in Different Modes
3) Database Shutdown in Different Modes
CHAPTER 6: MANAGING STORAGE
1) Introduction to Segments and Extents
2) Create, Alter, and Drop Tablespaces
3) Bring Tablespace Online and Offline
4) Add or Extend Datafile
5) Define Storage Parameters for Tablespace and Objects
6) Create Tables and Indexes in their own Tablespace
7) Analyze Database Objects
CHAPTER 7: MANAGING ROLLBACK SEGMENTS
1) Considerations While Creating Rollback Segments
2) Set Storage Parameters
3) Setting Optimal Size for Rollback Segments
4) Bring Rollback Segments Online and Offline
CHAPTER 8: MANAGING DATABASE USERS AND RESOURCES
1) Create, Alter, and Drop Users
2) Define Default and Temporary Tablespaces
3) Introduction to Privileges
4) Create and Alter Roles
5) Grant and Revoke Privileges and Roles
CHAPTER 9: DATABASE AUDITING
1) Audit Facility
2) Audit Trail
3) Audit Options
4) Audit Guidelines
5) Enable and Disable Auditing
CHAPTER 10: MANAGING LOCKS
1) Identify Locks
2) Monitor Locking Activity
CHAPTER 11: CONFIGURING CLIENT/SERVER FOR ORACLE DATABASES
1) Dedicated and Multi-threaded Server
2) Connectivity to the Database
3) Configuring SQL*Net Listener
4) Setting Up Database Aliases for SQL*Net
5) Database Links
CHAPTER 12: DATABASE BACKUP
1) Physical and Logical Backups
2) Online and Offline Backups
3) Full and Incremental Exports
4) Control File Backups
5) Archive Log Backups
6) Backup Strategy (Design Backup for a Database)
CHAPTER 13: DATABASE RECOVERY
1) Instance Recovery
2) Process Recovery
3) Media Recovery
4) Full Database Recovery
5) Recovery from Export Dump
6) Partial Recovery
7) Recovery from Media Error on Control File
8) Recovery from Media Error on Online Redo Log File
CHAPTER 14: DATABASE PERFORMANCE MONITORING AND TUNING
1) Monitoring Memory Usage
2) Monitoring Disk I/O
3) Trace and tkprof
4) Monitoring System Resources
5) Turning Memory Structures
6) Tuning I/O
7) Generate Execution Plans
8) Tuning SQL Statements
ADVANCED DBA TOPICS
1) Tablespace Fragmentation
2) Using SQL*Loader to Load Data
3) Use of Password File
![[HOME]](../home.gif){kind=small}
![[dates]](../sched.gif){kind=small}
![[reserve]](../reserve.gif){kind=small}
![[seminars]](../seminars.gif){kind=small}
This course was designed to provide the new DBA with a firm foundation in basic administrative taskes including installation, management,
and troubleshooting an Oracle7 or Oracle8 database. 
Install the Oracle Database
This course is for prospective DBA's and Advanced Application designers who are familiar with database concepts and have acquired responsibility for managing Oracle Databases.
Students should have some familiarity with RDBMS concepts, Client/Server concepts, and introductory Oracle including SQL, and PL/SQL.