We may earn an affiliate commission when you visit our partners.
Course image
Saurabh Dhingra

Selenium is one of the most famous UI test automation tool which works well with the TestNG testing framework.

Read more

Selenium is one of the most famous UI test automation tool which works well with the TestNG testing framework.

Data-Driven testing is test design and execution strategy where test data is external to your functional tests. One of the ways is to keep the test data in external files like Excel sheets.

The library used to read data from the excel sheet is POI from Apache

In this two hours guided project, through hands-on, practical experience, you will go through concepts writing reusable and structure code, writing utilities to read test data from an external source like Excel sheets, and derive test cases through these test data.

Enroll now

Two deals to help you save

What's inside

Syllabus

Project Overview
Selenium is one of the most famous UI test automation tool which works well with the TestNG testing framework. Data-Driven testing is test design and execution strategy where test data is external to your functional tests. One of the ways is to keep the test data in external files like Excel sheets. The library used to read data from the excel sheet is POI from Apache In this two hours guided project, through hands-on, practical experience, you will go through concepts writing reusable and structure code, writing utilities to read test data from an external source like Excel sheets, and derive test cases through these test data.

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Emphasizes the usefulness and widespread adoption of Selenium for UI test automation in the industry
Introduces Data-Driven testing, a popular strategy for managing test data externally, increasing efficiency
Incorporates practical exercises and hands-on experience to reinforce concepts and enhance learning retention
Utilizes POI library from Apache, a respected and widely used tool for reading data from Excel sheets in Java, ensuring compatibility and industry relevance
Focuses on developing reusable and structured code, promoting maintainability and adherence to best practices

Save this course

Save Data-Driven Testing (via spreadsheet) with Selenium & TestNG to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Data-Driven Testing (via spreadsheet) with Selenium & TestNG with these activities:
Review Selenium basics
Review basic concepts of Selenium to ensure a strong foundation for learning UI test automation in this course.
Browse courses on Selenium
Show steps
  • Revisit Selenium documentation
  • Practice writing basic Selenium scripts
Selenium + TestNG tutorials
Follow tutorials that provide step-by-step guidance on integrating Selenium and TestNG for effective UI test automation.
Browse courses on Selenium
Show steps
  • Find comprehensive tutorials on Selenium + TestNG
  • Follow the tutorials to set up and execute UI tests
POI exercises
Enhance your familiarity with the Apache POI library by completing exercises that cover reading and writing Excel data.
Show steps
  • Read data from an Excel spreadsheet using POI
  • Write data to an Excel spreadsheet using POI
Five other activities
Expand to see all activities and additional details
Show all eight activities
TestNG exercises
Complete a series of exercises and challenges to enhance your understanding and proficiency in using TestNG for unit testing.
Browse courses on TestNG
Show steps
  • Solve TestNG practice problems
  • Create a TestNG test suite
Develop a data-driven testing utility
Create a utility to read and utilize test data from external sources, such as Excel spreadsheets, to improve the efficiency and flexibility of your test automation scripts.
Browse courses on Data-Driven Testing
Show steps
  • Design the utility's architecture
  • Implement the utility's functionality
  • Test the utility thoroughly
Pair programming with a classmate
Collaborate with a peer to work on a UI test automation project, providingお互い mutual support and learning from each other's perspectives.
Show steps
  • Find a suitable classmate to pair with
  • Plan the project and divide responsibilities
  • Work together to develop and execute test cases
Participate in a coding challenge
Apply your UI test automation skills in a competitive environment, gaining valuable experience and pushing the limits of your abilities.
Show steps
  • Find a relevant coding challenge or competition
  • Prepare for the challenge by practicing and refining your skills
  • Participate in the challenge and give your best effort
Contribute to a Selenium project
Become an active contributor to the Selenium open-source community, gaining practical experience and enhancing your understanding of UI test automation.
Show steps
  • Find a suitable Selenium project to contribute to
  • Review the project documentation and codebase
  • Identify a specific area to contribute to
  • Submit a pull request with your contribution

Career center

Learners who complete Data-Driven Testing (via spreadsheet) with Selenium & TestNG will develop knowledge and skills that may be useful to these careers:
Software Development Engineer in Test
A Software Development Engineer in Test (SDET) is responsible for designing, developing, and executing automated tests for software applications. This course provides a strong foundation for SDETs by teaching them how to use Selenium and TestNG to write reusable and structured code, as well as how to read test data from external sources like Excel sheets. These skills are essential for SDETs to be able to efficiently and effectively test software applications.
Test Automation Engineer
A Test Automation Engineer is responsible for designing, developing, and executing automated tests for software applications. This course provides Test Automation Engineers with the skills they need to write reusable and structured code, as well as how to read test data from external sources like Excel sheets. These skills are essential for Test Automation Engineers to be able to efficiently and effectively test software applications.
Quality Assurance Analyst
A Quality Assurance (QA) Analyst is responsible for ensuring that software applications meet quality standards. This course provides QA Analysts with the skills they need to write automated tests and read test data from external sources, which are essential for testing software applications effectively.
Security Tester
A Security Tester is responsible for testing the security of software applications. This course provides Security Testers with the skills they need to write automated tests and read test data from external sources, which are essential for testing the security of software applications effectively.
Software Tester
A Software Tester is responsible for testing software applications to identify defects. This course provides Software Testers with the skills they need to write automated tests and read test data from external sources, which are essential for testing software applications effectively.
Performance Tester
A Performance Tester is responsible for testing the performance of software applications. This course provides Performance Testers with the skills they need to write automated tests and read test data from external sources, which are essential for testing the performance of software applications effectively.
Data Analyst
A Data Analyst is responsible for analyzing data to identify trends and patterns. This course provides Data Analysts with the skills they need to read test data from external sources, such as Excel sheets, which is essential for data analysis.
Business Analyst
A Business Analyst is responsible for analyzing business requirements and developing solutions. This course provides Business Analysts with the skills they need to write reusable and structured code, as well as how to read test data from external sources like Excel sheets. These skills are essential for Business Analysts to be able to effectively analyze business requirements and develop solutions.
Technical Writer
A Technical Writer is responsible for writing technical documentation. This course provides Technical Writers with the skills they need to write reusable and structured code, as well as how to read test data from external sources like Excel sheets. These skills are essential for Technical Writers to be able to effectively write technical documentation.
Product Manager
A Product Manager is responsible for developing and managing products. This course provides Product Managers with the skills they need to write reusable and structured code, as well as how to read test data from external sources like Excel sheets. These skills are essential for Product Managers to be able to effectively develop and manage products.
Project Manager
A Project Manager is responsible for planning, executing, and closing projects. This course provides Project Managers with the skills they need to write reusable and structured code, as well as how to read test data from external sources like Excel sheets. These skills are essential for Project Managers to be able to effectively plan, execute, and close projects.
Software Architect
A Software Architect is responsible for designing and developing software architectures. This course provides Software Architects with the skills they need to write reusable and structured code, as well as how to read test data from external sources like Excel sheets. These skills are essential for Software Architects to be able to effectively design and develop software architectures.
Machine Learning Engineer
A Machine Learning Engineer is responsible for developing and deploying machine learning models. This course provides Machine Learning Engineers with the skills they need to read test data from external sources, such as Excel sheets, which is essential for developing and deploying machine learning models.
Data Scientist
A Data Scientist is responsible for developing and applying statistical and machine learning models to data. This course provides Data Scientists with the skills they need to read test data from external sources, such as Excel sheets, which is essential for data analysis.
DevOps Engineer
A DevOps Engineer is responsible for bridging the gap between development and operations. This course provides DevOps Engineers with the skills they need to write reusable and structured code, as well as how to read test data from external sources like Excel sheets. These skills are essential for DevOps Engineers to be able to effectively bridge the gap between development and operations.

Reading list

We've selected seven books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Data-Driven Testing (via spreadsheet) with Selenium & TestNG.
Provides a comprehensive guide to clean code, covering topics such as naming conventions, coding style, and modularity. It also includes practical examples and hands-on exercises to help you master these concepts.
Provides a comprehensive guide to effective Java programming, covering topics such as object-oriented design, generics, collections, and concurrency. It also includes practical examples and hands-on exercises to help you master these concepts.
Provides a collection of practical recipes for Java developers, covering topics such as strings, collections, I/O, networking, and concurrency. It also includes tips and tricks to help you write more efficient and effective Java code.
Provides a comprehensive guide to TestNG, covering topics such as annotations, listeners, data providers, and parallel testing. It also includes practical examples and hands-on exercises to help you master these concepts.
Provides a comprehensive guide to concurrency in Java, covering topics such as threads, synchronization, locks, and thread pools. It also includes practical examples and hands-on exercises to help you master these concepts.
Provides a beginner-friendly introduction to Java, covering topics such as variables, operators, control flow, and object-oriented programming. It also includes practical examples and hands-on exercises to help you get started with Java.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Data-Driven Testing (via spreadsheet) with Selenium & TestNG.
Data-Driven Testing (via spreadsheet) with Selenium &...
Most relevant
Data-Driven Testing (via Database) with Selenium & Nunit
Most relevant
Data-Driven Testing (via Database) with Selenium & TestNG
Most relevant
Building Test Automation Framework - Selenium, C# & NUnit
Most relevant
Automated Tests in Java with Fluent Interface Using...
Most relevant
Learn to Code for Data Analysis
Most relevant
Building Test Automation Framework using Selenium and...
Basic Manual Software Testing +Agile+Bugzilla for...
Hands-On with Kubernetes Admission Controllers
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser