SQL Guide

1. CREATE

CREATE TABLE employee (id int NOT NULL PRIMARY KEY, name varchar(255) NOT NULL, email varchar(255), gender varchar(255), designation varchar(255));

2. INSERT

INSERT INTO employee (id, name, email, gender, designation) VALUES (1, 'Alice', 'alice@xyz.com', 'M', 'Software Developer'), (2, 'John', 'john@xyz.com', 'M', 'Software Manager'), (3, 'Ajay', 'ajay@xyz.com', 'M', 'Software Developer'), (4, 'Polina', 'polina@xyz.com', 'F', 'Sales Manager'), (5, 'Henry', 'henry@xyz.com', 'M', 'Senior Software Manager');

3. READ

SELECT * FROM employee WHERE designation = 'Software Developer';

4. UPDATE

UPDATE employee SET designation = 'Senior Software Developer' WHERE id = 1;

5. FIND ONE

SELECT * FROM employee WHERE id = 1;

6. DELETE

DELETE FROM employee WHERE id = 3;

7. VERIFY

SELECT * FROM employee;