Relational database service i2k2

Acutelearn is a leading training company, provides corporate, online and classroom training on various technologies like Amazon Web Services, Microsoft Azure, Office 365, Cisco UCS, VMware Vsphere, VMware VRA,VMware NSX 6.0, Citrix Netscaler, Citrix Xendesktop, Blue Prism,Openspan,Robotic Process Automation, etc...... Amazon Web Services Training Content: Introduction to Cloud Computing •Introduction to Cloud Computing •Why Cloud Computing? •Benefits of Cloud Computing AWS Overview •Introduction to the AWS products •Amazon Elastic Compute Cloud (EC2) •Amazon Simple Storage Service (S3) •Elastic Block Storage (EBS) •Elastic Load Balancing (ELB) •Amazon (RDS) •Amazon DynamoDB •Auto Scaling •Amazon ElastiCache Elastic Compute Cloud Essentials •Regions and Availability Zones •Amazon Machine Images (AMI) •Instances •AWS Management console •AWS CLI EC2 Instances •Instance types •Deploy / Manage Instances •Power states •Working with AMIs •Interact with Instances •Key pair, Tags •Security group •Elastic IP Address •Change instance types •Manage Instance IP Address Elastic Block Store (EBS) •Creating and deleting volumes •Attaching and detaching volumes to instances •Mounting and Unmounting the attached •volume •Creating snapshots AWS VPC •Understand subnets •Create VPC •Routing tables, •Internet Gateway •Elastic Network Interface •NAT Gateways, NAT Instance •NAT ACL’s •VPN, On-premises connectivity •Direct Connect Elastic Load Balancer (ELB) •Create External/Public Load balancer •Create Internal load balancer •Create ELB Rules Cloud Watch •Monitoring the AWS Service Health Dashboard •Getting statistics for a specific EC2 instance •Getting aggregated statistics •Metrics for other AWS Services and related namespaces •Setting up notifications Autoscale •Auto scaling components •Creation of launch configuration •Configuration of auto scaling policies based on the Load on EC2 instances. •Advantages of using Auto scaling with Elastic Load balancer (ELB) Route 53 •Route 53 Overview •Setup DNS Namespace •Domain Registration •Hosting zones •Creating different records in Route 53 Simple Storage Service (S3) •Creating and deleting buckets •Adding objects to buckets •Getting objects •Deleting objects •Object permissions and policies •S3 and Bucket policies Glacier Storage: •Creating Vaults •Accessing the Glacier vault using tools •Using Glacier for backups •Retrieval period Relational Database Service (RDS) •RDS Services •Configuring the Database Engine •Creating Database •Database Backups and restore •Database Replication Identity and Access management (IAM) •Creation of user accounts in AWS •Setting up multi factor Authentication (MFA) •Roles in IAM •Groups in IAM •Delegation of permissions for users •Creation of custom policies for delegation •Account settings •Credential Report Directory Services: •Setup Active directory •Adding EC2 instances to domain •Overview of different directory services Simple Notification Services (SNS) •Creation of a topic •Subscribing to topic via Email •Setting notification for EC2 instance changes Simple Queue Service (SQS) •SQS Overview Elastic Beanstalk •Creation of Web apps using Elastic Beanstalk •Environment overview •Migrating content in different environments. •Modifying the properties of the deployment. Cloud Front •Overview of CDN •Delivering content to CDN

Acutelearn is a leading training company, provides corporate, online and classroom training on various technologies like Amazon Web Services, Microsoft Azure, Office 365, Cisco UCS, VMware Vsphere, VMware VRA,VMware NSX 6.0, Citrix Netscaler, Citrix Xendesktop, Blue Prism,Openspan,Robotic Process Automation, etc...... AWS Course Content: Introduction to Cloud Computing •Introduction to Cloud Computing •Why Cloud Computing? •Benefits of Cloud Computing AWS Overview •Introduction to the AWS products •Amazon Elastic Compute Cloud (EC2) •Amazon Simple Storage Service (S3) •Elastic Block Storage (EBS) •Elastic Load Balancing (ELB) •Amazon (RDS) •Amazon DynamoDB •Auto Scaling •Amazon ElastiCache Elastic Compute Cloud Essentials •Regions and Availability Zones •Amazon Machine Images (AMI) •Instances •AWS Management console •AWS CLI EC2 Instances •Instance types •Deploy / Manage Instances •Power states •Working with AMIs •Interact with Instances •Key pair, Tags •Security group •Elastic IP Address •Change instance types •Manage Instance IP Address Elastic Block Store (EBS) •Creating and deleting volumes •Attaching and detaching volumes to instances •Mounting and Unmounting the attached •volume •Creating snapshots AWS VPC •Understand subnets •Create VPC •Routing tables, •Internet Gateway •Elastic Network Interface •NAT Gateways, NAT Instance •NAT ACL’s •VPN, On-premises connectivity •Direct Connect Elastic Load Balancer (ELB) •Create External/Public Load balancer •Create Internal load balancer •Create ELB Rules Cloud Watch •Monitoring the AWS Service Health Dashboard •Getting statistics for a specific EC2 instance •Getting aggregated statistics •Metrics for other AWS Services and related namespaces •Setting up notifications Autoscale •Auto scaling components •Creation of launch configuration •Configuration of auto scaling policies based on the Load on EC2 instances. •Advantages of using Auto scaling with Elastic Load balancer (ELB) Route 53 •Route 53 Overview •Setup DNS Namespace •Domain Registration •Hosting zones •Creating different records in Route 53 Simple Storage Service (S3) •Creating and deleting buckets •Adding objects to buckets •Getting objects •Deleting objects •Object permissions and policies •S3 and Bucket policies Glacier Storage: •Creating Vaults •Accessing the Glacier vault using tools •Using Glacier for backups •Retrieval period Relational Database Service (RDS) •RDS Services •Configuring the Database Engine •Creating Database •Database Backups and restore •Database Replication Identity and Access management (IAM) •Creation of user accounts in AWS •Setting up multi factor Authentication (MFA) •Roles in IAM •Groups in IAM •Delegation of permissions for users •Creation of custom policies for delegation •Account settings •Credential Report Directory Services: •Setup Active directory •Adding EC2 instances to domain •Overview of different directory services Simple Notification Services (SNS) •Creation of a topic •Subscribing to topic via Email •Setting notification for EC2 instance changes Simple Queue Service (SQS) •SQS Overview Elastic Beanstalk •Creation of Web apps using Elastic Beanstalk •Environment overview •Migrating content in different environments. •Modifying the properties of the deployment. Cloud Front •Overview of CDN •Delivering content to CDN Contact us +917702999361 / 371

Acutelearn is a leading training company, provides corporate, online and classroom training on various technologies like Amazon Web Services, Microsoft Azure, Office 365, Cisco UCS, VMware Vsphere, VMware VRA,VMware NSX 6.0, Citrix Netscaler, Citrix Xendesktop, Blue Prism,Openspan,Robotic Process Automation, etc...... AWS Course Content: Introduction to Cloud Computing •Introduction to Cloud Computing •Why Cloud Computing? •Benefits of Cloud Computing AWS Overview •Introduction to the AWS products •Amazon Elastic Compute Cloud (EC2) •Amazon Simple Storage Service (S3) •Elastic Block Storage (EBS) •Elastic Load Balancing (ELB) •Amazon (RDS) •Amazon DynamoDB •Auto Scaling •Amazon ElastiCache Elastic Compute Cloud Essentials •Regions and Availability Zones •Amazon Machine Images (AMI) •Instances •AWS Management console •AWS CLI EC2 Instances •Instance types •Deploy / Manage Instances •Power states •Working with AMIs •Interact with Instances •Key pair, Tags •Security group •Elastic IP Address •Change instance types •Manage Instance IP Address Elastic Block Store (EBS) •Creating and deleting volumes •Attaching and detaching volumes to instances •Mounting and Unmounting the attached •volume •Creating snapshots AWS VPC •Understand subnets •Create VPC •Routing tables, •Internet Gateway •Elastic Network Interface •NAT Gateways, NAT Instance •NAT ACL’s •VPN, On-premises connectivity •Direct Connect Elastic Load Balancer (ELB) •Create External/Public Load balancer •Create Internal load balancer •Create ELB Rules Cloud Watch •Monitoring the AWS Service Health Dashboard •Getting statistics for a specific EC2 instance •Getting aggregated statistics •Metrics for other AWS Services and related namespaces •Setting up notifications Autoscale •Auto scaling components •Creation of launch configuration •Configuration of auto scaling policies based on the Load on EC2 instances. •Advantages of using Auto scaling with Elastic Load balancer (ELB) Route 53 •Route 53 Overview •Setup DNS Namespace •Domain Registration •Hosting zones •Creating different records in Route 53 Simple Storage Service (S3) •Creating and deleting buckets •Adding objects to buckets •Getting objects •Deleting objects •Object permissions and policies •S3 and Bucket policies Glacier Storage: •Creating Vaults •Accessing the Glacier vault using tools •Using Glacier for backups •Retrieval period Relational Database Service (RDS) •RDS Services •Configuring the Database Engine •Creating Database •Database Backups and restore •Database Replication Identity and Access management (IAM) •Creation of user accounts in AWS •Setting up multi factor Authentication (MFA) •Roles in IAM •Groups in IAM •Delegation of permissions for users •Creation of custom policies for delegation •Account settings •Credential Report Directory Services: •Setup Active directory •Adding EC2 instances to domain •Overview of different directory services Simple Notification Services (SNS) •Creation of a topic •Subscribing to topic via Email •Setting notification for EC2 instance changes Simple Queue Service (SQS) •SQS Overview Elastic Beanstalk •Creation of Web apps using Elastic Beanstalk •Environment overview •Migrating content in different environments. •Modifying the properties of the deployment. Cloud Front •Overview of CDN •Delivering content to CDN

Amazon Compute & Networking Services •Amazon EC2 •Amazon ELB •Amazon Route 53 •Elastic Beanstalk •Lamda Amazon Storage Service & Content Delivery •Amazon Simple Storage Service (Amazon S3) •Glacier •Amazon Elastic Block Store (Amazon EBS) •Amazon Content Delivery Network (Amazon Cloud Front) Amazon Database Services •Amazon Relational Database Service (Amazon RDS) •Amazon DynamoDB •Amazon ElastiCache Amazon Application Development & Identity Access Management •Amazon Simple Notification Service (SNS) •Amazon CloudWatch •Amazon Simple Email Service (Amazon SES) •AWS Identity and Access Management (IAM) •Cloud Formation Amazon API & Supporting Tools •Amazon Command Line Interface API’s •Elastic-fox •S3-Browser Continuous Integration and Continuous Deployment (CI/CD) •Git,GitHub •Jenkins •Puppet •Saltstack(over view)

Amazon Compute & Networking Services •Amazon EC2 •Amazon ELB •Amazon Route 53 •Elastic Beanstalk •Lambda •VPC •AWS Direct Connect •Elastic Load Balancing •Amazon Route 53 •Auto Scaling Amazon Storage Service & Content Delivery •Amazon Simple Storage Service (Amazon S3) •Glacier •Amazon Elastic Block Store (Amazon EBS) •Amazon Content Delivery Network (Amazon Cloud Front) Amazon Database Services •Amazon Relational Database Service (Amazon RDS) •Amazon DynamoDB •Amazon ElastiCache Amazon Application Development & Identity Access Management •Amazon Simple Notification Service (SNS) •Amazon CloudWatch •Amazon Simple Email Service (Amazon SES) •AWS Identity and Access Management (IAM) •Cloud Formation •Amazon SQS •AWS CloudTrail Amazon API & Supporting Tools •Amazon Command Line Interface API’s •S3-Browser Continuous Integration and Continuous Deployment (CI/CD) •Git,GitHub •AWS OpsWorks Case Study •A classroom case study.

Oracle 11 G DBA Course content near marathahalli / kundalahalli / Whitefield What you will learn This Oracle Database: Introduction to SQL training helps you write sub queries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises. Benefits to You Gain expertise in relational database data management as you learn how to effectively use SQL commands against your business data. These features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Oracle Database 11g: Administration Workshop I What you will learn This Oracle Database 11g: Administration Workshop I Release 2 course explores the fundamentals of basic database administration. Expert Oracle University instructors will reinforce topics with structured hands-on practices that will prepare you for the corresponding Oracle Certified Associate exam. Benefits to You Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter. Oracle Database 11g: Administration Workshop I I What you will learn This Oracle Database 11g: Administration Workshop II Release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You'll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery. Benefits to You Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter. Reasons to study at Systems Domain • Oracle Authorized WDP Partner Status. • Experienced trainers who understand a candidate’s needs • Good track record of students being placed in reputed companies • Weekend batches, if required • Frequent events like Group Discussion, Personality Development, Interview Tips, and Presentations on Saturdays. For more detail contact Asma #2, 3rd Floor, Balaji Complex,Next To State Bank of Mysore Marathahalli Main Road, Near Marathahalli Bridge Junction Bangalore-

This Oracle Database: SQL and PL/SQL Fundamentals training deliver’s the fundamentals of SQL and PL/SQL along with the benefits of the programming languages using Oracle Database technology. You'll explore the concepts of relational databases. Benefits to You Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database. Hands-On Practices Demonstrations and hands-on practice reinforce the fundamental concepts that you’ll learn in this course. By enrolling in this course, you’ll begin using isql*plus, sql*plus, Oracle SQL Developer and plsql developer to develop these program units. Toad is available as optional tools.

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

Type Tutoring 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

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 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