Who can learn this course:
Anyone who want to become database administrator
Pre requisites :
· Oracle SQL/PLSQL Knowledge is mandatory
· Understanding of relational database concepts
· knowledge of Unix or Linux or windows Administration and its core functionality
· Any Programming Language is an advantage.
End Objective:
· Able to understand architecture and how its components work and interact with one another.
· Able to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management
· Able to Implement Various Backup/Recovery Strategies.
· Will be able to install, configure, and maintain the database
Course Duration:
· Total Number of Hours : 40 Hours
Course Content:
Introduction.
- Different types of oracle products and features.
- New features in oracle 11g
- Differences among oracle9i, oracle 10g and oracle 11g features along with its importance.
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
Creation of an oracle database.
- Oracle Database 11g Architecture
- Oracle instance architecture
- Oracle Read Consistency and Concurrency
Controlling the database
- Start and stop the enterprise manager database console
- Start and stop the listener
- Startup and shutdown the database
Database Creation.
- Manual
- Database Configuration Assistant(DBCA)
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.
- 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
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).
- Introduction
- Design, Testing, Implementation Strategies
- Offline(cold)/Online(hot) backups
- Performing Complete Recovery
- Performing Incomplete Recovery
Oracle Backup & Recovery (System Managed: RMAN).
- Introduction
- RMAN Architecture
- Configuration
- Setting up Catalog
- Online/Offline Backup using RMAN
- Backups Options
- Incremental Backups
- Complete Recovery
- Incomplete Recovery
- Table Space Point in Time Recovery (TSPITR)
- Disaster Recovery
Cloning.
- RMAN
- Manual
Logical Backup & Transporting data between databases.
- 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
High Availability (HA).
- Database Patch Management Introduction
- Applying Interim and Patch set Patches
- Patch History & Documentation
Oracle Enterprise Manager and Performance tuning
- New features and its analysis of statistics on performance Tuning
Proactive Maintenance
- Contents
- Optimizer statistics
- Automatic Workload Repository
Flashback.
- Introduction
- Configuration
- Flashback Query/Table/Drop/Database
- Flashback Version Query
- Creating Restore Points
Automatic Storage Management.
- New features and implementation
Oracle Grid Control.
- Introduction
- Architecture
- Managing the multiple database nodes using OEM grid control
Data Replication and Integration
- Oracle database 11g streams features overview
- Oracle database 11g streams (Data Replication and Integration)
Related Courses:
Oracle Database 11g performance tuning
Oracle Database backup and recovery
Oracle 11g RAC and Grid infrastructure administration
Oracle 11g Database security
Oracle Database 11g data warehousing fundamentals