Write a SQL query to increase the salaries of employees in the 'Engineering' department by 5000.

To increase the salaries of employees in the 'Engineering' department by 5000, you will use an UPDATE statement.

Step 1: Write the UPDATE query.
This query will update the Salary column in the Employee table, adding 5000 to the current salary for all employees where the Department is 'Engineering'.

UPDATE Employee
SET Salary = Salary + 5000
WHERE Department = 'Engineering';

• UPDATE Employee: Specifies that you are modifying the Employee table.
• SET Salary = Salary + 5000: Increases the value in the Salary column by 5000.
• WHERE Department = 'Engineering': Filters the update to only apply to rows where the Department column has the value 'Engineering'.