Welcome to Online Training from India
Oracle 10g DBA Online Training from India
Oracle 10g DBA Online Training Course Content
Course Duration : 50 to 60 Hrs
1.Introduction.
- Identify the oracle product
- Describe the basic concept of a relational database
- System requirements.
- Redhat Linux Installation
- Install software with the Oracle Universal Installer on Linux Platform
- Oracle Database Architecture
- Oracle instance architecture
- Oracle Read Consistency and Concurrency
- Start and stop the agent
- Start and stop the enterprise manager database console
- Start and stop the listener
- Startup and shutdown the database
- Manual
- Database Configuration Assistant(DBCA)
- Defining the table spaces and data files
- Create table spaces
- Manage table spaces
- Obtain table space information
- Control File Management
- Redo Log File Management
- Parameter File Management
- Obtain table space information
- Create and manage database user accounts
- Create and manage roles
- Grant and revoke privileges
- Control resource usage by using Profiles
- Understand Oracle Net concepts
- Use Oracle Net Manager to create and configure listeners
- Use the listener control utility to control the Oracle Net Listener
- Use the Oracle Net Manager to configure client and middle-tier connection
- Use TNSPING to test Oracle Net connectivity
- Create and modify tables
- Define constraints
- View the attributes of a table
- View the contents of a table
- Create indexes and views
- Introduction
- Design, Testing, Implementation Strategies
- Offline(cold)/Online(hot) backups
- Performing Complete Recovery
- Performing Incomplete Recovery
- Introduction
- RMAN Architecture
- Configuration
- Setting up Catalog
- Online/Offline Backup using RMAN
- Backups Options
- Incremental Backups,
- Scripts,
- Complete Recovery
- Incomplete Recovery
- Table Space Point in Time Recovery (TSPITR)
- Disaster Recovery
- Recovery of Corrupted DB-Blocks
- RMAN
- Manual
- Introduction Data pump (expdp, impdp) Utilities
- Exporting/Importing Tables
- Exporting/Importing Schemas
- Exporting/Importing Table space
- Exporting/Importing Database
- Transportable Table space within & across the database and platforms
- Database Patch Management Introduction
- Applying Interim and Patch set Patches
- Patch History & Documentation
- Contents
- Reading / Extracting the Content of Redo Logs (Online/archived) for recovery or auditing purpose
- Introduction
- Configuration
- Flashback Query/Table/Drop/Database
- Flashback Version Query
- Creating Restore Points
- Introduction Data pump (expdp, impdp) Utilities
- Exporting/Importing Tables
- Exporting/Importing Schemas
- Exporting/Importing Table space
- Exporting/Importing Database
- Transportable Table space within & across the database and platforms
- Introduction
- Architecture
- Configuring Standby database
- Performing Switch Over and Fail Over
- Monitoring & Troubleshooting
- Introduction
- Proactive Vs Reactive Tuning
- Tuning through effective DB Configurations
- Health Management/Periodical Checkup
- DB Defragmentation
- Configuring and using Oracle Parallel Processing Feature
- Tuning Memory, Disk I/O
- Resource Intensive SQL
- Managing the DB Statistics ( for CBO)
- Managing the AWR Snapshots
- Generating/ Interpreting the AWR Report
- Introduction
- Architecture
- Installation & Configuration
- Managing the multiple database nodes using OEM grid control
We are providing Oracle 10g DBA Online Training from Hyderabad India. We are one of best Institute to provide High Quality Oracle 10g DBA online training all over India. If you are staying in Hyderabad, Bangalore, Chennai, Pune, Delhi, USA, UK, Australia, Singapore etc. and unable to attend regular class room training programs then contact our training institute for information on online training. For more details on Oracle 10g DBA Online Training please call to 9290971883, / 9247461324, or drop a mail to revanthonlinetraining@gmail.com
Oracle 10g DBA online training institute address : B1, 3rd Floor, Eureka Court, Near Image Hospital, Ameerpet, Hyderabad, India