Creating Your Own Table - Volume 6

Curriculum Design and Instruction To Teach

The Fundamentals Of Structured Query

Language (SQL): Creating Your Own Table:

Volume 6:



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:

@. Creating Your Own Tables:

A. Introduction:

1. Creating Tables:

A. The create table command:

B. Datatypes in Oracle and Access:

C. Two Types of time:

D. Putting data into the new 1_foods table:

E. Creating the 1_employees table in Oracle:

2. Changing Tables:

A. Adding a primary key to a table:

B. Changing the primary key of a table:

C. Adding a new column to a table:

D. Expanding the length of a column:

E. Deleting a column from a table:

3. Tables with Duplicate Rows:

A. The problem with duplicate rows:

B. How to eliminate duplicate rows:

C. How to distinguish between duplicate rows:

4. Loading a Large Amount of Data from a Flat File:

A. The SQL*Loader in Oracle:

B. Loading delimited data in Oracle:

C. Analyze table in Oracle:

D. File import in Access:

5. Summary:


F. Making Other Changes to Tables:

* 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: