We may earn an affiliate commission when you visit our partners.
Saurabh Dhingra
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
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
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/l51jhs/data
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
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
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Review Selenium basics
Show steps
Review basic concepts of Selenium to ensure a strong foundation for learning UI test automation in this course.
Browse courses on
Selenium
Show steps
Show steps
Show steps
- Revisit Selenium documentation
- Practice writing basic Selenium scripts
Selenium + TestNG tutorials
Show steps
Follow tutorials that provide step-by-step guidance on integrating Selenium and TestNG for effective UI test automation.
Browse courses on
Selenium
Show steps
Show steps
Show steps
- Find comprehensive tutorials on Selenium + TestNG
- Follow the tutorials to set up and execute UI tests
POI exercises
Show steps
Enhance your familiarity with the Apache POI library by completing exercises that cover reading and writing Excel data.
Show steps
Show steps
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
Show steps
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
Show steps
Show steps
- Solve TestNG practice problems
- Create a TestNG test suite
Develop a data-driven testing utility
Show steps
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
Show steps
Show steps
- Design the utility's architecture
- Implement the utility's functionality
- Test the utility thoroughly
Pair programming with a classmate
Show steps
Collaborate with a peer to work on a UI test automation project, providingお互い mutual support and learning from each other's perspectives.
Show steps
Show steps
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
Show steps
Apply your UI test automation skills in a competitive environment, gaining valuable experience and pushing the limits of your abilities.
Show steps
Show steps
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
Show steps
Become an active contributor to the Selenium open-source community, gaining practical experience and enhancing your understanding of UI test automation.
Show steps
Show steps
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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.
For more career information including salaries, visit:
OpenCourser.com/course/l51jhs/data
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.
Save
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.
Save
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 tips and advice for software developers, covering topics such as productivity, quality, and career development. It also includes practical examples and hands-on exercises to help you master these concepts.
Save
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.
Save
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.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/l51jhs/data
Share
Similar courses
Here are nine courses similar to
Data-Driven Testing (via spreadsheet) with Selenium & TestNG.
Data-Driven Testing (via spreadsheet) with Selenium & Nunit
OpenCourser.com/course/bv8j65/data
Data-Driven Testing (via spreadsheet) with Selenium &...
Most relevant
Data-Driven Testing (via Database) with Selenium & Nunit
OpenCourser.com/course/rdb1ke/data
Data-Driven Testing (via Database) with Selenium & Nunit
Most relevant
Data-Driven Testing (via Database) with Selenium & TestNG
OpenCourser.com/course/tfu07l/data
Data-Driven Testing (via Database) with Selenium & TestNG
Most relevant
Building Test Automation Framework - Selenium, C# & NUnit
OpenCourser.com/course/2vvvxy/building
Building Test Automation Framework - Selenium, C# & NUnit
Most relevant
Automated Tests in Java with Fluent Interface Using WebDriver Selenium
OpenCourser.com/course/0eofo8/automated
Automated Tests in Java with Fluent Interface Using...
Most relevant
Learn to Code for Data Analysis
OpenCourser.com/course/ky4o9w/learn
Learn to Code for Data Analysis
Most relevant
Building Test Automation Framework using Selenium and TestNG
OpenCourser.com/course/9al1pk/building
Building Test Automation Framework using Selenium and...
Basic Manual Software Testing +Agile+Bugzilla for beginners
OpenCourser.com/course/wi55om/basic
Basic Manual Software Testing +Agile+Bugzilla for...
Hands-On with Kubernetes Admission Controllers
OpenCourser.com/course/eox3sm/hands
Hands-On with Kubernetes Admission Controllers
Effort
2 hours
Level
Intermediate
Via
Coursera
Institution
Coursera Project Network
Instructor
Saurabh Dhingra
Language
English
Good to know
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
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