12.1. Why SQL Matters in QA

Try these first

1. 1.

   What SQL command is used to retrieve data?

   Hint

   Think about what command helps you see data.

2. 2.

   What does the WHERE clause do?

   Hint

   It narrows down the selection of data.

3. 3.

   What command would you use to retrieve records from a SQL database?

   • DELETE
   • SELECT
   • UPDATE

   Hint

   This is the first step to getting information from a database.

4. 4.

   True or False: The WHERE clause can filter records based on specified conditions.

   • True
   • False

   Hint

   Think about how you narrow down results in a query.

5. 5.

   You need to ensure that all users with the same email in the database are unique. Write an SQL query to find duplicates based on email.

   Hint

   You are looking to count entries grouped by email.

6. 6.

   Write a test case scenario using SQL to validate that the total amount in orders matches the sum of items for multiple orders.

   Hint

   Think about how you can aggregate item prices grouped by orders.