Data connectivity one major requirement for test engineers to test along with data correctness. And this can be made possible if you have right set of Database Utilities in your automation framework which can be extended as per your data testing needs.
In this post, We are sharing common Database Utilities which can be used in live projects and also same can be used while solving coding exercises as given by overseas employers to test coding skills of Automation QAs.
Exercise 1:
Write method to Get all data from table in vector format
Exercise 2:
Write method to Get list of all available tables in database
Exercise 3:
Write method to Get list of column names for particular table
Exercise 4:
Write method to Get Column List for all available tables from data base
Exercise 5:
Write method to Establish Connection for given username and password
Exercise 6:
Write method to Execute database query for given username and password
Exercise 7:
Write method to Execute Update Query for given username and password
Exercise 8:
Write method to Execute Procedure Call for given username and password
Building better QA for tomorrow