Single-Table SELECT Statements
- SELECT * FROM CUSTOMERS;
- SELECT FirstName, LastName FROM CUSTOMERS;
- SELECT * FROM ORDERS WHERE OrderDate = '2024-01-01';
- SELECT ProductName FROM PRODUCTS WHERE Price > 50;
INSERT, UPDATE, and DELETE Statements
- INSERT INTO CUSTOMERS (FirstName, LastName) VALUES ('John', 'Doe');
- UPDATE CUSTOMERS SET LastName = 'Smith' WHERE CustomerID = 1;
- DELETE FROM CUSTOMERS WHERE CustomerID = 1;
Summary Paragraph
Completing these activities has given me a better understanding of how SQL is used to interact with databases. I learned how to retrieve data efficiently using SELECT statements, as well as how to manipulate data using INSERT, UPDATE, and DELETE commands. SQL is highly applicable to real-world environments, software development, and database management, and applies to me personally as I am considering a career in data analysis Understanding these core operations allows me to manage and organize data effectively, which will be valuable in both my current studies and future career in technology.