Goal

Identify SQL commands used to manage your database

Step 1. SQL Commands

There are about 100 SQL commands that are commonly used. You have learned about SELECT, INSERT, UPDATE and DELETE. W3Schools shows you on SQL at http://www.w3schools.com/SQl/default.asp (Links to an external site.)Links to an external site..

Explain what each of these commands do and explain the syntax.

Provide a sample that would work with your database.

INNER JOIN LIKE WILDCARDS * ALIASES IN BETWEEN JOINS SELECT INTO INSERT INTO SELECT CREATE TABLE PRIMARY KEY FOREIGN KEY CREATE INDEX IDENTITY DROP ALTER AVG COUNT MAX AND MIN GROUP BY 

In your reply post:

Check and see if the sample syntax was correct. If not, provide the solution.

Did they use the commands appropriately?

How can you use these tools to backup your data?