What is SQL query testing?

Question

SQL

I am doing an internship in one company and they gave me the task of testing sql queries. Testing is a new beast for me, and with all the questions, of course, was sent to Google. After digging into it, I came to the conclusion that testing sql queries is simply entering queries and checking for errors in the results of these same queries. But it seems to me that not everything is so simple and I'm missing something. I would appreciate any link or hint. Thank you in advance.

Answer 1

I would first read about the miracle EXPLAIN command

Answer 2

In SSMS, press the "Parse" button - the request text will be checked.
The "Debug" button will take you into the wonderful world of a programmer who can read a query plan.