Curriculum Design and Instruction To Teach
The Fundamentals Of Structured Query
Language (SQL): If-Then-Else and Subqueries:
Volume 18:
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:
@. If-Then-Else and Subqueries:
A. Introduction:
1. If-Then-Else Logic:
A. The decode function in Oracle:
B. The Immediate if (iif) function
in Access:
C. Attaching messages to rows:
D. Dividing data from one column into
two different columns:
E. Applying two functions to different
parts of the data:
F. A parameter query in Oracle:
G. Using a parameter more than once
in Oracle:
H. More ways to define parameters
in Oracle:
I. A parameter query in Access:
J. A query in Access with two
parameters:
K. Limitations on parameters in
Access:
3. Subqueries:
A. Introduction to subqueries:
B. Subqueries that result in a
list of values:
C. Subqueries that result in a single
value:
D. Avoid using not in with nulls:
4. Applications of Subqueries:
A. Subqueries used in an update
command:
B. Finding the difference between two
tables:
C. Using the most current data:
5. Older Features of Subqueries:
A. Correlated subqueries:
B. Subqueries using exists:
C. Using a subquery to write an
outer join:
D. Nested subqueries:
E. Subqueries can be used in
limited locations:
f. Many subqueries can also be
written as a join:
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:
