|
|
|
|
|
|
|
|
|
|
State-of-the-art training facilities
Class Room \ E-Learning training
Faculty with 10 years of average Apps exp.
Project and Hands-on Training
24\7 Support and 90 Days free Access
Prepare for ORACLE Certification
Apps training - All Functional and Technical
Latest Versions of Oracle Applications
Placement guaranteed for deserved students
|
|
|
|
| | |
|
|
|
|
Oracle DBA |
|
Software Version |
9i and 10g |
Course Duration |
5 days or 40 Hours Approx. |
Course Type |
Class Room and On-Line (E-Learning) Instructor-Led 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 Packes
- 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
|
|
|
|
|
Oracle Training | Oracle Functional Technical Courses |LA OC Nationwide
|
|