Default

Prerequisites • Strong knowledge of Oracle SQL • Strong conceptual knowledge of RDBMS concepts. About the Course We have designed this course specially for people who are interested to change their work domain or either they want to become a good Database Administrator in Oracle DBMS. Topics Covered DBA-I Topics Covered 1. Oracle 11g Installation • Pre-Installation Tasks a. Logging In to the System as root b. Checking Hardware Requirement c. Checking Software Requirement d. Checking Network Setup e. Creating Operating System Groups and Users f. Configuring kernel parameters g. Identifying Required Software Directories h. Identifying or Creating ORACLE_BASE directory i. Installation screens 2. Oracle Database Architect • System Global Area (SGA) a. Shared Pool b. Database Buffer Cache c. The Redo Log Buffer d. Java Pool e. Large pool f. Stream Pool • Fixed SGA a. Automatic Shared Memory Management b. The Oracle Background Process 3. Oracle Data Block Management • Introduction • Data block Overview a. Header (Common and Variable) b. Table Directory c. Row Directory d. Overhead e. Row Data f. Free Space • Free Space Management a. Availability and Optimization of Free Space in a Data Block b. Row Chaining and Migrating c. PCTFREE, PCTUSED, and Row Chaining d. The PCTFREE Parameter e. The PCTUSED Parameter f. PCTUSED g. How PCTFREE and PCTUSED Work Together • Extent Overview a. When Extents Are Allocated b. Determine the Number and Size of Extents c. How Extents Are Allocated d. When Extents Are Deallocated e. Extents in Nonclustered Tables f. Extents in Clustered Tables g. Extents in Materialized Views and Their Logs h. Extents in Indexes i. Extents in Temporary Segments j. Extents in Rollback Segments • Segment Overview a. Introduction to Data Segments b. Introduction to Index Segments c. Introduction to Temporary Segments d. Operations that Require Temporary Segments e. Segments in Temporary Tables and Their Indexes f. How Temporary Segments Are Allocated g. Allocation of Temporary Segments for Queries h. Allocation of Temporary Segments for Temporary Tables and Indexes • Undo Management a. Undo Quota b. Automatic Undo Retention c. External Views 4. Managing Tablespaces • Using Multiple Tablespaces • Creating Tablespaces • Locally Managed Tablespace a. Creating a Locally Managed Tablespace b. Segment Space management in locally managed tablespace • Big File tablespace a. Creating big file Tablespace b. Altering a Bigfile Tablespace c. Identifying a Bigfile Tablespace • Dictionary Managed Tablespace a. Creating Dictionary Managed Tablespace b. Specifying Tablespace Default Storage Parameters c. Specifying Tablespace Default Storage Parameters d. Coalescing Free Space in Dictionary-Managed Tablespaces e. Manually Coalescing Free Space 5. Managing User Privileges And Roles • Understanding User Privileges and Roles a. System Privileges b. Accessing Objects in the SYS Schema c. Object Privileges d. User Roles e. Creating Role • Granting Privileges and Roles • Grant With Admin Option DBA-II Topics Covered 1. Oracle Data Pump • Data Pump Component • Data Pump New Features • How Does Data Pump Access Data? a. Direct Path Loads and Unloads b. Situations in Which Direct Path Load Is Not Used c. Situations in Which Direct Path Unload Is Not Used d. External Tables • Accessing Data Over a Database Link • What Happens During Execution of a Data Pump Job? a. Coordination of a Job b. Tracking Progress within a Job c. Filtering Data and Metadata During a Job d. Transforming Metadata during a Job e. Maximizing Job Performance f. Loading and Unloading of Data g. Monitoring Job Status h. Monitoring the Progress of Executing Jobs • File Allocation a. Specifying Files and Adding Additional Dump Files b. Default Locations for Dump, Log, and SQL Files • Moving Data Between Different Database Versions • Original Export and Import Versus Data Pump Export and Import • How Data Pump Export Parameters Map to Those of the Original Export Utility • How Data Pump Import Parameters Map to Those of the Original Import Utility 2. RMAN Concepts • Configuring the Environment for RMAN Backups a. Showing and Clearing Persistent RMAN Configurations b. Configuring the Default Device for Backups: Disk or SBT c. Configuring the Default Type for Backups: Backup Sets or Copies d. Configuring Channels e. Configuring Control File and Server Parameter File Autobackups f. Configuring RMAN to Make Backups to a Media Manager g. Configuring the Backup Retention Policy h. Configuring Backup Optimization i. Configuring Oracle Flashback Database and Restore Points • About RMAN Channels a. Channel Control Options for Manual and Automatic Channels b. Channel Failover • About RMAN Backups About Image Copies • RMAN Backup Types a. Incremental Backups b. RMAN Backup Errors c. Tests and Integrity Checks for Backups d. Detecting Physical and Logical Block Corruption e. Backup Validation with RMAN • Restoring Files with RMAN a. Mechanics of Restore Operations b. File Selection in Restore Operations c. Datafile Media Recovery with RMAN d. Mechanics of Recovery: Incremental Backups and Redo Logs e. Incomplete Recovery f. Tablespace Point-in-Time Recovery g. Block Media Recovery with RMAN • Database Duplication with RMAN (CLONING) 3. User-Managed Backups • Cold Backup (consistent Backup) a. Take details of database Files& proceed with backup • Cold Backup (inconsistent Backup) a. Querying V$ Views to Obtain Backup Information b. Listing Database Files Before a Backup c. Determining Datafile Status for Online Tablespace Backups d. Making User-Managed Backups of the Whole Database e. Backing Up the Control File to a Binary File f. Backing Up the Control File to a Trace File • Running the DBVERIFY Utility Who should attend • Freshers to make their career into IT / Software Field as Data Base Administrator(DBA). • BPO guys, people who are working in different fields and want to become a DBA. What you need to bring We will provide you all the necessary things to learn the C Programming language, you don't need to bring anything with you for this course." Call us on or email Key Takeaways • Strong RDMBS knowledge • Way to proceed for the next step which is Oracle Performance Tuning at Administrator level.

Prerequisites • Strong knowledge of Oracle SQL • Strong conceptual knowledge of RDBMS concepts. About the Course We have designed this course specially for people who are interested to change their work domain or either they want to become a good Database Administrator in Oracle DBMS. Topics Covered DBA-I Topics Covered 1. Oracle 11g Installation • Pre-Installation Tasks a. Logging In to the System as root b. Checking Hardware Requirement c. Checking Software Requirement d. Checking Network Setup e. Creating Operating System Groups and Users f. Configuring kernel parameters g. Identifying Required Software Directories h. Identifying or Creating ORACLE_BASE directory i. Installation screens 2. Oracle Database Architect • System Global Area (SGA) a. Shared Pool b. Database Buffer Cache c. The Redo Log Buffer d. Java Pool e. Large pool f. Stream Pool • Fixed SGA a. Automatic Shared Memory Management b. The Oracle Background Process 3. Oracle Data Block Management • Introduction • Data block Overview a. Header (Common and Variable) b. Table Directory c. Row Directory d. Overhead e. Row Data f. Free Space • Free Space Management a. Availability and Optimization of Free Space in a Data Block b. Row Chaining and Migrating c. PCTFREE, PCTUSED, and Row Chaining d. The PCTFREE Parameter e. The PCTUSED Parameter f. PCTUSED g. How PCTFREE and PCTUSED Work Together • Extent Overview a. When Extents Are Allocated b. Determine the Number and Size of Extents c. How Extents Are Allocated d. When Extents Are Deallocated e. Extents in Nonclustered Tables f. Extents in Clustered Tables g. Extents in Materialized Views and Their Logs h. Extents in Indexes i. Extents in Temporary Segments j. Extents in Rollback Segments • Segment Overview a. Introduction to Data Segments b. Introduction to Index Segments c. Introduction to Temporary Segments d. Operations that Require Temporary Segments e. Segments in Temporary Tables and Their Indexes f. How Temporary Segments Are Allocated g. Allocation of Temporary Segments for Queries h. Allocation of Temporary Segments for Temporary Tables and Indexes • Undo Management a. Undo Quota b. Automatic Undo Retention c. External Views 4. Managing Tablespaces • Using Multiple Tablespaces • Creating Tablespaces • Locally Managed Tablespace a. Creating a Locally Managed Tablespace b. Segment Space management in locally managed tablespace • Big File tablespace a. Creating big file Tablespace b. Altering a Bigfile Tablespace c. Identifying a Bigfile Tablespace • Dictionary Managed Tablespace a. Creating Dictionary Managed Tablespace b. Specifying Tablespace Default Storage Parameters c. Specifying Tablespace Default Storage Parameters d. Coalescing Free Space in Dictionary-Managed Tablespaces e. Manually Coalescing Free Space 5. Managing User Privileges And Roles • Understanding User Privileges and Roles a. System Privileges b. Accessing Objects in the SYS Schema c. Object Privileges d. User Roles e. Creating Role • Granting Privileges and Roles • Grant With Admin Option DBA-II Topics Covered 1. Oracle Data Pump • Data Pump Component • Data Pump New Features • How Does Data Pump Access Data? a. Direct Path Loads and Unloads b. Situations in Which Direct Path Load Is Not Used c. Situations in Which Direct Path Unload Is Not Used d. External Tables • Accessing Data Over a Database Link • What Happens During Execution of a Data Pump Job? a. Coordination of a Job b. Tracking Progress within a Job c. Filtering Data and Metadata During a Job d. Transforming Metadata during a Job e. Maximizing Job Performance f. Loading and Unloading of Data g. Monitoring Job Status h. Monitoring the Progress of Executing Jobs • File Allocation a. Specifying Files and Adding Additional Dump Files b. Default Locations for Dump, Log, and SQL Files • Moving Data Between Different Database Versions • Original Export and Import Versus Data Pump Export and Import • How Data Pump Export Parameters Map to Those of the Original Export Utility • How Data Pump Import Parameters Map to Those of the Original Import Utility 2. RMAN Concepts • Configuring the Environment for RMAN Backups a. Showing and Clearing Persistent RMAN Configurations b. Configuring the Default Device for Backups: Disk or SBT c. Configuring the Default Type for Backups: Backup Sets or Copies d. Configuring Channels e. Configuring Control File and Server Parameter File Autobackups f. Configuring RMAN to Make Backups to a Media Manager g. Configuring the Backup Retention Policy h. Configuring Backup Optimization i. Configuring Oracle Flashback Database and Restore Points • About RMAN Channels a. Channel Control Options for Manual and Automatic Channels b. Channel Failover • About RMAN Backups About Image Copies • RMAN Backup Types a. Incremental Backups b. RMAN Backup Errors c. Tests and Integrity Checks for Backups d. Detecting Physical and Logical Block Corruption e. Backup Validation with RMAN • Restoring Files with RMAN a. Mechanics of Restore Operations b. File Selection in Restore Operations c. Datafile Media Recovery with RMAN d. Mechanics of Recovery: Incremental Backups and Redo Logs e. Incomplete Recovery f. Tablespace Point-in-Time Recovery g. Block Media Recovery with RMAN • Database Duplication with RMAN (CLONING) 3. User-Managed Backups • Cold Backup (consistent Backup) a. Take details of database Files& proceed with backup • Cold Backup (inconsistent Backup) a. Querying V$ Views to Obtain Backup Information b. Listing Database Files Before a Backup c. Determining Datafile Status for Online Tablespace Backups d. Making User-Managed Backups of the Whole Database e. Backing Up the Control File to a Binary File f. Backing Up the Control File to a Trace File • Running the DBVERIFY Utility Who should attend • Freshers to make their career into IT / Software Field as Data Base Administrator(DBA). • BPO guys, people who are working in different fields and want to become a DBA. What you need to bring We will provide you all the necessary things to learn the C Programming language, you don't need to bring anything with you for this course." Call us on or email at Key Takeaways • Strong RDMBS knowledge • Way to proceed for the next step which is Oracle Performance Tuning at Administrator level.

Prerequisites • Strong knowledge of Oracle SQL • Strong conceptual knowledge of RDBMS concepts. About the Course We have designed this course specially for people who are interested to change their work domain or either they want to become a good Database Administrator in Oracle DBMS. Topics Covered DBA-I Topics Covered 1. Oracle 11g Installation • Pre-Installation Tasks a. Logging In to the System as root b. Checking Hardware Requirement c. Checking Software Requirement d. Checking Network Setup e. Creating Operating System Groups and Users f. Configuring kernel parameters g. Identifying Required Software Directories h. Identifying or Creating ORACLE_BASE directory i. Installation screens 2. Oracle Database Architect • System Global Area (SGA) a. Shared Pool b. Database Buffer Cache c. The Redo Log Buffer d. Java Pool e. Large pool f. Stream Pool • Fixed SGA a. Automatic Shared Memory Management b. The Oracle Background Process 3. Oracle Data Block Management • Introduction • Data block Overview a. Header (Common and Variable) b. Table Directory c. Row Directory d. Overhead e. Row Data f. Free Space • Free Space Management a. Availability and Optimization of Free Space in a Data Block b. Row Chaining and Migrating c. PCTFREE, PCTUSED, and Row Chaining d. The PCTFREE Parameter e. The PCTUSED Parameter f. PCTUSED g. How PCTFREE and PCTUSED Work Together • Extent Overview a. When Extents Are Allocated b. Determine the Number and Size of Extents c. How Extents Are Allocated d. When Extents Are Deallocated e. Extents in Nonclustered Tables f. Extents in Clustered Tables g. Extents in Materialized Views and Their Logs h. Extents in Indexes i. Extents in Temporary Segments j. Extents in Rollback Segments • Segment Overview a. Introduction to Data Segments b. Introduction to Index Segments c. Introduction to Temporary Segments d. Operations that Require Temporary Segments e. Segments in Temporary Tables and Their Indexes f. How Temporary Segments Are Allocated g. Allocation of Temporary Segments for Queries h. Allocation of Temporary Segments for Temporary Tables and Indexes • Undo Management a. Undo Quota b. Automatic Undo Retention c. External Views 4. Managing Tablespaces • Using Multiple Tablespaces • Creating Tablespaces • Locally Managed Tablespace a. Creating a Locally Managed Tablespace b. Segment Space management in locally managed tablespace • Big File tablespace a. Creating big file Tablespace b. Altering a Bigfile Tablespace c. Identifying a Bigfile Tablespace • Dictionary Managed Tablespace a. Creating Dictionary Managed Tablespace b. Specifying Tablespace Default Storage Parameters c. Specifying Tablespace Default Storage Parameters d. Coalescing Free Space in Dictionary-Managed Tablespaces e. Manually Coalescing Free Space 5. Managing User Privileges And Roles • Understanding User Privileges and Roles a. System Privileges b. Accessing Objects in the SYS Schema c. Object Privileges d. User Roles e. Creating Role • Granting Privileges and Roles • Grant With Admin Option DBA-II Topics Covered 1. Oracle Data Pump • Data Pump Component • Data Pump New Features • How Does Data Pump Access Data? a. Direct Path Loads and Unloads b. Situations in Which Direct Path Load Is Not Used c. Situations in Which Direct Path Unload Is Not Used d. External Tables • Accessing Data Over a Database Link • What Happens During Execution of a Data Pump Job? a. Coordination of a Job b. Tracking Progress within a Job c. Filtering Data and Metadata During a Job d. Transforming Metadata during a Job e. Maximizing Job Performance f. Loading and Unloading of Data g. Monitoring Job Status h. Monitoring the Progress of Executing Jobs • File Allocation a. Specifying Files and Adding Additional Dump Files b. Default Locations for Dump, Log, and SQL Files • Moving Data Between Different Database Versions • Original Export and Import Versus Data Pump Export and Import • How Data Pump Export Parameters Map to Those of the Original Export Utility • How Data Pump Import Parameters Map to Those of the Original Import Utility 2. RMAN Concepts • Configuring the Environment for RMAN Backups a. Showing and Clearing Persistent RMAN Configurations b. Configuring the Default Device for Backups: Disk or SBT c. Configuring the Default Type for Backups: Backup Sets or Copies d. Configuring Channels e. Configuring Control File and Server Parameter File Autobackups f. Configuring RMAN to Make Backups to a Media Manager g. Configuring the Backup Retention Policy h. Configuring Backup Optimization i. Configuring Oracle Flashback Database and Restore Points • About RMAN Channels a. Channel Control Options for Manual and Automatic Channels b. Channel Failover • About RMAN Backups About Image Copies • RMAN Backup Types a. Incremental Backups b. RMAN Backup Errors c. Tests and Integrity Checks for Backups d. Detecting Physical and Logical Block Corruption e. Backup Validation with RMAN • Restoring Files with RMAN a. Mechanics of Restore Operations b. File Selection in Restore Operations c. Datafile Media Recovery with RMAN d. Mechanics of Recovery: Incremental Backups and Redo Logs e. Incomplete Recovery f. Tablespace Point-in-Time Recovery g. Block Media Recovery with RMAN • Database Duplication with RMAN (CLONING) 3. User-Managed Backups • Cold Backup (consistent Backup) a. Take details of database Files& proceed with backup • Cold Backup (inconsistent Backup) a. Querying V$ Views to Obtain Backup Information b. Listing Database Files Before a Backup c. Determining Datafile Status for Online Tablespace Backups d. Making User-Managed Backups of the Whole Database e. Backing Up the Control File to a Binary File f. Backing Up the Control File to a Trace File • Running the DBVERIFY Utility Who should attend • Freshers to make their career into IT / Software Field as Data Base Administrator(DBA). • BPO guys, people who are working in different fields and want to become a DBA. What you need to bring We will provide you all the necessary things to learn the C Programming language, you don't need to bring anything with you for this course." Call us on Key Takeaways • Strong RDMBS knowledge • Way to proceed for the next step which is Oracle Performance Tuning at Administrator level.

CCNP – Route Syllabus Enhanced IP Addressing Mechanisms •Variable Length Subnet Masking (VLSM) •Route-Summarization RIP v1 •Basic RIP Configuration •RIP operation •RIP using UNICAST •Injection of Default Route •Default Network using Default Information Orginate RIP v2 •Basic RIPv2 Configuration •RIP 2 Operation •Compatibility with RIP Version 1 •RIP V2 Plain Text Authentication EIGRP •Enhanced IGRP Terminology •Packet types •EIGRP Summarization •Configuring Basic EIGRP •Basic Metric Calculations •Passive Interfaces in EIGRP •Unequal Cost Load Balancing •Route Summarization •Injecting Default Route with Route Redistribution •Injecting Default Route with Summary-Address Command. •Redistributing Directly Connected Networks •Redistributing EIGRP into EIGRP with different AS # •Redistributing EIGRP into RIP •Redistributing EIGRP into RIP using Route Filtering •Redistributing Static using Route Filtering •EIGRP Authentication For More Details contact us: Elegant It Services contact no:

For Better Understanding of Your Training Sessions We have Furnished the Training Contents as Session by Session Session 1 • Definition of ERP • Introduction to Oracle Applications • Types of Data • Functional Consultant and Roles • Technical Consultant and Roles • DBA and Roles • Types of Projects Session 2 • Oracle Application Architecture • Data Base Structure of Oracle Applications • Introduction to Rice Components Session 3 • System Administration and Application Object Library (AOL) • Defining Application Users and Assigning the Responsibilities. • Creating Responsibilities • FND Tables and Understanding AOL and its Components Session 4 • Registration of Tables • Using AD_DD Package • Procedures to Register Database Tables in AOL Module Session 5 • Report Registration Steps • Register the Report in AOL Module • Executable Creation of Reports • Defining the Concurrent Program • Creation of Request Group Session 6 • Register the Parametric Report in AOL Module • Introduction to Report Parameters • Types of Parameters • Creating Value Sets • Value Set Default Types Session 7 • Developing a Report from Scratch as per Client requirement • Default Report Styles • Customization of Oracle Standard Reports Session 8 • Introduction to Forms • Form registration in Oracle Applications Session 9 • Creating Functions in AOL Module • Creation of New Menu • Oracle Application Default Menus Session 10 • Introduction to Template.FMB • Appstand.FMB • Introduction to Pre Defined Objects in Template.FMB Session 11 • Creating of New Template • Creating of New Block, Canvas in Template • Registration Steps for Template Session 12 • Overview of Flex Fields • Types of Flex Fields • Introduction to Key and Descriptive Flex Fields Session 13 • Steps for Creation of DFF • Flex Field Tables and Relations Session 14 • Overview of Profiles Options • Different Levels in Setting Profiles • Some Important Profile Options • Steps in Setting Profile Options Session 15 • Multiple Organization Concepts • Introduction to Multi Org • What is Multi Org and Why we need it • Defining Multi Org Structure Session 16 • Multi Org Tables • Overview of Procure to Pay (P2P Cycle) • Overview of Order to Cash (O2C Cycle) • Overview of Important Tables in PO, Inventory, OM, AP, AR, GL Session 17 • Introduction to Interfaces • Difference between Interfaces and Conversions • Types of Interfaces • Inbound Interfaces • Using SQL * Loader Session 18 • Working with Staging Table Scripts • Developing Validations Package • Interface Tables and Error Tables Session 19 • Introduction to Conversions • Conversion Flow Session 20 • Introduction to AIM Documentation • Preparation of AIM Documents Session 21 • Introduction to Business Documents • Preparation of MD 50 Documents, MD 70 Documents etc. Session 22 • Functional Flows of GL, AP, AR • Back End Tables Session 23 • Introduction of XML Reports • Developing XML Reports Session 24 • Steps for Registering the XML Reports in AOL Module Session25 • Introduction to workflow. • Development of workflow with about workflow components. • Back End Tables • FAQ’S in Oracle Apps Technical SADGURU TECHNOLOGIES H. No: , Flat No: 102, Sai Manor Apartment, S.R. Nagar Main Road, Hyderabad-, Landmark: Beside Umesh Chandra Statue, Mob: 91-, Ph: 040-

SADGURU TECHNOLOGIES phno: For Better Understanding of Your Training Sessions We have Furnished the Training Contents as Session by Session Session 1 • Definition of ERP • Introduction to Oracle Applications • Types of Data • Functional Consultant and Roles • Technical Consultant and Roles • DBA and Roles • Types of Projects Session 2 • Oracle Application Architecture • Data Base Structure of Oracle Applications • Introduction to Rice Components Session 3 • System Administration and Application Object Library (AOL) • Defining Application Users and Assigning the Responsibilities. • Creating Responsibilities • FND Tables and Understanding AOL and its Components Session 4 • Registration of Tables • Using AD_DD Package • Procedures to Register Database Tables in AOL Module Session 5 • Report Registration Steps • Register the Report in AOL Module • Executable Creation of Reports • Defining the Concurrent Program • Creation of Request Group Session 6 • Register the Parametric Report in AOL Module • Introduction to Report Parameters • Types of Parameters • Creating Value Sets • Value Set Default Types Session 7 • Developing a Report from Scratch as per Client requirement • Default Report Styles • Customization of Oracle Standard Reports Session 8 • Introduction to Forms • Form registration in Oracle Applications Session 9 • Creating Functions in AOL Module • Creation of New Menu • Oracle Application Default Menus Session 10 • Introduction to Template.FMB • Appstand.FMB • Introduction to Pre Defined Objects in Template.FMB Session 11 • Creating of New Template • Creating of New Block, Canvas in Template • Registration Steps for Template Session 12 • Overview of Flex Fields • Types of Flex Fields • Introduction to Key and Descriptive Flex Fields Session 13 • Steps for Creation of DFF • Flex Field Tables and Relations Session 14 • Overview of Profiles Options • Different Levels in Setting Profiles • Some Important Profile Options • Steps in Setting Profile Options Session 15 • Multiple Organization Concepts • Introduction to Multi Org • What is Multi Org and Why we need it • Defining Multi Org Structure Session 16 • Multi Org Tables • Overview of Procure to Pay (P2P Cycle) • Overview of Order to Cash (O2C Cycle) • Overview of Important Tables in PO, Inventory, OM, AP, AR, GL Session 17 • Introduction to Interfaces • Difference between Interfaces and Conversions • Types of Interfaces • Inbound Interfaces • Using SQL * Loader Session 18 • Working with Staging Table Scripts • Developing Validations Package • Interface Tables and Error Tables Session 19 • Introduction to Conversions • Conversion Flow Session 20 • Introduction to AIM Documentation • Preparation of AIM Documents Session 21 • Introduction to Business Documents • Preparation of MD 50 Documents, MD 70 Documents etc. Session 22 • Functional Flows of GL, AP, AR • Back End Tables Session 23 • Introduction of XML Reports • Developing XML Reports Session 24 • Steps for Registering the XML Reports in AOL Module Session25 • Introduction to workflow. • Development of workflow with about workflow components. • Back End Tables • FAQ’S in Oracle Apps Technical SADGURU TECHNOLOGIES H. No: , Flat No: 102, Sai Manor Apartment, S.R. Nagar Main Road, Hyderabad-, Landmark: Beside Umesh Chandra Statue, Mob: 91-, Ph: 040-

SADGURU TECHNOLOGIES phno: Email: For Better Understanding of Your Training Sessions We have Furnished the Training Contents as Session by Session Session 1 • Definition of ERP • Introduction to Oracle Applications • Types of Data • Functional Consultant and Roles • Technical Consultant and Roles • DBA and Roles • Types of Projects Session 2 • Oracle Application Architecture • Data Base Structure of Oracle Applications • Introduction to Rice Components Session 3 • System Administration and Application Object Library (AOL) • Defining Application Users and Assigning the Responsibilities. • Creating Responsibilities • FND Tables and Understanding AOL and its Components Session 4 • Registration of Tables • Using AD_DD Package • Procedures to Register Database Tables in AOL Module Session 5 • Report Registration Steps • Register the Report in AOL Module • Executable Creation of Reports • Defining the Concurrent Program • Creation of Request Group Session 6 • Register the Parametric Report in AOL Module • Introduction to Report Parameters • Types of Parameters • Creating Value Sets • Value Set Default Types Session 7 • Developing a Report from Scratch as per Client requirement • Default Report Styles • Customization of Oracle Standard Reports Session 8 • Introduction to Forms • Form registration in Oracle Applications Session 9 • Creating Functions in AOL Module • Creation of New Menu • Oracle Application Default Menus Session 10 • Introduction to Template.FMB • Appstand.FMB • Introduction to Pre Defined Objects in Template.FMB Session 11 • Creating of New Template • Creating of New Block, Canvas in Template • Registration Steps for Template Session 12 • Overview of Flex Fields • Types of Flex Fields • Introduction to Key and Descriptive Flex Fields Session 13 • Steps for Creation of DFF • Flex Field Tables and Relations Session 14 • Overview of Profiles Options • Different Levels in Setting Profiles • Some Important Profile Options • Steps in Setting Profile Options Session 15 • Multiple Organization Concepts • Introduction to Multi Org • What is Multi Org and Why we need it • Defining Multi Org Structure Session 16 • Multi Org Tables • Overview of Procure to Pay (P2P Cycle) • Overview of Order to Cash (O2C Cycle) • Overview of Important Tables in PO, Inventory, OM, AP, AR, GL Session 17 • Introduction to Interfaces • Difference between Interfaces and Conversions • Types of Interfaces • Inbound Interfaces • Using SQL * Loader Session 18 • Working with Staging Table Scripts • Developing Validations Package • Interface Tables and Error Tables Session 19 • Introduction to Conversions • Conversion Flow Session 20 • Introduction to AIM Documentation • Preparation of AIM Documents Session 21 • Introduction to Business Documents • Preparation of MD 50 Documents, MD 70 Documents etc. Session 22 • Functional Flows of GL, AP, AR • Back End Tables Session 23 • Introduction of XML Reports • Developing XML Reports Session 24 • Steps for Registering the XML Reports in AOL Module Session25 • Introduction to workflow. • Development of workflow with about workflow components. • Back End Tables • FAQ’S in Oracle Apps Technical SADGURU TECHNOLOGIES H. No: , Flat No: 102, Sai Manor Apartment, S.R. Nagar Main Road, Hyderabad-, Landmark: Beside Umesh Chandra Statue, Mob: 91-, Ph: 040-

Forget about holding a book consciously and fall freely in the world of imagination! Grippy™ is a thumb mounted book holder that makes reading books with one hand effortless, whether you are in a classroom, standing in a jam-packed metro or simply lying down on your back.  This great accessory has a unique ergonomic design that holds the pages of the book open for you. It is available in different sizes and in different colors. While Placing order,  1. Mention The size: S, M (default), L, XL 2. Mention the color of choice: Transparent (default), Black, White If not mentioned, the buyer would receive the one with the default color and size. For Keychain option, or to get a custom text engraved, drop a mail at contact@grippy.in Visit www.grippy.in for more information

Softgen Infotech located in BTM Layout, Bangalore is a leading training institute providing real-time and placement oriented Informatica Training Courses in bangalore. Our Informatica training course includes basic to advanced levels. we have a team of certified trainers who are working professionals with hands on real time Informatica projects knowledge which will provide you an edge over other training institutes. Our Informatica training centre is well equipped with lab facilities and excellent infrastructure for providing you real time training experience. We also provide certification training programs in Informatica Training. We have successfully trained and provided placement for many of our students in major MNC Companies, after successful completion of the course. We provide placement support for our students. Our team of experts at Softgen Infotech Training Institute, Bangalore have designed our Informatica Training course content and syllabus based on students requirements to achieve everyone's career goal. Our Informatica Training course fee is economical and tailor-made based on training requirement. We Provide regular training classes(day time classes), weekend training classes, and fast track training classes for Informatica Training in our centres located across bangalore. We also provide Online Training Classes for Informatica Training Course. Contact us today to schedule a free demo and complete course details on Informatica Training Course. What is Informatica Training ? Informatica Training Objectives Completeness- data missing or unusable?Confirmity- data stored in a non standard format?Consistency, Accuracy, Duplicates, Integrity.Leverage Informatica s expertise in metadata reporting planning and deployment.Understand the optimal Informatica architecture for your metadata needs.Preview custom metadata reports and dashboards based on your project objectives and Informaticas best practice.Metadata Reporting Enablement Strategy.Metadata reporting standards.Demonstration of Informaticas out-of-the-box and customized reports and dashboards based on your metadata requirements. Training Prerequesites Basics of data ware housingGood to have an idea about sql and pl/sqlGood to have a knowledge on Oracle database and its functionality Course Outline INTRODUCTION TO DATA WAREHOUSING Data warehouse concept Differences between Online Transaction Processing and data warehouse Types of Data Warehouse Data warehouse Architecture Difference between Data warehouse & Data mart Data Warehouse Approaches Data Warehouse Components Logical & physical Design* Operational data sources(ODS) OLAP and its types: ROLAP, MOLAP, HOLAP, DOLAP TOOL KNOWLEDGE Informatica PowerCenter Product Overview Power Center Domain Administration Console PowerCenter Repository PowerCenter Client Repository Service INTEGRATION SERVICE WEB SERVICES HUB MODELLING FOR DATA WAREHOUSE Defining Fact, Dimension, Attributes, Hierarchies, Grain and Granularity Grain and Granularity of Data Fact Table Dimension tables and types* Data Warehouse Schemas*: Star schema and Star Query, star flake schema, snow flake schema and Galaxy Schema REPOSITORY MANAGER Adding a Repository to the Navigator Configuring a Domain Connection Connecting to a Repository Viewing Object Dependencies Validating Multiple Objects Comparing Repository Objects Truncating Workflow and Session Log Entries Managing User Connections and Locks Managing Users and Groups Working with Folders POWERCENTER DESIGNER Source Analyzer Working with Relational Sources Working with Flat Files Target Designer Mappings Transformations Working with Ports Using Default Values for Ports User-Defined Default Values Tracing Levels Basic First Mapping Expression Transformation Filter Transformation Router Transformation Union Transformation Sorter Transformation Rank Transformation Aggregator Transformation Joiner Transformation Source Qualifier Lookup Transformation Lookup Types Lookup Transformation Components Connected Lookup Transformation Unconnected Lookup Transformation Lookup Cache Types: Dynamic, Static, Persistent, Shared Update Strategy Dynamic Lookup Cache Use Lookup Query Lookup and Update Strategy Examples Stored Procedure Transformation Connected Stored Procedure Transformation Unconnected Stored Procedure Transformation Sequence Generator Transformation Mapplets: Mapplet Input and Mapplet Output Transformations Normalizer Transformation XML Sources Import and usage Mapping Wizards Getting Started Slowly Changing Dimensions Mapping Parameters and Variables Parameter File Indirect Flat File Loading WORKFLOW MANAGER Working with Workflows Assigning an Integration Service Working with Links Workflow Variables Session Parameters Working with Tasks Session Task Email Task Command Task Working with Event Tasks Timer Task Decision Task Control Task Assignment Task Schedulers Worklets Partitioning Partitioning Attributes Partitioning Types Session Properties Workflow Properties ADVANCED TOPICS Push down Optimization Technique Unit Testing Version Control Real time Scenario on Dynamic Lookup Cache Real time Scenario on Unconnected Stored procedure and lookup transformation Constraint Based Load Ordering Target Load Plan Order. Informatica Training Course Details Duration:45 Hours Version:latest Version Regular: 1 Hour per day Fast Track: 2 - 3 Hours per day: 10 days Weekdays:Monday - Friday Weekend:Saturday and Sunday Online Training:Available Class Room Training: Available Course Fee: Talk to our Customer Support Mode of Payment:Talk to our Customer Support

Type Tutoring Our course Content Joomla2.5 Installation Add content to home page Discussing about default menus Add menu items to mainmenu Difference b/w component and module Template Position (Module Position) and Site Layout Menus Site Content Discuusing About Menu item Types Default components Discussing about module manager Discussing about extra functionality of website Global Configuration User Management Discussing About Template Manager Discussing about module development How to Work with Forms Mini Project explanation on FTP Shopping Cart For more details please contact: ,.

Srihitha Technologies Training which is one of the best Joomla and Drupal training institute in Ameerpet,Hyderabad.We have panel of experienced faculties who are working in top MNC and take classes online. We provide live interactive classes by our instructors. We provide one-to-one training programs and also group online training programs. Introduction Joomla2.5 Installation Add content to home page Discussing about default menus Add menu items to mainmenu Difference b/w component and module Template Position (Module Position) and Site Layout Menus Site Content Discuusing About Menu item Types Default components Discussing about module manager Discussing about extra functionality of website Global Configuration User Management Discussing About Template Manager Discussing about module development How to Work with Forms Mini Project explanation on FTP Shopping Cart

About Linux •Linux is the fastest growing open source operating system. Many organizations across the world realized the power, stability and cost benefits of implementing Linux. Linux has become the de-facto Operating system of choice for many Organizations. In today’s world, you cannot think of an Organization that does not use Linux in their IT. Linux is fast growing and creating immense opportunities across the world for Linux Administrators. •About Uclid IT •Uclid IT is the education division of Uclid IT Services Pvt Ltd. Known for the highest level of Quality standards & proven Placement track record, Uclid IT has become the Leader in providing High quality IT education. That’s why many corporate companies work with Uclid to provide various trainings like Boot camps, Skill enhancement, Reskilling etc… to their employees. Our association with around 15 plus Tier-1 IT & MNC companies has helped thousands of Uclid students to get jobs in these companies. With our world-class training infrastructure and highly experienced faculty members 1. INTRODUCING THE GNOME 3 DESKTOP 1.1. What Is GNOME 3? 1.2. What Is GNOME Shell? 1.2.1. Hardware Acceleration and Software Rendering 1.3. What is GNOME Classic? 1.3.1. The GNOME Classic Extensions 1.3.2. Switching from GNOME Classic to GNOME and Back 1.3.3. Disabling GNOME Classic as the Default Session 1.4. Getting More Information I. MIGRATION PLANNING 2. logind 2.1. Getting More Information 3. GSettings and dconf 3.1. Getting More Information 4. PolicyKit 4.1. Policy Configuration 4.2. Default Policy Venue Uclid IT Services, 25, Karve Road, 2nd Floor, Above Bank of Maharastra, Next to Ayurveda rasashala, Near Garware College. Pune, Maharastra. PH: +-

uclid it •About Linux •Linux is the fastest growing open source operating system. Many organizations across the world realized the power, stability and cost benefits of implementing Linux. Linux has become the de-facto Operating system of choice for many Organizations. In today’s world, you cannot think of an Organization that does not use Linux in their IT. Linux is fast growing and creating immense opportunities across the world for Linux Administrators. •About Uclid IT •Uclid IT is the education division of Uclid IT Services Pvt Ltd. Known for the highest level of Quality standards & proven Placement track record, Uclid IT has become the Leader in providing High quality IT education. That’s why many corporate companies work with Uclid to provide various trainings like Boot camps, Skill enhancement, Reskilling etc… to their employees. Our association with around 15 plus Tier-1 IT & MNC companies has helped thousands of Uclid students to get jobs in these companies. With our world-class training infrastructure and highly experienced faculty members 1. INTRODUCING THE GNOME 3 DESKTOP 1.1. What Is GNOME 3? 1.2. What Is GNOME Shell? 1.2.1. Hardware Acceleration and Software Rendering 1.3. What is GNOME Classic? 1.3.1. The GNOME Classic Extensions 1.3.2. Switching from GNOME Classic to GNOME and Back 1.3.3. Disabling GNOME Classic as the Default Session 1.4. Getting More Information I. MIGRATION PLANNING 2. logind 2.1. Getting More Information 3. GSettings and dconf 3.1. Getting More Information 4. PolicyKit 4.1. Policy Configuration 4.2. Default Policy Venue Uclid IT Services, 25, Karve Road, 2nd Floor, Above Bank of Maharastra, Next to Ayurveda rasashala, Near Garware College. Pune, Maharastra. PH: +-

ORACLE RAC ONLINE TRAINING BY REALTIME EXPERTS infrastructure setup Installation of Virtual workstation Installation of Open Filer Configuration of Open Filer Physical volumes Logical volumes Network permission Luns IQN Publish Installation of OEL Operating system OEL Oracle Enterprise Linux Disk Druid configuration Manual partitions Assigning static ip to Ethernet Time zone selection Root user password configuration Packages selection Post installation configuration Login to the OS Installing Virtual tools Sharing of Folders from host OS to virtual OS Cloning of OS in virtual workstation Start and Shut of OS Pre requisite Ip addressing design to RAC environment ping testing connectivity Adding luns from OS to san box configuring iscsi Mac address generation in virtual box configure ethernet static configure default gateway Resolve host to ip restarting service Installing RPMS on OS Creating partition on san box OCR,VD and Data partition Execute part probe Conversion of block to raw Permission on raw creation of groups creation of user password setting configure Trust relationship between nodes Time synchronization Verify run cluvfy Installing cluster ware unzip the cluster ware Execute run Installer Installing all the nodes at same time selection of VD partition selection of OCR Partition Execute scripts on all nodes verify crsctl crs Installing ASM Binaries unzip the binaries configure Kernel parameter Execute run Installer Installing all the nodes at same time configure ASM home location Execute scripts on all nodes verify ASM home location Installing RDBMS Binaries unzip the binaries configure Kernel parameter Execute run Installer Installing all the nodes at same time configure RDBMS home location Execute scripts on all nodes verify RDBMS home location Environment file Configure cluster ware environment configure ASM environment configure RDBMS environment Verify environment Listener Login to RDBMS environment Execute netca tool Listener configuration on all nodes Verify Listener service ASM instance and Disk group Login to ASM environment Configure ASM instance DBCA Configure disk group Verify ASM service Verify ASM disk group RDBMS instance and Database Login to RDBMS environment Configure Database DBCA tool Assign db name Select disk group to create db Verify database and instance service RAC Services View RAC services Learn how to stop and start services Srvctl stop database service Srvctl stop instance service Srvctl stop ASM service Srvctl stop listener service Srvctl stop nodeapps service Srvctl start nodeapps service Srvctl start listener service Srvctl start ASM service Srvctl start instance service Srvctl start database service Crs stop all service crs start all service Adding a New node to RAC Add new node network access in san box Os preparation Ip addressing design to new node ping testing connectivity Adding luns from OS to san box configuring iscsi Mac address generation in virtual box configure ethernet static configure default gateway Resolve host to ip restarting service Installing RPMS on OS Execute part probe Conversion of block to raw Permission on raw creation of groups creation of user password setting configure Trust relationship between existing RAC nodes Time synchronization Installing and Add cluster ware to existing RAC Installing and Add ASM to existing RAC Installing and Add RDBMS to existing RAC Environment file configure Listener configuration Add RDBMS instance to existing database Verify new node services Removing a existing node from RAC Stop and Remove RDBMS instance stop and remove ASM instance stop and remove listener stop and remove nodeapps delete ora Inventory update global inventory uninstall RDBMS binary Uninstall ASM binary Remove crs daemon Uninstall Clusterware Verify Load Balancing Server load balancing Preference configuration dbca configuration Manual configuration Adding and Deleting Client Load balancing configure tns Edit Tns names Verify client load balance Cloning RMAN Cloning Enable archive mode in RAC Configure FRA Perform RMAN Backup configure tns configure directory structure create parameter file create password file start instance in nomount connect by RMAN Perform duplicate database verify the clone database Patches Patch set unzip patch set Apply patch set for crs verify crs version stop relevant services Apply patch set for ASM Apply patch set for RDBMS start relevant services Execute scripts Verify the version OPATCH Stop relevant services unzip opatch Apply OPatch verify optach Up gradation upgrade cluster ware upgrade ASM binary Upgrade RDBMS binary Execute upgrade scripts Verify new version oracle rac online training CONTACT US: India: + Usa: +

SADGURU TECHNOLOGIES phno: For Better Understanding of Your Training Sessions We have Furnished the Training Contents as Session by Session Session 1 • Definition of ERP • Introduction to Oracle Applications • Types of Data • Functional Consultant and Roles • Technical Consultant and Roles • DBA and Roles • Types of Projects Session 2 • Oracle Application Architecture • Data Base Structure of Oracle Applications • Introduction to Rice Components Session 3 • System Administration and Application Object Library (AOL) • Defining Application Users and Assigning the Responsibilities. • Creating Responsibilities • FND Tables and Understanding AOL and its Components Session 4 • Registration of Tables • Using AD_DD Package • Procedures to Register Database Tables in AOL Module Session 5 • Report Registration Steps • Register the Report in AOL Module • Executable Creation of Reports • Defining the Concurrent Program • Creation of Request Group Session 6 • Register the Parametric Report in AOL Module • Introduction to Report Parameters • Types of Parameters • Creating Value Sets • Value Set Default Types Session 7 • Developing a Report from Scratch as per Client requirement • Default Report Styles

SADGURU TECHNOLOGIES phno: Email: For Better Understanding of Your Training Sessions We have Furnished the Training Contents as Session by Session Session 1 • Definition of ERP • Introduction to Oracle Applications • Types of Data • Functional Consultant and Roles • Technical Consultant and Roles • DBA and Roles • Types of Projects Session 2 • Oracle Application Architecture • Data Base Structure of Oracle Applications • Introduction to Rice Components Session 3 • System Administration and Application Object Library (AOL) • Defining Application Users and Assigning the Responsibilities. • Creating Responsibilities • FND Tables and Understanding AOL and its Components Session 4 • Registration of Tables • Using AD_DD Package • Procedures to Register Database Tables in AOL Module Session 5 • Report Registration Steps • Register the Report in AOL Module • Executable Creation of Reports • Defining the Concurrent Program • Creation of Request Group Session 6 • Register the Parametric Report in AOL Module • Introduction to Report Parameters • Types of Parameters • Creating Value Sets • Value Set Default Types Session 7 • Developing a Report from Scratch as per Client requirement • Default Report Styles • Customization of Oracle Standard Reports Session 8

I often get mails from people asking what are the questions generally asked in Weblogic by interviewers. Generally for an Administrator’s positions, in addition to Weblogic questions, there are a lot of Unix questions and a few questions related to process and case handling. These are the important questions that I cover while interviewing. 1. How do you differentiate between a server hang and server crash issue? When a Server crahes, the JAVA process no longer exists. When the Server is hung, it stops responding. We can use the weblogic.ADMIN utilty to ping the server. In case of a hang situation we can take multiple thread dumps and analyze the cause of hang. 2. What can be the various reasons for a server crash? a) Native IO b) SSL Native Libraries c) JVM d) Supported Configuration e) JDBC Driver issue 3. How do you troubleshoot a crash? JVM crash generates a hs_err_pid file. We need to look into the stack trace of the hs_err_pid file . If the thread is from a native io, we need to disable native io. if the stack trace is from the driver, we need to get in touch with the drive team. Quite possibly its a problem with driver. Changing the type of driver can be a workaround. If the thread shows it coming from an optimzed code, we can turn of optimization. If the stack is from native calls of application, its a bug with the application and it has to b modified. 4. Ho do you troubleshoot Server Hang? We can use java weblogic.Admin PING to check if we get a normal response. We need to take multiple thread dumps with kill -3 pid on unix and CTLR Break on Windows. Analyze the thread dump to find the root cause. 5. What can be the reasons of Server hang? Memory leak, databse query taking a long time to return, Deadlock. 6. What is memory leak? Memory leak is when objects are not romved from the heap even when they are not required. 7. What are the various causes for OUT OF MEMORY? a) Insufficient heap size, not able to match the extra load. b) Objects licing too long, like HTTP Sessions. c) Memory leak in application code. d) Full GC not happening due to JVM Bug. 8. How to troubleshoot and overcome such issues? Gather memory data by enabling GC verbose. If its due to Http Session, timing out http session after certain interval might help. Look into the code for jdbc connection handling. Optimizing the heap size according to the load. 9. When does High CPU Usage occur? It occurs when one process or one thread utilizes unexpectedly high proportion of CPU. 10. How to troubleshoot it? In Solaris environment, we need to take pstack and prstack and see what the threads are doing. In Windows we need to use pslist and process explorer. 11. What is Clustering and what is achieved through it? Clustering is the grouping together of servers for the purpose of high availability and scalability. Load balancing and Failover is achieved. 12. How does Cluster Communication Happen? Members of the Cluster communicate over the Cluster Multicast IP and Port by sending periodic heart beat messages. 13. What is the difference between the Sun JVM and BEA JRockit JVM? The most well know JVM is the implementation from Sun. The Sun JVM is called HotSpot. The Sun JVM is shipped in the Java Developer’s Kit (JDK) and Java Runtime Environment (JRE) from Sun. The BEA JRockit JVM from BEA systems is optimized for reliability and performance for server side applications. To achieve this, BEA JRockit JVM uses technologies such as code generation, hot spot detection, code optimization, advanced garbage collection algorithms and tight operating system integration. 14. TUning JVM Parameters. If you have a single processor, single thread machine then you should use the serial collector (default for some configurations, can be enabled explicitly for with -XX:+UseSerialGC). For multiprocessor machines where your workload is basically CPU bound, use the parallel collector. This is enabled by default if you use the -server flag, or you can enable it explicitly with -XX:+UseParallelGC. If you’d rather keep the GC pauses shorter at the expense of using more total CPU time for GC, and you have more than one CPU, you can use the concurrent collector (-XX:+UseConcMarkSweepGC). Note that the concurrent collector tends to require more RAM allocated to the JVM than the serial or parallel collectors for a given workload because some memory fragmentation can occur.

The smartmind Provide the online Spring training incudes merchandise overview, FAQ, real life alternatives and comparison of Spring ETL tools with other tools. Administers Spring manages global settings projects and interacts with the machine. Administrator set up project properties is used to specify general server default options, add and delete jobs and offers a command interface to the Spring repository. With Spring Administrator users can set user privileges occupation tracking limits, job scheduling options and concurrent occupations default option.

Program Name: Basic Excel 2010 Duration: 8 hrs Training Content:. Creating a Basic Worksheet · Customize the Quick Access Toolbar · Enter Data and Save a Workbook · Explore the User Interface and the Ribbon · Navigate and Select in Excel · Obtain Help Performing Calculations · Calculate with Functions · Copy Formulas and Functions · Create Basic Formulas Modifying a Worksheet · Insert and Delete Cells, Columns, and Rows · Manipulate Data · Search for Data in a Worksheet · Spell Check a Worksheet Formatting a Worksheet · Add Borders and Color to Cells · Apply Cell Styles · Apply Number Formats · Change Column Width and Row Height · Modify Fonts · Position Cell Contents Printing Workbook Contents · Print Workbook Contents Using Default Print Options · Set Page Breaks · Set Print Options Managing Large Workbooks · Format Worksheet Tabs · Manage Worksheets in a Workbook Training Name: HB Certified Programme in Intermediate Excel 2010 Duration: 16 hrs Training Content: Creating and Editing Formulae • Concept of Formulae • Creating Formulae, Editing Formulae • Mathematical Order • Copying Formulae • Using Functions - Sum, Average, Max, Min, Count, Counta • Applying Absolute (Fixed) Referencing Formatting and Proofing • Formatting Cells with Number formats, Font formats, Alignment, Borders, etc • Basic conditional formatting • Copying and Clearing Formats • Working with Styles • Spell Check, Find & Replace and AutoCorrect Range Names • Naming individual or range cells • Deleting and amending named ranges • Using named cells/ranges in formulae Conditional Functions & Formats and Date Calculations • Benefits and purpose • If Statements, Nested If • And, Or, Not • Combining If, And, Or, Not • Sumif, Countif • Conditional Formatting • Entering Dates and Times • Different date/time formats • How dates are stored • Calculating working days • Using the DAY(),MONTH(),YEAR() functions Formulae Auditing • Formula Auditing Tools • Revealing Formulae • Tracing Precedents/Dependents • Goto Special Worksheet Management & Linking • Linking sheets in the same file • Linking different Excel files • Using Edit, Links • Viewing different files at once • Saving a workspace • Viewing different sheets at once • Window Split • Data consolidation Basic List Management • Sorting Data • Adding Subtotals • Autofilter • Freeze Panes • Group and Outline • Data Form Excel Charts / Graphs • Using the Chart Wizard • Editing and Formatting charts • Saving custom chart types • Setting a default chart type Lookup & Information Functions • Vertical Lookup (Vlookup) • Horizontal Lookup (Hlookup) • Match and Index • IsText, IsValue, IsDate, IsNull, IsErr, Is Error, IsNa Advanced List Management • Advanced Filters • Using List Features • Dynamic Lists Pivot Tables • Using the Pivot Table Wizard • Changing the pivot table layout • Formatting • Grouping items • Inserting calculated fields • Pivot Table Options • Display and hide data in fields • Lay out reports directly on worksheet • Pivot Chart What If Analysis • Scenarios • Goal Seek • Solver Protecting & Sharing Files • Sharing a file • Tracking changes • Protecting file • Accepting or rejecting changes • Applying Data validation rules • Inserting comments Introduction to Macros • Purpose of Macros • Recording macros • Where to save macros • Running macros: • Custom buttons, menu items, keyboard shortcuts Visual Basic for Applications Environment • Visual Basic Editor and its options • Component Management • Shortcuts Connecting to Database/Outlook • Connect to MS Access • Access Database & Retrieve Data from MS Access • Create Table & Query Data Filter DB using Query • Update and Modify DB • Retrieve the Information through Excel from Outlook using VBA Advanced Excel 2010 Training Name: HB Certified Programme in Advanced Excel 2010 Duration: 24 hrs Training Content: Getting started with Macros · Recording and Modifying Macros · Assigning Macros to Toolbar, Buttons, Shortcut key Visual Basic for Applications Environment · Visual Basic Editor and its options · Component Management · Shortcuts Introduction to Procedural Programming · Procedures: Functions and Sub-routines · Data Types Control Flow · If...Then....Elseif....Else....Endif · Case · Do...Loop, While · For... Next · Exit · VBA and Sheet Data Exchange (Cells, Range Methods) · Getting and Printing Data from Users (InputBox, MsgBox) · how to link with Ms Access and SQL Call/Whatsapp 8939693655

NO 1 Best SAP BI Training Institute in Chennai with Placement…9600063484 No 1 Software Training Institute in Chennai with Placement Peridot is proud to introduce job oriented IT Training courses with globally accredited certification on all platforms that have wider scope in the existing IT Job Market. Real Time Training Free Demo Classes Real Time MNC Working Faculty Below are the Highlights of our course – 1) Two days free trial - If candidate likes this course, these days are adjusted in his actual schedule. 2) Live Project Exposure of Fortune companies. 3) Training by Subject Matter experts from CMM Level 5 companies 4) Running in ONE major financial cities of India – Chennai (ADYAR) 5) Worldwide online training of SAP BI professional and corporate classes at affordable fees. 6) Our basic course worth more than the advanced course of other institutes/freelancers. 7) Free Interview preparations. 8) 100% free assistance for Microsoft certifications. 9) 100 % guarantee in succeeding the certification at affordable fees. 10) Also provide online training to students of foreign countries. Learn SAP training from the Best Testing Institute in Chennai Join Us- Best SAP BI training institute in Chennai. You can find the detailed syllabus for COURSE OUTLINE: Modeling • Info area • Info Object Object Catalog • Characteristic Info Object • Key figure Info Object • DataStoreObject • Info Cube • Multiprovider • Info set • Openhubdestination Extraction • Data source • Transformation • Info package • Data Transfer Process • Standard Data source Extraction • Delta Management • LO Data Source Extraction • Flat file data source Extraction • Generic data source Extraction • BI Data source Extraction Administration • Managing Info Object • Managing DataStoreObject • Managing Info cube • Process Chains • BI Accelerator Reporting • Info provider • Characteristic Restriction • Default Values • Restricted Key figures • Calculated Key figures • Structures • Formulas • Variables • Cells • Conditions • Exceptions • Query Properties BW7.3 Features • Hybrid Provider • LSA Architecture • Semantically Partitioned Object • Dataflow • Additional Options for existing Objects Call 8056102481/9600063484to get detailed information about SAP training in Chennai or contact us through our enquiry form present on the right side of the page. Venue: Kamatchi KrupaApts, No: 84/8, Ground Floor, Venkatarathinam main street, Venkatarathinam Nagar, LB Road, Adyar, Chennai, Mobile : 8056102481 Mail: papitha.v@peridotsystems.in Visit Our Website: www.peridotsystems.in Tags:SAP Training in Chennai | Best SAP Training in Chennai | Corporate Training for SAP | Corporate Training SAP

Type Tutoring JMETER Testing Training Online in India Course Content: INTRODUCTION History The Future What is JMETER Advantages and Disadvantage Limitation GETTING STARTED REQUIREMENTS Java Version Operating Systems OPTIONAL Java Compiler JDBC Driver Apache SOAP INSTALLATION Downloading the Latest Release RUNNING JMETER JMeter's Class path Using a Proxy Server CONFIGURING JMETER BUILDING A TEST PLAN Adding and Removing Elements Loading and Saving Elements Configuring Tree Elements Saving the Test Plan Running a Test Plan Error reporting ELEMENTS OF A TEST PLAN Thread Group Controllers Listeners Timers Assertions Configuration Elements Pre-Processor Elements Post-Processor Elements Execution order Scoping Rules Properties and Variables Using Variables to parameterise tests BUILDING A WEB TEST PLAN Adding Users Adding Default HTTP Request Properties Adding Cookie Support Adding HTTP Requests Adding a Listener to View/Store the Test Results Logging in to a web-site BUILDING A DATABASE TEST PLAN Adding Users Adding JDBC Requests Adding a Listener to View/Store the Test Results BUILDING A WEBSERVICE TEST PLAN BUILDING A JMS POINT TO POINT TEST PLAN BUILDING A JMS TOPIC TEST PLAN BUILDING A MONITOR TEST PLAN LISTENERS REMOTE TESTING BEST PRACTICES Limit the Number of Threads Where to Put the Cookie Manager Where to Put the Authorization Manager Using the Proxy Server to record test scripts User variables Reducing resource requirements Parameterising tests FUNCTIONS REGULAR EXPRESSIONS

Upskill Technologies provides 2 day workshop for Advanced Excel and Dashboards.Mohd Arsalan has over 7 years of experience in providing corporate training MS-Excel in Hyderabad. Having trained more than students he has a great flavor for teaching with practical and real time examples.Content will be Creating Templates, Formatting, Creating Tables, Changing Default Options, Writing Formulas, If Conditions, Conditional Formatting, Using Formulas in conditions, Sum-IF, Count-If, Vlookup, Pivot Table Subtotals, Data Validation, Protecting Sheet and Workbook. Batch will start on . Please visit our site. If you need any information Please Contact us. e-mail: Cont.No.

Type Tutoring INSTALLING AND SETTING UP THE WAREHOUSE BUILDER ENVIRONMENT What Is Oracle Warehouse Builder? Basic Process Flow of Design and Deployment Oracle Warehouse Builder Licensing and Connectivity Options Installing Oracle Warehouse Builder 11.2 OWBSYS Schema Using OWB 11.2 with Database 10g R2 Using the Repository Assistant to Manage Workspaces Supported operating systems (OS), sources, targets, and optional components GETTING STARTED WITH WAREHOUSE BUILDER Logging In to OWB Design Center Overview of the Design Center OWB Projects Overview of Objects within a Project Overview of Objects within an Oracle Module Organizing Metadata Using Foldering Locations Navigator and Globals Navigator panels Setting Projects Preferences: Recent Logons UNDERSTANDING THE WAREHOUSE BUILDER ARCHITECTURE Warehouse Builder Development Cycle Overview of the Architecture for Design, Deployment, Execution Overview of Configurations, Control Centers, and Locations Creating Target Schemas Registering DB User as an OWB User Roles and Privileges of Warehouse Builder Users Registering an Oracle Workflow User DEFINING SOURCE METADATA Data warehouse implementation: Typical steps Difference Between Obtaining Relational and Flat File Source Metadata Creating Flat File Module Sampling Simple Delimited File Sampling Multi-record Flat File Creating an Oracle Module Selecting the Tables for Import DEFINING ETL MAPPINGS FOR STAGING DATA Purpose of a Staging Area Define OWB Mappings Mapping Editor Interface: Grouping, Ungrouping, and Spotlighting Creating External Tables Create and Bind process Levels of Synchronizing Changes Using the Automapper in the Mapping Editor Set loading type and target load ordering USING THE DATA TRANSFORMATION OPERATORS Component Palette Using a Joiner Lookup Operator: Handling Multiple Match Rows Using the Subquery Filter Operator Using the Set, Sequence, and Splitter Operators Pivot and Unpivot Operators Using the Aggreagator, Constant, Transformation, and Pre/Post Mapping Operators Deploying and Executing in Projects Navigator Panel CLEANSING AND MATCH-MERGING NAME AND ADDRESS DATA Integrating Data Quality into ETL Name and Address Data Cleansing Name and Address Server Name and Address Software Providers Settings in the Name and Address Operator Reviewing a Name and Address Mapping Consolidating Data Using the Match Merge Operator Using the Match Merge Operator in a Mapping USING PROCESS FLOWS Process Flow Concepts Creating a Process Flow Module, a Process Flow Package and a Process Flow Types of Activities: Fork, And, Mapping, End Activity Creating Transitions Between Activities Some More Activities: Manual, SQLPLUS, Email Generating the Process Flow Package DEPLOYING AND REPORTING ON ETL JOBS Logical Versus Physical Implementation Setting Object Configuration Deployment Concepts Invoking the Control Center Manager Deploy Options and Preferences Repository Browser Starting OWB Browser Listener and the Repository Browser Browsing Design Center and Control Center Reports USING THE MAPPING DEBUGGER Overview of the Mapping Debugger Initializing a Mapping Debugging Session Preparing the testing environment and test data Setting breakpoints and watch points Evaluating the flow of data to detect mapping errors ENHANCING ETL PERFORMANCE Performance Tuning at Various Levels Performance-Related Parameters in ETL Design Configuring Mappings for Operating Modes, DML Error Logging, Commit Control, and Default Audit Levels Enabling Partition Exchange Loading (PEL) for Targets Performance-Related Parameters in Schema Design Configuring Indexes, Partitions, Constraints Enabling Parallelism and Parallel DML Setting Tablespace Properties and Gathering Schema Statistics MANAGING BACKUPS, DEVELOPMENT CHANGES, AND SECURITY Overview of Metadata Loader Utilities (MDL) Managing Metadata Changes by Using Snapshots Using Change Manager Version Management of Design Objects Graphical UI for Security Management Object-Level Security Setting Security Parameters INTEGRATING WITH ORACLE BUSINESS INTELLIGENCE ENTERPRISE EDITION (OBI EE) Business Justification: Tools Integration Integrating with OBI EE and OBI SE Transferring BI Metadata to OBI EE Server Setting Up the UDML File Location Deriving the BI Metadata (OBI EE) Deploying the BI Module Converting the UDML File for OBI EE Oracle BI Admin and Answers Tool APPENDIX B: CREATING EXPERTS Harnessing OWB Power and Complexity for New Users OWB "Experts": Directed Guidance and Knowledge Management Creating an Expert Starting an Expert Creating Your Own Custom Dialog Scenario: ROLAP to MOLAP in Five Easy Steps Scenario: Expert for Creating External Table APPENDIX C: USING DIAGNOSIS AND DEBUGGING TECHNIQUES Collecting Information Before Contacting Oracle Support Sequence Used by Oracle Support Representatives to Process Calls Activating Debugging and Logging for Full Java Debug Trace Activating Tracing Using the Service_Doctor.sql Script Troubleshooting and Diagnosing Errors in Control Center Agent (CCA) Run-Time Views and Utilities Online Warehouse Builder Resources

Type Tutoring Overview of Site Recovery Manager VMware infrastructure Supports Site Recovery Manager Site Recovery Manager Features Site Recovery Manager Requirements Site Recovery Manager Environment Array-Based Replication Site Recovery Manager Process Overview Install SRM Set Up the Protected and Recovery Sites Configure Virtual Machines System Requirements Prerequisites for SRM Installation SRM Hardware and Software Requirements SRM Database Requirements Microsoft SQL Server Configuration Oracle Server Configuration Configuration Maximums SRM Licensing Import License Files Installing or Updating Site Recovery Manager Install Site Recovery Manager Update Site Recovery Manager Install the Site Recovery Manager Plug-In Updating Database Credentials Reverting to aPrevious Release Site Recovery Manager Administration Guide 4 VMware, Inc. Managing SRM Use the VI Client to Manage SRM Connecting the Protected and Recovery Sites Credential-Based Authentication Certificate-Based Authentication SRM Users, Groups, Permissions, and Roles SRM Permissions SRM Default Roles Add Roles Assign Virtual Center Access Permissions Add a New User Group and Role to SRM Change Access Permissions Remove Access Permissions Access SRM Log Files Protected Site Configuration Configure the Protected Site

Type Tutoring Vmware site recovery manager online training from Hyderabad Overview of Site Recovery Manager VMware infrastructure Supports Site Recovery Manager Site Recovery Manager Features Site Recovery Manager Requirements Site Recovery Manager Environment Array-Based Replication Site Recovery Manager Process Overview Install SRM Set Up the Protected and Recovery Sites Configure Virtual Machines System Requirements Prerequisites for SRM Installation SRM Hardware and Software Requirements SRM Database Requirements Microsoft SQL Server Configuration Oracle Server Configuration Configuration Maximums SRM Licensing Import License Files Installing or Updating Site Recovery Manager Install Site Recovery Manager Update Site Recovery Manager Install the Site Recovery Manager Plug-In Updating Database Credentials Reverting to aPrevious Release Site Recovery Manager Administration Guide 4 VMware, Inc. Managing SRM Use the VI Client to Manage SRM Connecting the Protected and Recovery Sites Credential-Based Authentication Certificate-Based Authentication SRM Users, Groups, Permissions, and Roles SRM Permissions SRM Default Roles Add Roles Assign Virtual Center Access Permissions Add a New User Group and Role to SRM Change Access Permissions Remove Access Permissions Access SRM Log Files Protected Site Configuration Configure the Protected Site

Type Computer A layer can be thought of as a large piece of clear plastic, as infinitely large as the drawing area in Autocad. When drawing in Autocad, everything is drawn on the default layer which is set current. Only the objects you are drawing are visible on the layer, the layer itself can never be seen - it is invisible. Each new layer is created by you, the user.Normally, it is acceptable to have a layer for each different part of a drawing. The layers created for a simple house plan could be as follows: Wall_External Wall_Internal Doors Windows Fittings Text_Notes Dimensions The separate lines and shapes representing each part of the house would be arranged on its relevant layer above. Each layer could be assigned its own colour so that everything drawn on that layer appeared the same colour. Learn it clearly on FU-VISION Only!!!! PLS CONTACT FOR MORE DETAILS CALL IMMEDIATE: MADURAI OFFICE ADDRESS: FU-VISION No-401,RAJAN COMPLEX, NO:56,TAMIL SANGHAM ROAD,SIMMAKKAL MADURAI –

Type Computer Autocad. When drawing in Autocad, everything is drawn on the default layer which is set current. Only the objects you are drawing are visible on the layer, the layer itself can never be seen - it is invisible. Each new layer is created by you, the user.Normally, it is acceptable to have a layer for each different part of a drawing. The layers created for a simple house plan could be as follows: Wall_External Wall_Internal Doors Windows Fittings Text_Notes Dimensions The separate lines and shapes representing each part of the house would be arranged on its relevant layer above. Each layer could be assigned its own colour so that everything drawn on that layer appeared the same colour. Learn it clearly on FU-VISION Only!!!! PLS CONTACT FOR MORE DETAILS CALL IMMEDIATE: MADURAI OFFICE ADDRESS: FU-VISION No-401,RAJAN COMPLEX, NO:56,TAMIL SANGHAM ROAD,SIMMAKKAL MADURAI –

Type Tutoring The Best OWB Online Training Institute From Hyderabad, India Course Content: INSTALLING AND SETTING UP THE WAREHOUSE BUILDER ENVIRONMENT What Is Oracle Warehouse Builder? Basic Process Flow of Design and Deployment Oracle Warehouse Builder Licensing and Connectivity Options Installing Oracle Warehouse Builder 11.2 OWBSYS Schema Using OWB 11.2 with Database 10g R2 Using the Repository Assistant to Manage Workspaces Supported operating systems (OS), sources, targets, and optional components GETTING STARTED WITH WAREHOUSE BUILDER Logging In to OWB Design Center Overview of the Design Center OWB Projects Overview of Objects within a Project Overview of Objects within an Oracle Module Organizing Metadata Using Foldering Locations Navigator and Globals Navigator panels Setting Projects Preferences: Recent Logons UNDERSTANDING THE WAREHOUSE BUILDER ARCHITECTURE Warehouse Builder Development Cycle Overview of the Architecture for Design, Deployment, Execution Overview of Configurations, Control Centers, and Locations Creating Target Schemas Registering DB User as an OWB User Roles and Privileges of Warehouse Builder Users Registering an Oracle Workflow User DEFINING SOURCE METADATA Data warehouse implementation: Typical steps Difference Between Obtaining Relational and Flat File Source Metadata Creating Flat File Module Sampling Simple Delimited File Sampling Multi-record Flat File Creating an Oracle Module Selecting the Tables for Import DEFINING ETL MAPPINGS FOR STAGING DATA Purpose of a Staging Area Define OWB Mappings Mapping Editor Interface: Grouping, Ungrouping, and Spotlighting Creating External Tables Create and Bind process Levels of Synchronizing Changes Using the Automapper in the Mapping Editor Set loading type and target load ordering USING THE DATA TRANSFORMATION OPERATORS Component Palette Using a Joiner Lookup Operator: Handling Multiple Match Rows Using the Subquery Filter Operator Using the Set, Sequence, and Splitter Operators Pivot and Unpivot Operators Using the Aggreagator, Constant, Transformation, and Pre/Post Mapping Operators Deploying and Executing in Projects Navigator Panel CLEANSING AND MATCH-MERGING NAME AND ADDRESS DATA Integrating Data Quality into ETL Name and Address Data Cleansing Name and Address Server Name and Address Software Providers Settings in the Name and Address Operator Reviewing a Name and Address Mapping Consolidating Data Using the Match Merge Operator Using the Match Merge Operator in a Mapping USING PROCESS FLOWS Process Flow Concepts Creating a Process Flow Module, a Process Flow Package and a Process Flow Types of Activities: Fork, And, Mapping, End Activity Creating Transitions Between Activities Some More Activities: Manual, SQLPLUS, Email Generating the Process Flow Package DEPLOYING AND REPORTING ON ETL JOBS Logical Versus Physical Implementation Setting Object Configuration Deployment Concepts Invoking the Control Center Manager Deploy Options and Preferences Repository Browser Starting OWB Browser Listener and the Repository Browser Browsing Design Center and Control Center Reports USING THE MAPPING DEBUGGER Overview of the Mapping Debugger Initializing a Mapping Debugging Session Preparing the testing environment and test data Setting breakpoints and watch points Evaluating the flow of data to detect mapping errors ENHANCING ETL PERFORMANCE Performance Tuning at Various Levels Performance-Related Parameters in ETL Design Configuring Mappings for Operating Modes, DML Error Logging, Commit Control, and Default Audit Levels Enabling Partition Exchange Loading (PEL) for Targets Performance-Related Parameters in Schema Design Configuring Indexes, Partitions, Constraints Enabling Parallelism and Parallel DML Setting Tablespace Properties and Gathering Schema Statistics MANAGING BACKUPS, DEVELOPMENT CHANGES, AND SECURITY Overview of Metadata Loader Utilities (MDL) Managing Metadata Changes by Using Snapshots Using Change Manager Version Management of Design Objects Graphical UI for Security Management Object-Level Security Setting Security Parameters INTEGRATING WITH ORACLE BUSINESS INTELLIGENCE ENTERPRISE EDITION (OBI EE) Business Justification: Tools Integration Integrating with OBI EE and OBI SE Transferring BI Metadata to OBI EE Server Setting Up the UDML File Location Deriving the BI Metadata (OBI EE) Deploying the BI Module Converting the UDML File for OBI EE Oracle BI Admin and Answers Tool APPENDIX B: CREATING EXPERTS Harnessing OWB Power and Complexity for New Users OWB "Experts": Directed Guidance and Knowledge Management Creating an Expert Starting an Expert Creating Your Own Custom Dialog Scenario: ROLAP to MOLAP in Five Easy Steps Scenario: Expert for Creating External Table APPENDIX C: USING DIAGNOSIS AND DEBUGGING TECHNIQUES Collecting Information Before Contacting Oracle Support Sequence Used by Oracle Support Representatives to Process Calls Activating Debugging and Logging for Full Java Debug Trace Activating Tracing Using the Service_Doctor.sql Script Troubleshooting and Diagnosing Errors in Control Center Agent (CCA) Run-Time Views and Utilities Online Warehouse Builder Resources

Oracle Identity and Access Management 11g R1  Complete practical approach, right from installation to configuration and admin(Hands on approach)  All configuration documents, so that you can implement on your own.  Topic Explanation followed by practical demonstration.  Complete Suite Implementation (OAM, OIM, OID), RCU, Webgate, OHS, BI Publisher, ODSEE, Custom Applications. 1) OAM 11g - Around 30+ hours • Oracle Identity and Access Management Suite 11g Component Overview (OAM, OIM, OID, OVD, ODSM, OAAM) • Installation and configuration of Oracle Access Manager(DB, RCU, Weblogic, OAM, OID) • OHS 11g installation • Configuration of OHS 11g Instances • Installation of OAM 11g WebGate11gR2 • Create a New Domain and Configure the OAM Server • Configuring Database Security Store for the Domain • Register the OAM 11g R2 WebGate with OAM 11g R2 Server • Working with WLS Embedded LDAP Directory and Default OAM User Identity Store • Configuring and working with OID as the New Identity Store for OAM • Creating OID Authenticator • Making Use of OID as the User Store for OAM Authentication • Deploying Custom Application • Unprotect and protect the application • Configuring Single Sign On for the deployed application. • Managing resources, Authentication Policies, Authorization Policies. • Managing constraint. • Single Sign-On and Session Management • Customizing the login page. • Demonstrating the Single Sign on • Observing Cookies. • Working with Identity Constraint, Authentication Schemes • Session Management • Customize Login Page 2) OIM 11g - Around 30+ Hours • OIM 11g Overview • Will cover all latest topic of OIM11gR2 with practical demonstration(Application Instance, Sandboxes(Sandbox import/Export) and Checkout/Cart,Scheduled Jobs, Lookup Configuration, Creating Entitlement, Password Policy) • Installation of Oracle Identity Manager Suite/ SOA Suite / OUD Server(As sample application). • Configuring Oracle Identity Manager. • Working with OIM Design Console, Administrative and User Console • create and manage records for organizations, roles, and users • Installing Oracle Directory Server EE, Configuring ODSEE/OUD(creating prefixes, loading sample data) • Importing and using a predefined connector (ODSEE/OUD) for OIM. • Working with Connector • Direct provisioning • Working with auto membership rules and access policies (Auto Provisioning or Criteria Based Provisioning) • Modifying provisioning process. • Working with provisioning process. • Working with workflow approvals, creating/modifying approval policies, request templates and managing requests created by a user. • Working with JDeveloper - Deploy and Register Custom SOA Composites • Working with requests. • Implementing authoritative and account reconciliation workflows for OIM. • Managing user access in OIM. • Working with authorization policies. • OIM - Admin and troubleshooting. Approach for both OIM and OAM is, take sample applications and demonstrate how things work in an enterprise.

Type Computer We ATS-Accent Techno Soft India (MNC), is a part of Ascent Technologies USA, concentrate on high end software training, which gives real time exposure. We are in need of skilled IT Graduates for our own concern & our clients, In spite of technical knowledge fulfillment we give technology training also. What is LAMP??? Linux, Apache, MySQL and PHP, an open-source Web development platform, also called a Web stack, that uses Linux as the operating system, Apache as the Web server, MySQL as the RDBMS and PHP as the object-oriented scripting language. Information Technology Services, in response to requests for a cost effective way for departments to run their own, secure, web-based applications, provides a range of "LAMP" (Linux, Apache, MySQL, PHP) service options for web hosting. Short for LAMP has become a de facto development standard. Today, the products that make up the LAMP stack are included by default in nearly all Linux distributions, and together they make a powerful web application platform. PHP is a reflective programming language originally designed for producing dynamic web pages... For Further Details. Angeline– Accent Techno Soft #203,Nehru street,Ramnagar, Gandhipuram,Coimbatore-