Columns

If you want to separate one cell content into separate columns in Excel, you can use the 'Convert Text to Columns Wizard'. This option is available in Data Tools in the Data tab. Text to Column is an amazing built-in tool in Excel. Using this you can separate texts into columns with characters like(/,-,space, and user input). we have already discussed how to join texts in Excel in our tutorial. To access the Text to Column shortcut in Excel, use: ALT + A + E How to Convert Text to Column in Exce...

If you want to separate one cell content into separate columns in Excel, you can use the 'Convert Text to Columns Wizard'. This option is available in Data Tools in the Data tab. Text to Column is an amazing built-in tool in Excel. Using this you can separate texts into columns with characters like (/,-,space, and user input). we have already discussed how to join texts in Excel in our tutorial. To access the Text to Column shortcut in Excel, use: ALT + A + E

If you want to separate one cell content into separate columns in Excel, you can use the ‘Convert Text to Columns Wizard’. This option is available in Data Tools in the Data tab. Text to Column is an amazing built-in tool in Excel. Using this you can separate texts into columns with characters like (/,-,space, […]

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

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

sadguru technologies 040-40154733​ 27. How many LTS (Logical Table Sources) can a logical table have? Whats the minimum and maximum? 28. How many server instances can coexist in an OBIEE cluster? 29. Whats a dimension only query in OBIEE? 30. Aggregation rules are set on top of …………… columns (Physical Columns or Logical Columns or Both) Lets get to questions that are little more complex in my opinion :) 31. What is alternative drill path? How do you set alternative drill path in OBIEE? 32. What are the pre-requisites for using aggregate persistence wizard? What does aggregate persistence wizard create and what does it help with? 33. Can you import data in multiple sheets from an Excel file? How do you import data from an Excel sheet? (Forget about csv files for now) 34. What are the uses of “Execute Direct SQL” feature in Answers? Is it a good practice to allow this feature for production users? 35. How do you disable “Execute Direct SQL” feature for all the users of your repository?

sadguru technologies . How many LTS (Logical Table Sources) can a logical table have? Whats the minimum and maximum? 28. How many server instances can coexist in an OBIEE cluster? 29. Whats a dimension only query in OBIEE? 30. Aggregation rules are set on top of …………… columns (Physical Columns or Logical Columns or Both) Lets get to questions that are little more complex in my opinion:) 31. What is alternative drill path? How do you set alternative drill path in OBIEE? 32. What are the pre-requisites for using aggregate persistence wizard? What does aggregate persistence wizard create and what does it help with? 33. Can you import data in multiple sheets from an Excel file? How do you import data from an Excel sheet? (Forget about csv files for now) 34. What are the uses of “Execute Direct SQL” feature in Answers? Is it a good practice to allow this feature for production users? 35. How do you disable “Execute Direct SQL” feature for all the users of your repository?

Advance Excel Trainers required in elegant it services in marathahalli • Exploring the Excel window • Getting help • Navigating workbooks • Navigating a worksheet Part 2: Entering and editing data • Entering and editing text and values • Entering and editing formulas • Working with pictures • Saving and updating workbooks Part 3: Modifying a worksheet • Moving and copying data • Absolute and relative references • Inserting and deleting ranges, rows, and columns Part 4: Using functions • Other useful functions Part 5: Formatting worksheets • Formatting text • Formatting rows and columns • Setting alignment • Applying borders to ranges • Using the Paste Special option • Removing a border • Conditional formatting • Copying formats and applying table formats • Using Find and Replace to change cell formats Part 6: Printing • Preparing to print • Page Setup options • Printing worksheets • Working with the print area Part 7: Creating charts • Chart basics • Using an embedded chart • Modifying charts • Changing a chart type • Applying Quick Layouts and Quick Styles • Formatting chart elements • Modifying an embedded chart • Printing charts Part 8: Managing large workbooks • Viewing large worksheets • Hiding and Unhiding columns and worksheets • Printing large worksheets • Using multiple worksheets • Previewing and printing multiple worksheets Advance Excel Course Syllabus Part 1: Work with Data •Text to Column •Group & Ungroup Your data •Using Subtotal •Conditional formatting Part 2: Work with Data - 2 •Remove Duplicates • Finding Unique Records • Unique records through criteria • Named Ranges • Drop Down • Data Validation Part 3: Presenting & Protecting the Date •Pivot Table •Charts •Goal Seek & Data Table •Scenario Manager & Solver •Protect & Un Protect work sheet / work book Part 4: Function & Formulas •Logical Functions •Text Functions •Date & Time Functions •Lookup Functions •Advance Sum Functions •Advance Count Functions •Validation Functions Part 5: Macros •What is a Macro ? •Creating Excel Macro •Running and Editing the Macro •Automating Tasks with Macro Thanks&Regards Elegant IT Services, #nd Floor,Aswath Nagar Varthur main road,Near Railway Fly Over Maratha halli,Land mark: Chemmunar Jewellers,

Advance Excel Quality training && coaching in elegant it services • Exploring the Excel window • Getting help • Navigating workbooks • Navigating a worksheet Part 2: Entering and editing data • Entering and editing text and values • Entering and editing formulas • Working with pictures • Saving and updating workbooks Part 3: Modifying a worksheet • Moving and copying data • Absolute and relative references • Inserting and deleting ranges, rows, and columns Part 4: Using functions • Other useful functions Part 5: Formatting worksheets • Formatting text • Formatting rows and columns • Setting alignment • Applying borders to ranges • Using the Paste Special option • Removing a border • Conditional formatting • Copying formats and applying table formats • Using Find and Replace to change cell formats Part 6: Printing • Preparing to print • Page Setup options • Printing worksheets • Working with the print area Part 7: Creating charts • Chart basics • Using an embedded chart • Modifying charts • Changing a chart type • Applying Quick Layouts and Quick Styles • Formatting chart elements • Modifying an embedded chart • Printing charts Part 8: Managing large workbooks • Viewing large worksheets • Hiding and Unhiding columns and worksheets • Printing large worksheets • Using multiple worksheets • Previewing and printing multiple worksheets Advance Excel Course Syllabus Part 1: Work with Data •Text to Column •Group & Ungroup Your data •Using Subtotal •Conditional formatting Part 2: Work with Data - 2 •Remove Duplicates • Finding Unique Records • Unique records through criteria • Named Ranges • Drop Down • Data Validation Part 3: Presenting & Protecting the Date •Pivot Table •Charts •Goal Seek & Data Table •Scenario Manager & Solver •Protect & Un Protect work sheet / work book Thanks&Regards Elegant IT Services, #nd Floor,Aswath Nagar Varthur main road,Near Railway Fly Over Maratha halli,Land mark: Chemmunar Jewellers, Bangalore - .Ph: -/87

SQL-PL SQL SQL •The Oracle database environment Reviewing basic architecture concepts, Oracle 10g Architecture,Main features of 9i and 10g •Basic SELECT Statement Writing the statement in sqlplus, Running the SELECT statement •Ordering the output Single Column, Descending order, Multiple column sort •Conditional retrieval of data Working with complex conditions, AND OR NOT,,,, LIKE BETWEEN •Pseudo columns and functions Pseudo Columns, Rownum, Sysdate, User & UID, the Dual Table •Working with character functions UPPER, LOWER, INITCAP, RPAD(), TRIM(), SUBSTR(), INSTR(), TRANSLATE(), REPLACE(), GREATEST(), LEAST(), •Working with date functions TO_CHAR(), TO_DATE(), MONTHS_BETWEEN(), ADD_MONTHS(), LAST_DAY(), NEXT_DAY() •Using non-character function ROUND(), TRUNC(), SIGN(), Working with multiple tables, Different type of Joins, Writing Outer Joins •Using the SET operators Union, Intersect, Minus •Aggregating data using group functions GROUP BY, HAVING •Creating Subqueries Single Row subqueries, Multiple row Subqueries •Enhancing groups function ROLLUP, CUBE •Transaction Control Language Rollback, Commit, Savepoint •Processing hierarchies Creating the Tree structure, LEVEL, CONNECT BY •Data Manipulation Language INSERT, UPDATE, DELETE •Data Definition Language CREATE, TRUNCATE, ALTER, DROP, RENAME, DESCRIBE •Using Declarative Constraints Not Null Constraint, Check Constraint, Unique Constraint, Primary Key Constraint, References Constraint, On Delete Cascade, On Delete Set Null •Other Database Objects Views, Sequences, Synonyms, Indexes USER_TABLES, USER_TAB_COLUMNS, USER_OBJECTS •Database Security Object Privileges, Granting access to objects PL -SQL •Blocks Structure, Writing Anoyomous Blocks •Variables Oracle Datatypes, TYPE and ROWTYPE declarations, Value assignments •Control structures IF ELSE ENDIF statement, IF ELSIF ELSE ENDIF statement, LOOP END, LOOP statement, WHILE condition, FOR condition •Cursors Implicit and Explicit Cursors, Cursor Manipulation statements, OPEN FETCH CLOSE EXIT WHEN •Error Handling Predefined Exceptions, Non-Predefined Excecptions, User Defined Exceptions •Procedures Creating and Calling Procedures •Functions Creating and Calling Functions •Packages Package Header, Package Body •Design Tips and Techniques Format of standard packages in an application, Spec and Body, NOCOPY hint ------------- thoery •Triggers Database triggers, CALLing procedures from triggers •Dynamic SQL EXECUTE IMMEDIATE, DBMS_SQL package •Oracle Supplied packages DBMS_OUTPUT, UTL_FILE •Collection datatypes Associative Arrays, Nested tables, VARRAYs For More Details contact us: Elegant It Services contact no:

Course content: "Teradata Admin Track" Teradata Architecture and other essentials Introduction What is Teradata and role of Teradata in Data Ware housing industry, Evolution of Teradata DW, Significant characteristics of Teradata, Advantages of Teradata over other RDBMS Teradata Architecture Understanding H/W and S/W components, involved in Architecture of Terdata(vdisks, AMP, PE Vprocs, BYNET etc...). Data distribution Understanding significance of Index in teradata(UPI, NUPI, SI, NUSI, Partitioned index) Data Protection Different levels of failures that could happen and fault tolarance of Teradata in that situations. (CLIQUE, CLUSTER, RAID, LOCKS and JORNALS) Advanced Teradata SQL HELP, SHOW, EXPLAIN, Define and execution of Macros, Date calculations, data type conversion, Case, COALESCE, sample, Ranking, Qualify, CSUM, MSUM, MDIFF, MAVG, WITH, WITH BY. Others (Optional) Unix Role of Unix in executing Teradata utility scripts and Basic commands used General Lifecycle of the projects General phases of a Development project. Documents required in each phase DBA Teradata DBA basics and responsibilities Initial Teradata Databases Administrative User Owners, Parents and Children Creating New Users and Databases Transfer of Ownership DELETE/DROP Statements User and Security Management Understand the Heirarchy,Teradata Administrator tool usage to perform creation of users, databases, Identify spaces, skew of databases, Moving spaces and accesses, And all the practicals to perform of all coming up topics. The Data Dictionary Updating Data Dictionary Tables Supplied Data Dictionary Views Restricted Views Suffix Options with Views Selecting Information about Created Object Children View, Databases View, Users View, Tables View Columns View, Indices View Capacity management and planning Spaces and types of tables - PERM, SPOOL, TEMP space terminology, Derived,Volatile, Global temporary tables. Identify current space usage and estimate the space requirments for the applications. Users, Accounts, and Accounting Creating and Using Account IDs Using Account IDs with Logon Dynamically Changing an Account ID Account Priorities Account String Expansion Access Rights Privileges/Access Rights Implicit, Automatic, and Explicit Rights GRAND and REVOKE accesses, GIVE command System Views for Access Rights Inheriting Access Rights, Transfer access rights, Delete or Drop / user or database Roles and Profiles What is a role, Advantages of Roles, Access Rights Using a Role, Implementing Roles, Nesting of roles, views for roles, Profiles, implementing Profiles, Teradata password control Work load management and Priority scheduler Levels of Workload Management, Priority Scheduler Architecture, and concepts Access logging and Query logging Setting up Access Logging, AccLogRules View, Query Logging (DBQL) Concepts, Objects used in Defining Rules for DBQL, DBQLRules View Setting up Access Logging, AccLogRules View, Query Logging (DBQL) Concepts, Objects used in Defining Rules for DBQL, DBQLRules View Performance monitoring (PMON) Resource usage, Session Management User session Info, SQL & Explain Steps Archive and Restore and copy Archive and restore data using ARCMAIN utility, Different levels of archiving and restoration, HUT locks, Revalidate references after restoration View point The Demo of view point portlets (which is new tool for DBAs having the features of PMON, TDMANAGER and TASM Performance tuning Explain plan, Statistics and Join strategies Explain plan and recommandations. Significance of collecting statistics Other indexes, and techniques Determine the proper join columns, Join index, Spars index, Aggregate index, SET / MULTSET with UPI and NUPI combinations, compress. Course Content: Teradata Dev Track History and Architecture Introduction OLTP, OLAP systems, Dataware house and Data Marts, Dimenssion modeling, Schemas, What is Teradata and role of Teradata in DW, Evolution of Teradata DW, Advantages of Teradata over other RDBMS Teradata Architecture Understanding H/W and S/W components, involved in Architecture of Terdata(vdisks, AMP, PE Vprocs, BYNET etc…). Database structure Data distribution Understanding significance of Index in teradata(UPI, NUPI, SI, NUSI, Partitioned index) Data Protection Different levels of failures that could happen and fault tolarance of Teradata in that situations.(CLIQUE, CLUSTER, RAID, LOCKS and JORNALS) Spaces and types of tables Different levels of accessing the objects granting the Privileges and locking mechanism SQL ASNI SQL Brief introduction of Relational concepts, understanding users, databases, tables, vies, index, macro etc. Sub query, corelated query, Data types, Joins, Arthimatic functions Teradata SQL Explore teradata specifc SQL statements such as show, help,explain..SET operations, Aggregate functions, Sring functions, Aliasing,FORMAT, conversion of the datatypes. Advanced Teradata SQL Define and execution of Macros, Date calculations, Case, COALESCE, sample, Ranking, Qualify, CSUM, MSUM, WITH, WITH BY. Client utilities SQL Assistant Settup ODBC for connecting through SQL assistant, options menu and EXPORT/IMPORT BTEQ Functinality,operations, exectuion and limitations FAST LOAD Functinality, Different phases, exectuion, restartability and limitations FAST EXPORT Functinality, Different phases, exectuion, restartability and limitations MULTI LOAD Functinality, Different phases, exectuion, restartability and limitations Performance tuning Explain plan & Statistics & Understanding Explain plan and recommandations. Significance of collecting statistics Other techniques Determine the proper join columns, Join index, Spars index, Aggregate index, SET / MULTSET with UPI and NUPI combinations, compress Others (Optional) Unix Role of Unix in executing Teradata utility scripts and Basic commands used General Lifecycle of the projects General phases of a Development project. Documents required in each phase

phptraininginjaipur.info How PHP Works The php.ini File Basic PHP Syntax PHP Tags PHP Statements and Whitespace Comments PHP Functions Variables Variable Types Variable Names (Identifiers) Type Strength Variable Scope Constants Variable-Testing and Manipulation Functions PHP Operators Creating Dynamic Pages Single Quotes vs. Double Quotes Flow Control If Conditions Loops while do…while for break and continue Arrays Enumerated Arrays Initializing Arrays Appending to an Array Reading from Arrays Looping through Arrays Associative Arrays Initializing Associative Arrays Reading from Associative Arrays Looping through Associative Arrays Two-dimensional Arrays Reading from Two-dimensional Arrays Looping through Two-dimensional Arrays Array Manipulation Functions PHP and HTML Forms HTML Forms How HTML Forms Work A Sample HTML Form Form Variables String Manipulation Formatting Strings Concatenation String Manipulation Functions Examples of String Functions Magic Quotes magic_quotes_gpc magic_quotes_runtime Recommendation on Magic Quotes Reusing Code and Writing Functions Including Files Require require_once auto_prepend_file and auto_append_file User Functions Defining and Calling Functions Default Values Variable Scope By Reference vs. By Value Form Processing Code Organization Simple SELECTs Introduction to the Northwind Database Some Basics Comments Whitespace and Semi-colons Case Sensitivity Selecting All Columns in All Rows Selecting Specific Columns Sorting Records Sorting By a Single Column Sorting By Multiple Columns Sorting By Column Position Ascending and Descending Sorts The WHERE Clause and Operator Symbols Checking for Equality Checking for Inequality Checking for Greater or Less Than

If you want to separate one cell content into separate columns in Excel, you can use the 'Convert Text to Columns Wizard'. This option is available in Data Tools in the Data tab. Text to Column is an amazing built-in tool in Excel. Using this you can separate texts into columns with characters like (/,-,space, and user input). we have already discussed how to join texts in Excel in our tutorial. To access the Text to Column shortcut in Excel, use: ALT + A + E https://www.basictutorials.in/how-to...

QA Testing Course Content: MANUAL TESTING SDLC 1. What are the different phases of SDLC? 2. How does the process of Software Development Start? 3. Project Initiation 4. Requirement Gathering and Analysis 5. What is Requirement document and what it contains? 6. What is use case document and what it contains? 7. What is Basic path and Alternate Path? 8. Role of Business Analyst 9. Example for explaining each phase 10. Role of technical specification team 11. What is Technical specification document? 12. What is System Design? 13. Role of Design team 14. What is design document? 15. Role of architecture team 16. System development 17. Role of development team 18. Deliverable of Development phase 19. System testing 20. Role of testers and types of testing 21. User acceptance testing 22. System deployment 23. System maintenance 24. Events in the maintenance phase like bug fixes 25. STLC 26. How are the phases of STLC carried out? 27. What is testing? 28. Role of testers 29. Why do we need to test? 30. Activities involved in the testing phase 31. What is test plan and test case document? 32. Steps of test case execution 33. What does test case document contain? 34. How to write test case document? 35. What is required to test any application? TEST CASES 1. What is test case? 2. What does test case document contain? 3. How to write test case document? 4. Different test case techniques TEST PLAN 1. What is Test Plan? 2. How to write test plan document? 3. What does the test plan document contain? 4. Who writes and approves the test plan document? 5. How manage the test case documents? 6. What is the pass/fail criterion? TYPES OF TESTING 1. Different Phases of testing 2. What is unit testing? 3. What is Minimum acceptance testing? 4. What is integration, system and system integration testing? 5. What is User acceptance testing? 6. What is Regression Testing? DEFECT ANALYSIS 1. What is a defect? 2. Various Defect tracking tools 3. How to use the defect tracking tools? 4. How to enter the details of defect in the defect tracking tool? 5. How to identify a defect? What is severity and priority? TRACEABILITY MATRIX 1. What is Traceability Matrix[TM]? 2. Who Prepares the TM document? 3. What is the reference for writing TM? 4. What is the use of TM? 5. What is present in the TM document? 6. Sample TM 7. Tools used for developing TM Various Teams and their Roles 1. Configuration Management Team 2. Role of configuration management team 3. What is Deployment? 4. Deployment Team 5. Role of Deployment team 6. Version Control 7. Various version tools and its usage 8. Difference between QC and QA 9. What is automation testing? 10. Why, what and when to automate? 11. Various tools used for automation testing MANAGEMENT TOOL QUALITY CENTER 1. Introduction to Quality Center 2. What is Quality Center ? 3. Why to use Quality Center 4. Version of Quality Center 5. Overview of quality Center user interface 6. Various tabs in Quality center 7. Requirement Module 8. Requirement Module Overview 9. Creating Requirement tree 10. Creating Parent & Child requirements 11. Understanding the Description tab 12. Understanding the History tab 13. Uploading attachments to requirement 14. A glance at various columns in requirement 15. Types of views in requirement module 16. Requirement grid view 17. Requirement coverage view 18. Test Plan Module 19. Creating folder structure 20. Create test cases 21. Requirement coverage 22. Test Lab Module 23. Overview of Test Lab 24. Detail of various tabs 25. Creating folders 26. Creating Test sets 27. Adding test cases 28. Different columns in Execution Grid 29. Execution Flow tab 30. Scheduling Test runs 31. Test Set Properties tab 32. Linked Defects tab 33. Running Tests manually 34. Running Tests automatically 35. Viewing Test results Quality Center Defects Overview of Defects 1. Creating defects after test execution 2. Adding defects in defect module 3. Creating defects during test execution 4. Linking Defects 5. How to close a defect 6. Closing defects after retest 7. Mailing the defects 8. Quality Center reports & graphs 9. Why Reports & Graphs? 10. How to create reports & graphs for Analysis? AUTOMATION TESTING: QUICK TEST PROFESSIONAL 1. Introduction to QTP 2. What is QTP 3. Prepare Before Automation 4. Application Under Test 5. First look at Add-Ins for QTP 6. Understanding the QTP User Interface Setting up preferences in QTP before recording. 1. Different versions of QTP(Text based) 2. Difference between QTP 9.0 and QTP 8.2. 3. Difference between QTP 9.2 and QTP 9.0 4. Difference between QTP 9.5 and QTP 9.2. • Record and run a script • Record a simple script • Save the script • Run the test script • Understand the result Introduction to Object Repository 1. What is Object Repository 2. Types of Object Repository 3. Object Repository Manager 4. Associating shared Object Repository with test 5. Shared Object Repository 6. Local Object Repository 7. Create a shared Object Repository 8. Add objects to shared Object Repository 9. Save an shared Object Repository 10. Modify the shared Object Repository 11. Comparing Local and Shared Object Repository Synchronization 1. What is Synchronization 2. Synchronization in QTP 3. Add Synchronization Steps for an Object Check Point 1. What is Check Point 2. Using Standard Check Point 3. Using Text Check Point 4. Using Access ability check point 5. Using XML Check Point Database checkpoint 1. What is database checkpoint 2. Writing SQL Query using Microsoft Query 3. Parameterize a database checkpoint 4. Output Values 5. What is Output value 6. Using Standard Output value 7. Using Text Output value 8. Using Database Output value 9. Using XML Output value Data Driven Test 1. What is Data Driven test 2. What is Parameterization http://trainingforu.blogspot.in/ Contact Person: Ashwini (M) 09620914455. Email: ashwini.hbst@gmail.com For More Details: Contact or Consult Our Office Once.

List the Attributes | Peculiarity of Oracle Database 12C Examine and explore design, Physical, Practical facet of a relational database Classify the Various types of SQL statements Outline the data set used by the course Signin to the database using SQL Developer environment Store queries to files and Operate script files in SQL Developer Bring Data using the SQL SELECT Statement Describe the abilities of SQL SELECT statements Produce a report of data from the output of a SELECT statement Select All Columns,Specific Columns using query Use Column Heading Defaults, Arithmetic Operators Explain and Explore Operator Precedence and Describe Command ?Thanks & Regards Learners ERA, USA: India: + UK: +

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

Learn MS-Excel from Industry Expert Navigating in a spreadsheet Understanding worksheets, columns, rows and cells Saving, opening, and closing workbooks Formatting numbers Clearing formats Applying borders to cells Merging cells Module 2: Formatting a Spreadsheet Changing column widths and row heights Changing alignment of cells Undoing and redoing actions Formatting numbers Clearing formats Applying borders to cells Merging cells Module 3: Previewing worksheets Page setup Printing of worksheets in multiple pages Repeating rows and columns for multiple pages Printing multiple worksheets Pivot Table, Report Preparation and much more. Show your Student-Id card to get discounted training fee

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

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

Real Time Training Oracle Apps Tech,Oracle Apps Tech elegant it services • What is ERP? • Comparison of Oracle Apps with other ERPS • Types of Roles, Types of projects, AIM documents • Oracle Apps structure, database structure and 3-tier architecture Application Object Library(AOL) • Concurrent program with parameters, Creating Value sets • Menu construction, Defining concurrent program • Levels of Oracle Applications, Creating users, WHO columns, Creating responsibilities • Scheduling concurrent program, Creating request group, Creating request set Multi Org Concepts • What is Multi Org and why we need • Multi Org Tables • Multi Org Views 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 • Purchasing order module with base table • General Ledger module with base tables • HRMS module with base table Reports • Report development process, Report registration process • Bind parameters, lexical parameters, reports with value set, Building report manually • Using repeating frames, Summary columns, Standard report customization Interfaces • Introduction to Interfaces, working with Out Bound Interfaces, using UTL_FILE package • Inbound Interface process, Working with SQL*Loader tool • Different option in SQL *Loader tool, bad file, discard file • Using Interface table approach • Using API Approach Conversions • Introduction to conversions, Creation of staging table • Developing the validation package, explaining the real time project code. • Completing the conversion task, Differences between Inbound interfaces and Conversions Forms • Form development process using TEMPLATE.FMB, Form registration process • Form personalization • Form Customation Using Custom.pll Workflows • Workflow Customization process steps Alerts • Overview on alerts • Creation of alerts • Types of alerts XML Publisher • Introduction to XML publisher, Report development process • Creating reports for multiple rows, Creating Data definitions, Creating templates, Multi Layout Reports • XML publisher Barcode Report(Advance) • XMLP Bursting Concept (Advance) Flex fields • Creating DFF, Creating KFF Functional Cycles • P2P Cycle(Procure to Pay Cycle) • O2C Cycle(Order to Cash Cycle) Thanks&Regards Elegant IT Services, #nd Floor,Aswath Nagar Varthur main road,Near Railway Fly Over Maratha halli,Land mark: Chemmunar Jewellers, Bangalore -

1.Introduction of Sharepoint 2013 •Sharepoint Three Tier Architecture •Sharepoint version history •Sharepoint 2013 Structure and capabilities •Significant changes from sharepoint 2010 •Hardware & software prerequisites for sharepoint 2013 2.Installation and Sharepoint Farm configuration •Hardware & Software Requirements •Install and configure Windows server 2008 r2 service pack1/ windows server 2012 •Install active directory domain services •Install sql server 2008 r2 service pack 1/ sql server 2012 •Install & configure sharepoint server 2013 3.Sharepoint site hierarchy •Creating Web application •Creating sitecollection •Creating list •Managing list columns and views •Using site columns, lookup fields •Check in/ check out and versioning settings for document library 4.Creation and configuration of wikis, blogs and surveys •Blogs •Survey •Discussion board 5.Security and permission management •Permission settings at site collection, sub sites list and item level •Configuring custom permission •Stop parent permissions •App identity 6.Managing web application and recommendation for port number, database and security •Web application settings •Content database •IIS websites 7.Managing Site collection and databases •Site collection and database quota •Add multiple content databases with single web application •Creating group and assigning permission accordingly 8.Retention Policy Management though Workflow •Configuration of Retention Policy •Creation of Workflow •Attaching workflow for Retention Policy •Retention Policy Workflow Timer Job configuration 9.Enterprise managed metadata services and user profile services •Creating terms and term stores •Using managed metadata in lists in libraries •User profile service configuration •User profile properties management •Synchronization services •My sites 10.Sharepoint designer, Logical structure of site and External content type •Installation of sharepoint designer 2013 •Creating and opening site in sharepoint designer 2013 •Creating and opening List/ library in sharepoint 2013 •Creating connection with external data source (Sql Server) 11.Search service application •Search service application overview •Site search configuration •Result types •Query rules •Search webparts 12.Backup and restore using PowerShell and running PowerShell script using Powershell_ISE •Overview of Backup options •Farm/ site backup and restore •Content backup and restore •Granular Backup of site collection 13.Upgrade and migration •Migration path and approaches •DB attach migration

Check out my other items ! *Sold under partnership. Authorized Reseller. WPS Office 2016 Business Edition - Annual Subscription Brand new interface The fire-new designed interface is simple, generous and easy to navigate. Greatly improve the efficiency of document editing.     VBA macros VBA enables you to program Spreadsheets so that you can automate a boring report, format a big ugly chart, clean-up some messy data or just play some random noises. Intuitive table operation Innovative paragraph & table adjustment tools. Tight, loose, wide or narrow, adjust your paragraph with drag and drop. Inserting as many rows & columns as you like by dragging the table. Multiple tabs It allows you to open several slide pages on just one single window interface, which will save you from the trouble of switching among presentation documents.     Over 1,000,000 rows & 10,000 columns   Check out my other items !

We offer training on STAAD-Pro by realtime trainer. Course details Introduction Problem initiation, unit specification Material Specification Member Specification Listining members, joints etc., Load specification Analysis Specification Selection Specification Finite element information Mesh generation, member property Element load specification for joints Concrete design as per IS-456, Design of beams, columns etc. Design initiation, design commands, take off command Steel design as per IS-800 parameter specification Analysis of plane , truss, simple beam cantilever beam Analysis of plane frame, plane truss, multilevel plane frame etc. For details contact : Arun 9845382820 Location : Techsys,Basaveshwar nagar,near hotel pavitra paradise Bangalore - 79, India

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

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