Database and Admin

Oracle 11g Training

The Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system produced and marketed by Oracle Corporation. Learn Oracle 11g with BestOnlineTrainers by starting from the basics of Oracle DB. Have a look at

Oracle Database training

course content:

  • Course Overview
  • Target Audience
  • Why choose us
  • Trainer Profile

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

You may be also interested in

Register for FREE Demo

Fields marked with (*) are mandatory

* Name:
* Email:
* Phone:
* Location:
* Course:
* Enquiry:
* Captcha:

 

Client Feedback

Thanks, you guys provided the best online training in SAP BODS. The hands on training is very informative and helpful.

- David Sergi, Camaga Ltd; U.K