Module 13 Lab - SQL

Single-Table SELECT Statements

SELECT * FROM Customers;
SELECT Customer ID FROM Customers
SELECT Customer Name FROM Customers
SELECT City FROM Customers
SELECT Country FROM Customers

Single-Table INSERT Statements

INSERT INTO Customers (Customer ID, Customer Name, City, Country);
VALUES ('1', 'Axel Lilac', 'Lafayette', 'USA')
('2', 'Freddy Helium', 'London', 'UK')
('3', 'John Bovine', 'New Jersey', 'USA')
('4', 'Damien Davide', 'Rome', 'Italy');

Single-Table UPDATE Statements

UPDATE Customers;
UPDATE Customers SET Custoner Name='Johnny Bovine' WHERE City='New Jersey'

Single-Table DELETE Statements

DELETE FROM Customers
DELETE FROM Customers Where Customer Name='Damien Davide'

What I have learnt from completing these activities is that I am not particularly confident with databases and SQL, and I will apply this by ensuring that I take time to go over what we've learnt here again, and spend time looking for additional resources in order to expand my understanding.