Testing Training (ETL, Selenium, Software, Hadoop) - Combo Course

Testing History, Testing description, Need for testing, Defect description, principles of Testing, Quality Assurance and control, Scope, Occurrence of Testing, Constraints of Testing, Software Tester Roles, SDLC Overview, Life Cycle models, STLC Overview, AGILE Testing

Test Strategy and Planning, Customizing Test Process, Budgeting Overview, Scheduling, Risk and configuration managementHands-on Exercise – Make planning to test a product and define test strategy for the same, Plan a dummy budget allocation

Test Scenarios, cases and Data, Test Case and Scenario Difference, Test Case creation for application, Traceability Matrix and Sample descriptionHands-on Exercise – Create Test Cases for an application, Create Traceability Matrix, Perform sample testing

Dynamic Techniques:

Black-box or Specification-based techniques, Boundary Value Analysis, Decision Table Testing, Equivalence Partitioning

Experience-based techniques:

Error Guessing, Exploratory Testing

Static Techniques:

Importance of STLC reviews, Review Activities, Roles and Responsibilities during ReviewHands-on Exercise – Do a Black-box or Specification-based testing, Perform Boundary Value Analysis, Test using Decision Table, Make a team of at least two people and do Review Activities of STLC

Levels of Testing:

Unit Testing, Integration Testing, System Testing, User Acceptance Testing

Types of Testing:

Regression Testing, Smoke Testing, Database Testing, Load Testing, Performance Testing, Compatibility Testing, Security Testing, Volume Testing, Stress Testing, Usability testing, Internationalization Testing, Localization TestingHands-on Exercise – Perform User Acceptance Testing based on requirements spec

Overview on Build and Release, Release Notes, Pre QA Checklist, Entry and Exit criteria, Test Execution, Hands onHands-on Exercise – Write a typical Release Note, Make a QA Checklist

Defect Prevention, Defect Discovery, Defect Life Cycle, Severity and Priority, Overview on RCA, Hands on Identify and log Defects, Bugzilla Tool – Hands onHands-on Exercise – Identify log Defects, Use Bugzilla Tool to log a defect and apply different stages of a bug (open, fixed, close etc)

Test Status Reports, Test Closure Reports, Tester and Developer, Team Collaboration, Client Interaction, Onshore/Offshore Model, Mitigate current challengesHands-on Exercise – Write Test Status Report, Write a Test Closure Report

Overview on Metrics & Measurements, Test Metrics Benefits, Life Cycle of Metrics, Test Metrics typesHands-on Exercise – Write Test Metrics

Need for Automation, Overview of Different Automation Tools – QTP and Selenium, Quality Center Overview, FAQsHands-on Exercise – Use an Automation Tool (QTP or Selenium or Quality Center)

Introduction to Hadoop and its constituent ecosystem, understanding MapReduce and HDFS,

Big Data, Factors constituting Big Data, Hadoop and Hadoop Ecosystem, Map Reduce -Concepts of Map, Reduce, Ordering, Concurrency, Shuffle, Reducing, Concurrency, Hadoop Distributed File System (HDFS) Concepts and its Importance, Deep Dive in Map Reduce – Execution Framework, Partitioner, Combiner, Data Types, Key pairs, HDFS Deep Dive – Architecture, Data Replication, Name Node, Data Node, Data Flow, Parallel Copying with DISTCP, Hadoop Archives

Installing Hadoop in Pseudo Distributed Mode, Understanding Important configuration files, their Properties and Demon Threads, Accessing HDFS from Command Line, Map Reduce – Basic Exercises, Understanding Hadoop Eco-system, Introduction to Sqoop, use cases and Installation, Introduction to Hive, use cases and Installation, Introduction to Pig, use cases and Installation, Introduction to Oozie, use cases and Installation, Introduction to Flume, use cases and Installation, Introduction to Yarn, Mini Project – Importing Mysql Data using Sqoop and Querying it using Hive

How to develop Map Reduce Application, writing unit test, Best Practices for developing and writing, Debugging Map Reduce applications

What Is Pig?, Pig’s Features, Pig Use Cases, Interacting with Pig, Basic Data Analysis with Pig, Pig Latin Syntax, Loading Data, Simple Data Types, Field Definitions, Data Output, Viewing the Schema, Filtering and Sorting Data, Commonly-Used Functions, Hands-On Exercise: Using Pig for ETL Processing

What Is Hive?, Hive Schema and Data Storage, Comparing Hive to Traditional Databases, Hive vs. Pig, Hive Use Cases, Interacting with Hive, Relational Data Analysis with Hive, Hive Databases and Tables, Basic HiveQL Syntax, Data Types, Joining Data Sets, Common Built-in Functions, Hands-On Exercise: Running Hive Queries on the Shell, Scripts, and Hue

Why Hadoop testing is important, Unit testing, Integration testing, Performance testing, Diagnostics, Nightly QA test, Benchmark and end to end tests, Functional testing, Release certification testing, Security testing, Scalability Testing, Commissioning and Decommissioning of Data Nodes Testing, Reliability testing, Release testing

Understanding the Requirement, preparation of the Testing Estimation, Test Cases, Test Data, Test bed creation, Test Execution, Defect Reporting, Defect Retest, Daily Status report delivery, Test completion., ETL testing at every stage (HDFS, HIVE, HBASE) while loading the input (logs/files/records etc) using sqoop/flume which includes but not limited to data verification, Reconciliation., User Authorization and Authentication testing (Groups, Users, Privileges etc), Report defects to the development team or manager and driving them to closure., Consolidate all the defects and create defect reports., Validating new feature and issues in Core Hadoop.

Report defects to the development team or manager and driving them to closure, Consolidate all the defects and create defect reports, Validating new feature and issues in Core Hadoop, Responsible for creating a testing Framework called MR Unit for testing of MapReduce programs.

Automation testing using the OOZIE, Data validation using the query surge tool.

Test plan for HDFS upgrade, Test automation and result

How to test install and configure.