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

BY
Intellipaat

Get the testing training of ETL, Selenium, software, and Hadoop software and latch onto the desirable job opportunity through the course by Intellipaat.

Mode

Online

Duration

92 Hours

Fees

₹ 27816

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study, Virtual Classroom
Mode of Delivery Video and Text Based

Course overview

ETL, Selenium, Software, and Hadoop are booming technologies that can help professionals to secure desirable job opportunities. The IT sector has evolved a lot and generates multiple opportunities for skilled professionals. The Testing Training (ETL, Selenium, Software, and Hadoop) Combo Course by Intellipaat offers the testing tutoring of these software and tools. The real-life projects of the course shall guide the learner for practical training. The aim of the course is to train the learners in the testing of the software and tools. The course consists of self-paced videos, projects, and assessments. 

Intellipaat has made its name in providing quality education and professional training to learners. The additional features of the platform shall aim for the overall development of the learner. The Testing Training (ETL, Selenium, Software, and Hadoop) Combo Course certification by Intellipaat shall be awarded to the learners after the completion of projects and assessments. The certificate is recognized in multiple MNCs and corporate companies this increases the chances for the learner to secure a job in prominent companies. 

The highlights

  • 100% online course 
  • 92 hours of self-paced videos 
  • 184 hours of project and exercises 
  • Certification 
  • Flexible schedule 
  • Job assistance

Program offerings

  • Online course
  • Self-paced videos
  • Project learning
  • Video demonstration
  • Assessments
  • Certification
  • Job assistance
  • Collaborative learning.

Course and certificate fees

Fees information
₹ 27,816

Intellipaat is the one-stop solution for learners who want to grab an understanding of the concept through online mode from the experts. The platform offers a self-paced learning mode for the learners to enhance knowledge at their convenient place and time. The Testing Training (ETL, Selenium, Software, and Hadoop) Combo Course certification fee shall be paid by the candidate at the time of registration. For the organizations, the platform offers corporate training to upskill their employees. The fee for both of the modes is distinct. Refer to the table below for the detailed fee structure. 

Fee structure for Testing Training (ETL, Selenium, Software, and Hadoop) Combo Course

Course name 

Fee in INR

Testing Training (ETL, Selenium, Software, and Hadoop) Combo Course self-paced training

Rs. 27,816

Testing Training (ETL, Selenium, Software, and Hadoop) Combo Course corporate training

 -

certificate availability

Yes

certificate providing authority

Intellipaat

Who it is for

Testing Training (ETL, Selenium, Software, and Hadoop) Combo Course certification benefits the working people or freshers by guiding them in the testing training of the software and tools. The course aims to provide quality education with the help of industry experts and shall help the candidate in securing a job. The professionals working at the following designations or the beginners who are looking to kick start their career in testing can enroll in the certification course. 

  • Software Developers, 
  • Software Testers, 
  • Data Analysts, Database Engineers,
  • Computer System Administrators, 
  • QA Managers, and Engineers, 
  • Database and Mainframe Professionals,
  • Business Intelligence and ETL Professionals,
  • Beginners looking for a career in software testing. 

Eligibility criteria

Basic knowledge of computers is necessary for the course. Besides this, having an understanding of C, Java programming, SQL or other programming languages shall prove to be advantageous while taking up Testing Training (ETL, Selenium, Software, and Hadoop) Combo Course classes. 

Certification Qualifying Details 

Testing Training (ETL, Selenium, Software, and Hadoop) Combo Course syllabus comprises modules for a clear understanding of each topic. The curriculum also consists of hands-on exercises for testing the acquired knowledge of the learner. Besides this, the projects that are part of the course shall be completed by the learner. In addition to this, after completing the curriculum experts lay emphasis on the soft skills of the learner and prepare them for the interview. After completing the theoretical and practical section of the course, the candidate shall receive Testing Training (ETL, Selenium, Software, and Hadoop) Combo Course certification from Intellipaat. 

What you will learn

Automation skills

This is a combo training course by Intellipaat that provides comprehensive training in Selenium testing, ETL testing, Software Testing, and Hadoop testing. The course has been developed by industry experts, and this is the advantage for the learners to grab the understanding of multiple software and tools through one course. Testing Training (ETL, Selenium, Software, and Hadoop) Combo Course certification by Intellipaat shall help the learner to grab an understanding of the following concepts. 

  • Introduction to software testing and tools
  • ETL testing life cycle and data warehouse workflow
  • ETL, RDBMS, Data Warehousing, and BI
  • Data checks using SQL and scope of BI testing
  • Selenium and Selenium IDE
  • Introduction to automated testing
  • Working with Selenium IDE functions and commands
  • Installing TestNG Plugin in Eclipse
  • Selenium RC, Sikuli and JUnit
  • Testing using Selenium Grid
  • Implement test cases, test scenarios, and test scripts
  • Introduction to Hadoop, HDFS, and MapReduce
  • Different levels and types of Software testing
  • HivePig, Sqoop, Flume, and Oozie

The syllabus

ETL Testing Course Content

ETL Testing Overview
  • Introduction to ETL testing
  • Life cycle of ETL Testing
  • Database concepts
  • ETL in Business Intelligence
  • Understanding the difference between OLTP and OLAP
  • Data warehousing.
ETL Testing Overview: Hands-on Exercise
  • Create OLTP and OLAP database
Database Testing and Data Warehousing Testing
  • Introduction to RDBMS
  • Relational database concepts
  • The distinction between database and data warehousing testing
  • Integrity constraints.
Database Testing and Data Warehousing Testing: Hands-on Exercise
  • How to test data warehousing testing, integrity constraints
ETL Testing Scenarios
  • The data warehouse workflow
  • ETL Testing scenarios
  • ETL Mapping
  • Data Warehouse Testing
  • Data Mismatch & Data Loss Testing.
ETL Testing Scenarios: Hands-on Exercise
  • Create a data warehouse workflow, Create ETL Mapping
Correctness, Completeness, Quality, Data Validation
  • Introduction to various testing scenarios
  • Structure validation
  • Constraint validation
  • Data correctness,
  • Completeness
  • Quality
  • Data validation
  • Negative testing.
Correctness, Completeness, Quality, Data Validation: Hands-on Exercise
  • Create tests as per testing scenarios
  • Validate the structure of the software
  • Do constraint validation
  • Check data correctness and completeness
  • Validate data
  • Perform negative testing
Data Checks with SQL
  • Using SQL for checking data
  • Understanding database structure
  • Working with SQL Scripts
Data Checks with SQL: Hands-on Exercise
  • Write SQL Scripts for checking data
Reports & Cube testing
  • Reports and Cube Testing
  • The scope of Business Intelligence Testing.
Reports & Cube testing:
  • Identify ETL testing Scope-Generate Reports, Test Cubes

Selenium Course Content

Core Java Concepts
  • Introduction to Java Programming
  • Defining Java
  • Need for Java
  • Platform Independent in Java
  • Define JRE, JVM, JDK
  • Important Features and Evolution of Java
Writing Java Programs using Java Principles
  • What is object-oriented programming
  • The concept of: 
    • Abstraction
    • Attributes
    • Methods
    • Constructors
    • Inheritance
    • Encapsulation
    • Polymorphism.
  • Overview of Coding basics
  • Setting up the required environment
  • Knowing the available IDEs
  • Writing a Basic-level Java Program
  • Define Package
  • What is Java Comments?
  • Understanding the concept of Reserved Words
  • Introduction to Java Statements
  • What are Blocks in Java
  • Explain a Class
  • Different Methods
Getting started with Selenium
  • Introduction to Selenium testing
  • The understanding significance of automation testing
  • Benefits of Selenium automation testing
  • Comparison of Selenium and Quick Test Professional
Selenium Features
  • Understanding the Selenium Integrated Development Environment
  • The concept of Selenium Remote Control
  • Working with Selenium Grid
  • Selenium Web Grid
Deep Dive into Selenium IDE
  • Detailed understanding of the Selenium IDE feature
  • The addition of script assertions
  • General Selenese commands
  • Deploying the first Selenium Script and Options
  • IDE Test Suite
  • Sample project IDE
  • Recording Selenium test case
  • Selenium limitations.
Deep Dive into Selenium IDE: Hands-on Exercise
  • Record a test case
  • Execute the First test case
Selenium Web driver Automation
  • The basic Architecture of Selenium Web Driver
  • Download and installation
  • Creating a Java function and executing
Selenium Web driver Automation: Hands-on Exercise
  • Install selenium web driver
Fire Path Installation
  • Deploying Web Drivers for scripting
  • Getting the HTML source of Web Element
  • Table and Form Elements
  • Firebug extension
  • Fire Path installation.
Fire Path Installation: Hands-on Exercise
  • Set up a Grid
Searching Elements
  • Locator
  • Locator-ID
  • Deploying searching elements using the link text, Name, Using XPath
  • searching elements using CSS and Web Element Properties
Searching Elements: Hands-on Exercise
  • Deploy searching elements 
    • using the link text
    • using the name
    • using XPath
  • Search elements using CSS and Web Element Properties
Advance User Interactions and Cross Browser Testing
  • Working with Advanced User Interactions
  • Understanding the various features like Drag and Drop, Double Click, Keys and Context
  • Deploying Cross Browser Testing using Web Driver and Executing tests in Chrome and Firefox.
Advance User Interactions and Cross Browser Testing: Hands-on Exercise
  • Deploy and execute a test case for Chrome
  • Deploy and execute a test case for Firefox
Introduction to TestNG Plugin
  • Installation of TestNG Plugin in Eclipse
  • TestNG sample script
  • Understanding Selenium test script writing
  • TestNG test suites creation
  • HTML and XML report generation using TestNG
Introduction to TestNG Plugin: Hands-on Exercise
  • Install the TestNG plugin in Eclipse
  • Write a TestNG script and execute
  • Generate an HTML report
  • Generate an XML report
TestNG Terminologies
  • Annotations
  • Parameters
  • Groups- 
    • Include and Exclude
    • Test Result
    • Data Providers
TestNG Terminologies: Hands-on Exercise
  • Mark annotation Group test results
TestNg Data Providers
  • TestNg Data Providers
  • Screenshot on failed Test cases
  • Wait for statements of Web Driver
  • Wait in Selenium
  • Explicit wait
  • Implicit wait
  • Fluent wait
  • PageLoad Timeout
TestNg Data Providers: Hands-on Exercise
  • Capture a screenshot on a failed test case Setup wait for the timeout to wait for page load before resuming test execution
Maven Integration
  • Introduction to Maven
  • Maven Usage
  • Configuring Maven with Eclipse
  • Taking automatic updates
  • Running tests in Maven
  • Creating POM.xml file
Maven Integration Tool
  • Maven Integration Tool
Web Driver Sample Programs
  • Learn to work with text box, button, link, checkbox, drop down and radio button
  • Selecting and Displaying Values
  • Write all values in Notepad/Excel/WordPad
  • Capturing screenshots (positive)
  • On Load Alerts
  • Scroll down Page in JavaScript’s
  • HTML Unit driver
  • Managing Multiple Windows and AJAX Auto suggestions
  • Managing Web Tables
Web Driver Sample Programs: Hands-on Exercise
  • Use text box, button, checkbox, drop-down, radio buttons, display views
  • Capture screenshots
  • Manage web tables
JUNIT Operations and Test Framework
  • Annotations in JUNIT
  • Methods in JUNIT
  • JUNIT Test Suites
  • ANT Build and JUNIT reporting
  • Test Framework
  • Data-driven framework
  • Keyword driven framework
  • Hybrid framework
  • Execution of Test case from Test Framework
JUNIT Operations and Test Framework: Hands-on Exercise
  • Load an excel file
  • Execute a test case using a Data-driven framework
  • Execute a test case using Keyword driven framework
Object Repository
  • Understanding of Object Repository
  • Using OR in Scripts
  • Learning sample scripts using object repository
  • Page Object Modeling
  • Page Factory
Object Repository: Hands-on Exercise
  • Using OR in scripts
  • Implement POM
Test Data Management
  • Test Data Management
Test Data Management: Hands-on Exercise
  • Load an excel file
  • Execute a test case using a Data-driven framework
  • Execute a test case using Keyword driven framework
Selenium Grid Concept
  • Selenium Grid Overview
  • Executing the single script in different browsers and different scripts in different browsers
Selenium Grid Concept: Hands-on Exercise
  • Set up a Grid
Mobile App Testing using Appium
  • UI Automator Framework in Appium
  • Locating elements in android app using UI Automator view
  • Automation testing for Android apps
Mobile App Testing using Appium: Hands-on Exercise
  • Write a test case using UI Automator for an Android app
Implementing BDD Framework using Cucumber
  • Use Cucumber to write BDD Acceptance Tests in Selenium.
  • Includes Agile Testing
  • Behaviour Driven Development (BDD)
  • Advantages and Limitations of BDD
  • Cucumber Fundamentals
  • Gherkin Syntax in Cucumber
  • Step Definition for Cucumber Feature File
  • Advantages of Cucumber
  • Implementing BDD Framework using Cucumber.

Software Testing Course Content

Introduction to Software Testing
  • 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 Planning
  • Test Strategy and Planning
  • Customizing Test Process
  • Budgeting Overview
  • Scheduling
  • Risk and configuration management
Test Planning: Hands-on Exercise
  • Make planning to test a product and define a test strategy for the same
  • Plan a dummy budget allocation
Design of Testing
  • Test Scenarios, cases and Data
  • Test Case and Scenario Difference
  • Test Case creation for application
  • Traceability Matrix and Sample description
Design of Testing: Hands-on Exercise
  • Create Test Cases for an application
  • Create a Traceability Matrix
  • Perform sample testing
Techniques of 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 Review
Techniques of testing: Hands-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 & Types of Testing
  • 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 Testing
Levels & Types of Testing: Hands-on Exercise
  • Perform User Acceptance Testing based on requirements spec
Executing test
  • Overview on Build and Release
  • Release Note
  • Pre QA Checklist
  • Entry and Exit criteria
  • Test Execution
  • Hands-on
Executing test: Hands-on Exercise
  • Write a typical Release Note
  • Make a QA Checklist
Managing Defect
  • Defect Prevention
  • Defect Discovery
  • Defect Life Cycle
  • Severity and Priority
  • Overview on RCA
  • Hands-on Identify and log Defects
  • Bugzilla Tool – Hands-on
Managing Defect: Hands-on Exercise
  • Identify log Defects
  • Use Bugzilla Tool to log a defect and apply different stages of a bug (open, fixed, close, etc)
Team Collaboration & Reporting
  • Test Status Reports
  • Test Closure Reports
  • Tester and Developer
  • Team Collaboration
  • Client Interaction
  • Onshore/Offshore Model
  • Mitigate current challenges
Team Collaboration & Reporting: Hands-on Exercise
  • Write Test Status Report
  • Write a Test Closure Report
Measurement & Metrics
  • Overview of Metrics & Measurements
  • Test Metrics Benefits
  • Life Cycle of Metrics
  • Test Metrics types
Measurement & Metrics: Hands-on Exercise
  • Write Test MSoftware Testing Course Contentetrics
Testing Tools & FAQs
  • Need for Automation
  • Overview of Different Automation Tools – QTP and Selenium
  • Quality Center Overview
  • FAQs
Testing Tools & FAQs: Hands-on Exercise
  • Use an Automation Tool (QTP or Selenium or Quality Center)

Hadoop Testing Course Content

Introduction to Hadoop and its Ecosystem, MapReduce and HDFS
  • 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
Hands-on Exercises
  • 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
MapReduce
  • How to develop Map Reduce Application
  • Writing unit test
  • Best Practices for Developing and writing
  • Debugging Map Reduce applications
Introduction to Pig & its features
  • 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
Introduction to Hive
  • 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
Hadoop Stack Integration Testing
  • 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
Roles and Responsibilities of Hadoop Testing
  • Understanding the Requirement
  • Preparation of the Testing Estimation
  • Test Cases
  • Test Data
  • Testbed 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 features and issues in Core Hadoop.
Framework called MR Unit for Testing of MapReduce Programs
  • Report defects to the development team or manager and drive them to closure
  • Consolidate all the defects and create defect reports
  • Validate new features and issues in Core Hadoop
  • and be Responsible for creating a testing Framework called MR Unit for testing of MapReduce programs.
Unit Testing
  • Automation testing using the OOZIE
  • Data validation using the query surge tool
Test Execution of Hadoop _customized
  • Test plan for HDFS upgrade
  • Test automation, and result
Test Plan Strategy Test Cases of Hadoop Testing
  • How to test install and configure.

Admission details

To enroll in the Testing Training (ETL, Selenium, Software, and Hadoop) Combo Course online, follow the steps mentioned below.  

Step 1: Visit the Intellipaat portal or click on the link https://intellipaat.com/testing-training-etl-selenium-software-hadoop/

Step 2: Click on the ‘Enroll Now’ Tab and add the Testing Training (ETL, Selenium, Software, and Hadoop) Combo Course. 

Step 3: Go to the edit cart section and fill in the required details. 

Step 4: Pay the Testing Training (ETL, Selenium, Software, and Hadoop) Combo Course certification fee online mode according to the selected mode of learning.

Step 5: Start learning by attending the Testing Training (ETL, Selenium, Software, and Hadoop) Combo Course classes. 

How it helps

The course of Testing Training (ETL, Selenium, Software, and Hadoop) Combo Course offers multiple benefits to the learners, including practical training, and assessments and thus, helping the candidate to latch onto the opportunity. The growing opportunities in this domain have made this course worthful for the people who want to pursue this domain in their careers. Mentioned below are the benefits that one can avail of from the course. 

  • According to NASSCOM, the global software testing market shall reach 50 billion by 2020. 
  • Selenium is one such testing tool that supports more browsers and languages than any other testing tool. 
  • In the United States, A Software QA Automation Tester can earn $112,000. 
  • The job assistance feature by Intellipaat shall enhance the soft skills of teh learners and help them to crack the interview. In addition to this, the experts shall also build impressive resumes for candidates. 
  • Peer learning is the platform provided by Intellipaat for the interaction between seniors and juniors. Besides this, the information regarding classes, and technical events are also shared through this feature. 
  • The 24*7 support from the mentors shall help the candidates to resolve their queries. 
  • The project on Testing Tube.
  • The project on Automating the various tasks in aciTime.
  • The project on Testing an eCommerce site with selenium using the BDD framework. 
  • The project on the JUnit test case. 
  • The certification shall help the candidate to secure a job position in prominent MNCs. 

FAQs

How many projects are associated with the course?

A total of four projects are associated with the course.

What are the perks of pursuing the course from Intellipaat?

Intellipaat offers multiple benefits like flexible learning, 24*7 support from mentors, peer learning, and job assistance for the candidates. 

What is the prerequisite for the course?

The basic knowledge of computers is necessary for enrolling in the course. However, the understanding of C programming, SQL, and Java programming shall benefit the learner while taking up the classes.

What is the advantage of the peer learning feature by Intellipaat?

The peer learning feature provides the platform to keep the candidates updated about technical events and classes. It also increases the interaction among juniors and seniors. 

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books