|
" SQL fundamentals / "
John J. Patrick
| Document Type
|
:
|
BL
|
| Record Number
|
:
|
688870
|
| Doc. No
|
:
|
b511059
|
| Main Entry
|
:
|
Patrick, John J
|
| Title & Author
|
:
|
SQL fundamentals /\ John J. Patrick
|
| Edition Statement
|
:
|
3rd ed
|
| Publication Statement
|
:
|
Upper Saddle River, NJ :: Prentice Hall,, c2009
|
| Page. NO
|
:
|
xxviii, 803 p. :: ill. ;; 24 cm
|
| ISBN
|
:
|
0137126026
|
|
|
:
|
: 9780137126026
|
| Notes
|
:
|
Includes index
|
| Contents
|
:
|
Storing information in tables -- Getting information from a table -- Compound conditions in the where clause -- Saving your results -- The data dictionary and other oracle topics -- Creating your own tables -- Formats, sequences, and indexes -- Data integrity -- Row functions -- Using row functions -- Summarizing data -- Controlling the level of summarization -- Inner joints -- Outer joints -- Union and union all -- Cross joints, self joints, and crosstab queries -- Combining tables in a production database -- If-then-else, parameter queries, and subqueries -- The multiuser environment -- The design of SQL -- Appendix A : Oracle is free : how to get your copy -- Appendix B : Quick start with oracle -- Appendix C : Quick start with access -- Appendix D : Diagram of the lunches database
|
| Subject
|
:
|
SQL (Computer program language)
|
| Subject
|
:
|
Microsoft Access
|
|
|
:
|
Oracle (Computer file)
|
| LC Classification
|
:
|
QA76.73.S67P38 2009
|
| |