Training file

BASE SAS MODULES Day 1: Introduction to the SAS System Components of Base SAS Software Output Produced by the SAS System Ways to Run SAS Programs Running Programs in the SAS Windowing Environment Introduction to DATA Step Processing The SAS Data Set introduction How the DATA Step Works: A Basic Introduction Supplying Information to Create a SAS Data Set Introduction to Raw Data Examine the Structure of the Raw Data: Factors to Consider Reading Unaligned Data Reading Data That Is Aligned in Columns Reading Data That Requires Special Instructions Reading Unaligned Data with More Flexibility Mixing Styles of Input Day 2: Introduction to Beyond the Basics with Raw Data Using INFILE statement and various options. Testing a Condition before Creating an Observation Creating Multiple Observations from a Single Record Reading Multiple Records to Create a Single Observation Problem Solving: When an Input Record Unexpectedly Does Not have enough values Day 3: Introduction to Starting with SAS Data Sets Understanding the Basics Input SAS Data Set for Examples Reading Selected Observations Reading Selected Variables Creating More Than One Data Set in a Single DATA Step Using the DROP=, KEEP= and WHERE= Data Set Options for Efficiency Introduction to DATA Step Processing Input SAS Data Set for Examples Adding Information to a SAS Data Set Defining Enough Storage Space for Variables Conditionally Deleting an Observation Day 4: Introduction to Working with Numeric Variables About Numeric Variables in SAS Input SAS Data Set for Examples Calculating with Numeric Variables Comparing Numeric Variables Storing Numeric Variables Efficiently Numeric Functions. Day 5: Introduction to Working with Character Variables Input SAS Data Set for Examples Identifying Character Variables and Expressing Character Values Handling Missing Values Creating New Character Values Saving Storage Space by Treating Numbers as Characters Character Functions Day 6: Introduction to Acting on Selected Observations Input SAS Data Set for Examples Selecting Observations Constructing Conditions Comparing Characters Introduction to Creating Subsets of Observations Input SAS Data Set for Examples Selecting Observations for a New SAS Data Set Conditionally Writing Observations to One or More SAS Data Sets Day 7: Introduction to Working with Grouped or Sorted Observations Input SAS Data Set for Examples Working with Grouped Data Working with Sorted Data Introduction to Using More Than One Observation in a Calculation Input File and SAS Data Set for Examples Accumulating a Total for an Entire Data Set Obtaining a Total for Each BY Group Writing to Separate Data Sets Using a Value in a Later Observation Day 8: Introduction to Using More Than One Observation in a Calculation Input File and SAS Data Set for Examples Accumulating a Total for an Entire Data Set Obtaining a Total for Each BY Group Writing to Separate Data Sets Using a Value in a Later Observation Introduction to Working with Dates Understanding How SAS Handles Dates Input File and SAS Data Set for Examples Entering Dates Displaying Dates Using Dates in Calculations Using SAS Date Functions Comparing Durations and SAS Date Values Day 9: Introduction to Combining SAS Data Sets Definition of Concatenating Definition of Interleaving Definition of Merging Definition of Updating Definition of Modifying 237 Comparing Modifying, Merging, and Updating Data Sets Day 10: Introduction to Concatenating SAS Data Sets Concatenating Data Sets with the SET Statement Concatenating Data Sets Using the APPEND Procedure Choosing between the SET Statement and the APPEND Procedure. Introduction to Interleaving SAS Data Sets Understanding BY-Group Processing Concepts Interleaving Data Sets Day 11: Introduction to Merging SAS Data Sets Understanding the MERGE Statement One-to-One Merging Match-Merging Choosing between One-to-One Merging and Match-Merging Introduction to Updating SAS Data Sets Understanding the UPDATE Statement Understanding How to Select BY Variables Updating a Data Set Updating with Incremental Values Understanding the Differences between Updating and Merging Handling Missing Values Day 12: Input SAS Data Set for Examples Modifying a SAS Data Set: The Simplest Case Modifying a Master Data Set with Observations from a Transaction Data Set Understanding How Duplicate BY Variables Affect File Update Handling Missing Values Introduction to Conditional Processing from Multiple SAS Data Sets Input SAS Data Sets for Examples Determining Which Data Set Contributed the Observation Combining Selected Observations from Multiple Data Sets Performing a Calculation Based on the Last Observation Day 13: Introduction to Analysing Your SAS Session with the SAS Log Understanding the SAS Log Locating the SAS Log Understanding the Log Structure Writing to the SAS Log Suppressing Information to the SAS Log Changing the Log’s Appearance Introduction to Directing SAS Output and the SAS Log Input File and SAS Data Set for Examples Routing the Output and the SAS Log with PROC PRINTTO Storing the Output and the SAS Log in the SAS Windowing Environment Redefining the Default Destination in a Batch or Non interactive Environment Introduction to Diagnosing and Avoiding Errors Understanding How the SAS Supervisor Checks a Job Understanding How SAS Processes Errors Distinguishing Types of Errors Diagnosing Errors Using a Quality Control Checklist Day 14: Introduction to Creating Detail and Summary Reports with the REPORT Procedure Understanding How to Construct a Report Input File and SAS Data Set for Examples Creating Simple Reports Creating More Sophisticated Reports Day 15: Introduction to Proc means Deriving descriptive statistics Introduction to Proc univariate and various options Day 16: Introduction to Proc freq Calculating counts using Freq Outputting the counts into a dataset Proc Transpose introduction Using VAR, ID and BY statement efficiently in transpose Reshaping the data with required variables Day 17: Introduction to Producing Charts to Summarize Variables Understanding the Charting Tools Input File and SAS Data Set for Examples Charting Frequencies with the CHART Procedure Customizing Frequency Charts Creating High-Resolution Histograms Day 18: Introduction to Writing Lines to the SAS Log or to an Output File Understanding the PUT Statement Writing Output without Creating a Data Set Writing Simple Text Introduction to the Basics of Understanding and Customizing SAS Output Understanding Output Input SAS Data Set for Examples Locating Procedure Output Making Output Informative Controlling Output Appearance Controlling the Appearance of Pages Representing Missing Values Day 19: Introduction to Customizing SAS Output by Using the Output Delivery System Input Data Set for Examples Understanding ODS Output Formats and Destinations Selecting an Output Format Creating Formatted Output Day 20: Proc Format introduction Creating format catalogue Converting catalogue to dataset Storing formats permanently and finding out formats in a library Accessing a Permanent SAS Data Set with User-Defined Formats ADVANCED SAS MODULES Day 21: Getting Started with the Macro Facility Replacing Text Strings Using Macro Variables Generating SAS Code Using Macros More Advanced Macro Techniques Other Features of the Macro Language Introduction to SAS Programs and Macro Processing How SAS Processes Statements without Macro Activity How SAS Processes Statements with Macro Activity Introduction to Macro Variables Macro Variables Defined by SAS Macro Variables Defined by Users Using Macro Variables Displaying Macro Variable Values Referencing Macro Variables Indirectly Manipulating Macro Variable Values with Macro Functions Introduction to Macro Processing Defining and Calling Macros How the Macro Processor Compiles a Macro Definition How the Macro Processor Executes a Compiled Macro Summary of Macro Processing Day 22: Introduction to the Scopes of Macro Variables Global Macro Variables Local Macro Variables Writing the Contents of Symbol Tables to the SAS Log How Macro Variables Are Assigned and Resolved Introduction to Macro Expressions Defining Arithmetic and Logical Expressions How the Macro Processor Evaluates Arithmetic Expressions Day 23: Introduction to Macro Quoting Deciding When to Use a Macro Quoting Function and Which Function to Use Using Various Macro Functions %STR and %NRSTR Functions etc Using the %BQUOTE and %NRBQUOTE Functions Referring to Already Quoted Variables Deciding How Much Text to Mask with a Macro Quoting Function Using %SUPERQ Summary of Macro Quoting Functions and the Characters They Mask Unquoting Text How Macro Quoting Works Other Functions That Perform Macro Quoting Day 24: Introduction to Storing and Reusing Macros Saving Macros in an Auto call Library Saving Macros Using the Stored Compiled Macro Facility General Macro Debugging Information Troubleshooting Your Macros Debugging Techniques Introduction to Writing Efficient and Portable Macros Keeping Efficiency in Perspective Writing Efficient Macros Writing Portable Macros PROJECT CONTENT COVERED Day Creation of Efficacy tables. Creation of Standard and safety tables. Day 28 Creation of listings Day Creation of Graphs a)Bar Charts b)Scatter plot c)Line plot d)Box plot Day 31 Creation of Analysis datasets/derived datasets Day 32 Introduction to SDTM CRF Annotation (ONLY BASICS) Introduction to mapping specification (ONLY BASICS) Introduction to SDTM dataset Creation (ONLY BASICS) Validation in Open CDISC (ONLY BASICS) Day 33 Introduction to ADAM Standards (ONLY BASICS) Mock interview and providing assistance for interview preparation Contact:

Oracle ADF Training in Hyderabad@Sadguru Technologies Oracle ADF Training Outline • Introduction to Oracle 11g ADF o What is Oracle ADF? o MVC architecture o Benefits of ADF o ADF architecture o ADF Faces o JDeveloper tools • Developing ADF applications o Applications and projects o Database connections o Overview of Business components o Steps to create business components o Business Components diagram o Application flow overview • Entity Objects o What is an entity object? o Entity object class diagram o Creating entity objects o Customizing attribute properties o Entity associations o Entity object definition file o Database synchronization, moving, and renaming o Entity diagrams • View objects o What is a view object? o View object class diagram o Steps to create a view object o Bind variables o Query-by-example view criteria o Adding view object instance to application module o Testing view objects o Read-only master-detail tables o Master-detail-detail o Inline detail tables Address: SADGURU TECHNOLOGIES H. No: 7-1-621/10, Flat No: 102, Sai Manor Apartment, S.R. Nagar Main Road, Landmark: Beside Umesh Chandra Statue, Hyderabad-500038, Mob: 91-8179736190,Ph: 040-40154733.

The primary goal of this course is to prepare the students to pass the OCA and OCP exams. This Oracle10g/11g OCP course is designed to provide Oracle professionals /graduates with an in-depth understanding of the DBA concepts and knowledge required for the OCA & OCP exams.This course covers all of the Oracle Database Administration topics including SGA instance management, file & tablespace management, user administration & security table & index management. Exercises are used to demonstrate each feature and the student will gain first-hand experience in the key Oracle DBA concepts required to pass the Oracle OCA & OCP exam. In addition, this course provides sample OCP exam questions and an opportunity to assess your overall knowledge of Oracle DBA concepts. We at DUCAT provide quality training in ORACLE DBA 10g, 11g, 11i and r12 on RHEL/Windows platforms respectively.

Systems Domain provides PHP coaching according to the present precondition of IT market. The course will take you through all you need to know to use PHP in creating an awesome web page. In this PHP coaching we will inform to create PHP web page connected with MySQL databases. PHP appears for Hypertext Preprocessor. It is an HTML-embedded scripting terminology. Much of its framework is obtained from C, Java. The objective of the terminology is to allow web designers to create dynamically designed sites quickly. PHP is a program that allows you create awesome sites. Training Contents of PHP: Overview of PHP Basic Scripting & Looping Constructs PHP Functions PHP Operators Classes & Objects (PHP 5.3) Arrays in PHP File Handling Using Cookies with PHP Miscellaneous PHP Tasks Working with Databases & Forms For any query send me mail........or come down in below address Kind regards Gowda Softwares LLP. , Sir M V Road, Near Bhanu Nursing Home Bommanahalli, Bangalore Contact Person:-Harish sir No:

Websharan Infotech is one of the most reliable and career oriented PHP Training Institute. In Jaipur. PHP is one of the most approachable programming languages that is known for its dynamic contents whether its front end or back end. PHP is easy & favorite programming language for web developers and stands for Hypertext Preprocesser We have best PHP trainer who teach from the basics of PHP and give real time and professional training with Industry standards projects in PHP and MySQL.In our training program you will learn PHP coding, MySQL, jQuery, AJAX, Content Management System (CMS) tools like Joomla, Wordpress, Drupal, PHP real time project and PHP/MySQL training. Websharan Infotech is the oldest Institute providing PHP Training in Jaipur. PHP is a server side scripting language which is used to create dynamic data-base driven websites. Now, be ready to bring your career in the right direction with the best PHP training institute in Jaipur. Our training programme include- HTML (Hyper Text Mark-up Language) CSS (Cascading Style Sheet) PHP Programming MySQL Data Base Java Training File handling, cooking and session handling PHP projects Working on CMS- Wordpress

Hi, Pleasant Greetings from Tstechnologies toevery one.Tstechnologies is providing On Line, Class rooms & weknd trainings with a fully qualified software professionals. If u are interested to join in our Institute can contact us Phne No: 040-

Training in Chennai provides 100% real-time, practical and placement focused Dot Net training in Chennai. Our Dot Net course concentrates from basic level training to advanced level training. Our Dot Net training in completely focused to get placement in MNC in Chennai and certification on Dot Net after completion of our course. Our team of Dot Net trainers are DotNet certified professionals with more real-time experience in live projects. Our Dot Net Course syllabus is enough for anyone who wants to get Dot Net certification which meets industry expectations. In our course plan, you will learn.Net® Framework,C#,Classes & Objects,OOPS,Namespace,Arrays, Collections & Generics,File I/O and Streams,Remoting & Reflection,SQL Server,ADO.NET® (Working with Database),ASP.NET® 4.0,Page Life Cycle,Web Form,Validation Controls,State Management,User Controls,Master Pages & Themes,Uploading Files,Handling Emails,ASP.NET Web Services,Deployment with practical exercises and live examples. We are charging very competitive in the market which helps to bring more Dot Net professionals into this market. Our Dot Net training course fee is very nominal which anyone can pay in instalment basis as well. We are having multiple class timings which suit everyone who wants to learn in their own timings. Our Dot Net training will be scheduled in regular weekdays and weekends based on the students request. We do have fast track Dot Net training and online Dot Net training with one-to-one basis. We are giving more Dot Net training for corporates which employees of their company will be benefits with our training. Venue:Sudha (HR) VR Career Solutions Pvt Ltd,No.73/30, 2nd Floor, Anna Neduchalai, Kandanchavadi,Chennai-600096. Land mark: Near SP Infocity, Opp: Aathi Parasakthi Mandapam.. Mobile No: 9840485300 Land Line No: 044-24967404.

Training in Chennai provides 100% real-time, practical and placement focused Dot Net training in Chennai. Our Dot Net course concentrates from basic level training to advanced level training. Our Dot Net training in completely focused to get placement in MNC in Chennai and certification on Dot Net after completion of our course. Our team of Dot Net trainers are DotNet certified professionals with more real-time experience in live projects. Our Dot Net Course syllabus is enough for anyone who wants to get Dot Net certification which meets industry expectations. In our course plan, you will learn.Net® Framework,C#,Classes & Objects,OOPS,Namespace,Arrays, Collections & Generics,File I/O and Streams,Remoting & Reflection,SQL Server,ADO.NET® (Working with Database),ASP.NET® 4.0,Page Life Cycle,Web Form,Validation Controls,State Management,User Controls,Master Pages & Themes,Uploading Files,Handling Emails,ASP.NET Web Services,Deployment with practical exercises and live examples. Venue:Sudha (HR) VR Career Solutions Pvt Ltd,No.73/30, 2nd Floor, Anna Neduchalai, Kandanchavadi,Chennai-600096. Land mark: Near SP Infocity, Opp: Aathi Parasakthi Mandapam.. Mobile No: 9840485300 Land Line No: 044-24967404.

Training Courses at TuffGeekers are designed to help you master practical mobile & web, design and development skills. These are vital skills required to not only become a successful Developer or Designer but to also be competitive in today’s world. Courses Offered: Android | iPhone | PHP | Software Testing | Web Designation | BDE Eligibility: B.Tech/B.E/Diploma/MCA/Msc (IT). Contact: ( Why TuffGeekers? In-house Placement Options. Live experience of working with the industry team. Training provided by IT company. Projectors in each Class room and Wi-Fi Labs. 100% Job Assistance. Trainers with several years of experience. High quality reference material for accelerated learning. About Tuff Geekers: Tuff Geekers Web Solutions is specialized in designing, developing and delivering high quality software solutions for Mobile devices. We are expert in Android, iPhone, Web Designing & Development and Multimedia application development. We provide Java, Android, objective C, iPhone, C/C++, Web Designing & Development, Multimedia (audio/video compression & processing, file formats...) trainings for beginners, working professionals and corporate. Thanks & Regards, Training Department Tuff Geekers Web Solutions SCF ,Phase 10,Mohali,Punjab Mob: ,(

Training provided in Hardware Course with fully practical oriented and real time work Nature. After completion of course you can work in hardware environment or you can start your own service centre. Classed conducted in fully practical and demo session Course covers Hardware Fundamentals About components Assembling of pc Bios setup Operating system installation Device Driver installation Software installation and un-installation Antivirus installation and updation preparation of hard disk using third party tool Creating Os drive as image file and restoring Trouble shooting Course duration: 30 Hrs Fees Rs offer fees: Rs contact BIT, Triplicane

CSDT Patna is leading PHP Web Training Center or Institute in Patna, Bihar, India.CSDT provides Websites Development training courses/tutorial in PHP.PHP Based Summer training, 6 months project based training,6(six) weeks summer training programme, website development Training. CSDT Qiuck lunch Online PHP Based Courses in patna. CSDT IT Solution is first PHP Based Training Institute, web Training,Industrial Training,Live Project.CSDT Provides Live Project Training for MCABCAB.tech and Other Students. csdt centre is Best PHP website development training institute in Patna bihar India. PHP Training in Patna CSDT PHP/MySql,Web Designing Training in Patna Web Designing is evergreen technologies which will be present our information to the whole web world. Our Web Designing Training in Patna provides End to End support. It’s really an art while creating a full-fledged Website of a client or for a product. If a website’s design is not up-to the standard it will get very minimum impact to the specific audience. Our Trainers for Web Designing is famous freelancers and corporate experts. They are working for companies and they know the international standards in web designing. By using the experience of them anyone can learn the basic to complex level website designing in short time period. After getting enough knowledge in static designs we started to train the students in dynamic languages. We chose PHP and MySQL for that. Reason for that is simple. PHP is the most powerful front end dynamic language in this world. So, by using PHP Training our students convert the static designs into dynamic websites. MySQL is a perfect open source RDBMS which will use by most web applications. Our Web Designing Training in Patna combined both PHP and MySQL in static pages to build a complete Dynamic application. We trained the students to work with MySQL to build a custom CMS. Web Design is not just creating web pages to display some image and content. We have to analyse the purpose of that website first. After reviewing the purpose we can have an idea about what we are going to do with that website. Then we have to mix the perfect composition of ideas and creativity into that to build a solid new website for clients. Each a every project should be unique. CSDT centre are the Best Web Designing Training Institute in Patna with complete structured syllabus.Web Designing Training is combination of both design and development of a website. CSDT Web Designing Training Syllabus covers from basic introduction of web to the perfect dynamic creation of CMS [Content Management System] using PHP. CSDT PHP Syllabus Web Designing:-(HTML,CSS,JAVASCRIPT,JQUERY,AJAX,XML,PHOTOSHOP) PHP Introduction The Origin of PHP, PHP is better than Its alternatives,Interfaces to External systems,Hardware and Software requirements,What a PHP Script Looks Like,Web Designing Basics and WYSIWYG Editor,Receiving User Input,Repeating Code Basic PHP Development How PHP scripts work,Basic PHP syntax,PHP data types,Google Caffeine,displaying type information,Testing for a specific data type, Changing type with Set type,Operators,Variable manipulation,Dynamic variables,Static vs. Dynamic Optimization,Analytics, Analysis and ROI Concept String Manipulation Formatting String for Presentation,Formatting String for Storage,Joining and Splitting String,Comparing String,Matching and replace Substring Control Structures If(), else if() and else if condition Statement,The switch statement,Using the ? operator,Using the while() Loop,The do while statement,Using the for() Loop,Breaking out of loops,Nesting loops Functions What a function,Creating a function,Returning value from function,User-defined functions,Dynamic function calls,Variable scope,Accessing variable with the global statement,Function calls with the static statement,Setting default values for arguments,Passing arguments to a function by value,Passing arguments to a function by reference,Testing for function existence Arrays,Single-Dimensional Arrays,Multidimensional Arrays,Associative arrays,Accessing arrays,Getting the size of an array,Looping through an array,Looping through an associative array,Examining arrays,merging arrays,Sorting arrays,Sorting an associative arrays Working With The File System Creating and deleting a file,Reading and writing text files,Working with directories in PHP,Checking for existence of file,Determining file size,Opening a file for writing, reading, or appending,Writing Data to the file,Reading characters Working With Forms Forms,Super global variables,Super global array,A script to acquire user input,Importing user input,Accessing user input,Combine HTML and PHP code,Using hidden fields,Redirecting the user,File upload and scripts,Delete a File Working With Regular Expressions The basic regular expressions,Matching patterns,Finding matches,Replace patterns Classes And Objects Object oriented concepts,Define a class,Class attributes,An Object,Creating an object,Object properties,Object methods,Object constructors and destructors,Class constants,Static method,Class inheritance,Abstract classes,Final keyword,Implementing Interface,Object serialization,Understanding Advance and New,Checking for class and method existence,Iterators Introduction To Database What is RDBMS technology?,Introduction to SQL,Connecting to the MYSQL,Selecting a database,Adding data to a table,Displaying returned data on Web pages,Finding the number of rows,Looping through database,Inserting data,Deleting data,Entering and updating data,Executing multiple queries,Understanding Primary and Foreign Keys,Understanding Database Normalization,Dealing with Dates and Times Cookies What is a Cookie?,Setting time in a cookie with PHP,Deleting a cookie,Creating session cookie,Working with the query string Session what is session?,Starting a session,Registering Session variables,working with session variables,destroying session,passing session Ids,encoding and decoding session variables,How to increase session expire time,How to work session without cookie? Advance PHP techniques Introduction about FTP/SMTP server,Math functions,File upload,File Download,E-mail with PHP,PHP configuration file,Error tacking and debugging JavaScript (Jquery) Introduction to JavaScript,Form validation using JavaScript,Email validation using JavaScript,Jquery Introduction to XML and its use. AJAX (Asynchronous JavaScript and XML) Introduction to AJAX,Introduction to XMLHttpRequest Object,Method and Properties of XMLHttpRequest,Application of AJAX in web application FrameWork Basic Concepts of Framework,Basic Concept of Code Igniter OsCommerce (Open Source Shopping Cart) Introduction to Shopping Cart,Introduction to osCommerce opensource,Discussion of various module of osCommerce

Type Computer Softgen Infotech located in BTM Layout, Bangalore is a leading training institute providing real-time and placement oriented Oracle Apps Training Courses in bangalore. Our Oracle Apps training course includes basic to advanced levels. we have a team of certified trainers who are working professionals with hands on real time Oracle Apps projects knowledge which will provide you an edge over other training institutes. Our Oracle Apps 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 Oracle Apps 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 Oracle Apps Training course content and syllabus based on students requirements to achieve everyone's career goal. Our Oracle Apps 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 Oracle Apps Training in our centres located across bangalore. We also provide Online Training Classes for Oracle Apps Training Course. Contact us today to schedule a free demo and complete course details on Oracle Apps Training Course. What is Oracle Apps Training ? Introduction to ERP Definition of ERP, Overview of popular ERP S Comparison of Oracle Apps with other ERP S Types of Roles Types of Projects AIM documentation standards Oracle Application Architecture. Database structure of OA Using TOAD Application Object Library Creating Users WHO columns Creating Responsibilities Request group construction Application development Defining concurrent program Concurrent programs with parameters Working with multiple concurrent programs Scheduling the Concurrent Program Concurrent Program incompatibilities Creating Request Set Procedure registration Value sets Value sets Overview of value sets Options in value sets Types of value sets Creation of value set Overview of value set tables Registration of Custom Objects Registration of Application Report development Report registration Parametric report registration Registration of a Table Registration of Sql, Sql Loader, PL/SQL programs Report Development: Customization of Reports – Adding DFF Info Customization of Reports – Removing Parameters Flexfields Report with Single Structure Report Coding Standards User Exits in Report design Customization of Reports – Adding Parameters Customization of Reports – Adding Logos Discoverer Administration Edition: Creating a end user layer database user Connecting to discoverer administrator, using the load wizard and the work area Modifying the Business Area Working with Custom Folders Creating Joins Customizing Items Designing a complex Folder Discoverer User Edition: Creation of Simple Workbook To design parameterized workbook To change Heading items To insert new sheet in the Workbook To add and remove items from Workbook To create duplicate sheet in Workbook To add title to the Worksheet To insert date, time, page numbers and image on Header/Title of Workbook To apply Conditional Formatting Interfaces Introduction to Interfaces Outbound Interfaces Using UTL_FILE package Inbound Interfaces Using SQL * Loader tool / dynamic table for files read(New concept) SQL * Loader Concepts Data File. Control File. Bad File. Discard File. Log File. Commands in Sql * Loader Registration Of control File in Oracle Apps. Conversions Overview on conversions Difference between Interfaces and conversions Working with staging table script Developing validations package Standards to be followed in conversions Flex Fields Overview of flex fields Types of Flex Fields Descriptive Flex Fields Key Flex Fields Step in creation of DFF Flex fields tables and relations Profiles Overview of profile options Different levels in Setting profiles Steps in setting a profile option Some important profile options Some important API’s of profiles Multi Org Concepts What is Multi Org and why we need. Multi Org Tables. Multi Org Views. PO Overview and tables Overview of purchasing Major setups and transactions Overview of some purchasing tables INV Overview and Tables Overview of inventory Major setups and transactions Overview of some INV Tables OM Overview and Tables Overview of order management Major setups and transactions Overview of some Order Management Tables GL Overview and Tables Overview of GL Major setups and transactions Overview of some GL tables AP Overview and tables Overview of payables Major setups and transactions Overview of some payable tables Alerts Overview on alerts Types of alerts Creation of alerts Workflows Introduction to workflow Workflow builder Attributes Creating Processes XML Publisher Introduction to XML Publisher Generating XML file using reports Creating Templates Creating Data Definitions Oracle Apps Training Course Details Duration:45 Hours Version:latest Version Regular: 1 Hour per day Fast Track: 3 - 4 Hours per day: 12 days Weekdays:Monday - Friday Weekend:Saturday and Sunday Online Training:Available Class Room Training: Not Available Course Fee: Talk to our Customer Support Mode of Payment:Talk to our Customer Support

We are the best Filenet training in Chennai and we are having experienced trainers. We offer world class training to our students. We can arrange for both week days and week end classes. We are the leading training institute in Chennai when compared to other training institute. We offer practical oriented classes rather theoretical classes. WHY PERIDOT? • Excellent lab infrastructure • Feasible cost • Limited batch size • LCD equipped classroom • Fast response • Real time trainers • Latest technologies offered in our institute • System is provided for each individual • Interactive classes • Free lab access upto 6months FILENET File Net presented a more "open" adaptation of its WorkFlo Business System programming, the Series 6500,that kept running on the IBM RS/6000 stage and the AIX working framework. SYLLABUS OF FILENET • File net process engine • File net applications • File net content engine • File net BPF • Developing struts • File net P8 marking sets • Installing file net • File net P8 5.1 released WEBSITE: www.peridotsystems.in CONTACT NO: 8056102481 MAIL ID: papitha.v@peridotsystems.in

AIX SYSTEM ADMINISTRATION Duration: (60 Days) Course sketch 1st WEEK Introduction to AIX operating system Basic commands of AIX User Management Group Management  Device Configuration in AIX operating system level Introduction to Software packaging in AIX Installing and removing the software’s in operating system level Fix (or) patch installation in operating system Types of installation in AIX operating system Installation of AIX operating system(OS) Boot process of AIX operating system 2nd WEEK Introduction to logical volume manager(LVM) Working with physical volumes(PV) Creating and increasing and decreasing the volume groups(VG) Listing and changing the physical volumes Creating, increasing and decreasing the logical volumes(LV) Listing the logical volumes Introduction to file system management Creating the file system in operating system(OS) Increasing and decreasing the file system Displaying the file systems Creation of compressed file systems Checking the file system consistency Mounting and unmounting the file systems 3rd WEEK Introduction to paging space Creating the paging space Changing the paging space Listing the paging space Activating and deactivating the paging space Removing the paging space Over view of error logging in AIX operating system Introduction to Backup and restoration Types of backups in operating system Backup of AIX operating system Restoration of AIX operating system Backup of file system Restoration of file system Backup of volume group Restoration of volume group System dumps of AIX operating system 4th WEEK Introduction to System Recourses Controller(SRC) Starting the Daemons Listing the Daemons Stopping and Refreshing the daemons Introduction to Scheduling Adding and listing the scheduling Clear the scheduling jobs Assign user permissions to scheduling Introduction to Network management Configuring the Network interfaces Activation and deactivation of network interfaces Checking the status of network interfaces TCP/IP configuration Route adding the AIX operating system Introduction of Processes Listing the information about processes Changing the priority of processes 5th WEEK Introduction to Network file system(NFS) Configuration of NFS server Configurations of NFS client Mounting and unmounting the NFS file system Disabling the NFS services Introduction to Process management CPU bound Memory Bound Network bound I/O bound Introduction to Object Data Manager(ODM) ODM commands ODM components Changing the attributes values of ODM Location and contents of ODM repository Predefined devices Customized devices System startup and shutdown of AIX operating system 6th WEEK Basic administration of cluster(HACMP) Troubleshooting of hacmp concepts Configuration of 2 node cluster Failover and resource group activities 7th WEEK Basic knowledge of Network Installation Manager Configuration of nim resources Configuration of nim master and nim client Restoration of OS Backup's through nim 8th WEEK Basic Administration of virtualization. Configuration if VIO server Creating the LPAR(Logical Partition) Performing the DLPAR operations For More Details contact us: Elegant It Services contact no:

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.

Oracle Apps Technical Online Training (One to One Online Training) Duration: 25 Sessions, Fee: 25,000 INR Oracle Apps Technical Course Content Introduction to ERP • Definition of ERP • Overview of popular ERP’S • Comparison of Oracle Apps with other ERP’S • AIM documentation standards • Oracle Application Architecture. • Database structure of OA • Using TOAD Types of Roles • Functional Consultant and Roles • Technical Consultant and Roles • Techno-Functional Consultant and Roles • Oracle Application DBA and Roles Application Object Library • System Administration and Application Object Library (AOL) • Defining an Applications User and Assigning the Responsibilities. • Understanding AOL and its Components • WHO columns • Creating Responsibilities • Request group creation • Menu Creation Application development • Defining concurrent program • Concurrent programs with parameters • Working with multiple concurrent programs • Concurrent Program incompatibilities • Creating Request Set • Default Types • Value sets Registration of Custom Objects • Report registration • Registration of a Table • Using AD_DD Package to register Database Component in AOL Interfaces and Conversions • Introduction to Interfaces • Difference Between Interfaces and Conversions • Outbound Interfaces o Using UTL_FILE package • Inbound Interfaces o Using SQL * Loader tool • SQL * Loader Concepts o Data File. o Control File. o Bad File. o Discard File. o Log File. • Working with staging table script • Developing validations package • Standards to be followed in conversions • Using oracle API’s in Interfaces and Conversions • Interface Tables and Error Tables Flex Fields • Overview of flex fields • Types of Flex Fields o Descriptive Flex Fields o Key Flex Fields • Step in creation of DFF • Flex fields tables and relations Profiles • Overview of profile options • Different levels in Setting profiles • Steps in setting a profile option • Some important profile options • Some important API’s of profiles Value sets • Overview of value sets • Options in value sets • Types of value sets • Creation of value set • Overview of value set tables • Usage of $FLEX and $PROFILE Multi Org Concepts • What is Multi Org and why we need. • Multi Org Tables. • Multi Org Viiews. Functional Modules Overview • Overview of Procure to Pay Flow (P2P Cycle) • Overview of Order to Cash Flow (O2C Cycle) • Major setups and transactions • Overview of important tables in PO,INV,OM,AP,AP,GL Reports in Oracle Applications • Introduction and Usage of USER_EXITS. • Developing a Report from scratch as per Client Requirement. • Developing a Report based on MD 50 Document. • Customization of Oracle Standard Reports. • Reports Registration Steps in Oracle Applications • Standards to develop a report in Oracle Apps Forms in Oracle Applications • New Form Development Process • Form Registration in Oracle Applications. • Calling one Form to another Form by using Button • Master-Detailed Forms • Form Personalization in Oracle Applications • Form Personalization v/s Form Customization Development of XML Reports FAQ’S in Oracle Apps Technical

Type Tutoring The Best Abinitio Online Training Institute From Hyderabad,India Course Content: Introduction to Data Warehousing Role of ETL Introduction to Ab Initio Ab Initio Tool Components Architecture of Ab Initio Connectivity between GDE and CO What Ab Initio Programming? Graph Components Graph Components DML – Data Manipulation Language To Prepare the Data (.dat) file Component Layouts Graph Development, Execution and debugging Dataset components Input file Output file Lookup file Intermediate fileInput table Output table Partition Concepts Data parallelism Pipeline parallelism Component parallelism Partition & De-Partition components Broadcast Partition by key Partition by Expression Partition by Percentage Partition by Range Partition by Round-Robin Partition with load balancing De- Partition Components Concatenate Gather Interleave Merge MFS (Multi-File system) MFS file system concepts Difference between serial and MFS file system Introduction to Sub-graphs Parameters and Input parameters Variables, Statements and Business Rules Sort components Sort Sort within groups Sample Find splitter Partition by key and sort Transform Components Aggregate Filter by Expression Roll-up Scan Scan with roll-up Join De-dup Sorted Match- sorted Reformate Multi-reformate Normalize and De-Normalize Database Components Input table Output table Truncate table Update table Join with DB Multi update table Run SQL Compress Components Compress Deflate Inflate Uncompress FTP Components FTP to FTP from Miscellaneous Components Gather Logs Redefine format Replicate Run Program Throttle Trash Generate EME (Enterprise Meta Environment) Tool Introduction and Overview

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

SADGURU TECHNOLOGIES --040- SUN-SOLARIS-10(SA-1) System Administration Paper 1 Pre-Requisites: BASIC UNIX COMMANDS SYSTEM CONCEPTS: Understanding different hosts in Solaris Environment Understanding types of servers and clients in Solaris Environment ADMINISTRATION AND CONFIGURATION OF CDE: Understanding CDE environment on Sun-Solaris Installation of Sun-Solaris on SPARC and INTEL Installation on standalone Network installation FILE SYSTEM: Introduction to file system Understanding different types of file systems Creating a file system using format command Converting the file system to UFS using newfs Mounting and un-mounting file systems Understanding vfstab and mnttab files Inconsistency checking using fsck Troubleshooting file systems with fsck USER ADMINISTRATION: Understanding types of groups Creating groups, modifying and deleting Creating users, modifying and deleting Administration of initialization files and customizing Monitoring of users Understanding password aging Advance file permissions using ACL RBAC with RBAC and administer can assign privileged functions to specific user accounts System security Troubleshooting BOOT PROCESS: Understanding booting process on SPARC & INTEL Understanding commands under OK prompt RUN LEVELS: Understanding different types of run levels Understanding default run level and customizing Understanding R-C scripts Adding and modifying run control scripts (R-C scripts) Understanding different types of shutdown commands Changing the init phases Address: , Flat No: 102, Sai Manor Apartment, Beside Umesh Chandra Statue, S.R. Nagar, Hyderabad, Andhra Pradesh Phone: Hours: Open today · 7:00 am – 9:00 pm

Contact us: +91-, The Best SAP BO Online Training Institute From Hyderabad, India Course Content: Introduction to Data Warehousing Role of ETL Introduction to Ab Initio Ab Initio Tool Components Architecture of Ab Initio Connectivity between GDE and CO What Ab Initio Programming? Graph Components Graph Components DML – Data Manipulation Language To Prepare the Data (.dat) file Component Layouts Graph Development, Execution and debugging Dataset components Input file Output file Lookup file Intermediate fileInput table Output table Partition Concepts Data parallelism Pipeline parallelism Component parallelism Partition & De-Partition components Broadcast Partition by key Partition by Expression Partition by Percentage Partition by Range Partition by Round-Robin Partition with load balancing De- Partition Components Concatenate Gather Interleave Merge MFS (Multi-File system) MFS file system concepts Difference between serial and MFS file system Introduction to Sub-graphs Parameters and Input parameters Variables, Statements and Business Rules Sort components Sort Sort within groups Sample Find splitter Partition by key and sort Transform Components Aggregate Filter by Expression Roll-up Scan Scan with roll-up Join De-dup Sorted Match- sorted Reformate Multi-reformate Normalize and De-Normalize Database Components Input table Output table Truncate table Update table Join with DB Multi update table Run SQL Compress Components Compress Deflate Inflate Uncompress FTP Components FTP to FTP from Miscellaneous Components Gather Logs Redefine format Replicate Run Program Throttle Trash Generate EME (Enterprise Meta Environment) Tool Introduction and Overview

Contact us: Swathi, +91-, 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

A brief history of Unix The Unix kernel The UNIX file system Getting started navigating the file system The file system structure Directories and files Pathnames Navigating the file system Basic Commands Command line syntax Basic file handling commands Directory handling commands Filename wildcard characters Redirection and Pipes Input redirection Output redirection Pipes Introduction to The vi Editor Overview of the vi editor Basic functions Switching to input mode Other useful commands Searching and Replacing Text Replacing text Using the vi editor Using sed for search and replace Searching for text with grep Linking files Recalling and Editing Commands Overview The bash shell The korn shell File Permissions and Access Control Users and user groups File access permissions Changing file attributes Switching users and user groups Linking files Processes What is a process? Monitoring processes Killing processes Background processes Job Control Grouping commands More Basic Commands The wc (word count) command The find command The cut command The sort command The finger command The User Environment Bizsmart solutions India pvt ltd 354,Aswath nagar, varthur road, Marathahalli bridge, opp safal fresh, Marathahalli, Bangalore -

DATASTAGE HANDS-ON LIVE ONLINE TRAINING,CORPORATE TRAINING,INTERVIEW & JOB SUPPORT BY SOFTWARE WORKING PROFESSIONALS Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided Course Curriculum (we can customize the course agenda as per your requirements) DATASTAGE Course Content DW and ETL Concepts • DW Overview • Data Consolidation and Integratiion • ETL Lifecycle • Data cleaning and conforming Information Server components • • Fast track • • Metadata workbench • • Business Glossary • • Information Analyzer • • Information Services Director • • Blueprint Director • • Deployment tool Web Console Administration • Managing users and groups • Managing user credentials Datastage Administrator • Project Administration • Setting Environment Variables • Managing Logs • Enabling RCP • User Roles and Permissions • Lab Exercises Datastage Architecture • Design time architecture • Run time architecture • Partition and pipeline parallelism Server Jobs • Server Vs Parallel jobs • Can I convert Server jobs to Parallel Jobs? • Architectural differences • Different stages • BASIC Programming • Containers Datastage Director • Director User Interface • Compiling single and multiple jobs • Validate, Run,Reset, Restart jobs • Scheduling Jobs • Checking logs • Performance monitor on designer • Logs for sequence jobs Importing Metadata • Sequential file metadata imports • Schemas • Direct import from database • Importing Shared metadata • Lab Exercises Handling files • Sequential filestage • Complex flat file stage • File formats • Managing huge files • Performance considerations • Rejecting invlaid data • Lab Exercises Parallel Job Stages • File stages • Database stages • Processing stages • Debug stages • Sequence job stages • Pivot stage • SCD Stage Handling input data • Processing file based data • Handling relational input data • Processing incremental data • Staging area • Lab Exercises Environment variables • Understaning the environment variables • Parallel • Buffering • Reporting • Monitoring • Database specific End to end ETL developmenmt task – Case study Troubleshooting Performance enhancements Best Practices Data quality

Oracle SOA Suite 11g Basic Concepts and Architecture •Overview of service-oriented architecture (SOA) • Overview XML, XSD, X Path, XSLT, SOAP, WSDL, UDDI •The basic concepts of Oracle BPEL Process Manager • BPEL Process Manager components Installation •Overview of the fusion architecture •Overview of the Web logic server •Overview of the soa server and bam server and Meta data schemas. •Creating the soa domain •Creating the soa server and bam server •Installation steps soa suite 11g •Preparing the start and stop scripts for soa server •Start and stop the admin server Interaction Patterns •Orchestrate services through BPEL for a Synchronous Service •Orchestrate services through BPEL for One-way. •Orchestrate services through BPEL for an Asynchronous Service SCA Architecture •Description of Composite xml. •Source code Explanation of BPEL File. •Source code Explanation WSDL File. •Source code Explanation of Component Type File. Hello World BPEL Process •Synchronous Hello World process. •Explanation of Below Activities. oReceive Activity Syntax. oInvoke Activity Syntax. oReply Activity Syntax. oAssign Activity. oBPEL Variables. oRelationship between BPEL Variables and WSDL messages. oDeploying the application Creation the connection for SOA server. Major & Minor Application Version. Compilation Build Deployment Tab SOA oApplication Testing in the SOA Server Parallel Processing and Conditional Branching •Processing with Parallel Flows oUsing Flown activity oUsing Flow activity •Conditional Branching oSwitch Activity oLimitation of the Receive activity oPick activity to implement the timeouts oPick activity to receive inputs from multiple operations into a single BPEL Fault Handling and Exception Management •Fault types oSystem Faults oBusiness Faults •Fault handling Process based fault handling System fault handling •For synchronous services •For asynchronous Business Faults oFor synchronous services oFor asynchronous Policy based fault handling Transformation Services •Transformation Service • Map Testing and Analysis • XSLT Mapping Tool Adapters and Accessing Adapter from BPEL •Adapter Framework •File Adapter oRead Operation oWrite Operation oSync Read Operation oList of files. •FTP Adapter oGet a file oPut a file oSynchronous get file oList of files •Advanced Queuing •Database Adapters oCalling stored Procedure oCRUD operations Insert Select Update Delete oRead Poll oCustom sql •JMS adapters. oJMS Producer oJMS Consumer •Oracle Apps Adapter introduction •Fault handling in the ADAPTERS •Transaction handling in Adapters Mediators •Introduction to mediators. •Working with mediators. •Event driven networks via mediator •Schematron files, parallel flows, sequential flows •Fault handling in the Mediator •Transaction handling in the Mediators Human Workflow and Work list Application •Human Workflow Service Concepts •Features of workflow service •Workflow service components •Modeling Workflows •Work list Application Features Business Rule and Decision Tables •Introduction to Business Rules. •Using Business Rules and Decision tables in BPEL Working with BAM •Oracle BAM Server •Oracle BAM Application •Features of Oracle BAM Application •Defining Data Object •Defining BAM Dashboard •Configuring BAM Adapter on WebLogic •Adding BAM Connection to application OSB WSDL Preparation and uploading into SBConsole Business service development Proxy service development Fault handling Message flows in the OSB OSB Faqs AIA AIA fundamentals CDMs AIA components ABM EBO EBM ABCS EBS EBF ABCS preparations EBS preparations One PIP explanation Other Topics SOA Suite 10g examples Migration from 10g to 11g OSB basics AIA Basics Dynamic partner link Correlations Preference variables DVMs XRef Tables ANT scripts MDM MDM upload scripts SOA Testing. SOA Production support. SOA Faqs. Resume Preparation help. SOA project explanation. Other Courses Offered by Sadguru Technologies: Web Logic & SOA Administration Oracle Service Bus (OSB) Oracle Application Integration Architecture (AIA) Oracle Business Process Management (BPM) Oracle Application Development Framework (ADF) Oracle Applications Framework (OAF) Web Sphere Application Server (WAS) Oracle Billing & Revenue Management (BRM) Sales Force CRM, Siebel CRM Business Analyst (BA) JAVA Oracle Identity Access Management (OIAM) Oracle Data Integrator (ODI) Web Center Oracle Apps (Functional, Technical) Contact at SADGURU TECHNOLOGIES H. No: , Flat No: 102, SaiManor Apartment, S.R. Nagar Main Road, Hyderabad-, Landmark: Beside Umesh Chandra Statue Mob: 91-, Ph: 040-

Oracle SOA Suite 11g Basic Concepts and Architecture Overview of service-oriented architecture (SOA) Overview XML, XSD, X Path, XSLT, SOAP, WSDL, UDDI The basic concepts of Oracle BPEL Process Manager BPEL Process Manager components Installation Overview of the fusion architecture Overview of the Web logic server Overview of the soa server and bam server and Meta data schemas. Creating the soa domain Creating the soa server and bam server Installation steps soa suite 11g Preparing the start and stop scripts for soa server Start and stop the admin server Interaction Patterns Orchestrate services through BPEL for a Synchronous Service Orchestrate services through BPEL for One-way. Orchestrate services through BPEL for an Asynchronous Service SCA Architecture Description of Composite xml. Source code Explanation of BPEL File. Source code Explanation WSDL File. Source code Explanation of Component Type File. Hello World BPEL Process Synchronous Hello World process. Explanation of Below Activities. Receive Activity Syntax. Invoke Activity Syntax. Reply Activity Syntax. Assign Activity. BPEL Variables. Relationship between BPEL Variables and WSDL messages. Deploying the application Creation the connection for SOA server. Major & Minor Application Version. Compilation Build Deployment Tab SOA Application Testing in the SOA Server Parallel Processing and Conditional Branching Processing with Parallel Flows Using Flown activity Using Flow activity Conditional Branching Switch Activity Limitation of the Receive activity Pick activity to implement the timeouts Pick activity to receive inputs from multiple operations into a single BPEL Fault Handling and Exception Management Fault types System Faults Business Faults Fault handling Process based fault handling System fault handling For synchronous services For asynchronous Business Faults For synchronous services For asynchronous Policy based fault handling Transformation Services Transformation Service Map Testing and Analysis XSLT Mapping Tool Adapters and Accessing Adapter from BPEL Adapter Framework File Adapter Read Operation Write Operation Sync Read Operation List of files. FTP Adapter Get a file Put a file Synchronous get file List of files Advanced Queuing Database Adapters Calling stored Procedure CRUD operations Insert Select Update Delete Read Poll Custom sql JMS adapters. JMS Producer JMS Consumer Oracle Apps Adapter introduction Fault handling in the ADAPTERS Transaction handling in Adapters Mediators Introduction to mediators. Working with mediators. Event driven networks via mediator Schematron files, parallel flows, sequential flows Fault handling in the Mediator Transaction handling in the Mediators Human Workflow and Work list Application Human Workflow Service Concepts Features of workflow service Workflow service components Modeling Workflows Work list Application Features Business Rule and Decision Tables Introduction to Business Rules. Using Business Rules and Decision tables in BPEL Working with BAM Oracle BAM Server Oracle BAM Application Features of Oracle BAM Application Defining Data Object Defining BAM Dashboard Configuring BAM Adapter on WebLogic Adding BAM Connection to application Other Topics SOA Suite 10g examples Migration from 10g to 11g OSB basics AIA Basics Dynamic partner link Correlations Preference variables DVMs XRef Tables ANT scripts MDM MDM upload scripts SOA Testing. SOA Production support. SOA Faqs. Resume Preparation help. SOA project explanation. Other Courses Offered by Sadguru Technologies: Web Logic & SOA Administration Oracle Service Bus (OSB) Oracle Application Integration Architecture (AIA) Oracle Business Process Management (BPM) Oracle Application Development Framework (ADF) Oracle Applications Framework (OAF) Web Sphere Application Server (WAS) Oracle Billing & Revenue Management (BRM) Sales Force CRM, Siebel CRM Business Analyst (BA) JAVA Oracle Identity Access Management (OIAM) Oracle Data Integrator (ODI) Web Center Oracle Apps (Functional, Technical) Contact at SADGURU TECHNOLOGIES H. No: 7-1-621/10, Flat No: 102, SaiManor Apartment, S.R. Nagar Main Road, Hyderabad-500038, Landmark: Beside Umesh Chandra Statue Mob: 91-8179736190, Ph: 040-40154733 

Techdata solution is a premier organization for Inhouse, Corporate training and software job assistance. Techdata solution is started by IT Industry experts and well experienced software trainers. We are providing comprehensive Inhouse, Corporate training in the most demanded technologies in the contemporary IT World, with real-time exposure.  Locations: Pune. Topics Covered:   Sas Training in Pune by our professionals: Introduction to Sas: 1.What is Sas? 2.History of Sas.. 3.Who is behind Sas? 4.Configuring HDFS. 5.Interacting With HDFS. 6.HDFS Permissions and Security. 7.Additional HDFS Tasks. 8.HDFS Installation. 9.Sas File System Shell. 10.File System Java API.   Sas Training in Pune Providing The Following Services:   •Soft Copy Material •Access To Recording Sessions On Demand Basis •Certification Material And Guidelines •Consultancy Guidelines •Interview Questions& Answers (or) FAQs •Mock Interviews •Sample Resumes & Resume Guidance •24x7 Online Technical Support •Online Training For Week End And Regular Batches   For more details please go through the website.               http://techdatasolution.in/sas-trainingpune.html Conatct Me +91 - Hadoop Training in Mumbai with interview support, Hadoop Training in Mumbai. Techdata solution is a premier organization for Inhouse, Corporate training and software job assistance. Techdata solution is started by IT Industry experts and well experienced software trainers. We are providing comprehensive Inhouse, Corporate training in the most demanded technologies in the contemporary IT World, with real-time exposure.  Locations:Mumbai. Topics Covered:   HADOOP Course topics that covered by our professionals: Introduction to Hadoop: 1.What is Hadoop? 2.History of Hadoop. 3.Who is behind Hadoop? 4.Configuring HDFS. 5.Interacting With HDFS. 6.HDFS Permissions and Security. 7.Additional HDFS Tasks. 8.HDFS Installation. 9.Hadoop File System Shell. 10.File System Java API.   Hadoop Training in Mumbai provideing The Following Services:   •Soft Copy Material •Access To Recording Sessions On Demand Basis •Certification Material And Guidelines •Consultancy Guidelines •Interview Questions& Answers (or) FAQs •Mock Interviews •Sample Resumes & Resume Guidance •24x7 Online Technical Support •Online Training For Week End And Regular Batches   For more details please go through the website.               +91 -

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

HADOOP ONLINE TRAINING,CORPORATE TRAINING,JOB AND INTERVIEW SUPPORT BY CORPORATE PROFESSIONALS Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided Hadoop Concepts (we can modify the course content as per your requirement) HADOOP ADMIN AND DEVELOPMENT Introduction:- • Big Data Introduction • Hadoop Introduction • What is Hadoop? Why Hadoop? • Hadoop History? • Different types of Components in Hadoop? • HDFS, MapReduce, PIG, Hive, SQOOP, HBASE, OOZIE, Flume, Zookeeper and so on… • What is the scope of Hadoop? Deep Drive in HDFS (for Storing the Data):- • Introduction of HDFS • HDFS Design • HDFS role in Hadoop • Features of HDFS • Daemons of Hadoop and its functionality • Name Node • Secondary Name Node • Job Tracker • Data Node • Task Tracker • Anatomy of File Wright • Anatomy of File Read • Network Topology • Nodes • Racks • Data Center • Parallel Copying using DistCp • Basic Configuration for HDFS • Data Organization • Blocks and • Replication • Rack Awareness • Heartbeat Signal • How to Store the Data into HDFS • How to Read the Data from HDFS • Accessing HDFS (Introduction of Basic UNIX commands) • CLI commands MapReduce using Java (Processing the Data):- • Introduction of MapReduce. • MapReduce Architecture • Data flow in MapReduce • Splits • Mapper • Portioning • Sort and shuffle • Combiner • Reducer • Understand Difference Between Block and InputSplit • Role of RecordReader • Basic Configuration of MapReduce • MapReduce life cycle • Driver Code • Mapper • and Reducer • How MapReduce Works • Writing and Executing the Basic MapReduce Program using Java • Submission & Initialization of MapReduce Job. • File Input/output Formats in MapReduce Jobs • Text Input Format • Key Value Input Format • Sequence File Input Format • NLine Input Format • Joins • Map-side Joins • Reducer-side Joins • Word Count Example • Partition MapReduce Program • Side Data Distribution • Distributed Cache (with Program) • Counters (with Program) • Types of Counters • Task Counters • Job Counters • User Defined Counters • Propagation of Counters • Job Scheduling PIG:- • Introduction to Apache PIG • Introduction to PIG Data Flow Engine • MapReduce vs PIG in detail • When should PIG used? • Data Types in PIG • Basic PIG programming • Modes of Execution in PIG • Local Mode and • MapReduce Mode • Execution Mechanisms • Grunt Shell • Script • Embedded • Operators/Transformations in PIG • PIG UDF’s with Program • Word Count Example in PIG • The difference between the MapReduce and PIG SQOOP:- • Introduction to SQOOP • Use of SQOOP • Connect to mySql database • SQOOP commands • Import • Export • Eval • Codegen and etc… • Joins in SQOOP • Export to MySQL HIVE:- • Introduction to HIVE • HIVE Meta Store • HIVE Architecture • Tables in HIVE • Managed Tables • External Tables • Hive Data Types • Primitive Types • Complex Types • Partition • Joins in HIVE • HIVE UDF’s and UADF’s with Programs • Word Count Example HBASE:- • Introduction to HBASE • Basic Configurations of HBASE • Fundamentals of HBase • What is NoSQL? • HBase DataModel • Table and Row • Column Family and Column Qualifier • Cell and its Versioning • Categories of NoSQL Data Bases • Key-Value Database • Document Database • Column Family Database • SQL vs NOSQL • How HBASE is differ from RDBMS • HDFS vs HBase • Client side buffering or bulk uploads • HBase Designing Tables • HBase Operations • Get • Scan • Put • Delete MongoDB:-- • What is MongoDB? • Where to Use? • Configuration On Windows • Inserting the data into MongoDB? • Reading the MongoDB data. Cluster Setup:-- • Downloading and installing the Ubuntu12.x • Installing Java • Installing Hadoop • Creating Cluster • Increasing Decreasing the Cluster size • Monitoring the Cluster Health • Starting and Stopping the Nodes OOZIE • Introduction to OOZIE • Use of OOZIE • Where to use? Hadoop Ecosystem Overview Oozie HBase Pig Sqoop Casandra Chukwa Mahout Zoo Keeper Flume • Case Studies Discussions • Certification Guidance • Real Time Certification and • interview Questions and Answers • Resume Preparation • Providing all Materials nd Links • Real time Project Explanation and Practice