Storing Information In Tables - Volume 1

Curriculum Design And Instruction To Teach

The Fundamentals Of Structured Query

Language (SQL): Storing Information On

Tables:


Author: Charles Hayes:


SQL commonly expanded as Structured Query

Language, is a computer language designed

for the retrieval and management of data in

relational database management systems,

database schema creation and modification,

and database object access control management.

SQL has been standardized by both ANSI and ISO.






Special Features Include:


Phases For Conducting A Needs Assessment:

Curriculum Design Supplement:

Curriculum Design Plan:

Lesson Plans:

Test:

Instructional Goals:

Instructional Objectives:

Instructional Activities:

Instructional Evaluation Techniques:

Standard Vocabulary:

A Limited Glimpse:



Topics Include:


@. Storing Information In Tables:

A. Introduction:

1. What is SQL?

2. What is a relational database

and why would you use one?

3. Why Learn SQL?

B. The Parts of a Table:

1. Data is stored in tables:

2. A row represents an object and the

information about it:

3. A coloumn represents one type of information:

4. A cell is the smallest part of a table:

5. Each cell should express just one thing:

6. Primary key columns identify each row:

7. Most tables are tall and thin:

C. Examples of Tables:

1. An Example of a table in Oracle and Access:

2. Some design decisions in the 1_employees table:

3. The Lunches database:

D. Summary:

* STATE OF THE ART CURRICULUM:

* NEW:

* BIBLIOGRAPHICAL REFERENCES & INDEX:

* ILLUSTRATIONS:

* PHOTOS:

* PAPERBACK:

* TRANSPARENT FRONT PAGE:

* BLACK OR WHITE BACK PAGE COVER:

* BINDED: BLACK OR WHITE COIL:

* 100 PAGES: 8x11"

* ALLOW 10 TO 14 DAYS TO RECEIVE ITEM:

* ORDER EARLY WHILE SUPPLIES LAST: