Hadoop Online Training

Our Institute offers Online Hadoop Training with Hadoop certification training material, Learn Big Data Hadoop course by experts. Live Tutorial Videos, Apache Hadoop Job Support. Attend Demo for free & you will find Spiritsofts is the best Institute within reasonable fee.

Spiritsofts is the best Training Institutes to expand your skills and knowledge. We Provides the best learning Environment. Obtain all the training by our expert professionals which is having working experience from Top IT companies.

The Training in is every thing we explained based on real time scenarios, it works which we do in companies.

Experts Training sessions will absolutely help you to get in-depth knowledge on the subject.

Key FeaturesCourse ContentFAQs

40 hours of Instructor Training Classes 24/7 Support

Lifetime Access to Recorded Sessions Practical Approach

Real World use cases and Scenarios Expert & Certified Trainers

Hadoop Course Content

Administrator coaching for Apache Hadoop
Introduction to Big Data and Hadoop

What is Big Data?
What area unit the challenges for process Big data?
What technologies support Big data?
Distributed systems
What is Hadoop?
Why Hadoop?
History of Hadoop
Use Cases of Hadoop
Hadoop eco System
HDFS
Map scale back
Statistics

Understanding the Cluster

Typical work flow
Writing files to HDFS
Reading files from HDFS
Rack Awareness
5 daemons

Best Practices for Cluster Setup

Best Practices
How to decide on the proper hadoop distribution
How to decide on right hardware

Cluster Setup

Install Pseudo cluster
Install Multi node cluster
Configuration
Setup cluster on Cloud – EC2
Tools
Security
Benchmarking the cluster

Routine Admin procedures

Metadata & knowledge Backups
Filesystem check (fsck)
File system Balancer
Commissioning and decommissioning nodes
Upgrading
Using DFS Admin

Monitoring the Cluster

Using the online user interfaces
Hadoop Log files
Setting the log levels
Monitoring with Nagios

Install ,Configure and use

PIG
HIVE
HBASE
Flume and Sqoop
Zookeeper

Developer coaching for Apache Hadoop
Introduction to Big Data and Hadoop

What is Big Data?
What area unit the challenges for process Big data?
What technologies support Big data?
Distribution systems.
What is Hadoop?
Why Hadoop?
History of Hadoop
Use Cases of Hadoop
Hadoop eco System
HDFS
Map scale back
Statistics

Understanding the Cluster

Typical work flow
Writing files to HDFS
Reading files from HDFS
Rack Awareness
5 daemons

Developing the Map scale back Application

Configuring development atmosphere – Eclipse
Writing Unit check
Running regionally
Running on Cluster
MapReduce workflows

How MapReduce Works

Anatomy of a MapReduce job run
Failures
Job programing
Shuffle and type
Task Execution

MapReduce varieties and Formats

MapReduce varieties
Input Formats – Input splits & records, text input, binary input, multiple inputs & information input
Output Formats – text Output, binary output, multiple outputs, lazy output and information output

MapReduce options

Counters
Sorting
Joins – Map aspect and scale back aspect
Side knowledge Distribution
MapReduce Combiner
MapReduce Partitioner
MapReduce Distributed Cache

Hive and PIG

Fundamentals
When to Use PIG and HIVE
Concepts

HBASE

CAP Theorem
Hbase design and ideas
Programming

Who Are The Trainers?

Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Spiritsofts verifies their technical background and expertise.

What If I Miss A Class?

We record each LIVE class session you undergo through and we will share the recordings of each session/class.

How Will I Execute The Practical?

Trainer will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.

If I Cancel My Enrollment, Will I Get The Refund?

If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.

Will I Be Working On A Project?

The Training itself is Real-time Project Oriented.

Keywords : Best Institute for Big Data Hadoop Training, Hadoop Online Training, Apache Hadoop Training, Hadoop Certification Material, Hadoop Training for Beginners, Hadoop Jobs for Freshers, Documentation, Dumps, Software Installation

Are These Classes Conducted Via Live Online Streaming?

Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

Is There Any Offer / Discount I Can Avail?

There are some Group discounts available if the participants are more than 2.

Who Are Our Customers?

As we are one of the leading providers of Live Instructor LED training, We have customers from USA, UK, Canada, Australia, UAE, Qatar, NZ, Singapore, Malaysia, Sydney, France, Finland, Sweden, Spain, Russia Moscow, Denmark, London, England, South Africa, Switzerland, Kenya, Philippines, Japan, Indonesia, Pakistan, Saudi Arabia, Qatar, Kuwait, Germany, Frankfurt Berlin Munich, Poland, Belarus, Belgium Brussels Netherlands Amsterdam, India and other parts of the world.

We are located in USA. Offering Online Training in Cities like New York, New jersey, Dallas, Seattle, Baltimore, Tempe, Chandler, Scottsdale, Peoria, Honolulu, Columbus, Raleigh, Nashville, Plano, Toronto, Montreal, Calgary, Edmonton, Saint John, Vancouver, Richmond, Mississauga, Saskatoon, Kingston, Kelowna, Houston, Minneapolis, Los Angeles, San Francisco, San Jose, San Diego, Washington DC, Chicago, Philadelphia, St. Louis, Edison, Jacksonville, Towson, Salt Lake City, Davidson, Murfreesboro, Atlanta, Alexandria, Sunnyvale, Santa Clara, Carlsbad, San Marcos, Franklin, Tacoma, California, Bellevue, Austin, Charlotte, Garland, Raleigh-Cary, Boston, Orlando, Fort Lauderdale, Miami, Gilbert.

Hyderabad (Ameerpet), Kukatpally, Vizag, Nellore, Lucknow, Coimbatore, Marathahalli, Electronic city , Silk board, Kakinada, Goa, Vijayawada, Bangalore, Noida, Chennai, Kolkata, Pune, Whitefield, Mumbai, Delhi NCR, Dubai, Doha, Melbourne, Brisbane, Perth, Wellington, Leeds, Manchester, Liverpool, Ireland Dublin, Oxford, Cambridge, Brighton, Cardiff, Bristol, Lithuania, Latvia, Italy, San Marion, China Beijing, Auckland etc…

Oracle Apps

Oracle RAC Online Training

Winsomesoft

Winsomesoft is the best Training Institutes to expand your skills and knowledge. We Provides the best learning Environment. Obtain all the training by our expert professional which is having working experience from Top IT companies.

The Training in is every thing we explained based on real time scenarios, it works which we do in companies.

Experts Training sessions will absolutely help you to get in-depth knowledge on the subject.

Key FeaturesCourse Content FAQs

45 hours of Instructor Training Classes
Lifetime Access to Recorded Sessions
Real World use cases and Scenarios
24/7 Support Lifetime
Practical Approach
Expert & Certified Trainers

RAC Introduction And Concepts

Database storage options (Core & Cluster)
Non RAC DB Vs RAC DB
Storage options Core DB vs. RAC DB
Files system files / RAW Partitions / ASM
What is ASM?
ASM Architecture
Benefits of ASM
What is Cluster?
What is Clusterware?
Software requirements and download locations

Grid Infrastructure Concepts

Quick review
What is GRID Infrastructure (ASM and Clusterware)
Clusterware Concepts and Architecture
Clusterware startup sequence
Clusterware startup processes
Oracle Clusterware stack
Cluster ready service stack
Oracle High availability services stack
Grid Plug and Play architecture
CSS and Voting Disk Functionality
CRS and OCR
Node eviction (Inter connect, VD)
Networking in RAC concepts
Networking in RAC configuration topology

Preparation Of RAC Machine And ASM Installation

ORACLE VM Box setup
OS Installation for RAC Node1
OS Configuration (rpms, config)
Creating Users and Groups
Creating Virtual Disks
Adding disks to Virtual Node1
Network configuration Public & Interconnect
Configuring Oracle ASM
Cloning Virtual Disk
Preparing Virtual Node2 from Node1
Configuring Node2

Installation Of Grid Infrastructure And RAC Software

Pre Installation Verification
Network verification (Private and Public)
Grid Installation
Completing Grid Installation
Verifying the services with crsctl
Clusterware proc. stop/stop on single / all node(s)
High availability services, stop and start
Installation of Oracle SW on Cluster
Log files on RAC Environment

Cache Fusion Concepts

Cache Fusion Concepts
Read / Read Contention
Read / Write Contention
Write / Write Contention
GCS and GES Concepts
Global Resource Directory (GRD)
What is Past Image? And concepts
Past Image vs. CR Image
Scan Listener concepts & Architecture

ASM Cluster File System

ASM & ASM cluster file system
ASM Key features and benefits
ASM Instance designs
ASM components
ASM disk groups and fail groups
ASM Scalability
Creating disk groups using asmca
Managing disk groups
Listing disks using asmcmd
Creating raw partitions
Creating Disk groups using asmca
Create database using dbca in RAC environment

RAC Backup And Recovery

RAC Specific Database Parameters
Identical and Unique parameters
Enabling Archive log mode in RAC Env
Manual Log switch for a local instance vs. global
Terminating sessions in RAC environment
Administering Oracle Clusterware
Controlling Clusterware
Finding OCR and VD file locations
Backup and Recovery of OCR,VD
Migrating VD and OCR files to different diskgroup
Managing Oracle Clusterware using crsctl & srvctl
OLR purpose and location
OCR and VD auto & manual backups
crsctl & srvctl commands
Difference between srvctl and crsctl
Disabling and enabling clusterware startup

Migration Of Non RAC DB To RAC DB

Non RAC DB to RAC DB
Using RMAN DB Duplication to RAC env
Enabling Single RAC DB to Multi Instance RAC DB
Configuring Migrated RAC DB as Cluster Aware DB
Creating spfile using pfile for RAC DB

Adding Node To Cluster

Add Node to existing Cluster
New node preparation and configuration
SSH configuration for password less connectivity
Cluvfy to check the state of new node
Performing Add Node script

Creating Services

Creating Services
Configuring tnsnames.ora for TAF
Performing TAF
RMAN Configuration for RAC DB
Backup RAC DB Using RMAN

Who Are The Trainers?

Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Winsomesoft verifies their technical background and expertise.

What If I Miss A Class?

We record each LIVE class session you undergo through and we will share the recordings of each session/class.

How Will I Execute The Practical?

If I Cancel My Enrollment, Will I Get The Refund?

Will I Be Working On A Project?

The Training itself is Real-time Project Oriented.

Are These Classes Conducted Via Live Online Streaming?

Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

Is There Any Offer / Discount I Can Avail?

There are some Group discounts available if the participants are more than 2.

Who Are Our Customers?

As we are one of the leading providers of Live Instructor LED training, We have customers from USA, UK, Canada, Australia, UAE, Qatar, NZ, Singapore, Malaysia, India and other parts of the world.

Hyderabad (Ameerpet), Vizag, Vijayawada, Bangalore, Noida, Chennai, Kolkata, Pune, Mumbai, Delhi NCR, Dubai, Doha, Melbourne, Brisbane, Perth, Wellington, Auckland etc…

Keywords: Best Institute for Oracle RAC Training, Oracle RAC Course Material, Oracle RAC Training, Oracle RAC Training Material, Oracle RAC Job Support, Oracle RAC Software, Oracle RAC Documentation, Oracle RAC Material PDF, Oracle RAC Jobs for Fresher’s, Oracle RAC Online Training, Oracle RAC Training in Hyderabad, Oracle RAC Institute in Bangalore, Oracle RAC Interview Questions, Oracle RAC Tutorial Videos, Oracle RAC Training institutes in Hyderabad, Oracle RAC Training Fees, Oracle RAC Certification Dumps,

Oracle Apps

Oracle Performance Tuning Training

Winsomesoft

Our institute offers online Oracle Performance Tuning training by experts, learn Oracle Performance Tuning certification training with course material, tutorial videos, Attend demo for free & you will find Spiritsofts is the best institute within reasonable fee.

The Training in is every thing we explained based on real time scenarios, it works which we do in companies.

Experts Training sessions will absolutely help you to get in-depth knowledge on the subject.

Key FeaturesCourse Content FAQs

40 hours of Instructor Training Classes
Lifetime Access to Recorded Sessions
Real World use cases and Scenarios
24/7 Support Lifetime
Practical Approach
Expert & Certified Trainers

Basic Tuning Tools

Monitoring tools overview
Enterprise Manager
V$ Views, Statistics and Metrics
Wait Events

Using Automatic Workload Repository

Managing the Automatic Workload Repository Create AWR
Snapshots
Real-Time SQL Monitoring

Defining Problems

Defining the Problem
Limit the Scope & Setting the Priority
Top SQL Reports
Common Tuning Problems & Tuning During the Life Cycle
ADDM Tuning Session
Performance Versus Business Requirements
Performance Tuning Resources & Filing a Performance Service
Request
Monitoring and Tuning Tools: Overview

Using Metrics and Alerts

Metrics, Alerts, and Baselines
Limitation of Base Statistics & Typical Delta Tools
Oracle Database 11g Solution: Metrics
Benefits of Metrics
Viewing Metric History Information & using EM to View Metric Details
Statistic Histograms & Histogram Views
Database Control Usage Model & Setting Thresholds
Server-Generated Alerts, Creating and Testing an Alert & Metric and Alert Views

Using Baselines

Comparative Performance Analysis with AWR Baselines
Automatic Workload Repository Baselines
Moving Window Baseline
Baselines in Performance Page Settings & Baseline Templates
AWR Baselines & Creating AWR Baselines
Managing Baselines with PL/SQL & Baseline Views
Performance Monitoring and Baselines & Defining Alert Thresholds Using a Static Baseline
Using EM to Quickly Configure & Changing Adaptive Threshold Settings

Using AWR Based Tools

Automatic Maintenance Tasks
ADDM Performance Monitoring
Active Session History: Overview

Monitoring an Application

What Is a Service? Service Attributes & Service Types
Creating Services & Managing Services in a Single-Instance Environment
Everything Switches to Services.
Using Services with Client Applications & Using Services with the Resource Manager
Services and Resource Manager with EM & Using Services with the Scheduler
Using Services with Parallel Operations & Metric Thresholds
Service Aggregation and Tracing & Service Aggregation Configuration.
Client Identifier Aggregation and Tracing & Service Performance Views

Identifying Problem SQL Statements

SQL Statement Processing Phases & Role of the Oracle Optimizer
Identifying Bad SQL, Real Time SQL Monitoring & TOP SQL Reports
What Is an Execution Plan? Methods for Viewing Execution Plans & Uses of Execution Plans
DBMS_XPLAN Package: Overview & EXPLAIN PLAN Command
Reading an Execution Plan, Using the V$SQL_PLAN View & Querying the AWR
SQL*Plus AUTOTRACE & SQL Trace Facility
How to Use the SQL Trace Facility
Generate an Optimizer Trace

Influencing the Optimizer

Functions of the Query Optimizer, Selectivity, Cardinality and Cost & Changing Optimizer Behaviour
Using Hints, Optimizer Statistics & Extended Statistics
Controlling the Behaviour of the Optimizer with Parameters
Enabling Query Optimizer Features & Influencing the Optimizer Approach
Optimising SQL Statements, Access Paths & Choosing an Access Path
Join & Sort Operations
How the Query Optimizer Chooses Execution Plans for Joins
Reducing the Cost

Using SQL Performance Analyzer

Real Application Testing: Overview & Use Cases
SQL Performance Analyzer: Process & Capturing the SQL Workload
Creating an SQL Performance Analyzer Task & SPA (NF Lesson 9) DBMS_SQLTUNE.CREATE_TUNING_TASK
Optimizer Upgrade Simulation & SQL Performance Analyzer Task Page
Comparison Report & Comparison Report SQL Detail
Tuning Regressing Statements & Preventing Regressions
Parameter Change Analysis & Guided Workflow Analysis
SQL Performance Analyzer: PL/SQL Example & Data Dictionary Views

SQL Performance Management

Maintaining SQL Performance and Optimizer Statistics & Automated Maintenance Tasks
Statistics Gathering Options & Setting Statistic Preferences
Restore Statistics
Deferred Statistics Publishing: Overview & Example
Automatic SQL Tuning: Overview
SQL Tuning Advisor: Overview
Using the SQL Access Advisor
SQL Plan Management: Overview

Using Database Replay

The Big Picture & System Architecture
Capture & Replay Considerations
Replay Options & Analysis
Database Replay Workflow in Enterprise Manager
Packages and Procedures
Data Dictionary Views: Database Replay
Database Replay: PL/SQL Example
Calibrating Replay Clients

Tuning the Shared Pool

Shared Pool Architecture & Operation
The Library Cache & Latch and Mutex
Diagnostic Tools for Tuning the Shared Pool
Avoiding Hard & Soft Parses
Sizing the Shared Pool & Avoiding Fragmentation
Data Dictionary Cache & SQL Query Result Cache
UGA and Oracle Shared Server
Large Pool & Tuning the Large Pool

Tuning the Buffer Cache

Oracle Database Architecture: Buffer Cache
Database Buffers
Buffer Hash Table for Lookups
Working Sets
Buffer Cache Tuning Goals and Techniques
Buffer Cache Performance Symptoms & Solutions
Automatically Tuned Multiblock Reads
Flushing the Buffer Cache (for Testing Only)

Tuning PGA and Temporary Space

SQL Memory Usage & Performance Impact
SQL Memory Manager
Configuring Automatic PGA Memory & Setting PGA_AGGREGATE_TARGET Initially
Monitoring & Tuning SQL Memory Usage
PGA Target Advice Statistics & Histograms
Automatic PGA and Enterprise Manager & Automatic PGA and AWR Reports
Temporary Tablespace Management: Overview & Monitoring Temporary Tablespace
Temporary Tablespace Shrink & Tablespace Option for Creating Temporary Table

Automatic Memory Management

Oracle Database Architecture, Dynamic SGA & Memory Advisories
Granule & Manually Adding Granules to Components
Increasing the Size of an SGA Component, SGA Sizing Parameters & Manually Resizing Dynamic SGA Parameters
Automatic Shared Memory Management & Memory Broker Architecture
Behaviour of Auto-Tuned & Manually Tuned SGA Parameters
Using the V$PARAMETER View & Resizing SGA_TARGET
Disabling, Configuring & Monitoring Automatic Shared Memory Management (ASMM)
Automatic Memory Management

Tuning Segment Space Usage

Space and Extent Management & Locally Managed Extents
How Table Data Is Stored & Anatomy of a Database Block
Minimize Block Visits
The DB_BLOCK_SIZE Parameter
Small & Large Block Size: Considerations
Block Allocation, Free Lists & Block Space Management with Free Lists
Automatic Segment Space Management
Migration and Chaining, Shrinking Segments & Table Compression: Overview

Tuning I/O

I/O Architecture, File System Characteristics, I/O Modes & Direct I/O
Bandwidth Versus Size & Important I/O Metrics for Oracle Databases
I/O Calibration and Enterprise Manager, I/O Calibration and the PL/SQL Interface & I/O Statistics and Enterprise Manager
Stripe and Mirror Everything
Using RAID
I/O Diagnostics
Database I/O Tuning
What Is Automatic Storage Management?

Performance Tuning Summary

Best practices identified throughout the course
Summarise the performance tuning methodology

Who Are The Trainers?

Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Spiritsofts verifies their technical background and expertise.

What If I Miss A Class?

We record each LIVE class session you undergo through and we will share the recordings of each session/class.

How Will I Execute The Practical?

If I Cancel My Enrollment, Will I Get The Refund?

Will I Be Working On A Project?

The Training itself is Real-time Project Oriented.

Are These Classes Conducted Via Live Online Streaming?

Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

Is There Any Offer / Discount I Can Avail?

There are some Group discounts available if the participants are more than 2.

Who Are Our Customers?

Oracle Apps

Oracle Data Guard Online Training

Winsomesoft

Enroll for Online Oracle Data Guard Training by Experts, Learn Oracle Data Guard Certification Training with Course Material | Tutorial Videos | Attend Demo for free & you will find Spiritsofts is the best institute within reasonable fee.

The Training in is every thing we explained based on real time scenarios, it works which we do in companies.

Experts Training sessions will absolutely help you to get in-depth knowledge on the subject.

Key FeaturesCourse Content FAQs

30 hours of Instructor Training Classes
Lifetime Access to Recorded Sessions
Real World use cases and Scenarios
24/7 Support Lifetime
Practical Approach
Expert & Certified Trainers

Introduction to Oracle Data Guard

Causes of Data Loss
Oracle Data Guard Architecture
Types of Standby Databases (benefits of each type)
Using the Data Guard Broker
Differentiating Between Standby Databases and Data Guard Broker Configuration
Data Protection Modes
Performing Role Transitions

Creating a Physical Standby Database by Using SQL and RMAN Commands

Preparing the Primary Database
Creating the Physical Standby Database

Oracle Data Guard Broker: Overview

Oracle Data Guard Broker Features
Oracle Data Guard Broker Configurations
Data Guard Monitor Process
Data Guard Monitor Configuration Files
Benefits of Using the Data Guard Broker
Comparing Configuration Management With and Without the Broker
Using DGMGRL

Creating a Data Guard Broker Configuration

Defining a Data Guard Configuration (overview)
Setting up the Broker Configuration Files
Setting the DG_BROKER_START Initialization Parameter to TRUE to start the Data Guard Broker
Creating the Broker Configuration
Adding the Standby Database to the Configuration

Creating a Physical Standby Database by Using Enterprise Manager Grid Control

Using Enterprise Manager Grid Control to Create a Physical Standby Database
Using the Add Standby Database Wizard
Verifying a Configuration
Editing Standby database properties
Viewing the Data Guard Configuration Status

Creating a Logical Standby Database

Monitoring the Data Guard Configuration by Using Enterprise Manager Grid ControlVerifying the ConfigurationViewing Log File Details
Using Enterprise Manager Data Guard Metrics
Using the DGMGRL SHOW CONFIGURATION Command to Monitor the Configuration
Viewing Standby Redo Log Information
Monitoring Redo Apply

Creating and Managing a Snapshot Standby Database

Snapshot Standby Database: Architecture
Converting a Physical Standby Database to a Snapshot Standby Database
Activating a Snapshot Standby Database: Issues and Cautions
Viewing Snapshot Standby Database Information
Converting a Snapshot Standby Database to a Physical Standby Database

Using Oracle Active Data Guard

Using Real-Time Query
Enabling and Disabling Real-Time Query
Enabling Block Change Tracking on a Physical Standby Database
Creating Fast Incremental Backups
Monitoring Block Change Tracking

Configuring Data Protection Modes

Preparing to Create a Logical Standby Database
Checking for Unsupported Objects , Data Types, and Tables
Ensuring Unique Row Identifiers
Creating the Logical Standby Using SQL Commands and Grid Control
Securing your Logical Standby Database

Performing Role Transitions

Contrast switchover vs. failover
Preparing for a Switchover
Performing a Switchover using DGMGRL and Enterprise Manager
Types of Failovers
Re-enabling Disabled Databases

Using Flashback Database in a Data Guard Configuration

Overview of Flashback Database
Configuring Flashback Database
Using Flashback Database Instead of Apply Delay
Using Flashback Database and Real Time Apply
Flashback Through Standby Database Role Transitions
Using Flashback Database After Failover

Oracle Business Process Management (BPM)

Installing the Observer Software
Configuring Fast-Start Failover
Configuring Automatic Reinstatement of the Primary Database
Initiating Fast-Start Failover from an Application
Disabling Fast-Start Failover
Starting and Stopping the Observer
Moving the Observer to a new Host

Managing Client Connectivity

Understanding Client Connectivity in a Data Guard Configuration
Preventing Clients from Connecting to the Wrong Database
Creating Services for the Data Guard Configuration Databases
Automating Client Failover in a Data Guard Configuration
Automating Failover for OCI Clients
Automating Failover for OLE DB Clients
Configuring JDBC Clients for Failover

Performing Backup and Recovery Considerations in an Oracle Data Guard Configuration

Backup and Recovery of a Logical Standby Database
Using the RMAN Recovery Catalog in a Data Guard Configuration
Creating the Recovery Catalog
Registering a Database in the Recovery Catalog
Configuring Daily Incremental Backups
Using a Backup to Recover a Data File on the Primary Database
Recovering a Data File on the Standby Database

Patching and Upgrading Databases in a Data Guard Configuration

Upgrading an Oracle Data Guard Broker Configuration
Using SQL Apply to Upgrade the Oracle Database
Performing a Rolling Upgrade by Using SQL Apply
Performing a Rolling Upgrade by Using an Existing Logical Standby Database
Performing a Rolling Upgrade by Creating a New Logical Standby Database
Performing a Rolling Upgrade by Using a Physical Standby Database

Monitoring a Data Guard Configuration

Monitoring the Data Guard Configuration by Using Enterprise Manager Grid ControlVerifying the ConfigurationViewing Log File Details
Using Enterprise Manager Data Guard Metrics
Using the DGMGRL SHOW CONFIGURATION Command to Monitor the Configuration
Viewing Standby Redo Log Information
Monitoring Redo Apply

Optimizing a Data Guard Configuration

Using Enterprise Manager Grid Control to monitor configuration performance
Setting the ReopenSecs and NetTimeout database properties
Compressing Redo Data
Delaying the Application of Redo Data
Optimizing SQL Apply
Adjusting the Number of APPLIER and PREPARER processes

Who Are The Trainers?

Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Spiritsofts verifies their technical background and expertise.

What If I Miss A Class?

We record each LIVE class session you undergo through and we will share the recordings of each session/class.

How Will I Execute The Practical?

If I Cancel My Enrollment, Will I Get The Refund?

Will I Be Working On A Project?

The Training itself is Real-time Project Oriented.

Are These Classes Conducted Via Live Online Streaming?

Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

Is There Any Offer / Discount I Can Avail?

There are some Group discounts available if the participants are more than 2.

Who Are Our Customers?

Oracle Apps

Oracle Apps Functional Training

Winsomesoft

Live Oracle Apps Functional Online Training by Experts, Learn Oracle Apps Functional Training Classes, Certification Material, Best institute in Hyderabad USA Singapore and Australia.

Oracle Apps Functional Online Training Course Content

ORACLE FINANACIALS-R12 FUNCTIONAL MODULES – Oracle Asset Management

Oracle Asset Management

Integration with other Modules
Asset Controls setup
Asset management setup steps
Asset key flexi fields
Assets Books
Book Controls Regions
Asset categories
Manual asset additions
CIP asset additions
CIP Conversion
Asset adjustments & maintenance
Mass Addition
Asset retirements
Depreciation of Assets
Asset accounting
Asset Inquiry
Asset Reporting
Revaluation of Assets
Reclassification of Assets
Retirement process of Assets

System Administration

Creating Responsibilities and users
Creating a new Request Group and Maintenance
Document Sequencing.

Oracle General Ledger

Introduction to Oracle General Ledger
Overview on R-12 GL concepts
Creating a chart of Accounts
Key Flexi fields
Calendar creation
Currency Creation and maintenances
Ledger / Ledger Sets, Data Set
Journal entries
Different Types of Journals
Journal Import
Budgets/Mass Budgets
Mass Allocation
Generating Standard Reports
Foreign and Multiple Currencies
Consolidations Processes
Reporting Currency (RC)

Multi Org Structure

Overview on Multi & Multi Org Feature
Creation of Organization Structure
Multi-Org Locations
Multi-Org Organizations
Multi-Org Profile Value
Multi-Org Administration
Multi-Org Reports

Oracle Purchasing

Overview Procurement Process
Oracle Purchasing (Integrations with Other Modules)
Purchasing Configuration Overview
Purchasing Process
Creating and maintenance of Vendor
Requisitions-Introduction
Performing requisition Inquiry
Setting up a unit requisition
RFQS
Quotations
Purchase Orders-Introduction
Creating Standard Purchase Orders
Creating Purchase orders using auto create
Creating Purchase orders
Using-Receiving-Introduction
Entering purchase Order Receipts
Correcting receiving transactions and entering returns
Performing accounting activity inquiry
Integration with oracle payables

Oracle Payables

Overview of Accounts Payable
AP Integration with other Oracle Modules
Oracle Payables Configuration
Introduction to Oracle Payables function’s
Suppliers Creation / Maintains
Invoices Introduction
Creating different Types of Invoices
Invoice matching
Employee Expense Report Processing
Prepayment
Payment manage Recording Stop and void payments
Accounting & Optional accounting features
Bank Creation / Maintaining.

Oracle Receivables

Overview of Oracle Receivables
Integration with other modules
Key Flexi field’s
Oracle Receivable Configuration
Customers & Customer profile Classes
Transaction (invoicing Process)
Recurring invoices
Receipt Process
Auto accounting
Auto invoicing
Standard Reporting
Collection Activities

Oracle Cash Management

Overview of Cash Management
Oracle Cash Management Configuration
System Parameters
Bank Statement’s
Bank Reconciliation process
Forecasting

Oracle Apps

Oracle Apps Technical Training

Winsomesoft

Oracle Apps Technical Training Course Content

Logon and logout of Oracle Applications
Entering data in ERP forms
Searching for available data in forms
Accessing Online Help

Report Development/Customization and Registration

a. Developing a new Report without parameter
- 1. How to develop a report using Reports 6i/10g
- 2. Deploying the new report into the server
- 3. Registering the new report as new Executable in ERP
  - i.Execution methods availability
- 4. Registering the executable as a new concurrent program
- 5. Attaching the concurrent program to the new request group
- 6. Attaching the request group to the new responsibility
b. Developing a new Report with parameters
- 1. How to develop a report using Reports 6i/10g
- 2. Deploying the new report into the server
- 3. Registering the new report as new Executable in ERP
- 4. Registering the executable as a new concurrent program
  - i.Defining the new Value sets
    - a. Independent Value set
    - b. Dependent Value set
    - c. Table Value set
    - d. None Value set
  - ii. Default types available
  - iii. Using the Existing value sets
- 5. Use of Token field
- 6. Attaching the concurrent program to the existing request group
- 7. Attaching the request group to the existing responsibility
c. Customizing the Existing Standard Report
- 1. Finding and downloading the standard report from the server
- 2. Check the feasibility of customizing the standard report based on the requirement
- 3. Procedure to customize the standards report as per the oracle guidelines
  - i. Rename the Existing .RDF with new .RDF
  - ii. Customize the RDF as per requirement
  - iii.Deploying the new RDF into the server
  - iv. Creating the new Executable for the new report
  - v. Creating the new concurrent program for the new executable
  - vi.Attaching the new program to the associated request group of responsibility.

Form Development/Customization in Oracle apps

a.Development and deployment of New form in oracle apps
- 1. Setting up the form builder environment
- 2. Template. FMB usage
- 3. Developing the New Form
- 4. How to Compile the new form
- 5. Registering the form in oracle applications
- 6. Creating the new function and attaching the new form to the function
- 7. Attaching the form to the Submenu/Menu
b. Customization and Deployment of Standard form in oracle apps
- 1. How to customize the standard forms
- 2. How to compile the form
- 3. Registering the form in oracle applications
- 4. Creating the new function and attaching the new form to the function
- 5. Attaching the form to the Submenu/Menu
- 6. Risks in customizing the standard forms
c. Developing the Query Find form in oracle applications
- 1. Steps in developing the Query Find Form
- 2. How to compile the new form
- 3. Registering the form in oracle applications
- 4. Creating the new function and attaching the new form to the function
- 5. Adding Calendars to Date Fields
- 6. Using Message Dictionary
- 7. Controlling Window Behavior
- 8. Difference between forms and form functions
d. Personalization of Existing form in Oracle apps
- 1. What is personalization?
- 2. What can be achieved by using Personalization?
- 3. Restrictions and options in Personalization
e. Usage of Custom.pll for customizing the Standard form
- 1. What is the use of Custom.PLL?
- 2. Restrictions in using the custom.PLL

Interface/Conversion Development

A. Types of interfaces in oracle apps

a. Inbound Interface
- 1. What is inbound Interface
- 2. Hot to develop inbound interface
- 3. Different ways of developing inbound interface
- 4. Inbound Interface flow
- 5. Use of SQL*Loader in inbound interface
- 6. Error Messages handling in inbound interfaces
b. Outbound Interface
- 1. What is outbound Interface?
- 2. How to Develop Outbound Interface
- 3. Different ways of developing Outbound interface
- 4. Use of UTL_FILE Package while developing the outbound interface

Workflow Fundamentals

Overview of Work-flow
Oracle Work-flow Home Pages
Work-list WebPages
Work-flow Monitor WebPages

Development of XML Publisher Report from RDF

What is XML Publisher Report
Benefits in Developing the XML Publisher Reports
Steps to follow in Developing the XML Publisher Report
Designing the report layout in RTF
Define the Data definition
Defining the Template

Development of PL/SQL Report

How To Develop a PL/SQL report
Advantages of Developing the PL/SQL report
Coding standards to follow while developing the PL/SQL report
Usage of ERRBUF and RETCODE parameters
Usage of FND_FILE.PUT_LINE in PL/SQL
Eroding out the concurrent program based on Conditions
Hot to call a concurrent program from Backend

Overview of the System administrator responsibility

Creation of Application Users
Creation of Responsibilities
Creation of Request Groups
Assigning the Responsibilities to the Users
System Profiles and their usage within oracle apps
Personal Profiles and their usage

Overview of the Application Developer Responsibility

Types and use of Flexfield
Use of Key Flexfield
Use of Descriptive Flexfield
How to identify the descriptive Flexfield in the forms
How to Enable the Descriptive Flexfield of a particular form
Lookup table and their usage
Registering the tables in oracle applications
Oracle apps table registration API
Building Message dictionary
Difference between request group and request set
Creating Custom Menus

What is New in R12 when compare to 11i

Major Features of R12
MOAC architecture
Multi org changes in R12
Use of SLA in R12
Some major table changes in R12
API Changes of R12

Migration of Objects from one instance to Other

Migrating the objects by using scripts
Migrating the objects by using the FNDLOAD
Migrating the objects by using screenshots

Procure to Pay Process

a. Purchase order Module(PO)
- 1. Requisition and Types
- 2. RFQ and Types
- 3. Creation Of Supplier and Site
- 4. Types of Purchase Orders
- 5. Different type of Purchase order Matching
- 6. Approvals the Purchase Orders
- 7. Creation of Receipts
- 8. Return to Vendor Process
b. Account Payables Module (AP)
- 1. Creation of Invoice
- 2. Setting up Payment Terms
- 3. Different Type of Invoices
- 4. Validating the Invoice
- 5. Accounting the Invoice
  - i. Draft
  - ii. Final
  - iii. Final Post
- 6. Approvals of Invoice
- 7. Making payment for the Invoice
- 8. Batch payment of the Invoices
c. Cash Management Module (CM)
- 1. Setting up the Banks, Bank Branch and Bank Account
- 2. Clearing the Payment
- 3. Reconciling the Payment
- 4. Uploading the Bank statement to CM which we receive from the banks
d. General Ledger Module (GL)
- 1. Defining the Calendar
- 2. Defining the Currency
- 3. Defining the Chart of accounts
- 4. Setting up Accounting Flexfield
- 5. Creating Journal batches
- 6. Fixing the Posting issues of the Journals
- 7. Creating the Budgets

Oracle Apps

Oracle Apps SCM Online Training

Winsomesoft

Enroll for expert level online Oracle SCM training by real time professionals. Learn Oracle SCM online training by experts with course material, Oracle e-business suite r12 supply chain management certification training ✓Best Institute for Oracle Apps SCM functional training within reasonable fee. We offers online course Hyderabad Canada USA UK South Africa and more

The Training in is every thing we explained based on real time scenarios, it works which we do in companies.

Experts Training sessions will absolutely help you to get in-depth knowledge on the subject.

Key FeaturesCourse Content FAQs

45 hours of Instructor Training Classes
Lifetime Access to Recorded Sessions
Real World use cases and Scenarios
24/7 Support Lifetime
Practical Approach
Expert & Certified Trainers

Oracle Apps SCM Online Training Course Content

Introduction of ERP and basic concepts of Oracle Applications

Oracle Inventory modules

Introduction of Inventory
Define Master Item
Assign Item to Organization
Copy Attributes from Item
Define sub inventories and Locators
On-hand Qty Checking
Transactions like miscellaneous receipts and issues
Move order transactions
Inter org transactions
Sub inventory to sub inventory transactions
Define item category’s and their groups by using KFF
Define cost of the item
ABC analysis
Counting’s like physical, cyclic & replenishment
Planning reports like Min-Max, Reorder Point & Safety stock updates
Generate relevant inventory reports
Different Types of Move Orders and Their Transactions
Lot, serial & Stock Locator generation methods and usage
Check mandatory profile options
Types of Items & Item relationships
Item Catalog creation and Usage
Item attribute controls, Item status attributes and their usage
Define Work day calendar with exception templates.
Define Inventory Locations
Learn about each and every Option in Inventory Parameters, Item Master & Sub Inventory
Learn about available key flex fields in Inventory

Oracle Purchasing Modules

Introduction of Purchasing
Define all the relevant setups for Purchasing(Purchasing Options, Receiving Options, Document Types, Line Types & Financial Options)
Define Suppliers and approved suppliers
Define requisitions(Internal & Purchase)
Define RFQ and Quotations(All Types)
Purchase Order flow
Types of purchase Orders
Define Manual Standard PO’s
Define Auto Standard PO’s
Define manual blanket PO’s and Release Blanket Release
Define Auto blanket PO’s
Receiving transactions Against PO’s
Return transactions Against PO’s
Generate all PO relevant reports
Define Requisition Template
Define requisition Through Auto create form
Define Planned Purchase Orders and release schedule Releases
Define Contract Purchase Agreement
Define all the relevant setups for purchasing Hierarchy(Job, Position, Employee, Buyer, Assign to User, Approval groups and Assign approval groups to Position or Job based on Approval hierarchy(Position Hierarchy or Employee supervisor Hierarchy)
Return to Vendor Process
Define Sourcing Rules and Assignments
Types of Receipt Routings and their usage
Automatic Document Creation Through Sourcing Rules

Order Management Modules

Introduction of Order Management
Type of Sales Orders
Understanding OM Cycles (General Sales Order, Return Material Authorization, Back to Back, Back Order, Drop ship, Internal Sales Order, Point of Sales, ATO and PTO)
All relevant setups for Order Management(Transaction Types, Shipping parameters, Document sequence, Document Assignments, Document Sets for Shipping, Mandatory Profiles, Grants & Roles, System Parameters, System Values, Pick Slip Grouping Rule, Ship confirm Rule & Pick Release Rule)
Define Customers and Sites
Define shipping methods
Define price list
Copy price list
Adjust price list
Add item to price list
Generate all OM relevant reports
Define Sales Person
Define Freight Carriers
Define and know the usage of Sales Agreements
Define Negotiations (Quotes)
Define holds and their usage
Define credit check rules
Learn about defaulting rules
Learn about Processing constraints
Know about available option in shipping transaction form
Related Auto Invoice setups in OM
Know about the sales order different statuses

Real Time

Real time scenarios
Complexities faced in the implementation
Support Tickets or Real time Errors
Questionnaire
CV Preparation

Who Are The Trainers?

Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Spiritsofts verifies their technical background and expertise.

What If I Miss A Class?

We record each LIVE class session you undergo through and we will share the recordings of each session/class.

How Will I Execute The Practical?

If I Cancel My Enrollment, Will I Get The Refund?

Will I Be Working On A Project?

The Training itself is Real-time Project Oriented.

Are These Classes Conducted Via Live Online Streaming?

Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

Is There Any Offer / Discount I Can Avail?

There are some Group discounts available if the participants are more than 2.

Who Are Our Customers?

Oracle Apps

Oracle Apps Financials Online Training

Winsomesoft

Oracle Apps Financials Online Training Course Content

Introduction to Oracle Financials

Integration among Financials

Inter-company Journals: Processing and Issues

Inter-company Journals: Processing and Issues

Design Suspense Accounts

Design Suspense Accounts

Journal Approvals

Journal Approvals

Journal Entry Tax and its relevance

Journal Entry Tax and its relevance

Rollup Groups and Summary Template

Rollup Groups and Summary Templates

Document Sequence for journals

Document Sequence for journals

Import Journals from other applications, Legacy Systems

Import Journals from other applications, Legacy Systems

Budgets

Enter Budgets Manually
Post Budgets
View Budget or Fund Balances

Revaluation

Revaluation

Need for Revaluation

Design the template

Translation

Business Consideration
View Balances

Consolidation

Business Needs
Map Subsidiaries to Parent
View Results

Multiple Reporting Currencies

Business Needs
Advantages and Limitations

Accounts Receivables

Accounts Receivables

Configuration / Setup

System Options
Auto accounting
Grouping rules
Other setup steps

Define Customers

Define Customers

Invoice Processing

Standard Invoices
Credit Memo/ Debit Memo
Customer Advance
Recurring Invoices
Import Invoice using AutoInvoic Import

Adjustments to Invoices

Editing
Cancellation

Receipts Processing

Individual/ Batches
Open Receipts
Apply against invoices
Supplier/ Customer knockoff

Adjustments to Receipts: Editing/ Cancellation

Adjustments to Receipts: Editing/ Cancellation

Accounting Events: Introduction/ Transfer to GL

Accounting Events: Introduction/ Transfer to GL

Bills Receivables

Bills Receivables

Cash Management

Enter Bank Statements

Manual Entry
Import Statements from bank (Concept)

Reconciliation

Manual
Automatic

Cash Forecasting

Cash Forecasting

Cash Positioning

Data Migration/ Conversion
Open Interfaces

Oracle Payables

Multiple Organizations

Need for multiple organizations
Business Group
Legal Entity
Operating Unit
Inventory Organization

Configuration / Setup

Map Set of Books
Design Financials Options
Design Payable Options
Create Bank Accounts
Payment Terms/ Distribution Sets
Taxes (Input, Offset, Recoverable, Withholding)
Special Calendars
Control Accounting Periods

Create Suppliers and Employees

Create Suppliers and Employees

Invoice Processing

Standard Invoices
Credit Memo/ Debit Memo
Expense Reports (Employee Reimbursements)
Prepayments (Supplier Advances)
Recurring or Regular Invoices
Quick Data Entry
Create A/c entries and transfer to GL

Adjustments to Invoices

Edit Invoices
Cancellation

Hold Invoices

Hold Invoices

Import invoices from other applications

Import invoices from other applications

Payment Processing

Individual Payments
Batch Payments
Void/ Cancellation
Payment Reconciliation
Integration with Cash Management
Accounting Events

Transfer Assets to Fixed Assets

Editing
Cancellation
Fixed Assets
Setup Calendar
Setup category
Setup Asset Book Asset Addition
Asset Retirement
Asset Revaluation
Mass Additions
Lease Asset

System Administration

Define Users and assign Responsibilities
Concept of Concurrent Programs / Reports
Concept of Profile Options and their significance

Journal Entry JE

Recurring / Tax / STAT / Suspence / Reverse
Mass Alocation / Conversion / Intercompany

General ledger

Configuration / Setup

Define (Non-ISO) or Enable (ISO) Currencies
Design Accounting Calendar
Concept of Flex fields in Oracle Applications
Difference between Key and Descriptive Flex fields
Design Value Sets and Define Values
Design Chart of Accounts and Considerations
Design Set of Books
Assign Set of Books to Responsibilities

Journal Processing

Enter Manual Journals
Post individual and multiple
Journals Automate Journal posting
View Account Balances online
Run reports to view account balances
Reverse Journals after posting
Automate Journal Reversals

Winsomesoft

Ready to Begin?

Find subjects you're passionate about by browsing our online course categories.Start learning with top courses Built With Industry Experts