TABLEAUE INFORMATICA COMBO Training in Pune/ Online

Courses Included:-

SQL + Informatica + Tableau

Duration of Training  :  4 months

Batch type  :  Weekdays/Weekends

Mode of Training  :  Classroom/Online/Corporate Training

Why Radical Technologies

ORACLE SQL

COURSE CONTENT :

For whom SQL is? :

IT or NON IT people can easily enter into leading Database Technology which is commonly used for all domain application software as back-end. There are so many reason to go ahead : 

• Oracle SQL is basic learning platform to get in IT, which is easy to learn.
• On completion Oracle SQL training you can attempt certification exam.
• Certified candidate can take benefit as IT document and can get good opportunity in IT world.
• Oracle SQL is easy for any support project for initial stage which get into IT carrier. In case you want to grow for development environment than it’s entry for programming.
• Now a days SQL is basic skill set for any IT/NON IT folks, It’s always helpful for any functional, support and technical consultant.

WEEK-01 :  

Oracle 12c SQL :

SQL Basic 

[1] Introduction to Oracle DB 12c 

Oracle Database 12c: Focus Areas, Fusion Middle-ware, Oracle Cloud, Services, Deployment Methods, RDBMS, Data Model, ER Diagram, Relation DB Terminology, SQL Statements and Development Environment, HR Schema Tables, DB Documentation. 

[2] Retrieving Data using SQL SELECT statement 

Basic Select Statement, Arithmetic Expression, Defining Null values, Concatenation Operator & Literal, Duplicate Rows, Displaying table structure. Practice Overview. 

[3] Restricting & Sorting Data 

Use of Where clause, Character Strings & Date Data, Comparison, Logical, Range, Pattern, & Other operators, Rules Precedence, Order By Clause, Substitution variables. Practice Overview 

WEEK-02 :

[4] Single Row Function & Customized Output 

SQL function, Single Row Function, Character/Case Functions, Number Functions, Nesting Function, Date Functions etc. Practice Overview. 

[5] Conversion & Conditional Expressions 

Conversion Function, Implicit/Explicit Data Conversion, General Function with covering NVL, NVL2, NULLIF, COALESCE, Conditional Expression with Decode function and Case Expression. Practice Overview. 

[6] Reporting Aggregated Data using Group Function 

Usages of Group function, Nesting Group Function, Creating Group Data, Restricting group data using Having Clause. Practice Overview. 

[7] Displaying Data from Multiple Tables using Join 

Type of Joins, Explaining with Natural Join, Using Clause, On Clause, SQL 99 Syntax, Three-Way Join, Self Join, NonEqui Join, Inner Versus Outer Join, Cross Join etc. Practice overview. 

WEEK-03 : 

[8] Using Sub-queries to solve queries 

Scenario to use Sub-query, Rules for Sub-queries, Type of Sub-queries, Single Row Sub-queries and Multi Row Sub-queries. Null value in Sub-query etc. Practice Overview.

SQL Advanced : 

[9] Using Set Operator 

Set Operator Rules, Covering Set Operator as UNION, UNION ALL, INTERSECT, MINUS etc. Practice Overview. 

[10] Managing Tables using DML      Statements 

Data Manipulation Language, Covering INSERT, UPDATE, DELETE & DB Transaction control using COMMIT, ROLLBACK, SAVEPOINT. Use of For update clause in SELECT Statement. 

[11] Introduction to Data Definition Language 

Database Object, Naming Rules, Various Data Types, CREATE TABLE statement, Constraint guidelines, Defining constraints as NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY & CHECK etc. ALTER TABLE, DROP TABLE Statement. Create Table using Sub-query. Practice Overview. 

WEEK-04 :

[12] Introduction to Data Dictionary Views

Data Dictionary Structure, How to use Data Dictionary, USER_OBJECTS, ALL_OBJECT, USER_CONSTRAININTS. TABLE Information, Column Information etc. Practice overview.

[13] Creating Sequence, Synonyms & Indexes 

Importance of Sequence, Synonyms & Indexes. Defining Sequence, Synonyms & Indexes & DROP statement etc. Practice overview. 

[14] Creating Views

What’s View? Advantage of Views, CREATE Simple & Complex views, Rules for performing DML operation on views. Modifying & Removing a view etc. Practice Overview. 

[15] Retrieving Data by using Sub-Query 

Multiple Column Sub-query, Column Comparison, Pair & Non Pair Sub-queries, Scalar  Sub queries, Co-related Sub-queries, Use of WITH clause. Practice Overview.

INFORMATICA 10.x DEV + ADMIN

Introduction to Informatica :

Informatica is a tool, supporting all the steps of Extraction, Transformation and Load process. Now days Informatica is also being used as an Integration tool. Informatica is an easy to use tool. It has got a simple visual interface like forms in visual basic. You just need to drag and drop different objects (known as transformations) and design process flow for Data extraction transformation and load. These process flow diagrams are known as mappings. Once a mapping is made, it can be scheduled to run as and when required. In the background Informatica server takes care of fetching data from source, transforming it, & loading it to the target systems/databases. Informatica can communicate with all major data sources (Mainframe/RDBMS/Flat Files/XML/VSM/SAP etc.), can move/transform data between them. It can move huge volumes of data in a very effective way, many a times better than even bespoke programs written for specific data movement only. It can throttle the transactions (do big updates in small chunks to avoid long locking and filling the transactional log). It can effectively join data from two distinct data sources (even a xml file can be joined with a relational table). In all, Informatica has got the ability to effectively integrate heterogeneous data sources & converting raw data into useful information

Informatica is not only ETL tool but also Data integrator.Informatica is one of the Best tool in current industry provides versatile solutions to any kind of data.In Radical we provide scenario based training with real time examples, project explanation, project related queries.
Any one who is having basic knowledge of SQL queries can start learning Informatica tool.
As it is a GUI based​ tool, coding knowledge wouldn’t be necessary.At least 1-3 yrs of experience is good enough to get interview calls.

COURSE CONTENT 

Administrator  Module :

• Understanding Domains

1. Nodes
2. Application Services

• Using Administration Console
• Managing the Domain

1. Managing Alerts
2. Managing Folders
3. Managing Permissions
4. Managing Application Services
5. Managing the Nodes

• Managing Users and Groups
• Managing Privileges and Roles

1. Domain Privileges
2. Repository Services Privileges
3. Reporting Service Privileges
4. Managing Roles – Assigning Privileges and Roles to Users and Groups

• Creating and Configuring the Repository Services
• Managing the Repository
• Creating and Configuring Integration Services

1. Enabling and Disabling the Integration Services
2. Running in Normal and Safe Mode
3. Configuring the Integration Services Processes

• Integration Services Architecture
• Creating the Reporting Services

1. Managing the Reporting Services
2. Configuring the Reporting Services

• Managing License

Advanced Workflow Module :

• Understanding Pipeline Partitioning

1. Partitioning Attributes
2. Dynamic Partitioning
3. Partitioning Rules
4. Configuring Partitioning

• Partitioning Points

1. Adding and Deleting Partitioning points
2. Partitioning Relational Sources
3. Partitioning File Targets
4. Partitioning transformations

• Partitioning Types
• Real Time Processing
• Commit Points
• Workflow Recovery
• Stopping and Aborting

1. Error Handling
2. Stopping and Aborting Workflows

• Concurrent Workflows
• Load Balancer
• Workflow Variables

1. Predefined Workflow Variables
2. User- Defined Workflow Variables
3. Using Worklet Variables
4. Assigning Variable Values in a Worklet

• Parameter and variables in Sessions

1. Working with Session Parameters
2. Assigning Parameter and Variables in a Session

• Parameter File
• Session Caches
• Incremental Aggregation
• Session Log Interface

Command Reference :

• Using Command Line Programs

1. Infacmd
2. Infasetup
3. Pmcmd
4. pmrep

Designer  Module :

• Using the Designer

1. Configuring Designer Options
2. Using Toolbars
3. Navigating the Workspace
4. Designer Tasks
5. Viewing Mapplet and Mapplet Reports

• Working with Sources

1. Working with Relational Sources
2. Working with COBOL Sources
3. Working with Cobol Source Files

• Working with Flat Files

1. Importing  Flat Files
2. Editing Flat Files Definition
3. Formatting Flat Files Column

• Working with Targets

1.  Importing Target Definition
2. Creating Target Definition from Source Definition
3. Creating Target Definition from Transformations
4. Creating Target tables

• Mappings

1. Working with Mappings
2. Connecting Mapping Objects
3. Linking Ports
4. Propagating Port Attributes
5. Working with Targets in a Mapping
6. Working with Relational Targets in a Mapping
7. Validating a Mapping
8. Using Workflow Generation Wizard

• Mapplets

1. Understanding Mapplets Input and Output
2. Using Mapplet Designer
3. Using Mapplets in Mapping

• Mapping Parameters and Variables
• Working with User-Defined Functions
• Using the Debugger

1. Creating Breakpoints
2. Configuring the Debugger
3. Monitoring the Debugger
4. Evaluating Expression

• Creating Cubes and Dimensions
• Using Mapping Wizard
• Naming Conventions

Performance Tuning Module :

Performance Tuning Overview

• Bottlenecks

1. Using Thread Statistics
2. Target Bottlenecks
3. Source Bottlenecks
4. Mapping Bottlenecks
5. Session Bottlenecks
6. System Bottlenecks

• Optimizing the Targets
• Optimizing the Source
• Optimizing the Mapping
• Optimizing the Transformations
• Optimizing the Sessions
• Optimizing thePowerCenter Components
• Optimizing the System
• Using Pipeline Partitions
• Performance Counters

Repository Module :

• Understanding the Repository
• Using Repository Manager
• Folders
• Managing Object Permissions
• Working with Versioned Objects
• Exporting and Importing Objects
• Copying Objects

Transformation Module :

• Working with Transformations

1. Configuring Transformations
2. Working with Ports
3. Working with Expressions
4. Reusable Transformations

• Aggregator Transformation
• Custom Transformation
• Expression Transformation
• External Transformation
• Filter Transformation
• Joiner Transformation
• Java Transformation
• Lookup Transformation
• Lookup Caches
• Normalizer Transformation
• Rank Transformation
• Router Transformation
• Sequence Generator Transformation
• Sorter Transformation
• Source Qualifier Transformation
• SQL Transformation
• Stored Procedure Transformation
• Transaction Control Transformation
• Union Transformation
• Update Strategy Transformation

Transformation Language Reference :

• The Transformation Language
• Constants
• Operators
• Variables
• Dates
• Functions
• Creating Custom Function

Workflow Basics Module :

• Workflow Manager

1. Workflow Manager Options
2. Navigating the Workspace
3. Working with Repository Objects
4. Copying Repository Objects
5. Comparing Repository Objects

• Workflow and Worklets

1. Creating a Workflow
2. Using Workflow Wizard
3. Assigning an Integration Service
4. Working with Worklets
5. Working with Links

• Sessions

1. Creating a Session Task
2. Editing a Session
3. Pre- and Post- Session Commands

• Session Configuration Objects
• Tasks

1. Creating a Task
2. Configuring Tasks
3. Working with Command Task
4. Working with Decision Task
5. Working with Event Task
6. Working Timer Task
7. Working with Assignment Task

• Sources

1. Configuring Sources in a Session
2. Working with Relational Sources
3. Working with Flat Sources

• Targets

1. Configuring Targets in a Session
2. Working with Relational Targets
3. Working with File Targets
4. Reject Files

• Validation

1. Validating Tasks
2. Validating Worklets
3. Validating Session
4. Validating Workflows

• Scheduling and Running Workflows

1. Scheduling a Workflow
2. Manually Starting a Workflow

• Sending Email

1. Working with Email Tasks
2. Working with Post-Session Email

• Workflow Monitor

1. Using Workflow Monitor
2. Customizing Workflow Monitor Options
3. Working with Tasks and Workflows
4. Using Gantt Chart View and Task View

• Workflow Monitor Details

1. Integration Services Properties
2. Workflow Run Properties
3. Worklet Run Properties
4. Session Task Run Properties
5. Performance Details

• Session and Workflow Logs

1. Log Events
2. Log Events Window
3. Working with Log Files
4. Workflow Logs

Note : Lab sessions for all the points mentioned above will be taken.

DATA WAREHOUSING SYLLABUS 

• Evolution of Datawarehousing – History
• The need of Datawarehousing
• Why Datawarehousing
• What is Datawarehousing – The Definition

1. Subject -Oriented
2. Integrated
3. Non – Volatile
4. Time Varying

• Datawarehousing Architecture

1. Data Source Layer
2. Data Extraction Layer
3. Staging Layer
4. ETL Layer
5. Data Storage Layer
6. Data Logic Layer
7. Data Presentation Layer
8. Metadata Layer
9. System Operation Layer

• Dimension table
• Fact table

1. Additive Facts
2. Semi Additive Facts
3. Non – Additive Fact
4. Cumulative
5. SnapShot

• Attribute
• Hierarchy
• Types of Schema

1. Star Schema
2. Snow Flake Schema
3. Fact Constellation Schema

• Slow Changing Dimension

1. SCD1 – Advantages/ Disadvantages
2. SCD2 – Advantages/ Disadvantages
3. SCD3 – Advantages/ Disadvantages

• OLAP and OLTP

1. Difference between OLAP and OLTP
2. Types Of OLAP
3. Multi-Dimensional (MOLAP)
4. Relational(ROLAP)
5. Hybrid(HOLAP)

TABLEAU

COURSE CONTENT : 

1. Introduction and Getting Started

• Why Tableau? Why Visualization?
• The Tableau Product Line
• Level Setting – Terminology
• Getting Started – creating some powerful visualizations quickly
• Review of some Key Fundamental Concepts
• What is Tableau?
•  What does the Tableau product suite comprise of? How Does Tableau Work?
• Tableau Architecture
• Connecting to Data & Introduction to data source concepts
• Understanding the Tableau workspace
• Dimensions and Measures
• Data Types & Default Properties
• Tour of Shelves & Marks Card
• Using Show Me
• Saving and Sharing your work-overview

2. Filtering, Sorting & Grouping

Filtering, Sorting and Grouping are fundamental concepts
when working with and analyzing data. We will briefly review these topics as they apply to Tableau

• Advanced options for filtering and hiding
• Understanding your many options for ordering and grouping your data: Sort, Groups, Bins, Sets
• Understanding how all of these options inter-relate

3. Working with Data

In the Advanced class, we will understand the difference between joining and blending data, and when we should do each. We will also consider the implications of working with large data sets, and consider options for when and how to work with extracts and the data engine. We will also investigate best practices in “sharing” data sources for Tableau Server users.

• Data Types and Roles
• Dimension versus Measures
• Data Types
• Discrete versus Continuous
• The meaning of pill colors
• Database Joins
• Data Blending
• Working with the Data Engine / Extracts and scheduling extract updates
• Working with Custom SQL
• Adding to Context
• Switching to Direct Connection

4. Working with Calculated Data and Statistics

 In the Fundamentals Class, we were introduced to some basic calculations: basic string and arithmetic calculations and ratios and quick table calculations. In the Advanced class, we will extend those concepts to understand the intricacies of manipulating data within Tableau

5. A Quick Review of Basic Calculations

Arithmetic Calculations

String Manipulation

Date Calculations

Quick Table Calculations

Custom Aggregations

Custom Calculated Fields

Logic and Conditional Calculations

 Conditional Filters

6. Advanced Table Calculations

Understanding Scope and Direction

Calculate on Results of Table Calculations

Complex Calculations

Difference From Average

Discrete Aggregations

Index to Ratios

7. Working with Parameters

In the Fundamentals class, we were introduced to parameters – How to create a parameter and use it in a calculation. In the Advanced class, we will go into more details on how we can use parameters to modify our title, create What-If analysis, etc

Parameter Basics

Data types of parameters

Using parameters in calculated fields

 Inputting parameter values and parameter control options

Advanced Usage of Parameters

Using parameters for titles, field selections, logic statements, Top X

8. Building Advanced Chart Types and Visualizations/Tips & Tricks

This topic covers how to create some of the chart types and visualizations that may be less obvious in Tableau. It also covers some of the more common tips & tricks/techniques that we use to assist customers in solving some of their more complex problems.

• Bar in Bar
• Box Plot
• Bullet Chart
• Custom Shapes
• Gantt Chart
• Heat Map
• Pareto Chart
• Spark Line
• KPI Chart

9. Best Practices in Formatting and Visualizing

• Formatting Tips
• Drag to Legend
• Edit Legend
• Highlighting
• Labeling
• Legends
• Working with Nulls
• Table Options
• Annotations and Display Options
• Introduction to Visualization Best Practices

10. Data Analysis And Reporting

• Data Analysis using Pivot Tables – use of row and column shelf, values and filters
• Difference between data layering and cross tabulation, summary reports, advantages and limitations
• Change aggregation types and summarisation
• Creating groups and bins in pivot data
• Concept of calculated fields, usage and limitations
• Changing report layouts – Outline, compact and tabular forms
• Show and hide grand totals and subtotals
• Creating summary reports using pivot tables

11. SQL : Data Manipulation (DML Commands)

• Insert, Update & Delete statements
• Select statement – Subsetting, Filters, Sorting. Removing Duplicates, grouping and aggregations etc
• Where, Group By, Order by & Having clauses
• SQL Functions – Number, Text, Date, etc
• SQL Keywords – Top, Distinct, Null, etc
• SQL Operators –  Relational (single valued and multi valued), Logical (and, or, not), Use of wildcard operators and wildcard characters, etc

12. SQL : Accessing Data From Multiple Tables Using SELECT

• Append and JoinsUnion and Union All – Use & constraints
• Intersect and Except statements
• Table Joins – inner join, left join, right join, full join
• Cross joins/cartesian products, self joins, natural joins etc
• Inline views and sub-queries
• Optimizing your work

13. Tableau : Data Handling & Summaries

• Date Aggregations and Date parts
• Cross tab & Tabular charts
• Totals & Subtotals
• Bar Charts & Stacked Bars
• Line Graphs with Date & Without Date
• Tree maps
• Scatter Plots
• Individual Axes, Blended Axes, Dual Axes & Combination chart
• Parts of Views
• Sorting
• Trend lines/ Forecasting
• Reference Lines
• Filters/Context filters
• Sets
  • In/Out Sets
  • Combined Sets
• Grouping
• Bins/Histograms
• Drilling up/down – drill through
• Hierarchies
• View data
• Actions (across sheets)

14. Tableau : Building Advanced Reports/ Maps

• Explain latitude and longitude
• Default location/Edit locations
• Building geographical maps
• Using Map layers

15. Tableau : Calculated Fields

• Working with aggregate versus disaggregate data
• Explain – #Number of Rows
• Basic Functions (String, Date, Numbers etc)
• Usage of Logical conditions

16. Tableau : Table Calculations

• Explain scope and direction
• Percent of Total, Running / Cumulative calculations
• Introduction to LOD (Level of Detail) Expressions
• User applications of Table calculations

17. Tableau : Parameters

• Using Parameters in
  • Calculated fieldsBins
  • Reference Lines
  • Filters/Sets
• Display Options (Dynamic Dimension/Measure Selection)
• Create What-If/Scenario analysis

18. Tableau : Building Interactive Dashboards

• Combining multiple visualizations into a dashboard (overview)
• Making your worksheet interactive by using actions
  • Filter
  • URL
  • Highlight
• Complete Interactive Dashboard for Sales & Services

19. Tableau : Formatting

• Options in Formatting your Visualization
• Working with Labels and Annotations
• Effective Use of Titles and Captions

20. Tableau : Working With Data

• Multiple Table Joins
• Data Blending
• Difference between joining and blending data, and when we should do each
• Toggle between to Direct Connection and Extracts

Learn Tableau Informatica Combo – Course in Pune with Training, Certification & Guaranteed Job Placement Assistance!

Online Batches Available for the Areas

Ambegaon Budruk | Aundh | Baner | Bavdhan Khurd | Bavdhan Budruk | Balewadi | Shivajinagar | Bibvewadi | Bhugaon | Bhukum | Dhankawadi | Dhanori | Dhayari | Erandwane | Fursungi | Ghorpadi | Hadapsar | Hingne Khurd | Karve Nagar | Kalas | Katraj | Khadki | Kharadi | Kondhwa | Koregaon Park | Kothrud | Lohagaon | Manjri | Markal | Mohammed Wadi | Mundhwa | Nanded | Parvati (Parvati Hill) | Panmala | Pashan | Pirangut | Shivane | Sus | Undri | Vishrantwadi | Vitthalwadi | Vadgaon Khurd | Vadgaon Budruk | Vadgaon Sheri | Wagholi | Wanwadi | Warje | Yerwada | Akurdi | Bhosari | Chakan | Charholi Budruk | Chikhli | Chimbali | Chinchwad | Dapodi | Dehu Road | Dighi | Dudulgaon | Hinjawadi | Kalewadi | Kasarwadi | Maan | Moshi | Phugewadi | Pimple Gurav | Pimple Nilakh | Pimple Saudagar | Pimpri | Ravet | Rahatani | Sangvi | Talawade | Tathawade | Thergaon | Wakad