Curriculum Design and Instruction To Teach
The Fundamentals Of Structured Query
Language (SQL): Summarizing Data: Volume 11:
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:
@. Summarizing Data:
A. Introduction:
1. Introduction to the Column Functions:
A. Summarizing all the data in a column:
B. A list of the column functions:
2. Maximum and Minimum:
A. Finding the maximum and minimum values:
B. Using a where clause with a column function:
C. Finding the rows that have the maximum
or minimum values:
3. Count:
A. Counting rows and counting data:
B. Counting to zero:
C. Counting the number of distinct values
in a column:
D. Counting the number of distinct values
in two or more columns:
4. Sum and Average:
A. The sum and average functions:
B. The problem with addition and how to solve it:
5. Other Topics:
A. Nulls are not always changed to zero:
B. Counting the number of nulls in a column:
C. Counting distinct dates:
6. 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:
