Oracle 11g Training

Introduction To Oracle DBA

• What is DBA ?
• Why a Company needs a DBA?
• Roles & Responsibilities of DBA
• Oracle Architecture
• Physical and Logical Phase of Database
• Types of files(Control file, Redolog file and Datafile)
• Different types of Datafiles
• Instance
• SGA(System Global Area) and Background Process

Database Creation

• Different Startup Modes
• Different Shutdown Modes
• Types of Database Creation
• Manual Method of Creation
• TABLESPACE MANAGEMENT
• Introduction to Table space
• Types of Table space(BIG & SMALL)
• Temporary Table space
• Altering/Renaming a Table space
• Renaming a data file
• Temporary Groups
• Table space Encryption(11g)

Storage Parameters

• What are segments?
• What are extents?
• What is Blocks?
• Oracle Blocks
• Estimation of Extents
• Dictionary Managed Table space
• Locally Managed Table space
• Storage Parameters(Initial, Next, Min Extents, Xtents, Pctincrease)

User Management

• Who are Database Users?
• Why to create a User?
• Creation of Users
• Assigning Privileges
• Creating and granting Roles
• Allocating table space Quotas to Users
• Assigning default table space for the Users
• Setting Profiles for the Users
• Levels of Authentication
• Schema Management(11g)
• Security(11g)

Undo Management

• What is Undo?
• Why Undo required?
• Pending offline status
• Brief idea about Rollback segments
• Flashback Features
• Flashback Table
• Flashback query
• Flashback Version query

Networking in Oracle

• Introduction to Oracle Networking
• Network default location
• Editing Network file
• Listener.ora
• Tnsnames.ora
• Introduction to Database Links
• Types of Database Links
• Introduction to Materialized views
• Advantages of Materialized view
• Refresh Modes

Redo-Log & Controlfile Management

• Introduction to Redo log
• Status of Redo logs
• Multiplexing the Redo log files
• Re-creation of Control file
• Renaming the Database
• Multiplexing the Control file

Logical Backup

• Understand the Business Objects
• Enterprise interface & architecture
• Manage Business Objects Enterprise content
• Secure Business Objects Enterprise content
• Secure application security
• Schedule content
• Publish reports
• Identify Business Objects Enterprise architecture
• Perform common server management tasks
• Manage the Business Objects Enterprise servers

Physical Backup

• Introduction to Physical backup
• Types of Physical backup
• Cold & Hot backup
• Recovery scenarios
• RMAN backup
• RMAN Point in time recovery
• RMAN 11g new features

Performance Tuning

• What is Performance Tuning?
• Why Tuning required?
• Types of Tuning
• Database Tuning
• Application Tuning
• SQL Tuning
• Memory Tuning
• Network Tuning
• Partitioning and Indexes
• Partitioning Enhancements
• AWR/ASH/ASMM/ADDM
• RAT(Real Application Testing)(11g)
• SQL Performance Analyses (11g)
• Row chaining and Row migration
• Resemble Table spaces

Availability

• Introduction to Data Guard
• Types of Standby databases
• 11g New features in Data Guard
• Types of Protection modes
• Active standby/snapshot standby(11g)
• Log Miner
• RMAN Point in time Recovery
• Introduction to Database Cloning
• RMAN Cloning
• Automatic Storage Management(ASM)

SQL Loader

• Introduction to SQL Loader
• Types of files
• Control file
• Infile
• Bad file
• Discard file
• Data file

Auditing

• What is auditing?
• Why auditing performed?
• Types of Auditing
• Levels of Auditing

FlashBack Features

• Flashback Database
• Flashback Archive(11g)

Miscellaneous

• Oracle 11g Installations
• Comparison between Oracle 10g and Oracle 11g
• New features Introduced in Oracle 10g
• Upgradation from Oracle 10g to Oracle11g
• Oracle DBA Online Training

Oracle DBA

• Oracle Applications Overview
• Overview of Oracle Applications

Oracle Applications Modules

• Financial Applications
• Manufacturing Applications
• Supply-Chain Management Applications
• Human Resources Applications

Oracle Applications Features

• Application Features
• Oracle Workflow
• Oracle Applications Multi-Org
• Oracle Applications System Administration
• Third Party Software Compatable with Oracle Applications

Oracle Applications Architechture

• Architecture

Implementation Methods

• Oracle Application Implementation Method
• Rapid Implementations
• Program Office
• Phased Implementations
• Case Studies

Effort and Cost

• ArchitectureUsing the Number and Type of Applications to Estimate Costs
• Relative Complexity of Each Application
• Business Systems Complexity
• Minimizing Customizations and Extensions to Lower Costs
• Business Processes
• Other Projects in Process
• Capability of the Project Team

Project Management and Control

• Project Team Roles
• Issue-Resolution Techniques
• Implementing Status Reporting
• Meeting Minutes
• Red Flags
• Project Plan
• Project Scope
• Critical Path
• Quality Control Procedures
• TAR Tracking, Resolution, and Logging
• Impact of Other Projects

Getting Started

• Forming the Project Team
• Starting Quickly
• Selecting and Scheduling the Modules
• Typical Tasks, Deliverables, and Milestones

Analyzing the Project

• Project Analysis Overview
• Business Process Analysis
• Determining Your Reporting Needs
• Infrastructure Analysis
• Customizations
• Legacy Data and Conversion
• Typical Tasks, Deliverables, and Milestones of the Analysis Phase

Converting Analysis into Solutions

• Designing Customizations
• The Solution/Conceptual Design Document
• Estimating Customizations
• Managing the Phase
• Initial Project Documentation
• Preparing for System Test
• Performance Testing Preparation
• Designing the Support Organization

Enabling the System

• Customization
• Managing the Phase
• Some Alternatives to Customizations

Launching The New Systems

• Managing Change
• Transitioning to New Systems
• Supporting Production Operations

Using Oracle General Ledger

• Introduction to Oracle General Leger
• Relationship to Other Oracle Applications
• New Features
• Resolving Issues and Gaps
• Configuring the GL Application
• Processing Transactions
• Understanding Reports

Using Oracle Payables

• Relationship to Other Oracle Applications
• New Features
• Configuring the AP Application
• Processing Transactions
• Balancing the Subledger to the General Ledger
• Using Open Interfaces in This Application
• Using Oracle Cash Management

Using Oracle Receivables

• Introduction to Oracle Receivables
• Relationship to Other Applications
• New Features
• Resolving Common Issues and Gaps
• Configuring the AR Application
• Converting Data for Major Entities
• Processing Transactions
• Balancing the AR Application Internally
• Balancing the Subsidiary Ledger to the General Ledger
• Using Open Interfaces in This AR
• Understanding Key AR Reports

Using Oracle Assets

• Relationship to Other Applications
• New Features
• Critical Implementation Factors
• Converting Data for Major Entities
• Balancing the Subledger to the General Ledger
• Using Open Interfaces in This Application
• Understanding FA Key Reports

Using Oracle Projects

• Introduction to Oracle Projects
• Relationship to Other Applications
• New Features
• Critical Implementation Factors
• Configuring the PA Application
• Advanced Configuration Tasks and Extensions
• Converting Legacy Data
• Processing PA Transactions
• Project Reporting
• Troubleshooting Oracle Projects

Using Oracle Purchasing

• How Purchasing Relates to Other Applications
• New Features in Oracle Purcashing
• Critical Implementation Factors
• Configuring the Puschasing Application
• Converting Data for Major Entities
• Topics of Interest
• Understanding Key Purchasing Reports
• Troubleshooting Oracle Purchasing

Using Oracle Inventory

• Introduction to Oracle Inventory
• Oracle Inventory Relationships to Other Applications
• New Features in Oracle Inventory
• Critical Implementation Factors
• Configuring the Inventory Application
• Loading System Items
• Processing Inventory Transactions
• Additional Inventory Application Functions

Using Oracle Order Management

• Introduction to Oracle Order Management
• Oracle Order Management Relationship to Other Applications
• New Features in Oracle Order Management
• Configuring Order Management Application
• Processing Order Management Transactions
• Understanding Key Order Management Reports
• Troubleshooting Order Management

Using Oracle Engineering and Bills of Material

• Using Oracle Engineering
• Using Oracle Bills of Material
• Troubleshooting Oracle Engineering and Bills of Material

Using Oracle Cost Management

• Understanding the Structure of the Cost Management Application
• Cost Managements Relationship to Other Applications
• New Features in Oracle Cost Management
• Critical Cost Management Implementation Factors
• Configuring Cost Management Application
• Processing Cost Management Transactions
• Understanding Key Reports from Cost Management
• Troubleshooting Oracle Cost Management

Using Oracle Planning Applications

• Introduction to Oracle Planning Applications
• Using Oracle Master Scheduling/MRP
• New Features in Using Oracle Master Scheduling/MRP
• Critical Oracle Planning Implementation Factors
• Configuring Oracle Planning Application
• Processing Oracle Planning Transactions
• Using Supply Chain Planning
• Using Oracle Alerts with This Application
• Using Open Interfaces in Oracle Planning Application
• Best Practices in Oracle Planning Applications
• MRP Understanding Key Reports

Oracle 11g is intended for:

• Database administrators

We guarantee learning at your convenience & pace.

• Instant Access:
  Get instant access to self-paced training after signup.
• Streaming video recording:
  Watch lessons any time at your schedule, free recording.
• Exercises:
  Practical exercises help you test what you are learning as you go.
• Free Demo:
  Sign up for free demo to check whether the course is right for you and interact with the faculty live.
• Experienced Trainers:
  We only hire the industry’s best trainers
• Live free interactive web sessions:
  Ask the Expert Shell Scripting trainers about the career prospects and clarify your questions any time after you complete the course.
• Structured Curriculum Schedule:
  Progress with your complete daily interactive lessons and assignments.
• Faculty Mentoring:
  Turn in daily and weekly homework for personalized feedback from faculty.
• Virtual Office Hours:
  Live interaction with the faculty and other students around the world.
• Hands on Live Projects:
  Work on live lab sessions to tackle real-world projects. Get 100% faculty guidance and ratings.

N/A