Assignment 13 | WEB-110

Learning Summary

Single-Table SELECT Statements

The following SQL statements were used to retrieve data from the CUSTOMERS table:

SELECT * FROM CUSTOMERS;
SELECT FirstName, LastName FROM CUSTOMERS WHERE City = 'Chicago';
SELECT COUNT(*) FROM CUSTOMERS WHERE State = 'IL';
SELECT DISTINCT City FROM CUSTOMERS;
SELECT * FROM CUSTOMERS ORDER BY LastName ASC;

INSERT, UPDATE, and DELETE Statements

The following SQL statements were used to modify data in the CUSTOMERS table:

INSERT INTO CUSTOMERS (FirstName, LastName, City, State) VALUES ('John', 'Doe', 'Springfield', 'IL');
UPDATE CUSTOMERS SET City = 'Naperville' WHERE LastName = 'Smith';
DELETE FROM CUSTOMERS WHERE LastName = 'Doe';

Summary

Engaging with SQL commands such as SELECT, INSERT, UPDATE, and DELETE has significantly enhanced my understanding of database management. By practicing these commands, I've learned how to retrieve specific data, add new records, modify existing entries, and remove unnecessary information from databases. This hands-on experience has not only solidified my grasp of SQL syntax but also demonstrated the practical applications of these commands in real-world scenarios. I can now confidently apply these skills to manage and manipulate data effectively in both current projects and future endeavors.