Based on the test cases written for the module, we have to cover the UI testing,
Whichever modules we are testing, our main focus should be on database.

1) What are tables affected?

2) From where the data is being retrieved and displayed on the UI and is it correct?

3) Above all we should know how to connect to the database? ability to write simple queries to retrieve data and manipulate the data using DML operations. Functional flow should be very well known!

4) Good knowledge on table level, column level constraints, ability to understand and execute complex queries related to joins is added advantage.