Metadata

WARM WELCOME FROM VELGRO TECHNOLOGIES!!! We are providing training for DATA WAREHOUSE Training is provided by well experienced (REAL TIME) Faculty!!! Fee structure Course fees: RS./- Data Warehouse The Compelling Need for Data Warehousing • Escalating Need for Strategic Information • Failures of Past Decision-Support Systems • Operational Versus Decision-Support Systems • Datawarehousing—The Only Viable Solution • Datawarehouse Defined • The Datawarehousing Movement • Evolution of Business Intelligence Data Warehouse: The Building Blocks • Review formal definitions of a data warehouse • Discuss the defining features • Distinguish between data warehouses and data marts • Study each component or building block that makes up a data warehouse • Introduce metadata and highlight its significance Trends in Data Warehousing • Data Warehouse Do-Overs • Proliferation of Data Sources • Outsourcing • Hub Versus Relational Databases • Active Data Warehouses • Fusion with CRM • Growing Number of End Users • More Complex Queries • Integrated Customer View • Exploding Data Volumes Planning and Project Management • Phases in project management • Inception • Elaboration • Construction • Transition Defining the Business Requirements • To gain agreement with stakeholders • To provide a foundation to communicate to a technology service provider what the solution needs to do to satisfy the customer’s and business’ needs • To provide input into the next phase for this project • To describe what not how the customer/business needs will be met by the solution Requirements as the driving force for data warehousing • Understand why business requirements are the driving force • Discuss how requirements drive every development phase • Specifically learn how requirements influence data design • Review the impact of requirements on architecture • Note the special considerations for ETL and metadata • Examine how requirements shape information delivery The Architectural Components • Overall Architecture • Data Warehouse Database • Sourcing, Acquisition, Cleanup and Transformation Tools • Meta data • Data Marts • Data Warehouse Administration and Management Infrastructure as the Foundation for Data Warehousing • Understand the distinction between architecture and infrastructure • Find out how the data warehouse infrastructure supports its architecture • Gain an insight into the components of the physical infrastructure • Review hardware and operating systems for the data warehouse • Study parallel processing options as applicable to the data warehouse • Discuss the server options in detail • Learn how to select the DBMS • Review the types of tools needed for the data warehouse • Study the concept and use of data warehouse appliances The Significant Role of Metadata • Find out why metadata is so important • Understand who needs metadata and what types they need • Review metadata types by the three functional areas • Discuss business metadata and technical metadata in detail • Examine all the requirements metadata must satisfy • Understand the challenges for metadata management • Study options for providing metadata Principles of Dimensional Modelling • Clearly understand how the requirements definition determines data design • Introduce dimensional modelling and contrast it with entity-relationship modelling • Review the basics of the STAR schema • Find out what is inside the fact table and inside the dimension tables • Determine the advantages of the STAR schema for data warehouses Dimensional Modelling: Advanced Topics • Discuss and get a good grasp of slowly changing dimensions • Understand large dimensions and how to deal with them • Examine the snowflake schema in detail • Learn about aggregate tables and determine when to use them • Completely survey families of STARS and their application Data Extraction, Transformation, and Loading • Part I: When to build your data warehouse • Part II: Building a new schema • Part III: Location of your data warehouse The Physical Design Process in DWH • Distinguish between physical design and logical design as applicable to the data warehouse • Study the steps in the physical design process in detail • Understand physical design considerations and know the implications • Grasp the role of storage considerations in physical design • Examine indexing techniques for the data warehouse environment • Review and summarize all performance enhancement options • Matching Information to the Classes of Users OLAP in the Data Warehouse • OLAP (Online Analytical Processing) • Overview & Introduction • OLAP Cube • HISTORY of OLAP • OLAP Operations • DATAWAREHOUSE • ARCHITECHTURE Difference between OLAP & • OLTP & TYPES OF OLAP APPLICATIONS OF OLAP • Data Warehousing and the Web • Data Warehouse Deployment • Data Quality: A Key to Success • Data Mining Basics • Growth and Maintenance contact person: SUJITHA Venue Address: #st floor,Gandhi Road, Velachery Email Id:velgrotechnologies at gmail dot com info at velgrotechnologies dot com Website:www dot velgrotechnologies dot com

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

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

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

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

SAP BODS 4.2 On-line & Classroom Training Bangalore 1. Data ware housing concepts Describe dimensional modeling 2. Understanding Data Integrator Describe components, management tools, and the development process Explain object relationship 3. Defining source and target metadata Create a database data store and import metadata Create a new file format and handle errors in file formats 4. Validating, tracing, and debugging jobs Use description and annotations Validate and trace jobs Use view data and the Interactive Debugger 5. Creating a batch job Create a project, job, work flow, and data flow Use the query transform in a data flow Use template tables 6. Using built-in transforms and nested data Use the case, merge, and validation transforms Use the Pivot, reverse Pivot Hierarchy flattening 7. Using built-in functions Use date and time functions and the date generation transform to build a Dimension table Use the lookup functions to look up status in a table Use match pattern functions to compare input strings to patterns Use database type functions to return information on data sources 8. Using Data Integrator Scripting Language and Variables Explain differences between global and local variables Create global variables and custom functions Use strings and variables in Data Integrator scripting language 9. Capturing Changes in Data Use Change Data Capture (CDC) with time-stamped sources Create an initial and delta load job Use history preserving transform 10. Handling errors and auditing Recover a failed job Create a manual, recoverable work flow Define audit points, rules and actions on failures 11. Supporting a multi-user environment Describe terminology and repository types in a multi-user environment Create and activate the central repository 12. Migrating Projects Work with projects in the central repository Creation of Profile Repository Understand Profiling 13. Using the Administrator Execute, schedule, and monitor batch jobs Understand architecture, load balance index, and job execution in server Groups 14 Profiling Data Set up the Data Profiler and users Submit a profiling task Monitor profiling tasks in the Administrator 15. Managing Metadata Import and export metadata Use Metadata Reports 16. Data Quality Management 17. SAP Integration Data extraction from ECC system to File, Table and SAP BI. Extract the data from SAP BI & NON SAP Systems using Open hub Services and Data services as 3rd party system.

IBM InfoSphere DataStage Online Training in Chennai India. We provide the best online/classroom/corporate training across India and other countries for IBM InfoSphere DataStage. IBM InfoSphere DataStage - popularity increasing rapidly IBM InfoSphere DataStage is an ETL tool and part of the IBM Information Platforms Solutions suite and IBM InfoSphere. It uses a graphical notation to construct data integration solutions and is available in various versions such as the Server Edition, the Enterprise Edition, and the MVS Edition. The IBM InfoSphere DataStage is capable of integrating data on demand across multiple and high volumes of data sources and target applications using a high performance parallel framework. InfoSphere DataStage also facilitates extended metadata management and enterprise connectivity Classes are conducted under guidance of experts who will help you to understand concepts very clearly. We even support even after you finish course. The training is provided by working professionals with more than 10+ years of experience. The training will be 100% real time. IBM InfoSphere DataStage Online Training in Chennai India. We provide the best online/classroom/corporate training across India and other countries for IBM InfoSphere DataStage. IBM InfoSphere DataStage - popularity increasing rapidly IBM InfoSphere DataStage is an ETL tool and part of the IBM Information Platforms Solutions suite and IBM InfoSphere. It uses a graphical notation to construct data integration solutions and is available in various versions such as the Server Edition, the Enterprise Edition, and the MVS Edition. The IBM InfoSphere DataStage is capable of integrating data on demand across multiple and high volumes of data sources and target applications using a high performance parallel framework. InfoSphere DataStage also facilitates extended metadata management and enterprise connectivity Classes are conducted under guidance of experts who will help you to understand concepts very clearly. We even support even after you finish course. The training is provided by working professionals with more than 10+ years of experience. The training will be 100% real time. IBM InfoSphere DataStage Online Training in Chennai India. We provide the best online/classroom/corporate training across India and other countries for IBM InfoSphere DataStage. IBM InfoSphere DataStage - popularity increasing rapidly IBM InfoSphere DataStage is an ETL tool and part of the IBM Information Platforms Solutions suite and IBM InfoSphere. It uses a graphical notation to construct data integration solutions and is available in various versions such as the Server Edition, the Enterprise Edition, and the MVS Edition. The IBM InfoSphere DataStage is capable of integrating data on demand across multiple and high volumes of data sources and target applications using a high performance parallel framework. InfoSphere DataStage also facilitates extended metadata management and enterprise connectivity Classes are conducted under guidance of experts who will help you to understand concepts very clearly. We even support even after you finish course. The training is provided by working professionals with more than 10+ years of experience. The training will be 100% real time. IBM InfoSphere DataStage Online Training in Chennai India. We provide the best online/classroom/corporate training across India and other countries for IBM InfoSphere DataStage. IBM InfoSphere DataStage - popularity increasing rapidly IBM InfoSphere DataStage is an ETL tool and part of the IBM Information Platforms Solutions suite and IBM InfoSphere. It uses a graphical notation to construct data integration solutions and is available in various versions such as the Server Edition, the Enterprise Edition, and the MVS Edition. The IBM InfoSphere DataStage is capable of integrating data on demand across multiple and high volumes of data sources and target applications using a high performance parallel framework. InfoSphere DataStage also facilitates extended metadata management and

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

INSTALLING AND SETTING UP THE WAREHOUSE BUILDER ENVIRONMENT What Is Oracle Warehouse Builder? Basic Process Flow of Design and Deployment Oracle Warehouse Builder Licensing and Connectivity Options Installing Oracle Warehouse Builder 11.2 OWBSYS Schema Using OWB 11.2 with Database 10g R2 Using the Repository Assistant to Manage Workspaces Supported operating systems (OS), sources, targets, and optional components GETTING STARTED WITH WAREHOUSE BUILDER Logging In to OWB Design Center Overview of the Design Center OWB Projects Overview of Objects within a Project Overview of Objects within an Oracle Module Organizing Metadata Using Foldering Locations Navigator and Globals Navigator panels Setting Projects Preferences: Recent Logons UNDERSTANDING THE WAREHOUSE BUILDER ARCHITECTURE Warehouse Builder Development Cycle Overview of the Architecture for Design, Deployment, Execution Overview of Configurations, Control Centers, and Locations Creating Target Schemas Registering DB User as an OWB User Roles and Privileges of Warehouse Builder Users Registering an Oracle Workflow User DEFINING SOURCE METADATA Data warehouse implementation: Typical steps Difference Between Obtaining Relational and Flat File Source Metadata Creating Flat File Module Sampling Simple Delimited File Sampling Multi-record Flat File

Best Education OWB Online trainings in hyderabad INSTALLING AND SETTING UP THE WAREHOUSE BUILDER ENVIRONMENT What Is Oracle Warehouse Builder? Basic Process Flow of Design and Deployment Oracle Warehouse Builder Licensing and Connectivity Options Installing Oracle Warehouse Builder 11.2 OWBSYS Schema Using OWB 11.2 with Database 10g R2 Using the Repository Assistant to Manage Workspaces Supported operating systems (OS), sources, targets, and optional components GETTING STARTED WITH WAREHOUSE BUILDER Logging In to OWB Design Center Overview of the Design Center OWB Projects Overview of Objects within a Project Overview of Objects within an Oracle Module Organizing Metadata Using Foldering Locations Navigator and Globals Navigator panels Setting Projects Preferences: Recent Logons UNDERSTANDING THE WAREHOUSE BUILDER ARCHITECTURE Warehouse Builder Development Cycle Overview of the Architecture for Design, Deployment, Execution Overview of Configurations, Control Centers, and Locations Creating Target Schemas Registering DB User as an OWB User Roles and Privileges of Warehouse Builder Users Registering an Oracle Workflow User DEFINING SOURCE METADATA Data warehouse implementation: Typical steps Difference Between Obtaining Relational and Flat File Source Metadata Creating Flat File Module Sampling Simple Delimited File Sampling Multi-record Flat File Creating an Oracle Module Selecting the Tables for Import

WEBLOGIC ADMIN TRAINING IN HYDERABAD@Sadguru Technologies We are glad to announce our newly launched Online Oracle Fusion Middleware 11g SOA The Oracle SOA Suite 11g: Administration course describes how Oracle SOA Suite 11g, a Middleware component of Oracle Fusion Middleware, provides a complete set of service infrastructure components (such as Mediator, BPEL, Human Workflow, Business Rules, and Business Process Management components) for designing, deploying, and managing SOA composite applications. The participant is therefore required to have knowledge about essential Oracle WebLogic Server administration tasks. They learn how to install and configure Oracle SOA Suite 11g components in Oracle WebLogic Server domains. They learn to use the Oracle Enterprise Manager Fusion Middleware Control Console to perform administrative tasks such as deploying SOA composite applications, configuring SOA composite application resources, monitoring SOA composite applications, managing and monitoring service engines, and updating the state of SOA composite applications. They also learn how to troubleshoot SOA composite applications by performing corrective actions such as fault recovery. They are given a brief introduction to tuning and configuring Oracle SOA Suite 11g environment for high availability. Course Contents: I. Introduction to Oracle Fusion Middleware 11g • Fusion Middleware concepts • Introduction to WebLogic Server • WebLogic Server Domain, Administration Server and Managed Server • Oracle Instance , Oracle Home, Metadata Repository • File System and Directory Structure in Fusion Middleware II. Installation & configuration of Fusion Middleware (DB, WebLogic & SOA Suite) • Installing Oracle Database • Installing Metadata Repository for Fusion Middleware • Installing WebLogic Server • Installing Additional Fusion Middleware component (SOA Suite) • Configuring Fusion Middleware component (SOA Suite) • Start/Stop Services Oracle Fusion Middleware 11g SOA Administrator Training - Contents • Start/Stop WebLogic Administration Server • Start/Stop Managed Server • Start/Stop Middleware Control III. Node Manager and Deploying Application • Introduction to Node Manager • Configuring Node Manager and starting Managed Servers using Node Manager • Overview of Deploying Applications • Understanding Data Sources • Deploying and Undeploying Java EE Applications IV. Monitoring Oracle Fusion Middleware • Overview of Monitoring Oracle Fusion Middleware • Monitoring the Status of Oracle Fusion Middleware • Monitoring an Oracle WebLogic Server Domain • Monitoring an Oracle WebLogic Server Administration Server or Managed Server • Monitoring a Component • Monitoring Applications • Monitoring the Performance of Oracle Fusion Middleware Components V. Configuring Security and High Availability for SOA • Creating Additional Administrative Users • Creating Additional Users with Specific Roles • Changing the Administrative User Password • Defining Virtual Hosts for SOA Cluster • Installation and Configuration of SOA in Active Cluster. Thanks & Regards, SADGURU TECHNOLOGIES H. No: 7-1-621/10, Flat No: 102, Sai Manor Apartment, S.R. Nagar Main Road, Hyderabad-500038, Landmark: Beside Umesh Chandra Statue, Approach Road Parallel to Main Road Mob: 91-8179736190, Ph: 040-40154733 Web site: http://www.sadgurutechnologies.com/ Blog:http://easyoraclefusionlessions.blogspot.in/ http://oraclesoasuite11gtraining.hpage.com/ …………………………………………………………………… …………………………………………………………….. Oracle WebLogic Server 11g Administration@ 8179736190 Duration: 25hours What you will learn This course trains Web administrators on techniques for installing and configuring Oracle WebLogic Server 11g. It alsotrains Web administrators to deploy Java EE applications to Oracle WebLogic Server 11g using Administration Consoleand command-line and scripting tools like WLST. Course Objectives: • Describe the architecture of WebLogic Server including domains, servers and machines • Install, configure and use WebLogic Server • Perform routine Oracle WebLogic Server administration functions • Set up a cluster of servers and distribute applications and resources to the cluster • Configure Oracle HTTP Server as the Web-tier front end for Oracle WebLogic Server instances and clusters • Deploy different types of Java EE applications to Oracle WebLogic Server • Deploy and manage large-scale Java EE applications to servers or clusters through the entire development andproduction lifecycle • Configure basic resource and application security • Backup and recover from various failures • Monitor application server using GUI and command-line tools such as automation scripts Thanks & Regards, SADGURU TECHNOLOGIES H. No: 7-1-621/10, Flat No: 102, Sai Manor Apartment, S.R. Nagar Main Road, Hyderabad-500038, Landmark: Beside Umesh Chandra Statue, Approach Road Parallel to Main Road Mob: 91-8179736190, Ph: 040-40154733 Web site: http://www.sadgurutechnologies.com/ Blog:http://easyoraclefusionlessions.blogspot.in/ http://oraclesoasuite11gtraining.hpage.com/

WEBLOGIC ADMIN TRAINING IN HYDERABAD@Sadguru Technologies We are glad to announce our newly launched Online Oracle Fusion Middleware 11g SOA The Oracle SOA Suite 11g: Administration course describes how Oracle SOA Suite 11g, a Middleware component of Oracle Fusion Middleware, provides a complete set of service infrastructure components (such as Mediator, BPEL, Human Workflow, Business Rules, and Business Process Management components) for designing, deploying, and managing SOA composite applications. The participant is therefore required to have knowledge about essential Oracle WebLogic Server administration tasks. They learn how to install and configure Oracle SOA Suite 11g components in Oracle WebLogic Server domains. They learn to use the Oracle Enterprise Manager Fusion Middleware Control Console to perform administrative tasks such as deploying SOA composite applications, configuring SOA composite application resources, monitoring SOA composite applications, managing and monitoring service engines, and updating the state of SOA composite applications. They also learn how to troubleshoot SOA composite applications by performing corrective actions such as fault recovery. They are given a brief introduction to tuning and configuring Oracle SOA Suite 11g environment for high availability. Course Contents: I. Introduction to Oracle Fusion Middleware 11g • Fusion Middleware concepts • Introduction to WebLogic Server • WebLogic Server Domain, Administration Server and Managed Server • Oracle Instance , Oracle Home, Metadata Repository • File System and Directory Structure in Fusion Middleware II. Installation & configuration of Fusion Middleware (DB, WebLogic & SOA Suite) • Installing Oracle Database • Installing Metadata Repository for Fusion Middleware • Installing WebLogic Server • Installing Additional Fusion Middleware component (SOA Suite) • Configuring Fusion Middleware component (SOA Suite) • Start/Stop Services

WEBLOGIC ADMIN TRAINING IN HYDERABAD@Sadguru Technologies We are glad to announce our newly launched Online Oracle Fusion Middleware 11g SOA The Oracle SOA Suite 11g: Administration course describes how Oracle SOA Suite 11g, a Middleware component of Oracle Fusion Middleware, provides a complete set of service infrastructure components (such as Mediator, BPEL, Human Workflow, Business Rules, and Business Process Management components) for designing, deploying, and managing SOA composite applications. The participant is therefore required to have knowledge about essential Oracle WebLogic Server administration tasks. They learn how to install and configure Oracle SOA Suite 11g components in Oracle WebLogic Server domains. They learn to use the Oracle Enterprise Manager Fusion Middleware Control Console to perform administrative tasks such as deploying SOA composite applications, configuring SOA composite application resources, monitoring SOA composite applications, managing and monitoring service engines, and updating the state of SOA composite applications. They also learn how to troubleshoot SOA composite applications by performing corrective actions such as fault recovery. They are given a brief introduction to tuning and configuring Oracle SOA Suite 11g environment for high availability. Course Contents: I. Introduction to Oracle Fusion Middleware 11g • Fusion Middleware concepts • Introduction to WebLogic Server • WebLogic Server Domain, Administration Server and Managed Server • Oracle Instance , Oracle Home, Metadata Repository • File System and Directory Structure in Fusion Middleware II. Installation & configuration of Fusion Middleware (DB, WebLogic & SOA Suite) • Installing Oracle Database • Installing Metadata Repository for Fusion Middleware • Installing WebLogic Server • Installing Additional Fusion Middleware component (SOA Suite) • Configuring Fusion Middleware component (SOA Suite) • Start/Stop Services Oracle Fusion Middleware 11g SOA Administrator Training - Contents • Start/Stop WebLogic Administration Server • Start/Stop Managed Server • Start/Stop Middleware Control III. Node Manager and Deploying Application • Introduction to Node Manager • Configuring Node Manager and starting Managed Servers using Node Manager • Overview of Deploying Applications • Understanding Data Sources • Deploying and Undeploying Java EE Applications IV. Monitoring Oracle Fusion Middleware • Overview of Monitoring Oracle Fusion Middleware • Monitoring the Status of Oracle Fusion Middleware • Monitoring an Oracle WebLogic Server Domain • Monitoring an Oracle WebLogic Server Administration Server or Managed Server • Monitoring a Component • Monitoring Applications • Monitoring the Performance of Oracle Fusion Middleware Components V. Configuring Security and High Availability for SOA • Creating Additional Administrative Users • Creating Additional Users with Specific Roles • Changing the Administrative User Password • Defining Virtual Hosts for SOA Cluster • Installation and Configuration of SOA in Active Cluster. Thanks & Regards, SADGURU TECHNOLOGIES H. No: 7-1-621/10, Flat No: 102, Sai Manor Apartment, S.R. Nagar Main Road, Hyderabad-500038, Landmark: Beside Umesh Chandra Statue, Approach Road Parallel to Main Road Mob: 91-8179736190, Ph: 040-40154733 Web site: http://www.sadgurutechnologies.com/ Blog:http://easyoraclefusionlessions.blogspot.in/ http://oraclesoasuite11gtraining.hpage.com/

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 SAP BO Course Content: call +91- 1) INTRODUCTION TO SAP BO AND DATA WAREHOUSING OLTP vs. OLAP Types of OLAP Data mart/Data warehouse Life cycle Star/Snow/Extended Star schema design 2) DATABASE CONCEPTS Views/Materialized Views Date/Time Functions Conversion functions Derived table & Stored Procedure 3) ARCHITECTURAL OVERVIEW Client tier components Application tier components Intelligence tier Processing tier Data tier Security management Information flow 4) UNIVERSE DESIGN Understanding Business Objects Universes Creating the Course Universe Building the Universe Structure Creating Dimension Objects Creating Measure Objects Resolving Loops in a Universe Resolving SQL Traps Using List of Values Applying Restrictions on Objects Using @Functions with Objects Using Hierarchies Deriving Tables & Indexes Working with Aggregate Awareness Designing Advanced Objects Creating Predefined Condition LOVs & Joins Securing Universes Implementing Universe Life Cycle Mgmt Maintaining & Optimizing Universes Creating Universe from Other Data sources 5) WEB INTELLIGENCE Understand concepts of Web intelligence Create Web Intelligence documents with Queries Restrict data returned by a query Design a report Enhance the presentation of data in reports Format a report Calculate data with formulas and variables Use multiple data sources Analyze data Manage and share Web Intelligence documents Work with Advanced Query techniques Work with calculation contexts Create formulas with character & date string functions Use “If” logic Work with additional reporting techniques Create hyperlinks 6) Xcelcius/DASHBOARD BUILDER Understanding Dashboard Manager Setting Up Dashboard Manager Creating Metrics Automating Dashboards with Rules Creating Analytics Creating Personal Dashboards Creating Corporate Dashboards Guiding Dashboard Navigation 7) ADMINISTRATION Understand the Business Objects Enterprise interface & architecture Manage Business Objects Enterprise content Secure Business Objects Enterprise content Secure application security Schedule content Publish reports Identify Business Objects Enterprise architecture Perform common server management tasks Manage the Business Objects Enterprise servers 8) WEBI-RICH CLIENT Installing Web Intelligence Rich Client Web Intelligence Rich Client working modes Launching Web Intelligence Rich Client To set user preferences in Web Intelligence Rich Client Working with documents Working with universes in Web Intelligence Rich Client Accessing Web Intelligence from Info View Working with queries in Web Intelligence Rich Client Working with reports 9) UNIVERSE BUILDER & QUERY BUILDER Universe Builder basics Building universes from XML metadata sources Updating XML metadata source universes Exporting a universe to a XML file format 10) SECURITY IMPLEMENTATION Creating Secured users & group Creation secured connections Creation of Secured objects Creation of security at Table, Column &row level Creation of secured restriction set and mapping to users or groups 11) IMPORT WIZARDPUBLISHING WIZARD Using Import wizard Creation of BIAR Migrating the BO objects From one CMS TO ANOTHER CMS Migrating the objects from one domain to another (dev/stage/Prod) Backup & Maintenance Deployment OVERVIEW OF SAP BO 4.1 Comparison of SAP BO 3.x & 4.x For free Demo call +91 OBIEE, INFORMATICA, ODI, HADOOP,SAP BO, FICO, HANA, SD, MM, BPC, PM, ABAP online training also provided

Microstrategy Traning at learning hub Magarpatta city /FC Road Pune (+91-93257-93756) www.learninghub.co.in Microstrategy Course Content at Learning Hub Introduction Business Intelligence OLAP Introduction of BI tools Database Overview Introduction to Microstrategy Microstrategy Architecture Microstrategy Desktop Microstrategy Web Microstrategy Servers Administration Folder Structure My Personal Objects Public Object Schema Object Metadata Report View Data – Export Auto Styles Custom Groups Facts Tables Update Scheme Microstrategy Tutorial (Direct) Advance Features Project Configuration Attribute Creation Metric Creation Drill Map Templates Prompt Filter Administration Facts Creation Of Reports Grid Report Analyzing Data Transformations Hierarchies Data Explorer Adhoc Reports Report Creation On Web Searches Documents Joins Experts Features and Administration Project Installation Intelligence Server User Privilege Security Implementation Object Manager Command Manager Formatting Report Administrative Configurations Web Creating Documents Document Properties Dashboards Working with dashboards Narrowcast Server Creating services Configuring Narrowcast server Scheduling reports through narrowcast server Narrowcast server Administration Different execution procedures in Narrowcast server Administration Command manager Enterprise manager Object manager Migration of reports to different environment Security filters Creation of users and Privileges Please Contact- Microstrategy Traning at learning hub Magarpatta city /FC Road Pune (+91-93257-93756) www.learninghub.co.in Microstrategy Course Content at Learning Hub Introduction Business Intelligence OLAP Introduction of BI tools Database Overview Introduction to Microstrategy Microstrategy Architecture Microstrategy Desktop Microstrategy Web Microstrategy Servers Administration Folder Structure My Personal Objects Public Object Schema Object Metadata Report View Data – Export Auto Styles Custom Groups Facts Tables Update Scheme Microstrategy Tutorial (Direct) Advance Features Project Configuration Attribute Creation Metric Creation Drill Map Templates Prompt Filter Administration Facts Creation Of Reports Grid Report Analyzing Data Transformations Hierarchies Data Explorer Adhoc Reports Report Creation On Web Searches Documents Joins Experts Features and Administration Project Installation Intelligence Server User Privilege Security Implementation Object Manager Command Manager Formatting Report Administrative Configurations Web Creating Documents Document Properties Dashboards Working with dashboards Narrowcast Server Creating services Configuring Narrowcast server Scheduling reports through narrowcast server Narrowcast server Administration Different execution procedures in Narrowcast server Administration Command manager Enterprise manager Object manager Migration of reports to different environment Security filters Creation of users and Privileges 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 Microstrategy Online Training, Microstrategy Class Room Training, Microstrategy Training in Magarpatta City, Microstrategy Jobs and Placement, MicrostrategyRemote Support, MicrostrategyOnline Help, Microstrategy Videos training, Microstrategyt raining by Learning Hub, Fast track classes in Microstrategy, Best Microstrategy training institutes in Pune, Best Faculty inMicrostrategy, Best online Faculty in Microstrategy, Professional classroom training inMicrostrategy, Professional online trainingMicrostrategy, Microstrategy Certification ,Microstrategy training in Dubai,MicrostrategyTraining in Melbourne, Microstrategy Training in Dubai, MicrostrategyTraining,MicrostrategyWorkflow Training Microstrategy Training, MicrostrategyOnline Training,Microstrategycertfication and support

COGNOS Course Content Traning at learning hub Magarpatta city /FC Road Pune (+91-93257-93756) www.learninghub.co.in Cognos Course Detail COGNOS Course Content @ Learning Hub INTRODUCTION TO DATAWARE HOUSING (DWH) • Introduction to DWH • Characteristics of DWH • OLTP Vs OLAP Databases • Different Approaches of DWH (Kimball Vs Inmon) • Data mart Vs Data Warehouse • Fact Table Vs Dimension Table • Types Of Facts • Types Of Dimensions • ETL • Staging Area • Concepts of Schemas (Star schema & Snowflake schema) • CLP Modeling • Industry leading ETL and Reporting tools INTRODUCTION TO COGNOS • About Cognos • 3 – Tier Architecture • Cognos Release (EP series7, Reportnet , Cognos 8.0/8.1/8.2/8.3) and their differences • Features of Cognos 8.4 • Cognos Vs other OLAP tools • Cognos components (Modeling & Reporting) COGNOS CONNECTIONS • Personalize Cognos Connection • Create and manage portals, shortcuts, report views..etc • Running the Report Burn • Scheduling Reports • Various Options in Cognos Connection REPORT STUDIO • Report Studio User Interface • Creating, Save and run reports • Managing Reports. • Creating list, Cross Tab etc. • Report templates, formatting Reports – fonts, style, header, footer, boarder…etc • Filters, Parameters and Prompts • Subtotals and Calculations • Working with Queries • Generating and Creating Prompt Page • Types Of Reports • Types of Prompts • Types of Variables • Query Calculations & Layout Calculations • Filters and Dynamic Filters • Conditional Block • Conditional Formatting • Master Details • Cascading Prompt • Operators • Setting Burst Options • Drill through • Setting Variables • Report Functions • Report Validation • Reports Run with Options • Different types of Reports with various functionalities • Unions • Joins • Components and there properties. QUERY STUDIO • Introduction • About Ad-hoc Reports • Types of Report(List, Cross Tab, Chart Reports & Others) • Applying Filters, Prompts & Calculations • Sorting, Grouping, Sections & Aggregate Functions • Run and Manage reports ANALYSIS STUDIO • Insert Data • Nest Data • Replace Data • Sort Data • Explore Data • Change the measure • Drill down for Details • Hide Items • Insert a calculation • Save a custom set • Define a filter • Compare sets of data • Using Dynamic Context FRAMEWORK MANAGER • About Framework Manager • Framework Manager, Metadata Modeling • Creation of Interface and Usage • Creating Model & Namespace (Layers) • Importing Metadata • Naming convention for objects in a project • Creating Query Subjects & Query Items • Merging Query Subjects • Creating Relationships & Setting Cardinalities • Creating Parameter Maps & Macros • Creating of Model Filters, Prompts & Calculations • Add Business Rules and Set Governors • Assigning package level security • Improving performance • Publishing Package 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

DATA STAGE TECHNOLOGY: What is Data stage?? Data Stage integrates data across multiple and high volumes of data sources and target applications. It integrates data on demand with a high performance parallel framework, extended metadata management, and enterprise connectivity. DataStage also has a set of Windows-based graphical tools that allow ETL processes to be designed, the metadata associated with them managed, and the ETL processes monitored. There are also There are also two DataStage engines, the “server engine” and the “parallel engine” Usage of DataStage within organization it has window Clients which connettto tthe Server on tthe Unix / Windows or Mainfframe platform.. The Clients can be used tto devellop,, deploy and run datastage jjobs.. In a deployment environment,, tthe jjobs can be kicked off tthrough scripts directly on Unixservers TYPES OF DATA STAGE CLIENT:: DATA STAGE ADMINISTRATOR DATASTAGE DESIGNER DATASTAGE MANAGER DATASTAGE DIRECTOR DATA STAGE TECHNOLOGY PARCTICE-:: INFRASTRUCTURE SETUP/MAINTENANCE SUPPORT SALES/ MARKETING KNOWLEDGE BASED REPOSITORY PARTNER MANAGEMENT TECHNICAL SUPPORT TRAINING AND TERM EVALUTION ADVANTAGES OF DATASTAGE- Helps for better business decisions; It is able to integrate data coming from all parts of the company; It helps to understand the new and already existing clients; We can collect data of different clients with him, and compare them; It makes the research of new business possibilities possible; We can analyze trends of the data read by him. CONCLUSION- DataStage has proved to be an excellent ETL tool within the industry. The need for Data Integration and Consolidation within organizations is fuelling the need for datastage. Data Transfer format landscape is gradually moving towards XML in every industry. PR3 Systems provides detailed training and consulting services for DataStage, Best Practices in DataStage Project Design and Helping organizations to consolidate their Data and Information Network To join Online Training session kindly feel free to contact with us Name - Madhurima Bose Contact No. - +91 - /

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

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

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

Welcome to TS Technologies We are offering Online IBM File Net training by our REAL TIME EXPERT having 10 years of experience working with TOP MNC. Course Duration: 1 month Timings: 6am,7am,10pm 1) Overview of ECM Platform features 2) Overview of main applications of Platform Install Platform Applications on VMware Configure and integrate platform applications 3) Verify Installation Content Management Overview of Content Management Features with Demos 4) Understanding of Important API packages and typical usage scenarios Setup API Usage Environment Create Session with CMS Store Local file in CMS using default CMS classes Create document classes with ALL data types Get Information about properties created using API Save document and set/get all data type values using self created document classes 5) Enable Content Based Search on CMS 6) Search/Retrieve documents added based on CBR and Metadata values Set Security on document classes using Platform Applications Use Security API to get the privileges for different users Set Audit configurations on document classes using Platform Applications Retrieve and set Auditing data using API Configure events in CMS Write code in events to set some extra properties 7) Create Folders and Custom Objects and set security and audit 8) Business Process Management Overview of Business Process Management Features with Demos Understanding of Important API packages and typical usage scenarios Setup API Usage Environment Create Session with BPM Create KYC Workflow with Maker and Checker Steps Initiate Workflow using CMS events and Using OOTB Applications Create BPM properties with ALL data types in KYC Workflow Get Information about properties created using API Save workflow properties with all datatype values of the launched workflow and dispatch Search/Retrieve Work items Metadata values Set Security on step using Platform Applications Use Security API to get the priviledges for different users Set Audit configurations on step using Platform Applications Retrieve and set Auditing data using API Configure Component Integrator Create and configure component integrator and use in KYC process 9) Attach a custom UI with a workflow step Search work items using Admin applications Handling any malfunctions in process 10) Web UI Development Overview of Web UI Features with Demos Understanding of Important API packages and typical usage scenarios Setup API Usage Environment Create Session with BPM Understand the existing preferences and impact on UI - Session Hands on for Preferences Understand the concept of search templates and stored searches Hands on stored searches and search templates Understand the concept of entry templates Hands on entry templates Understanding concept of BPF Create and configure BPF and use it /file-net.html For further details please contact TS Technologies (+-,) Thanks & regards Shobhana

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

Overview: IBM Cognos Framework Manager is a metadata modeling tool that drives query generation for IBM Cognos software. A model is a collection of metadata that includes physical information and business information for one or more data sources. IBM Cognos software enables performance management on normalized and denormalized relational data sources and a variety of OLAP data sources. ABOUT ECORPTRAININGS: Ecorp Trainings are one of the best institute providing quality level of training in E-learning process.This is instructor led online training. We also provide corporate training , if group of people interested in same technology. Contact us for detailed course content & register for a free demo. We also provide support in client interviews , resume preparation , ticket resolving. Contact us for custom designed training course by experts exclusively for yourself. We provide training for almost all IT technologies i.e ; JAVA , DOTNET , SAP ,ORACLE , PEOPLESOFT ,HYPERION etc, contact us if you have any particular need. ECORP TRAININGS. Gtalk ID : ecorptrainings Skype ID : ecorptrainings

SequelGate Tech (SequelGate Technologies Pvt. Ltd.) is one of the training organizations providing specialized in SQL/PL-SQL, Oracle DBA and Oracle Apps DBA All our sessions are completely Practical and Real-time. Oracle DBA with PROJECT - ONLINE TRAINING COURSE DETAILS: Oracle 11g RDBMS Architecture Structural components of Server Oracle Database versions Differences between Physical & Logical Structures Oracle 11gR2 Database Installation Software & Hardware Requirements Linux Commands Installing Oracle 11gr2 RDBMS Database Creation Creating with Database Configurations Assistant (DBCA) Metadata Tables & Views Metadata Views Stages in Starting & Stopping the Database Startup Options Shutdown options Database Files Adding parameter to spfile Deleting parameter from spfile Multiplexing a control file Multiplexing using pfile Multiplexing using spfile Managing Files & Tablespaces Data File Management Different status of a Data File Types of Tablespaces Different status of Table space Modes of Tablesp User Management Schema Management Quota Management Privilege Management Profile Management Role Management Networking Introduction to Networking Client side Configuration Server Side Configuration Oracle Listeners Backups & Recoveries Introduction to Backups Types of Failures Types of Backups Physical Backups Database Cloning loning Concepts Cloning Techniques Cloning Oracle Home & Database Patching & Upgrading of Database atch using Opatch utility Understanding the upgrade process Upgrading Oracle11g to Oracle 12Z Database Performance Tuning Oracle Tools for Performance Tuning Instance & Database Tuning Execution Plans, using EXPLAIN PLAN TKPROF AWR, ADDM All Sessions are Completely Practical and Real time. One Real-time Project for every course. Contact us today for Oracle DBA Online trainings @ Sequelgate For free Oracle DBA Online Demo, SequelGate Training Institute Schedules for Oracle DBA Online- TRAINING: India: SR Nagar Branch: Office: +91 (0) 40 64577244 Mobile: +91 (0) 9666440801 Address-1: 108/2RT, Road No 1, SR Nagar, Land Mark: Beside Bus Stop, Hyderabad, India. Madhapur Branch: Mobile: +91 (0) 9030040801 Office: +91 (0) 4065358866 USA: Office: +1 (510) 400-4845 Address-2: Sai Anu Avenue, Street Number 3, Patrika Nagar,  HITEC City, Hyderabad - 81 (India). 

Oracle MySQL DBA(100% job guarantee) Course Contents Introduction •Describing MySQL •Currently Supported Operating Systems •Describing Installation of MySQL MySQL Architecture •Client/Server Architecture •MySQL Architecture Overview •How MySQL Uses Disk Space •How MySQL Uses Memory The MySQL Server •Types of MySQL Distributions •Starting and Stopping MySQL on Linux •Upgrading MySQL •Managing Multiple instances in one Server Configuring the MySQL Server •MySQL Configuration •Dynamic Server Variables •Binary Logging MySQL Clients •Overview of Administrative Clients •Using the mysql Client •The mysql dmin Client •MySQL Connectors •Third-Party APIs Overview of Data Types •Data Types •Numeric Data Types •Character String Data Types •Binary String Data Types •Temporal Data Types •NULLs •Column Attributes Metadata •Metadata Access Methods •The INFORMATION_SCHEMA Database/Schema •Using SHOW and DESCRIBE •The mysqlshow Command Storage Engines •Storage Engine Overview •MyISAM, InnoDB, and MEMORY Storage Engines •Other Storage Engines •Choosing Appropriate Storage Engines •Using Multiple Storage Engines •Storage Engine Comparison Chart Partitioning •Overview of Partitioning and reasons for using Partitioning •Creating a Partitioned Table •Obtaining Partition Information •Modifying and Removing Partitions •Partition Modification Performance Effects •Partition Pruning •Storage Engine Partition Information Transactions and Locking •Transactions •Transaction Control statements •Isolation Levels •Locking Security and User Management •Security Risks •Security Measures •Privileges •Access Levels 1 - User Accounts, 2 – Databases, 3 – Tables, 4 – Columns, 5 - Stored Routines •User Account Maintenance •Client Access Control •Using Secure Connections Table Maintenance •Table Maintenance •Client and Utility Programs for table maintenance •Table Maintenance per Storage Engine Exporting and Importing Data •Exporting and Importing Data •Exporting and Importing Data Using SQL •Import Data with the SQL scripts Programming with MySQL •Defining, Executing and Examining Stored Routines •Stored Routines and Execution Security •Defining, Creating, and Deleting Triggers •Trigger Restrictions and Privileges •Defining Events •Schedule Events •DBA's Use of MySQL Programming •Backup Stored Routines Views •What is a view? •Creating Views •Managing Views Backup and Recovery •Planning for Recovery Backup •Backup Tools Overview •Making Raw Backups •Making Logical (Text) Backups •Backup Log and Status Files •Replication as an Aid to Backup •Backup Method Comparison •Data Recovery Introduction to Performance Tuning •Using EXPLAIN to Analyze Queries •General Table Optimizations •Setting and Interpreting MySQL Server Variables Introduction to High Availability •MySQL Replication •Master-slave Replication •Master-Master Replication

DataFlux Data Management Studio(DDMS) is a data management suite that combines :Data quality, Data integration,Master data management.It provides a process and technology framework to deliver a single, accurate and consistent view of your enterprise data.Data Management Studio gives you the ability to:Merge customer, product, or other enterprise data ,Unify disparate data through a variety of data integration methods (batch, real time, virtual) ,Verify and complete address information ,Integrate disparate data sets and ensure data quality ,Transform and standardize product codes ,Monitor data for compliance in batch or real time ,Manage metadata hierarchy and visibility. DataFlux Data Management Studio(DDMS) is a data management suite that combines :Data quality, Data integration,Master data management.It provides a process and technology framework to deliver a single, accurate and consistent view of your enterprise data.Data Management Studio gives you the ability to:Merge customer, product, or other enterprise data ,Unify disparate data through a variety of data integration methods (batch, real time, virtual) ,Verify and complete address information ,Integrate disparate data sets and ensure data quality ,Transform and standardize product codes ,Monitor data for compliance in batch or real time ,Manage metadata hierarchy and visibility.

Peridot systems Peridot Systems is one of the best training institutes for Software Testing, Oracle 10g/11gDBA, Dot Net 4.0, Salesforce.com, Core Java, J2EE, DB2, Solaris Admin, Websphere, WebLogic, Solaris, LINUX commands in Chennai with placement. We give Job oriented training apart from the theoretical topics. We give 100% Placement assistance and guide the students during their Interview sessions and on their Communication Skills Initiated by a crew of highly competent and expert professionals with an unique objective to bridge the gap between the field of education and IT industry. Peridot is proud to introduce job oriented IT Training courses with globally accredited certification on all platforms that have wider scope in the existing IT Job Market. These platforms are picked after a thorough research and analysis based upon the existing and prospective IT industry in mind. SharePoint Server 2010 Administration Topics • Introduction to SharePoint 2010 Technologies. • Collaboration and Web Content Management. • SharePoint 2010 Client Integration. • Creating and Configuring SharePoint Web Applications. • Administering Sites and Site Collections. • Architecting a SharePoint Infrastructure. • Installing and Configuring a SharePoint Farm. • Configuring SharePoint Security. • Managing Metadata and Content Types. • Document and Records Management. • Configuring InfoPath and Workflow Services. • Configuring SharePoint Search and Indexing. • Configuring SharePoint Personalization Services. • Introduction to Business Intelligence. • SharePoint Disaster Recovery. Venue: Peridot Systems #84/8 Venkatarathinam Main Street, Venkatarathinam Nagar,Adyar, Chennai - 600 020.(Near Adyar BSNL Telephone Exchange) Contact: 9952954654

course content for oracle hyperion training online and class room training PLANNING OVERVIEW Oracle's Enterprise Performance Management System Oracle's Business Intelligence Suite Enterprise Edition Plus Architecture of Planning Relationship Between Planning and Essbase Navigation of Workspace CREATING DIMENSIONS EPM Architect Period, Scenario and Version Dimensions Entity Dimensions Account Dimensions Custom Dimensions METADATA Loading Data Using Application Views Deploying Applications Setting Up Exchange Rates LOADING DATA AND CALCULATING DATABASE Setting Up Data Loads and Calculating Loading Data SECURITY etc..,

WEBLOGIC ADMIN TRAINING IN HYDERABAD@Sadguru Technologies We are glad to announce our newly launched Online Oracle Fusion Middleware 11g SOA The Oracle SOA Suite 11g: Administration course describes how Oracle SOA Suite 11g, a Middleware component of Oracle Fusion Middleware, provides a complete set of service infrastructure components (such as Mediator, BPEL, Human Workflow, Business Rules, and Business Process Management components) for designing, deploying, and managing SOA composite applications. The participant is therefore required to have knowledge about essential Oracle WebLogic Server administration tasks. They learn how to install and configure Oracle SOA Suite 11g components in Oracle WebLogic Server domains. They learn to use the Oracle Enterprise Manager Fusion Middleware Control Console to perform administrative tasks such as deploying SOA composite applications, configuring SOA composite application resources, monitoring SOA composite applications, managing and monitoring service engines, and updating the state of SOA composite applications. They also learn how to troubleshoot SOA composite applications by performing corrective actions such as fault recovery. They are given a brief introduction to tuning and configuring Oracle SOA Suite 11g environment for high availability. Course Contents: I. Introduction to Oracle Fusion Middleware 11g • Fusion Middleware concepts • Introduction to WebLogic Server • WebLogic Server Domain, Administration Server and Managed Server • Oracle Instance , Oracle Home, Metadata Repository • File System and Directory Structure in Fusion Middleware II. Installation & configuration of Fusion Middleware (DB, WebLogic &