Intro to Excel
Intro to SQL
SQL Queries
Key Board Commands
Wild Card
100
Two-dimensional structure with rows and columns.
What is a table?
100

Define what data looks like and how it can be used.

What is a datatype?

100
Specifies how data is sorted in a results set.
What is the ORDER BY clause?
100

Specify the database in the dropdown in SQL-Server Management Studio or use the 'Use database' syntax.

How do you specify the database that you are using for a query?

100

[Name with space]

What is the syntax to identify a field-name that includes a space?

200

A collection of data stored in a format that can easily be accessed.

What is a database?

200

This uniquely identifies a row in a table.

What is a primary key?

200
In a SQL query, specifies the table that data is selected from.
What is the FROM clause?
200
A tool that 'helps' you write queries.
What is the query design window?
200

'Invented' the relational database.

Who is E.F. Codd?

300

True and False are representatives of what data type?

What is a Boolean?

300

Data is stored in tables that are linked together based on how they relate

What is a Relational Database?

300

Selects everything from the Personnel table.

What does the following query do? SELECT * FROM Personnel;

300
Right click on a SQL-Server object.
Hw can you easily perform a variety of functions in SQL-Server Management Studio?
300

NOT AND OR

What is the order of operations for compound WHERE statements?

400

Select * from Customers

Where CustomerName Like (‘%ana%’, ‘%anp%’) ;

What is a FIRST NAME INCLUDES the sequence of letters "ana" and LAST NAME INCLUDES sequence of letters "anp"?

400

Data that is stored in tables that are not linked(don't understand SQL)

What is NoSQL?

400

Allows you to specify pattern matches for data retrieval values.

What does IN allow you to do in SQL?

400
TEMPDB
Which of the system databases is used by SQL-Server as a temporary workspace?
400

Use the syntax /* */ or --

What is How do you add comments to SQL?

500
Processing is divided between client and server.
What is a client-server system?
500

A data type in standard SQL used to store large amounts of data. It is basically a binary string of variable length, stored as a sequence of bytes or octets.

What is BLOB?

500

WHERE Weight is between 2000 and 3000 OR Where Weight is > 1999 and < 3001 OR WHERE Weight is >= to 2000 and <=3000

What WHERE clause will select weight values between 2000 and 3000?

500
Click the 'EXECUTE' command on the toolbar.
How do you 'run' a SQL Query?
500
* % _
What are wild card characters in SQL?
M
e
n
u