MARC details
| 000 -LEADER |
|---|
| fixed length control field |
02183nam a2200409 a 4500 |
| 001 - CONTROL NUMBER |
|---|
| control field |
BDZ0004929165 |
| 003 - CONTROL NUMBER IDENTIFIER |
|---|
| control field |
StDuBDS |
| 005 - DATE AND TIME OF LATEST TRANSACTION |
|---|
| control field |
20180923143606.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION |
|---|
| fixed length control field |
010920s2002 njua f 001 0 eng d |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
|---|
| International Standard Book Number |
9780130669476 (pbk.) : |
| Terms of availability |
£35.99 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
|---|
| International Standard Book Number |
0130669474 |
| 040 ## - CATALOGING SOURCE |
|---|
| Original cataloging agency |
StDuBDS |
| Transcribing agency |
StDuBDS |
| Modifying agency |
StDuBDSZ |
| 050 #0 - LIBRARY OF CONGRESS CALL NUMBER |
|---|
| Classification number |
QA76.73.S67 |
| Item number |
P38 2002 |
| 072 #7 - SUBJECT CATEGORY CODE |
|---|
| Subject category code |
COM |
| Source |
ukslc |
| 072 #7 - SUBJECT CATEGORY CODE |
|---|
| Subject category code |
UMT |
| Source |
thema |
| 082 0# - DEWEY DECIMAL CLASSIFICATION NUMBER |
|---|
| Classification number |
005.7565 PAT |
| 100 1# - MAIN ENTRY--PERSONAL NAME |
|---|
| Personal name |
Patrick, John J. |
| 245 10 - TITLE STATEMENT |
|---|
| Title |
SQL fundamentals / |
| Statement of responsibility, etc. |
John J. Patrick. |
| 250 ## - EDITION STATEMENT |
|---|
| Edition statement |
2nd ed. |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. |
|---|
| Place of publication, distribution, etc. |
Upper Saddle River, N.J. : |
| Name of publisher, distributor, etc. |
Prentice Hall PTR, |
| Date of publication, distribution, etc. |
c2002. |
| 300 ## - PHYSICAL DESCRIPTION |
|---|
| Extent |
xxvi, 834 p. : |
| Other physical details |
ill. ; |
| Dimensions |
24 cm. |
| 500 ## - GENERAL NOTE |
|---|
| General note |
Previous ed.: 1999. |
| 500 ## - GENERAL NOTE |
|---|
| General note |
Includes index. |
| 500 ## - GENERAL NOTE |
|---|
| General note |
CD-ROM in back pocket. |
| 505 0# - FORMATTED CONTENTS NOTE |
|---|
| Formatted contents note |
1.Storing information in tables -- 2.Getting information from a table -- 3.Compound conditions in the where clause -- 4.Saving your results -- 5.Modifying data through a view -- 6.Creating your own tables -- 7.Formats, sequences, and indexes -- 8.Data integrity -- 9.Row functions -- 10.Using row functions -- 11.Summarizing data -- 12.Controlling the level of summarization -- 13.Inner joins -- 14.Outer joins -- 15.Union and union all -- 16.Cross joins and self joins -- 17.Combining talbes in a production database -- 18.If-then-else and subqueries -- 19.The multiuser environment -- 20.The design of SQL -- Appendix A.Obtaining and installing ORACLE -- Appendix B.Tips on using ORACLE -- Appendix C.Tips on using ACCESS -- Appendix D.Diagram of the lunches database. |
| 520 8# - SUMMARY, ETC. |
|---|
| Summary, etc. |
SQL is a standardised query language for requesting information from a database. Covering topics such as inner joins, self joins and subqueries using clear, easy to follow examples, this book compares and contrasts Oracle 9I and Access 2000 databases. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
SQL (Comptuer program language). |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
SQL (Computer program language) |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
Relational databases. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
Database management. |
| 650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
Computers and IT. |
| Source of heading or term |
ukslc |
| 650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
Database programming |
| Source of heading or term |
thema |
| 902 ## - LOCAL DATA ELEMENT B, LDB (RLIN) |
|---|
| a |
170814 |
| 907 ## - LOCAL DATA ELEMENT G, LDG (RLIN) |
|---|
| a |
.b1031572x |
| b |
main |
| c |
- |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) |
|---|
| Suppress in OPAC |
0 |
| 998 ## - LOCAL CONTROL INFORMATION (RLIN) |
|---|
| Operator's initials, OID (RLIN) |
0 |
| Cataloger's initials, CIN (RLIN) |
050316 |
| First Date, FD (RLIN) |
m |
| Local |
a |
| -- |
- |
| -- |
0 |