Session 13: Database SQL Activities

By Nicholas Korostelev

The following are examples of single-table SELECT statements completed during the activity:

SELECT * FROM CUSTOMERS;
SELECT FirstName, LastName FROM CUSTOMERS;
SELECT * FROM CUSTOMERS WHERE Country = 'USA';

The following are examples of INSERT, UPDATE, and DELETE statements:

INSERT INTO CUSTOMERS (FirstName, LastName, Country) VALUES ('John', 'Doe', 'USA');
UPDATE CUSTOMERS SET Country = 'Canada' WHERE LastName = 'Doe';
DELETE FROM CUSTOMERS WHERE LastName = 'Doe';

While completing this activity, I learned how to use basic SQL commands such as SELECT, INSERT, UPDATE, and DELETE to manage data in a database. I found that although SQL can seem simple at first, it requires practice to fully understand how queries work and how to structure them correctly. This knowledge is useful because databases are widely used in web development and many real-world applications. I can apply these skills in future projects by using SQL to store, retrieve, and manage data efficiently. Overall, this activity helped me build a strong foundation in working with relational databases.