Curriculum Design and Instruction To Teach
The Fundamentals Of Structured Query
Language (SQL): Combining Tables in a
Production Database: Volume 17:
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:
@. Combining Tables In A Production
Database::
A. Introduction:
1. Methods of Joining Three or
More Tables:
A. Joining several tables in a series
of steps:
B. Joining several tables at once in
the where clause:
C. Joining several tables at once in the
from clause:
2. Losing Information:
A. Be careful with an inner join:
B. Be careful with a left and right
outer join:
C. A full outer join preserves all the
information:
D. A Full outer join of several tables:
3. Caring About the efficiency of Your
Computer:
A. Monitor your queries:
B. Use the indexes:
C. Select the data you want early
in the process:
D. Use a table to save summarized data:
E. Try several ways of writing the SQL:
4. Standardizing the Way That Tables Are
Joined:
A. The joins are part of the database design:
B. A view can standardize the way tables are
Joined:
C. Ad hoc reporting:
4. 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:
