Curriculum Design and Instruction To Teach
The Fundamentals Of Structured Query
Language (SQL): Modifying Data Through A
View: Volume 5:
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:
@. Modifying Data Through A View::
A. Introduction:
1. Transactions:
A. An Example of a transaction:
2. Modifying Data Through a View:
A. Changing data through a view:
B. Example of changing data through a view:
C. Views using With Check Option:
3. Oracle SQLplus:
A. How to set column formats and headings
using SQLplus:
B. How to find the column names in a table
or view using SQLplus:
C. How to use a spool file:
D. How to get online help in SQLplus:
E. How to show the parameter settings
for SQLplus:
F. About the SQLFUN_LOGIN script:
G. How to use the Oracle SQLplus
documentation:
4. Finding Information About Tables and Views:
A. Overview of the Data Dictionary:
B. How to find the names of all the tables:
C. How to find the names of all the views:
D. How to find the select statement that
defines a view:
E. How to find the names of the column
in a table or view:
f. How to find the primary key of a table:
5. 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:
