New Batches Started at Sgraph Infotech!!! Data Science (8AM to 9AM), Pega (8AM to 9AM), MSBI (10AM to 11AM), Power BI (9AM to 10AM), Salesforce (6PM to 7 PM), RPA-Automation Anywhere (7AM to 8AM), Oracle DBA 12C (6:30 PM to 7:30 PM), Selenium (7PM to 8PM). Contact Us right now: For more information Call: +91-8049570931 / sgraphinfotech@gmail.com.

ETL Testing Training Institutes in Bangalore

An ETL (Extract-Transform-Load) apparatus separates every one of the information from heterogeneous information sources which can be Microsoft, Oracle or whatever other utilizing social database and changes the information like applying figuring’s, keys, joining fields, expelling off base information documents and fields, and so on and loads it into the Data Warehouse.

Sgraph InfoTech's ETL trying course lets you master in ETL testing. This ETL testing preparing is for both learners and experts. In this course length you will find out about all ETL testing ideas, information warehousing ideas and SQL inquiries. We are giving this ETL testing preparing with position help.

Sgraph Infotech is giving ETL Testing instructional class with 8+ years of constant and area experienced experts IT personnel. ETL Testing instructional class substance, material and syllabus is composed according to the business and profession advancement arranged principles and ETL Testing course is playing gigantic request in IT showcase. Such a large number of undertakings are utilizing ETL Testing programming. Sgraph Infotech gave general classes to understudies with typical track, quick track and end of the week sessions.

In our foundation affirmed mentor will help the understudy amid the ETL Testing preparing with ongoing undertakings. In this course the competitor will think about essentials to cutting edge ETL Testing ideas. These components and offices make us the best ETL Testing preparing foundation in Marathahalli, Bangalore We are enthusiastic and devoted to give quality preparing Don't squander your important time enlist today in Sgraph Infotech for additional data get in touch with us/email us.

Key Features

  • 45 hours of training
  • Training by more than 7 years experienced professionals
  • Limited seats for every batch
  • Flexibility in training hours
  • Hands-On project experience
  • Technically updated lab facility
  • 24/7 support for the candidate

Who should take this ETL Testing Course?

       The following software or industry professionals were deserved to take this ETL Testing training.

  • Senior IT professionals.
  • Java and non java background.
  • Freshers

What You Will Get After the Course?

  • Placement assistance
  • Trainers will help on Resume preparation
  • Backlog class available if any student has missed the class
  • Latest and updated study material

What are the Prerequisites to learn ETL Testing course?

         knowledge on java,basic java and OOPS.

An ETL (Extract-Transform-Load) apparatus separates every one of the information from heterogeneous information sources which can be Microsoft, Oracle or whatever other utilizing social database and changes the information like applying figuring’s, keys, joining fields, expelling off base information documents and fields, and so on and loads it into the Data Warehouse.
 

Software Testing Training

 Course Content:

 

  1. Testing Overview
    • What is testing?
    • Why is Testing?

 

  1. Software Test Life Cycle
    • Requirement Analysis
    • Test Strategizing
    • Test Case Development
    • Test Environment Setup
    • Test Execution
    • Test Cycle Closure

 

  1. SDLC Vs STLC

 

  1. V -Model of testing

 

  1. Test case design/optimization techniques
    • Need for test case optimization
    • Functional Technique
    • Structural Technique
    • Special Technique

 

  1. Testing Techniques
    • Static Testing
    • Dynamic Testing
      • White Box Testing/Structural Testing
      • Black Box Testing

 

  1. Types of Testing
    • Functional Testing
      • Unit Testing
      • Integration Testing
      • Smoke Testing
      • System Testing
      • Regression Testing
      • User Acceptance Testing
      • Globalization Testing
      • Localization Testing

 

  • Non Functional Testing
    • Performance Testing
    • Compatibility Testing
    • Data Migration Testing
    • Data Conversion Testing
    • Security/Penetration Testing
    • Usability testing
    • Install/Un-Install Testing

 

  1. Defect reporting and tracking
    • Defect Lifecycle
    • Defect Management Tools

 

  1. When to STOP Testing?

 

  1. Testing Deliverables

 

  1. Quality Assurance Vs Quality Control

 

  1. Test Measurements and Metrics
    • Cost Of Quality

 

 

HP Quality Center

 

Course Content:

 

  1. Introduction to HPQC
  2. Overview of HPQC
  3. Working with different tabs
  4. Test case creation
  5. Test Execution
  6. Creating traceability through HPQC
  7. Defect creation & Linkage
  8. Working with different reports
  9. Working with Dash Board

 

 

 

 

 

 

SQL Scripting

 

Course Content:

 

  1. What is SQL?
  2. What Can SQL do?
  3. Most Important SQL Commands
  4. Working with DDL, DCL, DML commands
  5. Working with different SQL commands
  6. Working with different SQL functions
  7. Understanding of Data base Vs UI reports validation
  8. Working with different SQL scripts.

 

 

 

ETL Testing

 

Course Content:

 

  1. Why ETL?
    • ETL Concepts:

 

  1. ETL Requirements:

 

  1. What is Data Warehouse?
    • Working with OLTP
    • Working with OLAP

 

  1. Data Warehouse designing techniques
    • Fact & Dimension tables
    • Attribute & Lookup tables
    • Aggregate Tables

 

  1. Understanding Data Mart

 

  1. Dimensional Modeling:
    • Normalization
      • Snow-Flake Schema
    • De-normalization
      • Start Schema
    • Entity Relationship Model
    • Slowly Changing Dimensions

 

Software Testing Process

 

  1. Different teams involved in SDLC
  2. Requirement gathering and understanding
  3. Choosing the SDLC methodology
  4. Requirements implementation
  5. Customer satisfaction
  6. Software implementation into production
  7. Production maintenance.

 

How will I do the Lab Practice?

We have the technically updated lab to give you the best hands-on project experience out instructor’s gives you best support if get stuck anywhere while practicing, we will provide the cloud lab which give the access to your PC or Laptop. Then you can access our server from anywhere.

Who are the instructors?

Our instructors were the best industry and domain knowledge professionals with 7+ years of experience in ETL Testing training in Bangalore.

What if I miss a class?

We will provide you the backup classes if you miss any session. You can continue the missed classes from next batch.

How can I request for a demo class?

You can either walk-in to our ETL Testing training institute in Marathahalli, or you can send the query to us from the website then we can arrange the ETL Testing training demo session for you.

What are the payment options?

You can pay directory or you can transfer the money online. We also accept cards.

Will I get the required software from institute?

Definitely you can get or access the software from our server or we can provide the required software to you depending on the course.

Is there any offer or discount I can avail?

Yes, you can find the best offers and discounts which are vary time to time you can check with us.

Course Content

ETL Testing Course Content

Oracle Basics & Concepts

  • DBMS
  • RDBMS
  • DBMS vs RDBMS
  • Why Database Required
  • Different types of databases and difference
  • ASCII vs UNICODE
  • PL/SQL Basics
  • Oracle Architecture
  • Diff B/W Database & Files
  • OLTP
  • OLAP, ROLAP, MOLAP
  • METADATA
  • DDL,DML,DCL
  • BASIC ADMIN ACTIVITIES
  • DATATYPES
  • TABLES
  • SQL ,SUB QUERIES,CORELATED SUB QUERY
  • INNER QUERY,OUTER QUERY
  • FUNCTIONS AND TYPES AND IMPORTANCE
  • JOINS AND DIFFERENT TYPES
  • VIEWS n MATERIALIZED VIEWS
  • INDEX
  • CONSTRAINTS
  • REFERENTIAL INTEGRITY
  • PARTITIONING
  • PERFORMANCE TUNING
  • DIFFERENT TYPES OF TECHNIQES
  • DATABASE SCHEMA

DWH Concepts

  • WHAT IS DWH ?WHY WE REQUIRE THAT ?
  • DWH ARCHITECTURE
  • DATA MART and TYPES
  • DM vs DWH
  • DATA CLEANZING
  • DATA SCRUBING
  • DATA MASKING
  • NORMALIZATION
  • ODS
  • STG AREA
  • DSS
  • Diff B/w OLTP vs ODS,OLAP vs DSS
  • DIMENTION MODELING
  • DIMENSIONS
  • FACTS
  • AGGREGATES
  • DWH SCHEMA designing
  • STAR SCHEMA,SNOWFLAKE SCHEMA,GALAXY SCHEMA,FCS
  • SLOWLY CHANGING DIMENSIONS
  • INITIAL LOAD
  • INCREMENTAL LOAD
  • FULL LOAD
  • CDC- change data capture

ETL Testing Concepts

  • Introduction of ETL-Extract,Transform,Load
  • ETL TOOLS and Diff Types of ETL Tools
  •  
  • ETL ARCHITECTURE
  • ETL TESTING AND WHY WE REQUIRE
  • DIFFERENT ETL TOOLS ARCHITECTURES
  • SDLC and Methods/Models
  • STLC and Methods/Models
  • SDLC vs STLC
  • Reverse Engineering
  • QC(Quality Center and BugZilla)
  • Roles and Responsibilities
  • Minus,Duplicate,Count,Intersection
  • Detect Defects
  • Defects Logging and Reporting
  • How to prepare Queries very quickly with the help of mapping
  • Performance Tuning and Performance Testing,Report Testing,UI Testing
  •    Quality and different standards that tester should follow,Why?
  • Testplan Preparation
  • Testcases Preparation
  • Preparation of Test data
  • Process Of ETL Testing

Testing Concepts

  • Whitebox Testing
  • Blackbox Testing
  • Gray Box Testing
  • Regression Testing
  • Smoke Testing vs Sanity Testing
  •    User Testing
  • Unit testing
  •   Intigration testing
  •    Module testing
  •   System testing
  •     UAT

ETL Tool and Testing

  • Data Extract
  • Data Transform
  • Data Load
  • Import Source
  • Import Target
  • Mappings,Maplets/li>
  • Workflows,Worklets
  • Transformations,Functionalities,Rules and Techniques
  • Import and Export
  • Coping and Rules
  • Queries Preparation based on Transformations
  • Importance of ETL Testing
  • Creating of Mappings,Sessions,Workflows
  • Running of Mappings,Sessions,Workflows
  • Analyzing of Mappings,Sessions,Workflows
  • Tasks and Types

Practice:

  • Testing scenarios, creation of test cases and scripts
  • Test case execution and defect tracking and reporting
  • Preparation of Test data
  • Practice ETL Testing with Real Time Scenarios and FAQ’s

BOOK YOUR COURSE

ADDRESS

Sgraph Infotech
3rd Floor, JP Royale- 90/4,
Above ICICI Bank, Outer Ring Road,
Opposite Park Plaza, Marathahalli
Bengaluru, Karnataka - 560037.
Mobile: +91-9620885025/8049570931
E-mail: sgraphinfotech@gmail.com

OUR TRAINING COURSES

Best Android Training in Marathahalli Bangalore

Best .Net Training in Bangalore

Best Oracle SQL Training Institutes in Bangalore

Best PLSQL Training Centers in Bangalore

Best Big Data and Hadoop Training Courses in Bangalore

Best MSBI Training Institutes in Bangalore

Best Microsoft Power BI Training Bangalore

Best Oracle DBA Training at Bangalore

CONTACT FORM

© 2016 | All rights reserved |Developed By Nexevo Technologies | Sitemap