Getting Information From A Table - Volume 2

Curriculum Design and Instruction To Teach

The Fundamentals Of Structured Query

Language (SQL): Getting Information From A

Table: Volume 2:



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:


@. Getting Information From A Table:

A. Introduction:

1. The Select Statement:

A. The goal: Get a few columns and

rows from a table:

B. Overview of the select statement:

2. The Select Clause:

A. Overview of the Select clause:

B. Using the select clause to get

a list of some of the colums:

C. Using the select clause to get

a list of all of the columns:

D. Using the select statement to get

the distinct values in one column:

E. Using the select clause to get the

distinct values of several columns:

3. The Where Clause:

A. Overview of the where clause:

B. Using an Equal condition in

the where clause:

C. Using a Less Than condition

in the where clause:

D. Using a Not Equal condition

in the where clause:

E. Using the in condition in

the where clause:

F. Using the between condition

in the where clause:

G. Using the like condition in

the where clause:

H. Using the is null condition

in the where clause:

4. The Order By Clause:

A. Overview of the order by clause:

B. Sorting the rows by several columns

in ascending order:

C. Sorting the rows by several columns

in various orders:

D. The whole process so far:

5. Summary:

* HOW TO DO THE EXERCISES ON THE COMPUTER:

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