SQL Fundamentals

• SELECT * FROM CUSTOMERS;
• SELECT customerName, contactLastName, contactFirstName FROM CUSTOMERS;
• SELECT * FROM EMPLOYEES WHERE jobTitle = 'Sales Rep';
• SELECT DISTINCT country FROM CUSTOMERS;

• INSERT INTO CUSTOMERS (customerName, contactLastName, contactFirstName, phone, addressLine1, city, country) VALUES ('Tech Innovators', 'Doe', 'John', '555-1234', '123 Digital Way', 'San Francisco', 'USA');
• UPDATE CUSTOMERS SET phone = '555-9876' WHERE customerName = 'Tech Innovators';
• DELETE FROM CUSTOMERS WHERE customerName = 'Tech Innovators';

Reflection

Completing these activities made me better understand SQL. I learned that while SELECT statements are important for reporting, mastering INSERT, UPDATE, and DELETE is vital for keeping data correct. In my future career as a developer, I can use these skills to create more dynamic applications that work smoothly with relational databases. This will help ensure that user information is stored correctly and retrieved efficiently.