Write a query to insert a new employee into the "employees" table with employee_id = 103, employee_name = "John Smith", and department_id = 2.
Slide 12 - Open question
A GDPR request has come through. You've been asked to delete a customer and all related data related to, Sarah Mcdonalds, smaccies@beeffarmer.com from your users table.
Slide 13 - Open question
SQL DROP
DROP is DELETE for database objects instead of records. You can remove; tables, views, indexes or even the whole database:
Keywords; DROP, TABLE, VIEW, INDEX, DATABASE.
Syntax:
DROP TABLE users;
DROP DATABASE school_database;
Slide 14 - Slide
JOIN (INNER JOIN)
JOIN combines rows from two or more tables with a related column.
Syntax:
SELECT columns
FROM table1
INNER JOIN table2 on table1.column = table2.column;