Term
| Structured Query Language |
|
Definition
| database language used for database definition, manipulation, and querying in a relational database |
|
|
Term
| What are 3 reasons to learn SQL |
|
Definition
1) Not all businesses use Access
2) Not all queries can be created using QBE
3) SQL can help you to troubleshoot QBE queries |
|
|
Term
| What are the 4 main operations performed when using SQL? |
|
Definition
| (SIUD) Select, Insert, Update, Delete |
|
|
Term
| the Select function selects ______ |
|
Definition
| what attribute you want displayed in your output |
|
|
Term
| What is the general syntax for the Select operation |
|
Definition
|
|
Term
| when must brackets be used in SQL |
|
Definition
| when you are typing something with spaces |
|
|
Term
| What does the Insert operation do? |
|
Definition
| inserts rows into a table |
|
|
Term
| What do the Update/Delete operations do? |
|
Definition
| They modify/delete 1 or more rows in a table |
|
|
Term
| Do you need to include the table name where each attribute is located in the Select operation? |
|
Definition
| YES; ie. Customer.CustomerName |
|
|
Term
| What does the From operation do |
|
Definition
| Includes all the tables you need in your query; ie. Customer or Sales |
|
|
Term
| What does the Where/And operation do? |
|
Definition
Specifies criteria (not always needed);
ie. Where Customer.CustomerCity="Tampa" |
|
|
Term
| What are the main logical operators? |
|
Definition
|
|
Term
| What do you need to do if there is more than 1 table in your FROM line? |
|
Definition
| List where the foreign key from one table equals the foreign key from another ie. WHERE Customer.CustomerID=[Sales Order].CustomerID |
|
|
Term
|
Definition
| It means to select all attributes from a given table |
|
|
Term
| What is * used as in criteria? |
|
Definition
| * is used as a wildcard; ie. 199*; or Names that begin with Ti* |
|
|
