6. INSERT

The INSERT statement is used to add new records to a table.

Example:

INSERT INTO Customers (CustomerName, ContactEmail)
VALUES ('New Customer', 'new@example.com');

This query inserts a new customer into the "Customers" table.

7. UPDATE

The UPDATE statement is used to modify existing records in a table.

Example:

UPDATE Employees
SET Salary = Salary * 1.1
WHERE Department = 'Sales';

This query increases the salary of employees in the "Sales" department by 10%.

8. DELETE

The DELETE statement is used to remove records from a table.

Example:

DELETE FROM Orders
WHERE OrderDate < '2023-01-01';

This query deletes orders placed before January 1, 2023.

Conclusion

With these types of queries, you can perform a wide range of operations on your database. Whether you're retrieving specific data, analyzing trends, or making changes to the records, SQL provides the tools you need to work with databases effectively.

Remember to practice writing and executing different queries to become more comfortable with SQL. The more you practice, the more confident you'll become in managing and querying databases!