SQL fundamentals
by
Patrick, John J.
Title
:
SQL fundamentals
Author
:
Patrick, John J.
ISBN
:
9780137126026
Personal Author
:
Patrick, John J.
Edition
:
3rd ed.
Publication Information
:
Upper Saddle River, NJ : Prentice Hall, ©2009.
Physical Description
:
xxviii, 803 pages : illustrations ; 24 cm
General Note
:
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.
Title Subject
:
Oracle (Computer file)
Microsoft Access.
Microsoft Access. (OCoLC)fst01371910
Oracle (Computer file) (OCoLC)fst01363816
Subject Term
:
SQL (Computer program language)
SQL (Computer program language) (OCoLC)fst01102869
Electronic Access
: