Database Queries Summary

Single-Table SELECT Statements

The following commands extract specific data sets from the database without altering any underlying records.

• SELECT * FROM CUSTOMERS;
• SELECT FirstName, LastName FROM CUSTOMERS WHERE City = 'Chicago';
• SELECT ProductName, Price FROM PRODUCTS ORDER BY Price DESC;

INSERT, UPDATE, and DELETE Statements

These commands actively modify the database structure by adding new information, changing existing records, and removing obsolete data.

• INSERT INTO CUSTOMERS (FirstName, LastName, City) VALUES ('Ethan', 'Eustaquio', 'Schaumburg');
• UPDATE CUSTOMERS SET City = 'Springfield' WHERE CustomerID = 105;
• DELETE FROM CUSTOMERS WHERE CustomerID = 105;

Learning Application

Completing these activities provided a clear understanding of database manipulation using structured query language (SQL). Practicing basic selection commands allowed me to retrieve specific data points efficiently. Furthermore, executing insert, update, and delete statements demonstrated how to maintain accurate records within a complex system. In the future, I can apply these skills to web development projects to build dynamic applications that interact securely with backend servers.