Wednesday, January 30, 2013

ETL Testing Online Training Course Content


We need to aware of below topics

Oracle Basics & Concepts
1. DBMS
2. RDBMS
3. DBMS vs RDBMS
4. Why Database Required
5. Different types of databases and difference
6. ASCII vs UNICODE
7. PL/SQL Basics
8. Oracle Architecture
9. Diff B/W Database & Files
10. OLTP
11. OLAP, ROLAP, MOLAP
12. METADATA
13. DDL,DML,DCL
14. BASIC ADMIN ACTIVITIES
15. DATATYPES
16. TABLES
17. SQL ,SUB QUERIES,CORELATED SUB QUERY
18. INNER QUERY,OUTER QUERY
19. FUNCTIONS AND TYPES AND IMPORTANCE
20. JOINS AND DIFFERENT TYPES
21. VIEWS n MATERIALIZED VIEWS
22. INDEX
23. CONSTRAINTS
24. REFERENTIAL INTEGRITY
25. PARTITIONING
26. PERFORMANCE TUNING
27. DIFFERENT TYPES OF TECHNIQES
28. DATABASE SCHEMA

DWH Concepts
1. WHAT IS DWH ?WHY WE REQUIRE THAT ?
2. DWH ARCHITECTURE
3. DATA MART and TYPES
4. DM vs DWH
5. DATA CLEANZING
6. DATA SCRUBING
7. DATA MASKING
8. NORMALIZATION
9. ODS
10. STG AREA
11. DSS

ETL Testing Course Contents

12. Diff B/w OLTP vs ODS,OLAP vs DSS
13. DIMENTION MODELING
14. DIMENSIONS
15. FACTS
16. AGGREGATES
17. DWH SCHEMA designing
18. STAR SCHEMA,SNOWFLAKE SCHEMA,GALAXY SCHEMA,FCS
19. SLOWLY CHANGING DIMENSIONS
20. SCD TYPE1,TYPE2,TYPE3
21. INITIAL LOAD
22. INCREMENTAL LOAD
23. FULL LOAD
24. CDC- change data capture
25. FAQ’S

ETL Testing Concepts
1. Introduction of ETL-Extract,Transform,Load
2. ETL TOOLS and Diff Types of ETL Tools
3. ETL ARCHITECTURE
4. ETL TESTING AND WHY WE REQUIRE
5. DIFFERENT ETL TOOLS ARCHITECTURES
6. SDLC and Methods/Models
7. STLC and Methods/Models
8. SDLC vs STLC
9. Reverse Engineering
10. QC(Quality Center and BugZilla)
11. Roles and Responsibilities
12. Minus,Duplicate,Count,Intersection,etc…
13. Detect Defects
14. Defects Logging and Reporting
15. How to prepare Queries very quickly with the help of mapping
16. Performance Tuning and Performance Testing,Report Testing,UI Testing
17. Quality and different standards that tester should follow,Why?
18. Testplan Preparation
19. Testcases Preparation
20. Preparation of Test data
21. Process Of ETL Testing

Testing Concepts
1. Whitebox Testing
2. Blackbox Testing
3. Gray Box Testing
4. Regression Testing
5. Smoke Testing vs Sanity Testing
6. User Testing
7. Unit testing
8. Intigration testing
9. Module testing
10. System testing
11. UAT

ETL Tool and Testing

1. Data Extract
2. Data Transform
3. Data Load
4. Import Source
5. Import Target
6. Mappings,Maplets
7. Workflows,Worklets
8. Transformations,Functionalities,Rules and Techniques
9. Import and Export
10. Coping and Rules
11. Queries Preparation based on Transformations
12. Importance of ETL Testing
13. Creating of Mappings,Sessions,Workflows
14. Running of Mappings,Sessions,Workflows
15. Analyzing of Mappings,Sessions,Workflows
16. 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

Check the below link

The best Online Training for ETL Testing is as follows

 Call:  Sandeep Manem
          +91-8237320101
          +91-9885320101
Trained around 100+ students and placed around 90+ in Top MNC's with 90% success rate.


8 comments:

  1. ETL testing and data stores is a superb method to handle the huge data groups existing within an organization. This article will allow you to discover more information regarding both these phrases.
    You most likely found out about datawarehouses & research instruments previously in database relevant discussions or in career meetings. The truth is that everyday more and more corporations are beginning to think (and develop) data warehouses or other data analysis and mathematical methods smartmind online training provides best online training for Etl testing. http://smartmindonlinetraining.com/etl-testing-online-training/

    ReplyDelete
  2. ETL Testing online training This program is appropriate for the skilled manual testers or Fresher’s with GAP UN agency area unit longing for break/faster job amendment in ETL Testing that is that the most difficult testing ability, UN agency wish to shift/upgrade to ETL testing from manual, automation testing, mainframe testing, those who wish to upgrade their data in data ware housing testing , those who got knowledge warehousing or data integration comes in their company and wish Training/experience to begin acting on them ASAP as skilled Smart mind Online Training ETL Testing online training.
    ETL Testing online training

    ReplyDelete
  3. Just found your post by searching on the Google, I am Impressed and Learned Lot of new thing from your post. I am new to blogging and always try to learn new skill as I believe that blogging is the full time job for learning new things day by day.
    "Emergers Technologies"

    ReplyDelete
  4. Somebody necessarily help to make severely posts I might state. This is the first time I frequented your website page and to this point? I surprised with the research you made to create this particular post extraordinary. Well done admin..
    Pega Training in Chennai

    ReplyDelete
  5. This comment has been removed by the author.

    ReplyDelete
  6. When I initially commented, I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get several emails with the same comment. Is there any way you can remove people from that service? Thanks.
    Amazon Web Services Training in OMR , Chennai | Best AWS Training in OMR,Chennai
    Amazon Web Services Training in Tambaram, Chennai|Best AWS Training in Tambaram, Chennai

    ReplyDelete
  7. The ETL testing training will help candidates become proficient in handling the ETL testing tool with ease. This course is good for both beginners and experts and will help candidates learn about things such as data warehousing, OLAP, OLTP, deployment of SQL and business intelligence. There are several institutes which provide ETL Testing Training in Bangalore.

    ReplyDelete
  8. A little grouping of execs are capable of you manually because of they’re absolute to offer the standard services. So, if you face any issue with your package you don’t need to go anywhere except us. You merely need to build an easy charge less call on our QuickBooks Support Phone Number variety and rest leave on united states of america country. Without doubt, here you'll find the unmatchable services by our supportive technical workers.

    ReplyDelete

Note: Only a member of this blog may post a comment.