₦airaland Forum

Email : info@unitedglobalsoft.com
Call :09030624004

What Is Microsoft BI?

Core concept – BI is the cube or UDM
Example cube as seen using Excel pivot table
MS BI is comprehensive – more than Analysis Services on SQL Server
Demonstration of SQL Reporting Services with cube as data source

OLAP Modeling

Modeling source schemas—stars and snowflakes
Understanding dimensional modeling— Dimensions (Type 1, 2, or 3) or rapidly changing
Understanding fact (measures) and cube modeling
Other types of modeling—data mining etc

Using SSAS in BIDS

Understanding the development environment
Creating Data Sources and Data Source Views
Creating cubes – using the UDM and the Cube Build Wizard
Refining Dimensions and Measures in BIDS

Intermediate SSAS

KPIs
Perspectives
Translations – cube metadata and currency localization
Actions – regular, drill-through and reporting

Advanced SSAS

Using multiple fact tables
Modeling intermediate fact tables
Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing dimensions, write back dimensions
Modeling changing dimensions – Dimension Intelligence w/ Wizard
Using the Add Business Intelligence Wizards – write-back, semi-additive measures, time intelligence, account intelligence

Cube Storage and Aggregation

Storage topics – basic aggregations, MOLAP
Advanced Storage Design – MOLAP, ROLAP, HOLAP
Partitions – relational and Analysis Services partitions
Customizing Aggregation Design – Processing Design
Rapidly changing dimensions / ROLAP dimensions
Welcome to the Real Time – Proactive Caching
Cube processing options

Beginning MDX

Basic syntax
Using the MDX query editor in SQL Server Management Studio
Most-used Functions & Common tasks
New MDX functions

Intermediate MDX

Adding calculated members
Adding scripts
Adding named sets
.NET Assemblies

SSAS Administration

Best practices – health monitoring
XMLA scripting (SQL Mgmt Studio)
Other Documentation methods
Security – roles and permissions
Disaster Recovery – backup / restore
Clustering – high availability

Introduction to Data Mining

What and why?
Examples of using each of the 9 algorithms (MS Clustering, MS Decision Trees, Naïve Bayes, MS
Sequence Clustering, MS Time Series, MS Association Rules, MS Neural Network)
Data Mining dimensions
Data Mining clients
Processing mining models

Introduction to Reporting Clients

Excel 2003 Pivot Tables
SQL RS & Report Builder
SPS RS web parts & .NET 2.0 report viewer controls
Business Scorecards 2005 & ProClarity

Future Directions – Integration with Office 12

SharePoint 12 and AS
Report Center (type of dashboard) uses KPIs, Reports, Excel Web, Filter
Excel Services 12 and AS (Web Services)

SQL Server 2005 Integration Services
Introduction to SQL Server Integration Services

Product History
SSIS Package Architecture Overview
Development and Management Tools
Deploying and Managing SSIS Packages
Source Control for SSIS Packages

SSIS for DBAs: Using SQL Server Management Studio

The Import and Export Wizard
Importing and Exporting Data
Working with Packages
Database Maintenance Plans
Creating Database Maintenance Plans using SSMS
Scheduling and Executing Plans
Examining Database Maintenance Plan Packages
Changes in SQL Server 2005 Service Pack 2

Business Intelligence Development Studio

Launching BIDS
Project templates
The package designer
The Toolbox
Solution Explorer
The Properties window
The Variables window
The SSIS menu

Introduction to Control Flow

Control Flow Overview
Precedence Constraints
The Execute SQL Task
The Bulk Insert Task
The File System Task
The FTP Task
The Send Mail Task

Advanced Control Flow

Containers – grouping and looping
The Web Service Task
The WMI tasks
The Analysis Services tasks
The Execute Process Task
The Execute Package Task

Introduction to Data Flow

Data Flow Overview
Data Sources
Data Destinations
Data Transformations
The Copy Column Transformation
The Derived Column Transformation
The Data Conversion Transformation
The Conditional Split Transformation
The Aggregate Transformation
The Sort Transformation
Data Viewers

Variables and Configurations

Variables Overview
Variable scope
SSIS system variables
Using variables in control flow
Using variables in data flow
Using variables to pass information between packages
Property expressions
Configuration Overview
Configuration options
Configuration discipline

Debugging, Error Handling and Logging

SSIS debugging overview
Breakpoints in SSIS
SSIS debugging windows
Control Flow: The OnError event handler
Data Flow: Error data flow
Configuring Package Logging
Built-in log providers

Advanced Data Flow

Revisiting data sources and destinations
The Lookup Transformation
Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations
The Multicast Transformation
The Merge and Merge Join Transformations
The Data Mining Query Transformation
The Data Mining Model Training Destination
The Slowly Changing Dimension Transformation

Extending SSIS through Custom Code

Introduction to SSIS scripting
The SSIS script editor
The SSIS object model
Script in Control flow: The Script Task
Script in Data flow: The Script Component
Introduction to SSIS component development

SSIS Package Deployment

Configurations and deployment
The deployment utility
Deployment options
Deployment security
Executing packages – DTExec and DTExecUI

SSIS Package Management

The SSIS Service
Managing packages with DTUtil
Managing packages with SQL Server Management Studio Scheduling packages with SQL Server Agent

SQL Server 2005 Reporting Services
Introduction to SQL Server Reporting Services

Tour of Features
Reporting Services Architecture
Reporting Services Terminology
Reporting Services Editions
Taking Reporting Services for a Spin

Creating Reports

Deconstructing Reporting Services
Shared Data Sources
Creating Reports from Scratch

Calculations and Formatting

Creating Expressions
Using the Global Collections
Formatting Items
Conditional Formatting

Grouping and Sorting

Creating Groups
Calculating Totals and Percentages
Interactive Sorting
Creating Drill-Down Reports

Report Parameters

Creating Report Parameters
Creating Drop-Down Parameters
Multi-Valued Parameters
Debugging Parameter Issues

Creating Matrix Reports and Charts

Creating a Basic Matrix Report
Matrix Subtotals
Creating a Basic Chart
Exploring the Charting Possibilities

Managing Reporting Services

Deploying Reports and Data Sources
Exporting Reports and Printing
Using the Web-Based Report Manager
Using SQL Server Management Studio-based Reporting Services Manager

Reporting Services Security

Two Parts to Reporting Services Security
Securing Access to Reports
Data Source Security

Programming Reporting Services

The Many Reporting Services APIs
Integrating Reporting Services into Applications using URL Access
Using the Report Viewer Controls

Advanced Reporting Services Programming

Using the Reporting Services Web Service
Working with Custom Assemblies

Snapshots and Subscriptions

Caching and Snapshots
Creating Standard Subscriptions
Creating Data-Driven Subscriptions
Managing Subscriptions

Ad-Hoc Reporting with Report Builder

The Report Builder Architecture
Creating Report Model Projects
Running Report Builder

If you want to know more about Microsoft BI (MSBI) Training do not hesitate to call +91-9393 002 123 or mail us on info@unitedglobalsoft.com

Oracle DBA Online Training in India

Email : info@unitedglobalsoft.com
Call :09030624004


Pre-requisites:
SQL, PL/SQL,LINUX
.
INTRODUCTION TO ORACLE

Exploring the Oracle Database Architecture
Creating an Oracle Database
Managing the Database Instance
Managing Database Storage Structures (Table spaces & Segments)
Administering User Security
Managing Data Concurrency
Managing Undo Data
Configuring the Oracle Network Environment
Backup and Recovery Concepts (cold, hot & RMAN)
Use of RMAN Recovery Catalog & Configuring Backup Settings
Performing Database Backups with RMAN
Performing Database Recovery
Moving Data - Export & Import, External Tables & SQL Loader
Using Flashback Technology I
Using Flashback Technology II
Implementing Oracle Database Auditing
Implementing Oracle Database Auditing
Database Maintenance
Performance Management
Managing Performance by SQL Tuning
Diagnosing the Database
Managing Space
Managing Space for the Database
Managing the ASM Instance
Duplicating a Database / Cloning Database
Data Guard
Installing your Oracle Software
Database Patches & Database Upgrades
Introduction to Real Application Clusters
OLTP vs OLAP
Data modeling
Snake-Flow diagram
Dimensions and Facts
IQD preparation
IQD publishing
Cube generation
Cube publishing into portal
Validations
Adhoc reports
Zero suppression reports
Performance and Tuning with OLAP
Backup and recovery in OLAP
http://unitedglobalsoft.com/oracle-dba-training-in-hyderabad.html
If you want to know more about Oracle DBA Training do not hesitate to call +91-9393 002 123 or mail us on info@unitedglobalsoft.com

Microsoft bi Online Training in India

Email : info@unitedglobalsoft.com
Call : 09030624004

What Is Microsoft BI?

Core concept – BI is the cube or UDM
Example cube as seen using Excel pivot table
MS BI is comprehensive – more than Analysis Services on SQL Server
Demonstration of SQL Reporting Services with cube as data source

OLAP Modeling

Modeling source schemas—stars and snowflakes
Understanding dimensional modeling— Dimensions (Type 1, 2, or 3) or rapidly changing
Understanding fact (measures) and cube modeling
Other types of modeling—data mining etc

Using SSAS in BIDS

Understanding the development environment
Creating Data Sources and Data Source Views
Creating cubes – using the UDM and the Cube Build Wizard
Refining Dimensions and Measures in BIDS

Intermediate SSAS

KPIs
Perspectives
Translations – cube metadata and currency localization
Actions – regular, drill-through and reporting

Advanced SSAS

Using multiple fact tables
Modeling intermediate fact tables
Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing dimensions, write back dimensions
Modeling changing dimensions – Dimension Intelligence w/ Wizard
Using the Add Business Intelligence Wizards – write-back, semi-additive measures, time intelligence, account intelligence

Cube Storage and Aggregation

Storage topics – basic aggregations, MOLAP
Advanced Storage Design – MOLAP, ROLAP, HOLAP
Partitions – relational and Analysis Services partitions
Customizing Aggregation Design – Processing Design
Rapidly changing dimensions / ROLAP dimensions
Welcome to the Real Time – Proactive Caching
Cube processing options

Beginning MDX

Basic syntax
Using the MDX query editor in SQL Server Management Studio
Most-used Functions & Common tasks
New MDX functions

Intermediate MDX

Adding calculated members
Adding scripts
Adding named sets
.NET Assemblies

SSAS Administration

Best practices – health monitoring
XMLA scripting (SQL Mgmt Studio)
Other Documentation methods
Security – roles and permissions
Disaster Recovery – backup / restore
Clustering – high availability

Introduction to Data Mining

What and why?
Examples of using each of the 9 algorithms (MS Clustering, MS Decision Trees, Naïve Bayes, MS
Sequence Clustering, MS Time Series, MS Association Rules, MS Neural Network)
Data Mining dimensions
Data Mining clients
Processing mining models

Introduction to Reporting Clients

Excel 2003 Pivot Tables
SQL RS & Report Builder
SPS RS web parts & .NET 2.0 report viewer controls
Business Scorecards 2005 & ProClarity

Future Directions – Integration with Office 12

SharePoint 12 and AS
Report Center (type of dashboard) uses KPIs, Reports, Excel Web, Filter
Excel Services 12 and AS (Web Services)

SQL Server 2005 Integration Services
Introduction to SQL Server Integration Services

Product History
SSIS Package Architecture Overview
Development and Management Tools
Deploying and Managing SSIS Packages
Source Control for SSIS Packages

SSIS for DBAs: Using SQL Server Management Studio

The Import and Export Wizard
Importing and Exporting Data
Working with Packages
Database Maintenance Plans
Creating Database Maintenance Plans using SSMS
Scheduling and Executing Plans
Examining Database Maintenance Plan Packages
Changes in SQL Server 2005 Service Pack 2

Business Intelligence Development Studio

Launching BIDS
Project templates
The package designer
The Toolbox
Solution Explorer
The Properties window
The Variables window
The SSIS menu

Introduction to Control Flow

Control Flow Overview
Precedence Constraints
The Execute SQL Task
The Bulk Insert Task
The File System Task
The FTP Task
The Send Mail Task

Advanced Control Flow

Containers – grouping and looping
The Web Service Task
The WMI tasks
The Analysis Services tasks
The Execute Process Task
The Execute Package Task

Introduction to Data Flow

Data Flow Overview
Data Sources
Data Destinations
Data Transformations
The Copy Column Transformation
The Derived Column Transformation
The Data Conversion Transformation
The Conditional Split Transformation
The Aggregate Transformation
The Sort Transformation
Data Viewers

Variables and Configurations

Variables Overview
Variable scope
SSIS system variables
Using variables in control flow
Using variables in data flow
Using variables to pass information between packages
Property expressions
Configuration Overview
Configuration options
Configuration discipline

Debugging, Error Handling and Logging

SSIS debugging overview
Breakpoints in SSIS
SSIS debugging windows
Control Flow: The OnError event handler
Data Flow: Error data flow
Configuring Package Logging
Built-in log providers

Advanced Data Flow

Revisiting data sources and destinations
The Lookup Transformation
Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations
The Multicast Transformation
The Merge and Merge Join Transformations
The Data Mining Query Transformation
The Data Mining Model Training Destination
The Slowly Changing Dimension Transformation

Extending SSIS through Custom Code

Introduction to SSIS scripting
The SSIS script editor
The SSIS object model
Script in Control flow: The Script Task
Script in Data flow: The Script Component
Introduction to SSIS component development

SSIS Package Deployment

Configurations and deployment
The deployment utility
Deployment options
Deployment security
Executing packages – DTExec and DTExecUI

SSIS Package Management

The SSIS Service
Managing packages with DTUtil
Managing packages with SQL Server Management Studio Scheduling packages with SQL Server Agent

SQL Server 2005 Reporting Services
Introduction to SQL Server Reporting Services

Tour of Features
Reporting Services Architecture
Reporting Services Terminology
Reporting Services Editions
Taking Reporting Services for a Spin

Creating Reports

Deconstructing Reporting Services
Shared Data Sources
Creating Reports from Scratch

Calculations and Formatting

Creating Expressions
Using the Global Collections
Formatting Items
Conditional Formatting

Grouping and Sorting

Creating Groups
Calculating Totals and Percentages
Interactive Sorting
Creating Drill-Down Reports

Report Parameters

Creating Report Parameters
Creating Drop-Down Parameters
Multi-Valued Parameters
Debugging Parameter Issues

Creating Matrix Reports and Charts

Creating a Basic Matrix Report
Matrix Subtotals
Creating a Basic Chart
Exploring the Charting Possibilities

Managing Reporting Services

Deploying Reports and Data Sources
Exporting Reports and Printing
Using the Web-Based Report Manager
Using SQL Server Management Studio-based Reporting Services Manager

Reporting Services Security

Two Parts to Reporting Services Security
Securing Access to Reports
Data Source Security

Programming Reporting Services

The Many Reporting Services APIs
Integrating Reporting Services into Applications using URL Access
Using the Report Viewer Controls

Advanced Reporting Services Programming

Using the Reporting Services Web Service
Working with Custom Assemblies

Snapshots and Subscriptions

Caching and Snapshots
Creating Standard Subscriptions
Creating Data-Driven Subscriptions
Managing Subscriptions

Ad-Hoc Reporting with Report Builder

The Report Builder Architecture
Creating Report Model Projects
Running Report Builder
http://unitedglobalsoft.com/msbi-online-training-in-india.html
If you want to know more about Microsoft BI (MSBI) Training do not hesitate to call +91-9393 002 123 or mail us on info@unitedglobalsoft.com

Amazon Web services Online Training in India

Email : info(at)unitedglobalsoft(dot)com
Call : 09030624004

Introduction to Cloud computing

What is Cloud computing?
What are the different service delivery models in Cloud?
What are the different deployment models in Cloud computing?

Private Clouds -

Introduction to private clouds
Deploying a Microsoft private cloud using System Center 2012 and Windows 2012

Public Clouds - Amazon Web Services

Getting started with Amazon cloud
Creating accounts and analyzing the cost breakdown
Evaluating Service Level Agreements (SLA)
Console, command-line tools and API

Overview of the architecture

EC2
S3
EBS
Beanstalk
RDS
VPC
CloudFront
SimpleDB
SQS
CloudWatch

Achieving Agility with EC2
Managing the EC2 infrastructure

Browsing Amazon Machine Images (AMI)
Specifying security groups and key pairs

Provisioning resources

Evaluating Elastic Block Store (EBS) and instance store root devices
Assigning elastic IP addresses
Mapping instance types to computing needs

Implementing Durable and Reliable Storage
Storing data in the cloud

Persisting off-instance storage with EBS volumes
Creating backups with snapshots
Achieving high durability with SimpleStorage Service
Transmitting data in/out of the Amazon cloud

Simplifying the database infrastructure

Achieving high-availability of nonrelational data with SimpleDB
Effortlessly implement a relational database with Relational Database Service (RDS)

Creating cost-effective distributed solutions

Decoupling applications with Simple Queue Service
Leveraging CloudFront for high-performance edge cache content delivery
Delivering static and streaming content

Adapting EC2 to Your Business Needs
Customizing virtual machines

Modifying existing images
Creating new images off of running instances
Converting an instance store AMI to an EBS AMI

Creating an AWS cloud architecture

Applying best practices for a cloud solution
Selecting a cloud setup for different use case scenarios

Handling Dynamic Resource Requirements
Monitoring from inside or outside of the cloud

Visualizing utilization metrics with CloudWatch
Setting alarms to send and receive notifications

Transparently scaling to meet load variations

Distributing incoming traffic with elastic load balancing
Dynamically adding and removing instances with Auto Scaling
Setting capacity thresholds

Hosting Applications with Elastic Beanstalk
Improving application delivery with Platform as a Service (PaaS)

Deploying scalable applications on the AWS cloud
Selecting and launching an application environment

Managing application environments

Customizing and configuring platform stacks
Provisioning application resources with CloudFormation

AWS Security Features
Controlling account security

Configuring access credentials
Managing users with Identity Access Management (IAM)

Leveraging the Virtual Private Cloud (VPC)

Provisioning isolated AWS resources
Bridging EC2 instances to your internal network with a VPN
Launching EC2 instances on dedicated hardware
http://unitedglobalsoft.com/amazon-web-services-online-training-in-india.html
If you want to know more about Amazon Web Services Training do not hesitate to call +91-9393 002 123 or mail us on info@unitedglobalsoft.com

C Language Training in Hyderabad

Email : info@unitedglobalsoft.com
Call : 09030624004

Overview of C

History of C
Importance of C
Discuss Algorithm
Demonstrate the Use of Flowchart
Basic Structure of C Program
Sample Programs: Printing a Message, Adding Two Numbers, etc
Executing a C Program
Case Studies

2. Constants, Variables and Data Types

Introduction
Character Set
C Tokens
Keywords and Identifiers
Constants
Variables
Data Types
Declaration of Variables
Assigning Values to Variables

3. Operators and Expressions

Introduction
Arithmetic Operators
Relational Operators
Logical Operators
Assignment Operators
Increment and Decrement Operators
Conditional Operator
Bitwise Operators
Evaluation of Operators
Precedence of Arithmetic Operators
Case Studies

4. Managing Input and Output Operators

Introduction
Reading a Character
Writing a Character
Formatted Input
Formatted Output

5. Decision Making and Branching

Introduction
Decision Making with IF Statement
Nesting of IF..ElSE Statements
The Switch Statement
The ?: Operator
The Goto Statement
Case Studies

6. Decision Making and Looping

Introduction
The While Statement
The do Statement
The For Statement with example
Jumps in Loops with example
Case Studies

7. Arrays

Introduction
One-Dimensional Arrays
Two Dimensional Arrays
Initializing Two Dimensional Arrays
Multi Dimensional Arrays
Dynamic Arrays
Case Studies

8. Character Arrays and Strings

Introduction
Declaring and Initializing String Variables
Reading Strings from Terminal
Writing Strings to Screen
Arithmetic Operators on Characters
Putting Strings together
Comparison of Strings
String Handling Functions
Case Studies

9. User-defined Functions

Introduction
Definition of Functions
Need of User-defined Functions
A Multi-function program
Elements of User-defined Functions
Return Values and their types
Function calls
Function Declaration
Category of Functions
Nesting of Functions
Recursion
Passing Arrays to Functions
Passing Strings to Functions
The Scope, Visibility and Lifetime of Variables
Case Studies

10. Structures and Unions

Introduction
Defining and Declaring a Structure
Accessing structure members
Operations on Individual Members
Arrays of Structures
Arrays within the Structures
Structures within Structures
Structures and Functions
Unions
Case Studies

11. Pointers

Introduction
Understanding Pointers
Accessing the Address of a Variable
Declaring Pointer Variable
Initializing of Pointer Variables
Accessing a Variable through its pointer
Chain of Pointers
Pointer Expression
Pointer Increments
Pointer and Arrays
Pointer and Character Arrays
Array of Pointer
Pointer as Function Arguments
Function Returning Pointer
Pointers to Functions
Pointers and Structures
Case Studies

12. File Management in C

Introduction
Defining and Opening a File
Closing a File
Input/output Operations on Files
Random Access to Files
Command Lines Arguments
Case Studies

13. Dynamic Memory Allocation and Linked Lists

Introduction
Dynamic Memory Allocation
Allocating a Block of Memory : Malloc
Allocating Multiple Blocks of Memory : Calloc
Releasing the Used Space: Free
Altering the size of a Block: Realloc
Case Studies

14. Linked Lists

Introduction
Concepts of Linked Lists
Advantages of Linked Lists
Types of Linked Lists
Creating a Linked List
Inserting an Item
Deleting an Item
Applications of Linked Lists
Case Studies

15. The Preprocessor

Introduction
Macro Substitution
File Inclusion
Case Studies

http://unitedglobalsoft.com/c-language-online-training.html
If you want to know more about C language Training do not hesitate to call +91-9393 002 123 or mail us on info@unitedglobalsoft.com

Data Modeling online training in India

Email : info@unitedglobalsoft.com
Call : 09030624004

Introduction to Data Modeling
What is a Data Model.
Data Modeler Role

Business Requirement Analysis
Development of Data Model
Reports
Review
Creation of Database
Support and Maintenance

Components of a Data Model
Data Model Methodologies
Entity-Relationship Model

Data Modeling as Part of Database Design
Steps In Building the Data Model
Identifying Data Objects and Relationships

Read the documents provided by Trainer & google.
Data Modelling Methodology

Logical Data Modelling.
Physical Data Modelling
Logical vs Physical
Relational Data Modelling
Dimensional Data Modelling
Relational vs Dimensional
Slowly Changing Dimensions
Identifying and Non-Identifying relationship
Many2Many relationship and Transform
Supertype & Subtype relationship

What is Schema
Schemas in Data warehouse

Normalization Concepts (1nf, 2nf, 3nf)
Third normal Form
Star Schema and its Transformation Restrictions
Snowflake Schemas

Dimensional Modeling for Data Warehouse

Reports

Data Modelling Report
Logical Data Model Report
Physical Data Model Report

Read the documents provided by Trainer & google.
Erwin Features

Forward Engineering
Reverse Engineering
Complete Compare
Reoprts Generation
Data Model Versioning
Overview of all the features

Indexing and Partitioning Concepts using SQL Sever as a DB
Data Process and Managament

Data Profiling and Data Quality
Reference Data Managament
Data Dictionary
Data Conversion Techniques

Read the documents provided by Trainer & google.

One Business Scenario - Requirement will be provided by trainer, based on requirement student has to to convert the same requirement to model. Trainer will clarify all his/her doubts incase any while creating the model.
http://unitedglobalsoft.com/datamodeling-online-training-in-india.html
If you want to know more about Data Modeling Training do not hesitate to call +91-9393 002 123 or mail us on info@unitedglobalsoft.com

Oracle DBA Online Training in India

Email id: info@unitedglobalsoft.com
Call : 09030624004

Pre-requisites:
SQL, PL/SQL,LINUX
.
INTRODUCTION TO ORACLE

Exploring the Oracle Database Architecture
Creating an Oracle Database
Managing the Database Instance
Managing Database Storage Structures (Table spaces & Segments)
Administering User Security
Managing Data Concurrency
Managing Undo Data
Configuring the Oracle Network Environment
Backup and Recovery Concepts (cold, hot & RMAN)
Use of RMAN Recovery Catalog & Configuring Backup Settings
Performing Database Backups with RMAN
Performing Database Recovery
Moving Data - Export & Import, External Tables & SQL Loader
Using Flashback Technology I
Using Flashback Technology II
Implementing Oracle Database Auditing
Implementing Oracle Database Auditing
Database Maintenance
Performance Management
Managing Performance by SQL Tuning
Diagnosing the Database
Managing Space
Managing Space for the Database
Managing the ASM Instance
Duplicating a Database / Cloning Database
Data Guard
Installing your Oracle Software
Database Patches & Database Upgrades
Introduction to Real Application Clusters
OLTP vs OLAP
Data modeling
Snake-Flow diagram
Dimensions and Facts
IQD preparation
IQD publishing
Cube generation
Cube publishing into portal
Validations
Adhoc reports
Zero suppression reports
Performance and Tuning with OLAP
Backup and recovery in OLAP
http://unitedglobalsoft.com/oracle-dba-training-in-hyderabad.html

If you want to know more about Oracle DBA Training do not hesitate to call +91-9393 002 123 or mail us on info@unitedglobalsoft.com

Business Analyst Training in Hyderabad

Email : info@unitedglobalsoft.com
Call : 09030624004

Topics Covered Introduction to Business Analysis

Introduction to Business Analysis
Business Composition and Architecture
Roles and Responsibilities of a Business Analyst
Need for a Business Analyst
Project Team
Importance of a Business Analyst in the Project Team

System Development Life Cycle (SDLC)

Understanding Concept of Business Modeling
Requirement Gathering
Analysis
Implementation
Testing
Deployment

Understanding and Capturing business needs

Setting up priorities
Feasibility studies
Project scope
Risk assessment
Evaluating and selecting an initiative
Setting up future vision

Software Engineering Methods

Waterfall Method
RAD Methodology
AGILE Methodology
Prototype Model
Comparison between Waterfall & RUP
Artifacts delivered in each phase of RUP

Requirement Analysis Process

Creating Requirement gathering strategy
Planning
Requirements Activities
Requirement Gathering Techniques
Different Types of Requirements
Creating Business Requirement Document
Creating Software Requirement Specifications
Requirements Risk Management
Manage Requirements Change

UML Methodology

Use Case Diagrams
Activity Diagrams
Sequence Diagrams
State Chart Diagrams

Use Cases

Understanding Use Cases
Use Case Relationships
Use Case Brainstorming
Creating Use cases from Requirements
Creating Use Case Narratives
Change Management & Version Control Concept

Business Requirement Gathering Tools

MS Visio

Business Analysis & Modeling Tools

MS Visio

Business Process Improvement

Selection of process teams and leader
Process analysis training
Process analysis interview
Process documentation
Review cycle
Problem analysis

Modeling Data and Processes

Data models
Conceptual, logical and physical schemes
Data modeling process
Modeling methodologies
Entity relationship diagrams
Generic data modeling
Semantic data modeling

Software Testing

Introduction to QA Methodology
Role of BA in Testing
Creating Test Plans
Creating Test Cases
Different Testing Methods
Functional and Regression testing
White Box and Black Box Testing
Positive and Negative Testing
GUI and Unit Testing
User Acceptance Testing
http://unitedglobalsoft.com/business-analyst-training-in-hyderabad.html

Informatica Online Training in India

Email: info@unitedglobalsoft.com
Call:09030624004

DATAWAREHOUSING CONCEPTS

INTRODUCTION TO DATAWAREHOUSING

Data Warehousing Concepts
Dataware housing (what/Why/How)
Data Modelling(Schemas, FACTS and DIMENSIONS)
Slowly Changing Dimensions
Metadata
POWERCENTER COMPONENTS AND USER INTERFACE

PowerCenter Architecture
PowerCenter Client Tools
Lab – Using the Designer and Workflow Manager
SOURCE QUALIFIER

Source Qualifier Transformation
Lab Project Overview
Lab A – Load Payment Staging Table
Source qualifier Joins
Lab B – Load Product Staging Table
Source Pipelines
Lab C – Load Dealership and Promotions Staging Table and Real time issues
EXPRESSION, FILTER, FILE LISTS AND WORKFLOW SCHEDULER

Expression Editor
Filter Transformation
File Lists
Workflow Scheduler
Lab – Load the Customer Staging Table and Real time issues
JOINS, FEATURES AND TECHNIQUES I

Joiner Transformation
Shortcuts
Lab A – Load Sales Transaction Staging Table
Lab B – Features and Techniques I and Real time issues
LOOKUPS AND REUSABLE TRANSFORMATIONS

Lookup Transformation
Reusable Transformations
Lab A – Load Employee Staging Table
Lab B – Load Date Staging Table and Real time issues
DEBUGGER

Debugging Mappings
Lab – Using the Debugger
SEQUENCE GENERATOR

Sequence Generator Transformation
Lab – Load Date Dimension Table and Real time issues
LOOKUP CACHING, MORE FEATURES AND TECHNIQUES

Lookup Caching
Lab A – Load Promotions Dimension Table
Lab B – Features and Techniques II
Review and more Lab Activities and Real time issues
ROUTER, UPDATE STRATEGY AND OVERRIDES

Router Transformation
Update Strategy Transformation
Expression Default Values
Source Qualifier Override
Target Override
Session Task Mapping Overrides
Lab – Load Employee Dimension Table and Real time issues
DYNAMIC LOOKUP AND ERROR LOGGING

Dynamic Lookup
Error Logging
Lab – Load Customer Dimension Table
UNCONNECTED LOOKUP, PARAMETERS AND VARIABLES

Unconnected Lookup Transformation
System Variables
Mapping Parameters and Variables
Lab – Load Sales Fact Table
SORTER, AGGREGATOR AND SELF-JOIN

Sorter Transformation
Aggregator Transformation
Active and Passive Transformations
Data Concatenation
Self-Join
Lab – Reload the Employee Staging Table and Real time issues
SCD type1 – LAB

SCD type2 – LAB

SCD type3 – LAB

MAPPLETS

Mapplets
Lab – Load Product Daily Aggregate Table
Review and more Lab Activities and Real time issue
WORKFLOW VARIABLES AND TASKS

Link Conditions
Workflow Variables
Assignment Task
Decision Task
Email Task
Lab – Load Product Weekly Aggregate Table
MORE TASKS AND REUSABILITY

Event Raise Task
Event Wait Task
Command Task
Reusable Tasks
Reusable Session Task
Reusable Session Configuration
WORKLETS AND MORE TASKS

Worklets
Timer Task
Control Task
Lab – Load Inventory Fact Table
If you want to know more about Informatica Training do not hesitate to call +91-9393 002 123 or mail us on info@unitedglobalsoft.com

SAS Online Training in India

Email: info@unitedglobalsoft.com
Call:09030624004

SAS Training Course Content:
Accessing Data

Use FORMATTED and LIST input to read raw data files.
Use INFILE statement options to control processing when reading raw data files.
Use various components of an INPUT statement to process raw data files including column and line
pointer controls, and trailing @ controls
Combine SAS data sets.
Access an Excel workbook.
Creating Data Structures
Create temporary and permanent SAS data sets.
Create and manipulate SAS date values.
Export data to create standard and comma-delimited raw data files.
Managing Data
Investigate SAS data libraries using base SAS utility procedures.
Sort observations in a SAS data set.
Conditionally execute SAS statements.
Use assignment statements in the DATA step.
Modify variable attributes using options and statements in the DATA step.
Accumulate sub-totals and totals using DATA step statements.
Use SAS functions to manipulate character data, numeric data, and SAS date values.
Use SAS functions to convert character data to numeric and vice versa.
Process data using DO LOOPS.
Process data using SAS arrays.
Validate and clean data.
Generating Reports
Generate list reports using the PRINT procedure.
Generate summary reports and frequency tables using base SAS procedures.
Enhance reports through the use of user-defined formats, titles, footnotes and SAS System reporting.
Generate reports using ODS statements.
Handling Errors
Identify and resolve programming logic errors.
Recognize and correct syntax errors.
Examine and resolve data errors.
If you want to know more about SAS Training do not hesitate to call +91-9393 002 123 or mail us on info@unitedglobalsoft.com