RKG Logo training-ITBiz
RKG Logo
Home Courses Fees Schedule REGISTER NOW Corporate Training Locations
Microsoft Office Tools
Adobe Acrobat Courses
SharePoint Training
Microsoft Dynamics
Social Media Courses
Project Management
Application Devp Tools
Oracle Developer Tools
Data Warehouse & BI
Data Base & System Admin
Programming Languages
Reporting Tools
Networking & Security
Web Technologies
Medical Records
Business Skills
ERP Training
Corporate Training On-Site
Oracle DBA 10g
Oracle DBA
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
  • 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 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

Enroll Online   

Live Chat
Enroll Online
Enroll By Fax
Fee & Schedule
Send Message
Follow us on .....
For further information call 949-387-3772 or FAX 949-681-8247 or email to info@SONUtraining.com
SONU Training is the training wing of RKG Technologies Inc
Disclaimer: RKG Technologies is not linked with Microsoft, Oracle, Adobe, IBM or any other software company we provide training
Copyright © 2004 RKG Technologies Inc. All rights reserved.