Workshop

Team-Fly    

 
Sams Teach Yourself SQL in 24 Hours, Third Edition
By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Hour  1.  Welcome to the World of SQL


The following workshop is composed of a series of quiz questions and practical exercises. The quiz questions are designed to test your overall understanding of the current material. The practical exercises are intended to afford you the opportunity to apply the concepts discussed during the current hour, as well as build upon the knowledge acquired in previous hours of study. Please take time to complete the quiz questions and exercises before continuing. Refer to Appendix C,"Answers to Quizzes and Exercises," for answers.

Quiz

1:

What does the acronym SQL stand for?

2:

What are the six main categories of SQL commands?

3:

What are the four transactional control commands?

4:

What is the main difference between client/server and Web technologies as they related to database access?

5:

If a field is defined as NULL, does that mean that something has to be entered into that field?

Exercises

1:

Identify the categories in which the following SQL commands fall:

 CREATE TABLE  DELETE SELECT INSERT ALTER TABLE UPDATE 
2:

Study the following tables and pick out the column that would be a good candidate for the primary key:

EMPLOYEE_TBL

INVENTORY_TBL

EQUIPMENT_TBL

name

item

model

phone

description

year

start date

quantity

serial number

address

item number

equipment number

employee number

location

assigned to

3:

Refer to Appendix B,"Using MySQL for Exercises." Download and install MySQL on your computer to prepare for hands-on exercises in the following hours of instruction.


Team-Fly    
Top
 


Sams Teach Yourself SQL in 24 Hours
Sams Teach Yourself SQL in 24 Hours (5th Edition) (Sams Teach Yourself -- Hours)
ISBN: 0672335417
EAN: 2147483647
Year: 2002
Pages: 275

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net