عنوان

SQL fundamentals /

Terms of Availability and/or Price

(pbk. : alk. paper)

Terms of Availability and/or Price

(pbk. : alk. paper)

(Number (ISBN

0137126026

(Number (ISBN

9780137126026

Number

b511059

Title Proper

SQL fundamentals /

General Material Designation

[Book]

First Statement of Responsibility

John J. Patrick

Edition Statement

3rd ed

Place of Publication, Distribution, etc.

Upper Saddle River, NJ :

Name of Publisher, Distributor, etc.

Prentice Hall,

Date of Publication, Distribution, etc.

c2009

Specific Material Designation and Extent of Item

xxviii, 803 p. :

Other Physical Details

ill. ;

Dimensions

24 cm

Text of Note

Includes index

Text of Note

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

0

Microsoft Access

Oracle (Computer file)

SQL (Computer program language)

Class number

Book number

Patrick, John J

Date of Transaction

20140115103453.0

Electronic name

[Book]

Y