There are iii mind aspect of whatsoever dynamics website, cloud base of operations applications too those are backend code, UI too the database. So what nosotros code at backend volition define forepart terminate which is UI, too what nosotros or user position inwards the UI fields goes to the database.
Main departure betwixt the UI Testing, Backend Code Testing too the Data Base Testing are shown below.
Backend Testing: Here to perform the backend testing, tester should know the code too how it work. Here tester volition come across all the code too stimulate to honour out whatsoever defect within the code. Tester who performs backend testing is called every bit White Box Tester.
UI: The forepart terminate of the application which is viewable for the terminate user, hither what tester request to essay are the things similar buttons, colors, text alignments, links, images, layout, navigations etc. are the occupation of UI testing.
Database Testing: similar in that place are forms where user insert his details hence this exceptional request to endure stored somewhere. That is stored inwards database. All the information is stored inwards database. Database is real of import thing. And it request to endure ensure that information base of operations should endure designed too working properly. Database Tester request to essay next affair spell performing database testing.
- Database Structure: each champaign of form has its ain row to shop the data. For example, suppose in that place is a form called research form which has fields similar name, number, e-mail id, too description, hence database should endure designed similar in that place should endure a tabular array inwards database whose cite should endure research tabular array too inwards that tabular array in that place should endure ane split upwards column for each champaign similar ane column for cite field, mo column for mobile release filed similar this nosotros request to brand column for every field. So this is the tester responsibleness that each too every champaign has its house inwards tables. And in that place should endure a tabular array for well-nigh of the form too every input that nosotros receive got from the terminate user on form should larn stored inwards database properly. And in that place is non whatsoever missing database or whatsoever missing column or whatsoever missing tables.
- Data: to a greater extent than or less fourth dimension in that place is possibility that information does non larn stored database, for trial lets say terminate user is filling the research form on our software too it submitted the form past times clicking on the salve push too software shown too a message similar your research stored successfully but if nosotros click the information base of operations in that place is non whatsoever entry acquaint of that research which user simply filled. So it is request to endure ensured that information are properly getting stored inwards the data.
- Another scenarios is when user desire to update his research or whatsoever information too hence user volition click on the edit push too hence brand necessary modify too salve the form too hence if nosotros banking concern fit the information base of operations in that place is possibilities similar novel updated information is non updated inwards database or it mightiness practice a novel entry for updating. This are the possibilities that tin come, testers request to regard this possibilities too should, too should essay the software past times considering this possibilities.
- Another things similar indexing inwards database which helpful for retrieving information from the database fast. When you lot search anything on software too hence search that searched give-and-take inwards database too suppose in that place is huge information is database without indexing too hence it volition receive got lots of time. But if in that place is proper indexing done inwards database too hence it volition receive got less fourth dimension to demonstrate the result. Tester likewise request to aspect for such a things spell performing the database testing.
- Triggers: triggers are the codes which should larn executed afterwards exceptional trial happens. This working of trigger request to endure banking concern fit properly, all the triggers are working properly or not, the fourth dimension of execution or the sequence of the executions are right or non this affair request to endure tested. There are other things similar stored procedures which is likewise request to endure tested whether those all are working every bit per the expectation or not.
- This is brusk article on how nosotros tin source our database testing too what things request to endure tested inwards database.