Online columns

OBIEE 11g Training Course Content call + History of OBIEE What is a Dimension table and Fact table. Understanding Primary key and Foreign keys. Basic RPD creation using Scott(oracle DB) Basic RPD creation using Microsoft Excel Creating Alias tables and alias table usage Deploying and undeploying Views Testing and validating Repository Differences between Online, Offline and Read only mode RPD How to bring RPD to online mode for Reporting Introduction to servers Architecture of OBIEE Setting Log Levels Building physical layer, BMM layer and Presentation layer Creating Logical Tables, Columns and Joins Working with Column properties, filters, sorting, edit formula and deleting columns What is Web Catalog & Instanceconfig.xml Creating Presentation catalog and shared folders Building analytics requests Sorting Presentation tables and columns Adding Calculations to fact Calculation measures on basis of physical and logical columns Using Rename, Calculation Wizard Working with Enterprise Manager Creating dimensional hierarchy Creating Level based measures Modeling Time Series Data & Time based Measures (Ago, Todate & Periodrollup) Working with Multiple LTS Static, Dynamic Repository Variables Creating Initializations blocks Working with Weblogic Administration Console Using Admin Console to create Users and Groups Assigning of permissions to users and user group Restricting the Objects (Tables, Columns, Subject Area) to Users System and Non System Session Variables Security at data levels Enabling and disabling the Cache using Enterprise Manager Making the table cacheable Purging cache using different techniques Creating Saved Filters Creating different types of Views (table, title, pivot table, pie chart, column selector, view selector, legend, etc) Creating Shared Dashborad. Creating Dashboard Prompts Setting Scope for a Prompt Creating and working with Agents Using Direct Database Requests Creating report using multiple subject area’s Parent-child hierarchies Fragmentation Using Catalog Manager MUDE(Multi User Development Environment) Creating KPI’s,Scorecards and Action links Rpd and catalog migration from OBIEE 10g to OBIEE 11g

Duration: 10.5 hours Size: 1.63 GB 1. Database Basics 1. Oracle Database Introduction & Basics of Tables. 2. Setting Up the SQL Development Environment (Mac & Windows). 3. IMPORTANT Prepare the Data in the Database. 3.1 course_data.txt.txt 2. Single Table Queries (Exercises & Solutions in the Lectures) 1. Oracle Exams and Certification Information.html 2. Retrieving Data Using the SELECT Clause. 3. Using the WHERE Clause in a Query. 4. Using Operators in the WHERE Clause. 5. Combining WHERE, AND & OR with Operators. 6. Query Filtering Continued BETWEEN, IN and NULL. 7. Query Filtering Conditions & Operator Precedence. 8. Ordering, Concatenating & Aliasing Query Results. 3. Single Row Functions (Exercises and Solutions In the Lectures) 1. Single Row Functions (SRF) & Using The Dual Table. 2. Using Functions in WHERE And Character Based SRFs. 3. Numeric and Date Data type SRFs. 4. Conversion SRFs & Date Formatting. 5. Some More Date Functions.html 6. Concluding SRFs & NULL NULLIF Functions. 4. Grouping Functions (Exercises and Solutions In the Lectures) 1. Grouping Functions MIN, MAX, AVG, COUNT etc.. 2. GROUP BY Clause & HAVING Clause. 3. More Practice With The GROUP BY Clause. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures) 1. SELECT within SELECT (Subqueries). 2. Relating Tables Together Using JOINs. 3. Joins Continued INNER & OUTER Joins. 4. Correlated Subqueries with EXISTS & NOT EXIST operators. 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures) 1. Creating Your Own Tables & Design Considerations. 10. Views and Other Objects and Commands (Newly Added). 11. SQL could be tricky, check this out!.html 12. Granting and Revoking Privileges. 2. Inserting Data Into Our Table. 3. Create Table With a Primary Key Constraint. 4. Using ALTER to modify the table structure. 5. Create Table with SELECT + UPDATE Data. 7. DELETE, TRUNCATE, and DROP Commands. 8. Working With Database Indexes. 9. System Tables, Pseudo Columns & Deleting Duplicates (Newly Added). Guides PDF Advanced Oracle PL_SQL Developer’s Guide.pdf Beginning Oracle SQL for Oracle Database 12c, 3 edition.pdf.pdf OCA Oracle Database 12c_ SQL Fundamentals I Exam Guide (Exam 1Z0-061).pdf OCA_ Oracle Database 12c Administrator Certified Associate Study Guide_ Exams 1Z0-061 and 1Z0-062.pdf OCP_ Oracle Database 12c Administrator Certified Professional Study Guide_ Exam 1Z0-063.pdf Oracle 12c SQL.pdf creating_other_schema_objects_questions.pdf e47689.pdf subqueries_to_solve_queries_questions.pdf

OBIEE 11g Training Course Content 1. History of OBIEE 2. What is a Dimension table and Fact table. 3. Understanding Primary key and Foreign keys. 4. Basic RPD creation using Scott(oracle DB) 5. Basic RPD creation using Microsoft Excel 6. Creating Alias tables and alias table usage 7. Deploying and undeploying Views 8. Testing and validating Repository 9. Differences between Online, Offline and Read only mode RPD 10. How to bring RPD to online mode for Reporting 11. Introduction to servers 12. Architecture of OBIEE 13. Setting Log Levels 14. Building physical layer, BMM layer and Presentation layer 15. Creating Logical Tables, Columns and Joins 16. Working with Column properties, filters, sorting, edit formula and deleting columns 17. What is Web Catalog & Instanceconfig.xml 18. Creating Presentation catalog and shared folders 19. Building analytics requests 20. Sorting Presentation tables and columns 21. Adding Calculations to fact 22. Calculation measures on basis of physical and logical columns 23. Using Rename, Calculation Wizard 24. Creating Bins 25. Working with Enterprise Manager 26. Creating dimensional hierarchy 27. Creating Level based measures 28. Modeling Time Series Data & Time based Measures (Ago, Todate & Periodrollup) 29. Working with Multiple LTS 30. Static, Dynamic Repository Variables 31. Creating Initializations blocks 32. Working with Weblogic Administration Console 33. Using Admin Console to create Users and Groups 34. Assigning of permissions to users and user group 35. Restricting the Objects (Tables, Columns, Subject Area) to Users 36. System and Non System Session Variables 37. Security at data levels 38. Enabling and disabling the Cache using Enterprise Manager 39. Making the table cacheable 40. Purging cache using different techniques 41. Creating Saved Filters 42. Creating different types of Views (table, title, pivot table, 43. pie chart, column selector, view selector, legend, etc) 44. Creating Shared Dashborad. 45. Creating Dashboard Prompts 46. Setting Scope for a Prompt 47. Creating and working with Agents 48. Using Direct Database Requests 49. Creating report using multiple subject area’s 50. Parent-child hierarchies 51. Fragmentation 52. Using Catalog Manager 53. MUDE(Multi User Development Environment) 54. Creating KPI’s,Scorecards and Action links 55. Rpd and catalog migration from OBIEE 10g to OBIEE 11g

OBIEE 11g Training Course Content 1. History of OBIEE 2.What is a Dimension table and Fact table. 3.Understanding Primary key and Foreign keys. 4.Basic RPD creation using Scott(oracle DB) 5.Basic RPD creation using Microsoft Excel 6.Testing and validating Repository 7.Differences between Online, Offline and Read only mode RPD 8.How to bring RPD to online mode for Reporting 9.Introduction to servers 10.Architecture of OBIEE 11.Setting Log Levels 12.Building physical layer, BMM layer and Presentation layer 13.Creating Logical Tables, Columns and Joins 14.Working with Column properties, filters, sorting, edit formula and deleting columns 15.What is Web Catalog & Instanceconfig.xml 16.Creating Presentation catalog and shared folders 17.Building analytics requests 18.Sorting Presentation tables and columns 19.Adding Calculations to fact 20.Calculation measures on basis of physical and logical columns 21.Using Rename, Calculation Wizard 22.Working with Enterprise Manager 23.Creating dimensional hierarchy 24.Creating Level based measures 25.Modeling Time Series Data & Time based Measures (Ago, Todate & Periodrollup) 26.Working with Multiple LTS 27.Static, Dynamic Repository Variables 28.Creating Initializations blocks 29.Working with Weblogic Administration Console 30.Using Admin Console to create Users and Groups 31.Assigning of permissions to users and user group 32.Restricting the Objects (Tables, Columns, Subject Area) to Users 33.System and Non System Session Variables 34.Security at data levels 35.Enabling and disabling the Cache using Enterprise Manager 36. Making the table cacheable 37.Purging cache using different techniques 38.Creating Saved Filters 39.Creating different types of Views (table, title, pivot table, 40.pie chart, column selector, view selector, legend, etc) 41.Creating Shared Dashborad. 42. Creating Dashboard Prompts 43. Setting Scope for a Prompt 44.Creating and working with Agents 45.Using Direct Database Requests 46.Creating report using multiple subject area’s 47.Parent-child hierarchies 48.Fragmentation 49.Using Catalog Manager 50.MUDE(Multi User Development Environment) 51.Creating KPI’s,Scorecards and Action links 52.Rpd and catalog migration from OBIEE 10g to OBIEE 11g 53. BI Publisher For Demo and more details call: +91 or mail

OBIEE 11g Training Course Content 1. History of OBIEE 2. What is a Dimension table and Fact table. 3. Understanding Primary key and Foreign keys. 4. Basic RPD creation using Scott(oracle DB) 5. Basic RPD creation using Microsoft Excel 6. Testing and validating Repository 7. Differences between Online, Offline and Read only mode RPD 8. How to bring RPD to online mode for Reporting 9. Introduction to servers 10. Architecture of OBIEE 11. Setting Log Levels 12. Building physical layer, BMM layer and Presentation layer 13. Creating Logical Tables, Columns and Joins 14. Working with Column properties, filters, sorting, edit formula and deleting columns 15. What is Web Catalog & Instanceconfig.xml 16. Creating Presentation catalog and shared folders 17. Building analytics requests 18. Sorting Presentation tables and columns 19. Adding Calculations to fact 20. Calculation measures on basis of physical and logical columns 21. Using Rename, Calculation Wizard 22. Working with Enterprise Manager 23. Creating dimensional hierarchy 24. Creating Level based measures 25. Modeling Time Series Data & Time based Measures (Ago, Todate & Periodrollup) 26. Working with Multiple LTS 27. Static, Dynamic Repository Variables 28. Creating Initializations blocks 29. Working with Weblogic Administration Console 30. Using Admin Console to create Users and Groups 31. Assigning of permissions to users and user group 32. Restricting the Objects (Tables, Columns, Subject Area) to Users 33. System and Non System Session Variables 34. Security at data levels 35. Enabling and disabling the Cache using Enterprise Manager 36. Making the table cacheable 37. Purging cache using different techniques 38. Creating Saved Filters 39. Creating different types of Views (table, title, pivot table, 40. pie chart, column selector, view selector, legend, etc) 41. Creating Shared Dashborad. 42. Creating Dashboard Prompts 43. Setting Scope for a Prompt 44. Creating and working with Agents 45. Using Direct Database Requests 46. Creating report using multiple subject area’s 47. Parent-child hierarchies 48. Fragmentation 49. Using Catalog Manager 50. MUDE(Multi User Development Environment) 51. Creating KPI’s,Scorecards and Action links 52. Rpd and catalog migration from OBIEE 10g to OBIEE 11g 53. BI Publisher

COGNOS Business Intelligence 10.1 Introduction to data warehousing Introduction to Cognos 10.1 Query studio: Types of reports Query studio templates User interface Operation on list report Data formatting Expand and collapse group Custom groups Filters and calculations Conditional formatting Report studio: Types of reports User interfaces Page structure and page view Operations on list Discontinuous cross tab Advances sorting and grouping Map reports and gauge chart Formatting the data Types Filters and calculations Prompts Tree prompt Cascading prompts Drill through Drill through on charts Drill up and drill down Bookmark Master – Detail relationship Re usability of queries Working with MDX functions Variables Conditional styles and formatting Conditional formatting with charts Render variable Conditional blocks Conditional layouts Layout component reference Bursting Dashboard reports Understating the reports from query explorer Understanding and exploring the tools in toolbox Performance tuning Analysis studio: Introduction to analysis studio Types of analysis Rows columns and context Suppress zeros and nulls Filters and calculations Top and bottom rows Sorting Drill up and drill down Convert to chart Replacing columns and rows Open in report studio

Type Computer Oracle Apps Technical Online Training By IT Experts: magnific IT provides the best Software’s training for various Computer IT courses through Webex, We are providing Oracle Apps Technical Training based on specific needs of the learners especially we will give innovative one to one Classes which has great opportunities in the present IT market. We also provides Class room course to contend with today’s competitive IT world. Learners can grasp the technology-subject from our highly experienced & certified trainers which will be helping the students to work in real time projects. Learners can choose either regular course or fast track classes or weekend Training classes. It’s proud to be we are one of the top leading Oracle Apps Technical online training provider from India. We are into this field with passion and dedication we are in to online trainings from many years. Our team of well experienced Oracle Apps Technical trainers with vast real time IT experience in online trainings is dedicated towards providing quality training. SunItLabs has taken great steps in providing best quality Online Classes. We placed Our students in INDIA,USA, UK, SINGAPORE, NEWZELAND, CANADA, AUSTRALIA. Oracle Apps Technical Online Training Concepts: 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 Menu construction Request group construction Application development Defining concurrent program Concurrent programs with parameters Working with multiple concurrent programs Scheduling the Concurrent ProgramConcurrent Program incompatibilities Creating Request Set Procedure registration Value sets Reports registration Report development Report registration Parametric report registration Reports with repeating frames Module Overviews Inventory Module flow with base tables Accounts Payable module flow with base tables Accounts Receivable module flow with base tables Order Management module flow with base tables Form registration Template.fmb Appstand.fmb Form development using templates Form customization concepts Form Registration Process Custm.Pll Using function Zoom_available() Using procedure Event() Interfaces Introduction to Interfaces Outbound Interfaces - Using UTL_FILE package Inbound Interfaces - Using SQL * Loader tool 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 Types of Flex Fields Descriptive Flex Fields Key Flex Fields Workflows Introduction to workflow Workflow builder Attributes Creating Processes Sending notifications using workflows XML Publisher Introduction to XML Publisher Generating XML file using reports Creating Templates Creating Data Definitions Discoverer Introduction to Discoverer tool Discoverer Administrator Creating EUL Creating Business Areas Discoverer Desktop Creating work books We also provide oracle-dmantra

Type Computer HyderabadSys is a leading training institute providing real-time and placement oriented Oracle 11g Online Training Courses in usa, uk, Canada, Malaysia, Australia, India, Singapore. Our Oracle 11g DBA training course includes basic to advanced levels. We have a team of certified trainers who are working professionals with hands on real time Oracle 11g DBA projects knowledge which will provide you an edge over other training institutes. The Oracle 11g Course is an orderly excercise with loads of screenshots and amazingly clear and unequivocal directions. It is planned to be utilized as a part of conjunction with Oracle's standard guide, which is a decent beginning stage for figuring out how to introduce and oversee Oracle database frameworks. The Course, which we are putting forth to you this week, gives connection hints and some valuable elucidations that make the guide much simpler to take after. The Course covers an extensive variety of themes, including introductory establishment and setup, client and security organization, controlling pattern, execution tuning, and reinforcement forms. Oracle 11g Online Training Concepts: 1.Oracle 11g – SQL & PL/SQL 2.The Oracle database environment 3,Basic SELECT Statement 4.Conditional retrieval of data 5.Working with variables 6.Pseudo columns and functions 7.Using non-character function 8.Using the SET operators 9.Aggregating data using group functions 10.Using Declarative Constraints 11.Database Security 12.Improving query performance PH NO: INDIA- +91 USA- +

SequelGate is one of the best training institutes for PL-SQL Training, oracle DBA Training, and Oracle Apps DBA Training. We have been providing Online and Classroom Training’s and Corporate training’s. All our training sessions are COMPLETELY PRACTICAL. PL-SQL Training with PROJECT - ONLINE TRAINING COURSE DETAILS: Introduction to DBMS Introduction to RDBMS Sub Language Commands Introduction to SQL Built-in Functions Grouping the result of a query Working with Integrity Constraints Querying Multiple Tables (Joins) Working with Sub Queries Working with DCL, TCL Commands Maintaining Database Objects Pseudo Columns in Oracle Data Partitions & Parallel Process Locks PL/SQL (Procedure Language – SQL) Advanced PL/SQL Database Triggers in PL/SQL Implementing Object Technology Using Collections Advanced Features Oracle Built-in Packages Introduction to Oracle Database Oracle Utilities Duration: 4 weeks, every day for 1.5 hours and all sessions are completely practical. One Real-time Project included in the course. All Sessions are Completely Practical and Realtime. Contact us today for practical PL-SQL Online training. SequelGate Training Institute  Office: (+91) 040 65358866 Mobile: (+91) 0 9030040801  Sai Anu Avenue, Street Number 3, Patrika Nagar, HITEC City, Hyderabad - 81 (India).

HyderabadSys is a leading training institute providing real-time and placement oriented Oracle 11g Online Training Courses in usa, uk, Canada, Malaysia, Australia, India, Singapore. Our Oracle 11g DBA training course includes basic to advanced levels. We have a team of certified trainers who are working professionals with hands on real time Oracle 11g DBA projects knowledge which will provide you an edge over other training institutes. The Oracle 11g Course is an orderly excercise with loads of screenshots and amazingly clear and unequivocal directions. It is planned to be utilized as a part of conjunction with Oracle's standard guide, which is a decent beginning stage for figuring out how to introduce and oversee Oracle database frameworks. The Course, which we are putting forth to you this week, gives connection hints and some valuable elucidations that make the guide much simpler to take after. The Course covers an extensive variety of themes, including introductory establishment and setup, client and security organization, controlling pattern, execution tuning, and reinforcement forms. Oracle 11g Online Training Concepts: 1.Oracle 11g – SQL & PL/SQL 2.The Oracle database environment 3,Basic SELECT Statement 4.Conditional retrieval of data 5.Working with variables 6.Pseudo columns and functions 7.Using non-character function 8.Using the SET operators 9.Aggregating data using group functions 10.Using Declarative Constraints 11.Database Security 12.Improving query performance PH NO: INDIA- +91 USA- +

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

sadguru technologies -040 -- ​Oracle Apps Technical Online Training Concepts: 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 Menu construction Request group construction Application development Defining concurrent program Creating Request Set Procedure registration Value sets

MICROSOFT EXCEL CLASSROOM / ONLINE TRAINING IN HYDERABAD EXPLORING EXCEL Touring the Excel Interface Inserting, Moving & Selecting Content Format Numerical Data & Reference Cells Building a Table & Using AutoFill Inserting & Deleting Rows & Columns Introducing Formulas Introducing Functions Using the Insert Function Dialog Box Using Statistical Functions & the Status Bar Using Auditing Commands Exploring Absolute Cell Referencing Naming Cell Ranges & Using Name Manager Pasting Data & Using the Clipboard FORMATTING & STYLIZING IN EXCEL Formatting Cells Using Format Painter Number Formatting Using Cell Styles Creating Cell Styles Changing Styles Using & Creating Table Styles Filtering a Table Layout Using Conditional Formatting Formatting Worksheets with Themes Inserting Graphical Elements Managing Multiple Worksheets Outputting a Document Saving a Document.

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:

OBIEE Online Training Course Duration - 40hrs Sadguru Technologies-8179736190 Data warehousing overview Basics of Data Warehousing What is OLTP and OLAP? Difference between OLTP and OLAP Advantages of OLAP What is Data Marts and ODS? Dimensional Modeling Overview Introduction to Dimensional Modeling What are Facts and Dimensions? Star schema and Snowflake schema Introduction to Business Intelligence What is Business Intelligence Where BI tools are Used Why the Oracle Business Intelligence Advantages Architecture, Components Clients - Answers, Delivers, Dashboards and Web administration, Servers- Oracle BI server, Presentation, Scheduler server Server Architecture Repository Basics What is Meta data? Creating a Repository using BI Administration Tool Physical, Business Model and Mapping, and presentation layers Properties of repository objects Building Physical Layer of a Repository Objects of Physical Layer DSN for a data sources Build physical layer Building business Model mapping layer Objects of BMM layer Building Business model (creating logical tables, columns, joins) Creating simple measuresOBIEE Online Training Course Duration - 40hrs Data warehousing overview Basics of Data Warehousing What is OLTP and OLAP? Difference between OLTP and OLAP Advantages of OLAP What is Data Marts and ODS? Dimensional Modeling Overview Introduction to Dimensional Modeling What are Facts and Dimensions? Star schema and Snowflake schema Introduction to Business Intelligence What is Business Intelligence Where BI tools are Used Why the Oracle Business Intelligence Advantages Architecture, Components Clients - Answers, Delivers, Dashboards and Web administration, Servers- Oracle BI server, Presentation, Scheduler server Server Architecture Repository Basics What is Meta data? Creating a Repository using BI Administration Tool Physical, Business Model and Mapping, and presentation layers Properties of repository objects Building Physical Layer of a Repository Objects of Physical Layer DSN for a data sources Build physical layer Building business Model mapping layer Objects of BMM layer Building Business model (creating logical tables, columns, joins) Creating simple measures

OBI ARCHITECTURE Clients OBI Presentation Services OBI Server OBI Repository (.rpd) Data Sources OBI COMPONENTS OBI Administration Tool OBI Answers Intelligence dashboards REPOSITORY BASICS Oracle Business Analysis Warehouse DAC and Informatica Server Informatica Server ETL Sample Request Processing Using the OracleBI Administration Tool Repository Directory Repository Files ( Initialization files and log files) Informatica Server ETLLoading a repository into Oracle BI Server memory Creating a repository Connection Pool Repository Modes ( ONLINE and OFFLINE ) Physical Layer Business Model & Mapping Layer Presentation Layer Presentation Catalogs, Folders and Columns Error Messages Note: All Training will be on BI Sample Schema. BUILDING THE PHYSICAL LAYER OF A REPOSITORY Defining an ODBC System DSN Setting up connection pool properties Importing data sources ( Physical Schema ) Verifying the import Defining physical keys and joins Creating alias and select tables BUILDING THE BUSINESS MODEL AND MAPPING LAYER OF A REPOSITORY Creating the logical business model Creating the logical tables, columns, and sources Defining logical joins Adding Calculation to a Fact Table Building measures BUILDING THE PRESENTATION LAYER OF A REPOSITORY Creating a new Presentation Catalog Modifying Presentation layer objects

OBI ARCHITECTURE Clients OBI Presentation Services OBI Server OBI Repository (.rpd) Data Sources OBI COMPONENTS OBI Administration Tool OBI Answers Intelligence dashboards REPOSITORY BASICS Oracle Business Analysis Warehouse DAC and Informatica Server Informatica Server ETL Sample Request Processing Using the OracleBI Administration Tool Repository Directory Repository Files ( Initialization files and log files) Informatica Server ETLLoading a repository into Oracle BI Server memory Creating a repository Connection Pool Repository Modes ( ONLINE and OFFLINE ) Physical Layer Business Model & Mapping Layer Presentation Layer Presentation Catalogs, Folders and Columns Error Messages Note: All Training will be on BI Sample Schema. BUILDING THE PHYSICAL LAYER OF A REPOSITORY Defining an ODBC System DSN Setting up connection pool properties Importing data sources ( Physical Schema ) Verifying the import Defining physical keys and joins Creating alias and select tables BUILDING THE BUSINESS MODEL AND MAPPING LAYER OF A REPOSITORY Creating the logical business model Creating the logical tables, columns, and sources Defining logical joins Adding Calculation to a Fact Table Building measures BUILDING THE PRESENTATION LAYER OF A REPOSITORY Creating a new Presentation Catalog Modifying Presentation layer objects Rename tables

OBI ARCHITECTURE Clients OBI Presentation Services OBI Server OBI Repository (.rpd) Data Sources OBI COMPONENTS OBI Administration Tool OBI Answers Intelligence dashboards REPOSITORY BASICS Oracle Business Analysis Warehouse DAC and Informatica Server Informatica Server ETL Sample Request Processing Using the OracleBI Administration Tool Repository Directory Repository Files ( Initialization files and log files) Informatica Server ETLLoading a repository into Oracle BI Server memory Creating a repository Connection Pool Repository Modes ( ONLINE and OFFLINE ) Physical Layer Business Model & Mapping Layer Presentation Layer Presentation Catalogs, Folders and Columns Error Messages Note: All Training will be on BI Sample Schema. Creating the logical business model Creating the logical tables, columns, and sources Defining logical joins Adding Calculation to a Fact Table Building measures BUILDING THE PRESENTATION LAYER OF A REPOSITORY Creating a new Presentation Catalog Modifying Presentation layer objects Rename tables

OBI ARCHITECTURE Clients OBI Presentation Services OBI Server OBI Repository (.rpd) Data Sources OBI COMPONENTS OBI Administration Tool OBI Answers Intelligence dashboards REPOSITORY BASICS Oracle Business Analysis Warehouse DAC and Informatica Server Informatica Server ETL Sample Request Processing Using the OracleBI Administration Tool Repository Directory Repository Files ( Initialization files and log files) Informatica Server ETLLoading a repository into Oracle BI Server memory Creating a repository Connection Pool Repository Modes ( ONLINE and OFFLINE ) Physical Layer Business Model & Mapping Layer Presentation Layer Presentation Catalogs, Folders and Columns Error Messages Note: All Training will be on BI Sample Schema. Creating the logical business model Creating the logical tables, columns, and sources Defining logical joins Adding Calculation to a Fact Table

ORACLE DATABASE ADMIN COURSE CONTENT Traning at learning hub Magarpatta city /FC Road Pune (+91-93257-93756) www.learninghub.co.in ORACLE DATABASE ADMIN COURSE CONTENT 1: Creating the Database 2: Starting Up and Shutting Down • Viewing the Quiesce State of an Instance • Suspending and Resuming a Database 3: Managing Oracle Database Processes • Terminating Sessions • Identifying Which Session to Terminate • Terminating an Active Session • Terminating an Inactive Session 4: Monitoring the Operation of Your Database • Server-Generated Alerts • Monitoring the Database Using Trace Files and the Alert Log • Monitoring Locks • Monitoring Wait Events • Process and Session Views 5: Oracle Database Structure and Storage • Managing Control Files • Managing the Redo Log • Managing Archived Redo Logs 6: Managing Table spaces Transportable Table spaces 7: Managing Data files and Temp files 8: Managing the Undo Table space undo retention, switching undo table space 9: User management creation of users and roles, assign privileges 10:Automatic Storage Management create ASM instance, create disk groups 11:Managing Schema Objects • Tables, indexes, views, synonyms and sequence generator • Space management • Managing resumable space allocation, reclaiming wasted space • Managing Tables • adding, renaming and dropping of table columns • Managing Indexes • B*tree, bitmap • Managing Partitioned Tables and Indexes • Range, hash,list and composit partitioning • Managing Clusters • creation and altering of clusters • Managing Views, Sequences, and Synonyms • Oracle Network • Listener and tnsnames • Distributed Database Concepts • Utilities • Data pump , SQL*Loader • Backup and Recovery • Rman • Performance Tuning • Data Guard • configuring physical standby database • Miscellaneous Please Contact- Learning Hub, S-12,Destination Centre, 2nd Floor, Above HDFC Bank, Next to Noble Polyclinic, MAGARPATTA CITY, PUNE – 411013, PH: +91- 93257-93756. Skype id : learning.hub01 Email: learninghub01@gmail.com www.learninghub.co.in ORACLE DATABASE ADMI Online Training, ORACLE DATABASE ADMIN Class Room Training, ORACLE DATABASE ADMIN Training in Magarpatta City, ORACLE DATABASE ADMIN Jobs and Placement, ORACLE DATABASE ADMIN Remote Support, ORACLE DATABASE ADMIN Online Help, ORACLE DATABASE ADMIN Videos training, ORACLE DATABASE ADMIN Training by Learning Hub, Fast track classes in ORACLE DATABASE ADMIN, Best ORACLE DATABASE ADMIN Training institutes in Pune, Best Faculty in ORACLE DATABASE ADMIN, Best online Faculty in ORACLE DATABASE ADMIN, Professional classroom training in ORACLE DATABASE ADMIN, Professional online training ORACLE DATABASE ADMIN, ORACLE DATABASE ADMIN Certification , ORACLE DATABASE ADMIN training in Dubai, ORACLE DATABASE ADMINTraining in Melbourne, ORACLE DATABASE ADMIN Training in Dubai, ORACLE DATABASE ADMIN Training, ORACLE DATABASE ADMIN Workflow Training ORACLE DATABASE ADMI Training, ORACLE DATABASE ADMI Online Training, ORACLE DATABASE ADMIN certfication and support

Type Computer Softgen Infotech located in BTM Layout, Bangalore is a leading training institute providing real-time and placement oriented SQL Server Training Courses in bangalore. Our SQL Server training course includes basic to advanced levels. we have a team of certified trainers who are working professionals with hands on real time SQL Server projects knowledge which will provide you an edge over other training institutes. Our SQL Server 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 SQL Server 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 SQL Server Training course content and syllabus based on students requirements to achieve everyone's career goal. Our SQL Server 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 SQL Server Training in our centres located across bangalore. We also provide Online Training Classes for SQL Server Training Course. Contact us today to schedule a free demo and complete course details on SQL Server Training Course. What is SQL Server Training ? SQL Server Training Objectives Installing Microsoft SQL ServerUpgrading to SQL Server Management StudioMonitoring the Database ServerDatabase and Index MaintenanceUsing the Database Tuning AdvisorSQL Server Disaster RecoveryDatabase AvailabilityReplicating InformationHTTP Synchronization for Merge ReplicationOLE DB Command objectMonitoring and Performance Training Prerequesites Any Programming Language Knowledge.Good understanding of relational databasesSome experience with client databases, such as Access. Course Details SQL Server Overview Availability and Scalability Features Security Features Data Management Features Administration and Maintenance Features Development Features To enable SQLiMail Testing mail delivery Installing SQL Server SQL Server Editions Installing Microsoft SQL Server System Requirements Preparing for a SQL Installation Installation Checklist Setup Features Using the System Consistency Checker Component Install Unattended Installation Installation Sequence Installation Maintenance Upgrading to SQL Server Management Studio Management Studio Windows Registered Servers Object Explorer Review Database Objects Modify Database Properties Create Database Scripts The Maintenance Plans Node Solution Explorer Query Editor Template Explorer Dynamic Help Upgrading to SQL Server Computer Manager SQL Server Services node SQL Server Network Configuration node SQL Server Native Client Configuration node The SQLCMD Management Utility SQLCMD Syntax SQLCMD Variables Dedicated Administrative Connection SQL Server Management Studio SQLCMD Mode Securing SQL Server Implementing Securable New Security Features Principals Securable Permissions Permission Types Managing Logins Managing Schemas Managing Users Schema Definition Using Schemas Managing Execution Context Managing Permissions Manage Server Permissions Manage Server-Scope Securable Permissions Manage Database Permissions Manage Database-Scope Securable Permissions Native Data Encryption Code and Module Signing Database Availability SQL Data Availability Database Mirroring The Witness Server and Automatic Failover Configuring Database Mirroring Transaction Safety Level Operating Modes High Availability Operating Mode High Protection Operating Mode High Performance Operating Mode Monitoring Mirroring Database States for Database Mirroring Prepare the Servers Configure Mirroring Verify Principal and Mirror Access Execute the Mirror Failover Verify Mirror and Witness Status Terminating the Mirror Session SQL Server Integration Services Creating the Database Objects Creating a Package Using Business Intelligence Studio Integration Services Project Template OLE DB Command object Column Mappings Adding a Data Viewer Monitoring the Database Server Managing Metadata Views Metadata Storage System Views Information Schema Catalog Views Sys All Dynamic Management Views System Stored Procedures Database and Index Maintenance Index Management New Index Features Creating Indexes Online Index Maintenance Parallel (multiple CPU) Index Operations Lock Options Included Columns in Indexes Partitioned Tables and Indexes XML Index Support Altering an Index Rebuilding an Index Reorganizing an Index Disabling an Index Dropping an Index Index Fragmentation Using the Database Tuning Advisor SQL Server Disaster Recovery Disaster Recovery SQL Disaster Recovery Feature Enhanced Features Database Snapshots Creating a Snapshot Common Snapshot Applications Undeleting table rows Undoing a table update Recovering a dropped object Backup and Restore Media Integrity Changes Recovering the MASTER Database Create a mirrored backup Restore from the backup mirror Create a snapshot Restore the snapshot data Automate the creation of daily snapshots Replicating Information Replication Enhancements Stand-alone Replication Monitor Support for Oracle Publishing HTTP Synchronization for Merge Replication Subscriber Initialization Replicating DDL Statements Modified User Interface Replication Management Objects To Configure Publishing and Distribution Configuring Peer-to-Peer Replication Create a Publication Create a Subscription with RMO Monitoring and Performance SQL Server Profiler Optimal Data Storage Diagnostic Tools Query Analyzer Database Engine Tuning Advisor Index Optimization Federated Database Servers Partitioned Indexes Lock Optimization SQL Server Training Course Details Duration:30 Hours Version:latest Version Regular: 1 Hour per day Fast Track: 2 - 3 Hours per day: 10 days Weekdays:Monday - Friday Weekend:Saturday and Sunday Online Training:Available Class Room Training: Available Course Fee: Talk to our Customer Support Mode of Payment:Talk to our Customer Support

Relational data warehouses served communications service providers well in the past, but it�s time to start thinking beyond columns and rows. Unstructured data will be the fuel that powers risk management and decision-making in the near future. And to use all sorts of data to its fullest potential, we need new ways of storing, accessing and analyzing that data. BigDataTraining.IN provides Big Data and Hadoop Training in Chennai Classroom / Online Courses with handsOn Sessions. Hadoop Training Certification Exam is available via online and classrooms. Hadoop Training goes MainStream � We are now tied up with leading IT giants for resource consulting & Placements for numerous Big Data Projects in Pipeline. Hadoop Training with Project from Experts! First Main Road, Adyar, Chennai - To register for upcoming classes weekends(Classroom) August - Fast Track (Classroom)- September Online Class- August

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

JOB ORIENTED SHAREPOINT TRAINING INSTITUTE IN CHENNAI ADYAR Peridot systems proud to introduce the job oriented SharePoint training in Chennai adyar... For more syllabus details you need contact papitha (8056102481)...Our trainers having well experienced in IT Industry... Website: www.peridotsystems.in PERIDOT:  Complete practical training  2 days demo classes  Training Duration : 45 days  Online training classes  Excellent Environment SharePoint Course SYLLABUS: • Creating/updating/propagating • Content types • Creating/updating/propagating • Using Lookups and Calculated Columns For More Syllabus Details contact us, Contact Numbers: 8056102481/9600063484 , 044-42115526 Mail id: Papitha.v@peridotsystems.in Name: papitha TAGS: SharePoint 2013 Training in Chennai | Best SharePoint 2013 Training in Chennai| SharePoint 2013 Training institute in Chennai with placement.

SHAREPOINT TRAINING INSTITUTE IN CHENNAI ADYAR 8056102481... Peridot systems proudly introduce the job oriented SharePoint training institute in Chennai adyar with guaranteed jobs...for more information you need about the course syllabus details contact papitha (8056102481).We provide practical training more than theoretical training by real time trainers... Website: www.peridotsystems.in “REAL TIME TRAINING BY WORKING EXPERTS” BENEFITS:  2 days demo classes  45 days training classes  Online, classroom and corporate training classes  Weekdays and weekend batches Course SYLLABUS: • Creating/updating/propagating • Content types • Using Lookups and Calculated Columns • Enforcing Unique values in List Contact details, Mobile No’s: 8056102481/9600063484, 044-42115526 (papitha) Mail id: Papitha.v@peridotsystems.in TAGS: SharePoint 2013 Training in Chennai | Best SharePoint 2013 Training in Chennai| SharePoint 2013 Training institute in Chennai with placement.

OBIEE Online Training Course Duration - 40hrs Data warehousing overview Basics of Data Warehousing What is OLTP and OLAP? Difference between OLTP and OLAP Advantages of OLAP What is Data Marts and ODS? Dimensional Modeling Overview Introduction to Dimensional Modeling What are Facts and Dimensions? Star schema and Snowflake schema Introduction to Business Intelligence What is Business Intelligence Where BI tools are Used Why the Oracle Business Intelligence Advantages Architecture, Components Clients - Answers, Delivers, Dashboards and Web administration, Servers- Oracle BI server, Presentation, Scheduler server Server Architecture Repository Basics What is Meta data? Creating a Repository using BI Administration Tool Physical, Business Model and Mapping, and presentation layers Properties of repository objects Building Physical Layer of a Repository Objects of Physical Layer DSN for a data sources Build physical layer Building business Model mapping layer Objects of BMM layer Building Business model (creating logical tables, columns, joins) Creating simple measures Building presentation layer Objects of presentation layer Properties of the presentation

BEST SHAREPOINT TRAINING INSTITUTE IN CHENNAI WITH 100% PLACEMENT... Peridot systems providing no of software and hardware training courses in Chennai adyar...call to papitha (8056102481) for more information you need about the course content and syllabus details...we provide 70% practical training and 30% theoretical training by well experienced trainers... Our Official Website: www.peridotsystems.in Advantages for students: • Course name: SharePoint • Demo classes: 2 days • Training duration: 45 days • Training types: online, corporate and classroom training classes. SHAREPOINT: • Creating/updating/propagating • Scopes SharePoint 2013 Training • Content types • Creating/updating/propagating • Using Lookups and Calculated Columns • Enforcing Unique values in List Contact Details, Mobile Numbers: 8056102481/9600063484 Land-Line: 044-42115526 Contact Person: papitha Mail id: Papitha.v@peridotsystems.in TAGS: SharePoint 2013 Training in Chennai | Best SharePoint 2013 Training in Chennai| SharePoint 2013 Training institute in Chennai with placement.

OBIEE Online Training Course Duration - 40hrs Sadguru Technologies-8179736190 -040-40154733 Data warehousing overview Basics of Data Warehousing What is OLTP and OLAP? Difference between OLTP and OLAP Advantages of OLAP What is Data Marts and ODS? Dimensional Modeling Overview Introduction to Dimensional Modeling What are Facts and Dimensions? Star schema and Snowflake schema Introduction to Business Intelligence What is Business Intelligence Where BI tools are Used Why the Oracle Business Intelligence Advantages Architecture, Components Clients - Answers, Delivers, Dashboards and Web administration, Servers- Oracle BI server, Presentation, Scheduler server Server Architecture Repository Basics What is Meta data? Creating a Repository using BI Administration Tool Physical, Business Model and Mapping, and presentation layers Properties of repository objects Building Physical Layer of a Repository Objects of Physical Layer DSN for a data sources Build physical layer Building business Model mapping layer Objects of BMM layer Building Business model (creating logical tables, columns, joins) Creating simple measures

JOB ORIENTED PEOPLESOFT TRAINING INSTITUTE IN CHENNAI... Peridot systems providing real time training to our valuable students. Our trainers having well experienced in leading mnc. For more course syllabus details contact papitha (8056102481). We offer both weekdays and weekend training classes. Website: www.peridotsystems.in Advantages:  Placement guidance  Demo classes  Online & Corporate training classes  45 days training classes. Course syllabus: PROCESS SCHEDULER • Run Control ID • Creating Run Control Page • SQR Introduction • Building your first SQR program • SQR columns, variables and literals Contact details, No’s: 8056102481/9600063484, 044-42115526 (papitha) Mail id: Papitha.v@peridotsystems.in Website: www.peridotsystems.in

SequelGate is one of the best training institutes for PL-SQL Training, oracle DBA Training, and Oracle Apps DBA Training. We have been providing Classroom and Online Training’s and Corporate training’s. All our training sessions are COMPLETELY PRACTICAL. PL-SQL Training with PROJECT - CLASSROOM TRAINING COURSE DETAILS: Introduction to DBMS Introduction to RDBMS Sub Language Commands Introduction to SQL Built-in Functions Grouping the result of a query Working with Integrity Constraints Querying Multiple Tables (Joins) Working with Sub Queries Working with DCL, TCL Commands Maintaining Database Objects Pseudo Columns in Oracle Data Partitions & Parallel Process Locks PL/SQL (Procedure Language – SQL) Advanced PL/SQL Database Triggers in PL/SQL Implementing Object Technology Using Collections Advanced Features Oracle Built-in Packages Introduction to Oracle Database Oracle Utilities Duration: 3 weeks, every day for 1.3 hours and all sessions are completely practical. One Real-time Project included in the course. All Sessions are Completely Practical and Realtime. Contact us today for practical PL-SQL Classroom training. SequelGate Training Institute  Office: (+91) 040 65358866 Mobile: (+91) 0 9030040801  Sai Anu Avenue, Street Number 3, Patrika Nagar, HITEC City, Hyderabad - 81 (India).