Back to Courses

Oracle DBA Online Training

Online Training by SV Soft Solutions

Inquire Now

Online / Training

Inquire to Request Schedule

View this Course

Inquire for Price

Inquire Book Now

RESPONSE RATE

Details
About the Provider

Book Now

Inquire

Details

Introduction (Theory)
- Identify the oracle product
- Describe the basic concept of a relational database
- New features in oracle 11g
Installing oracle database 11g software
- System requirements
- Redhat Linux 5.0 Installation (with and without Vmware workstation)
- Installation of multiple oracle servers and multiple oracle databases on Vmware workstation (features and advantages for RAC implementation with Vmware configuration)
- Install software with the Oracle Universal Installer on Linux Platform
Oracle database Architecture
- Oracle Database 11g Architecture
- Oracle instance architecture
- Oracle Read Consistency and Concurrency
Database Creation.
- Manual
- Database Configuration Assistant(DBCA)
Controlling the database
- Start and stop the enterprise manager database console
- Start and stop the listener
- Startup and shutdown the database
Storage Structures and architecture of Oracle 11g DBA
- Logical structure Vs Physical structure
- Defining the tablespaces and data files
- Create tablespaces
- Manage tablespaces
- Obtain tablespace information
- Managing Undo Data
File Management ( Theory)
- Control File Management
- Redo Log File Management
- Parameter File Management
- Obtain tablespace information
User Management
- Create and manage database user accounts
- Roles
- Privileges
- Control resource usage by using Profiles ion
Oracle Database Security
- Apply the principal of least privilege
- Manage default user accounts
- Implement standard password security features
Oracle Net Services
- Understand Oracle Net concepts
- Use Oracle Net Manager to create and configure listeners
- Use the listener control utility to control the Oracle Net Listener
- Testing Oracle Net connectivity
- Shared Server: Connection pooling
Managing schema objects
- Create and modify tables
- Define constraints
- View the attributes of a table
- View the contents of a table
- Create indexes and views
Oracle Backup & Recovery (User Managed) (Theory)
- Describe the basics of database backup, restore and recovery
- List the types of failure that may occur in an Oracle Database
- Describe ways to tune instance recovery
- Identify the importance of checkpoints, redo log files, and archived log file
Oracle Backup
- Archive Log Mode
- Hot Backup
- Cold Backup
- RMAN Backup
Cloning
- Cold Backup Cloning
- RMAN Backup cloning
Logical Backup & Transporting data between databases
- Introduction Data pump (expdp, impdp) Utilities
- Exporting/Importing Tables
- Exporting/Importing Schemas
- Exporting/Importing Database
Invalid Objects
- Compiling Invalid objects
- Status of Invalid objects
- Retriving count of each object type for each owner
- Rebuild Indexes
Proactive Maintenance
- Contents
- Optimizer statistics
- Automatic Workload Repository
Monitoring and Resolving Lock Conflicts
- Detect and resolve lock conflicts
- Manage deadlocks
Automatic Storage Management (Theory)
- New features and implementation
Database Recovery (Practice only after getting experience)
- Recover from loss of a control file
- Recover from loss of a redo log file
- Recover from loss of a data file

Reviews

Be the first to write a review about this course.

Write a Review

SV Soft Solutions is a premier IT Training and Placement Institute. We attempt best quality courses in areas of PeopleSoft, SAP, Oracle, Android, Microsoft, Servicenow, Datawarehousing, Hadoop, Amazon Web services and Tibco. Our online training institute is the best place for you to brush up your technical leading and build a good career ahead in IT related technologies. Our main assets are our Trainers who have minimum 8 years of experience in IT. Our training takes place with well prepared training materials. We provide excellent documentation and preparation materials for learners.

Online Learning Course Benefits