ETL and Report Testing Online Training certfication in USA|India|UK

1
ETL and Report testing ONLINE TRAINING
2
ETL and Report testing

• SUDEEP Technologies is one of the leading
  Training Company involved in providing ETL AND
  REPORT TESTING ONLINE TRAINING. Our Trainers are
  expert in providing Online Training with real
  time experience.

3

• OUR ETL and report testing
• Data Warehousing concepts
• DBMS and RDBMS
• What is Data Warehousing and necessity of it?
• Data warehousing architecture
• OLAP,ROLAP, MOLAP
• Data mining
• Meta data
• Tables, views
• Constraints

4

• Fact and Dimensional Tables
• Partitioning of tables
• Concepts of Referential Integrity
• Concepts of Modelling
• Database Schema
• Concepts of normalization
• Concepts of Slowly Changing Dimensions
• Concepts of Data MartFull and Incremental
  extraction Process
• Change Data capture

5

• SQL Concepts
• DDL, DML commands
• All the basic functions (Character Functions,
• Conversion Functions, Advanced functions,
  Mathematical Functions and Date Functions)
• Joins
• Practice SQLs for some sample test scenarios

6

• ETL testing
• What is ETL and importance of ETL testing??
• Creating, running and analysing
  sessions/workflows in Informatica
• Preparation of Test strategy, Test plan and
  estimations
• Testing scenarios, creation of test cases and
  scripts
• Test case execution and defect tracking and
  reporting

7

• Report Testing
• Validation of the report data with DB and UI
  testing
• Preparation of Test data
• Levels of testing
• Unit testing
• Integration testing
• Module testing
• System testing
• Uat
• Practice sessions on ETL Testing

8

• Ph 9700024555
• Address 74-15-4, 3rd Floor, Swarna plaza, Auto
  Nagar, Terminal, krishna Nagar, vijayawada-520007
• Website URL
• http//www.sudeeptechnologies.com/courses/software
  -testing/etl-and-report-testing-online-training/11
  7

9
THANK YOU