Database SQL Activities - Session 13

Single-Table SELECT Statements

Below are examples of SELECT statements used in this activity:

• Insert Into customers (first_name) values;
• SELECT FIRST_NAME, LAST_NAME FROM CUSTOMERS;
• SELECT * FROM ORDERS WHERE ORDER_ID = 1;

INSERT, UPDATE, and DELETE Statements

Below are examples of data modification statements:

• INSERT INTO CUSTOMERS (FIRST_NAME, LAST_NAME) VALUES ('John', 'Doe');
• UPDATE CUSTOMERS SET FIRST_NAME = 'Jane' WHERE CUSTOMER_ID = 1;
• DELETE FROM CUSTOMERS WHERE CUSTOMER_ID = 1;

Summary

In this assigment database, select and insert and detle to my webpage with statements. I learn that an database is where an collection of data is sotred. also their are many different databases as well. sql is a special purpose, that works, that keep thing work in flow. the sql sellect statement returns a result of a set. which the reading and the video i feel that I did the work the best as i can, and the best to my ablitles. over all, their is lots of new information that I learn and pick on about.