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.