عنوان
پدید آورنده
موضوع
رده
کتابخانه
محل استقرار
INTERNATIONAL STANDARD BOOK NUMBER
(Number (ISBN
0080460046
(Number (ISBN
9780080460048
NATIONAL BIBLIOGRAPHY NUMBER
Number
b606678
TITLE AND STATEMENT OF RESPONSIBILITY
Title Proper
Joe Celko's SQL for Smarties :
General Material Designation
[Book]
Other Title Information
Advanced SQL Programming
First Statement of Responsibility
Joe Celko.
.PUBLICATION, DISTRIBUTION, ETC
Name of Publisher, Distributor, etc.
Morgan Kaufmann
Date of Publication, Distribution, etc.
2010
PHYSICAL DESCRIPTION
Specific Material Designation and Extent of Item
(840 pages).
SERIES
Series Title
The Morgan Kaufmann Series in Data Management Systems
CONTENTS NOTE
Text of Note
Part I: Data Relational Model Basics Keys and uniqueness; Normalization Practical Hints for Normalization; Practical Hints for Denormalization; Encoding and scales Implementations;Generator functions Part II: DDL (Data Declaration Language)Part III: DML (Data Manipulation Language) 1. Numeric Data in SQL 2. Temporal Datatypes in SQL 3. Character Datatypes in SQL 4. Other Expressions 5. Table Operations 6. INSERT INTO Statement 7. The UPDATE Statement 8. Comparison or Theta Operators 9. Valued Predicates 10. LIKE and SIMILAR TO Predicates 11. BETWEEN and OVERLAPS Predicates 12. The [NOT] IN Predicate 13. [NOT] EXISTS() Predicate 14. Quantified Subquery Predicate 15. The Simple SELECT Statement 16. OUTER JOINs 17. Old versus New JOIN syntax 18. Bin Packing 19. VIEWs 20. TEMPORARY TABLEs 21. Partitioning Data 22. Grouping Operations 23. Aggregate Functions 24. Other Aggregate Functions 25. Auxiliary Tables 26. Statistics in SQL 27. Regions, Runs, Gaps, Sequences and Series 28. Array Structures in SQL 29. Set Operations 30. Subsets 31. Trees in SQL 32. Graphs in SQL 33. Optimizing Code.
PERSONAL NAME - PRIMARY RESPONSIBILITY
Joe Celko.
PERSONAL NAME - ALTERNATIVE RESPONSIBILITY
Joe Celko
ELECTRONIC LOCATION AND ACCESS
Electronic name
مطالعه متن کتاب [Book]
Y
