Curriculum Design and Instruction To Teach
The Fundamentals Of Structured Query
Language (SQL): The Multiuser Environment:
Volume 19:
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:
@. The Multiuser Environment:
A. Introduction:
1. Database Configurations:
A. The Single-user environment:
B. The multiuser environmrnt:
C. The distributed environment:
D. Connecting via the Internet:
2. Operating in a Multiuser Environment:
A. How to use a table you do not own:
B. Synonyms:
C. Snapshots:
3. Security and Privileges:
A. Identifying the user:
B. Privileges:
C. Roles:
4. Several People Using the Same Table
at the Same Time:
A. One Person changing data while another
person is looking at it:
B. Two people changing different rows in the
same table:
C. Two people changing the same row in a table:
5. Locks:
A. Row locks:
B. Rollback segments:
C. Table locks:
D. Types of locks:
E. Select for update:
F. Stability while running a select
statement:
G. Stability while running a transaction:
6. The Data Dictionary and the Multiuser
Environment:
A. All versus USER:
B. How to find the tables you want in the
Data Dictionary:
C. How to find the Meaning of the columns:
7. How to Create a Shared Application:
A. Creating the Lunches database as a shared
application:
8. 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:
