Saving Your Results - Volume 4

Curriculum Design and Instruction To Teach

The Fundamentals Of Structured Query

Language (SQL): Saving Your Results:

Volume 4:



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:

@. Saving Your Results:

A. Introduction:

1. Saving Your Results in a New Table

or View:

A. Creating a new table from the results

of a select statement:

B. Creating a new view from the results

of a select statement:

C. Similariites between tables and views:

D. Difference between tables and views:

E. Deleting a table:

F. Deleting a view:

G. One view can be built on top of another view:

H. Preventative delete:

2. Modifying the Data in a Table:

A. Adding one new row to a table:

B. Commit and roll back:

C. Adding many new rows to a table with

a select statement:

D. Changing data in the rows

already in a table:

E. Deleting rows from a table:

F. Constraints with insert, update,

and delete:

G. Autocommit:

H. Using the Access GUI environment to

change the data in a table:

3. 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:

* 150 PAGES: 8x11"

* ALLOW 10 TO 14 DAYS TO RECEIVE ITEM:

* ORDER EARLY WHILE SUPPLIES LAST: