Shared Flashcard Set

Details

AIS
SQL
15
Accounting
Undergraduate 4
12/03/2010

Additional Accounting Flashcards

 


 

Cards

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
Select
From
Where
And;
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
<=
>=
=
<
>
<> = not equal to
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
What does SELECT * mean?
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*
Supporting users have an ad free experience!