Write basic SQL queries.

Question

Accepted Answer

Basic SQL queries are essential for data retrieval and manipulation in databases, crucial for quality analysis.

SELECT statement: Retrieves data from a database. Example: SELECT * FROM employees;
WHERE clause: Filters records based on conditions. Example: SELECT * FROM employees WHERE department = 'Sales';
JOIN operation: Combines rows from two or more tables based on a related column. Example: SELECT employees.name, departments.name FROM employees JOIN departments ON employees.department_id = departments.id;
INSERT statement: Adds new records to a table. Example: INSERT INTO employees (name, department) VALUES ('John Doe', 'HR');
UPDATE statement: Modifies existing records. Example: UPDATE employees SET department = 'Marketing' WHERE name = 'John Doe';
DELETE statement: Removes records from a table. Example: DELETE FROM employees WHERE name = 'John Doe';

Interview Questions Asked to Senior Quality Analyst at Other Companies