|
| Oracle DBA 10g and 11g |
| |
| Software Version |
9i, 10g and 11g |
| Course Duration |
5 Days |
| Course Type |
Class Room and Instructor-Led On-Line (E-Learning) Hands-On Training |
|
| Course Overview |
This intensive course provides basic understanding of the architecture, database and file system used with Oracle Database. The course covers installation procedures, creating database and managing databases, managing users and schemas, backup recovery, performance monitoring, advanced PL/SQL concepts and advanced Oracle Database features. |
| Intended Audience for this course |
This course is designed for those who have technical background, knowledge with any computer language, Java, J2EE, XML, .NET Developers, ERP Developers, DBAs, IT management and Staff, Business Analysts, Technical Consultants, Students and also those who want to become Oracle Data Base Administrators. |
|
| Course Topics |
|
|
| Introduction to DBA |
|
- Relational Database Systems
- Integrity Constraints
- Tasks and Responsibilities of DBA
- Installation
|
|
| Installation |
- Oracle Universal Installer
- Prerequisite Checks
- Installation
- Configuration
|
|
| Creating Database |
- Database Architecture
- Control and Redo Log Files
- Oracle Instance Management
- Memory Structures and Processes
- Data Dictionary and Control, Grid Control
- Configuration Assistant Overview
- Creating Database
- Passwords and Storage
- File Locations and Backup Recovery
|
|
| Managing Database and Schemas |
|
- Starting and Stopping database control
- Accessing Database Control
- Viewing Alert Log
- Introduction to Schemas
- Schema Objects
- Data Types
- Defining Constraints
- Creating views and indexes
- Sequences
|
|
| Managing Users |
|
- User Accounts
- Users and Profiles
- Privileges
- Roles
- Database Users and Schemas
|
|
| Backup and Recovery |
|
- Backup and Recovery issues
- Instance Recovery
- Configuring Backup Strategy
- Scheduling and Managing Backups
- Instance Status
- Control and Redo Log files
- Oracle Recovery Manager overview
- Catalog Maintenance
|
|
| PL/SQL |
|
- PL/SQL Objects
- Functions, Procedures and Packages
- Triggers
- Configuration Options
|
|
| Performance Monitoring |
- Monitoring Methodologies
- Data Dictionary Metrics
- Optimizer Statistics
- Dynamic Performance Views
|
|
| Advanced Features |
- Cloning Oracle Applications
- RAID Partitioning
- Thresholds
- Tuning and Diagnostic Advisors
- OAM Rapid Clone
|
|
| Introduction to Oracle Database 11g Administration |
|
- Your responsibilities as an Oracle 11g DBA
- Configuring the instance and database
- Maintaining security
- Balancing user requirements and resources
- Ensuring database availability
|
|
| The Oracle 11g architecture |
|
- Processing transactions with the server
- Identifying types of Oracle 11g processes and memory structures
- Determining database file structure
- Archiving redo log information
- Sizing the Result Cache for optimizing repeated queries
|
|
| Building an Oracle 11g Database |
|
- Creating the database
- Setting the initialization parameters
- Simplifying memory allocation with memory targets
- Establishing network connectivity
- Converting from text-based to server parameter files
- Configuring control files and redo log files
|
|
|
