Amazon cover image
Image from Amazon.com

Joe Celko's SQL for smarties : advanced SQL programming / Joe Celko.

By: Material type: TextSeries: Morgan Kaufmann series in data management systemsPublication details: San Francisco : Morgan Kaufmann, 2000.Edition: 2nd edDescription: xxi, 553 p. : ill. 23 cmISBN:
  • 1558605762
ISSN:
  • 9781558605763
Subject(s): LOC classification:
  • QA76.73.S67 .C44
Contents:
1. Database Design -- 2. Normalization -- 3. Numeric Data in SQL -- 4. Temporal Datatypes in SQL -- 5. Character Datatypes in SQL -- 6. NULLs -- Missing Data in SQL -- 7. Other Expressions -- 8. Other Schema Objects -- 9. Table Operations -- 10. Comparison or Theta Operators -- 11. Valued Predicates -- 12. LIKE and SIMILAR Predicates -- 13. BETWEEN and OVERLAPS Predicates -- 14. The [NOT] IN Predicate -- 15. EXISTS () Predicate -- 16. Quantified Subquery Predicate -- 17. The SELECT Statement -- 18. VIEWs and TEMPORARY TABLEs -- 19. Partitioning Data -- 20. Grouping Operations -- 21. Aggregate Functions -- 22. Auxiliary Tables -- 23. Statistics in SQL -- 24. Regions, Runs and Sequences -- 25. Array Structures in SQL -- 26. Set Operations -- 27. Subsets -- 28. Adjacency List Model of Trees in SQL -- 29. Nested Set Model of Trees in SQL -- 30. Graphs in SQL -- 31. Optimizing Code.
Tags from this library: No tags from this library for this title.
Star ratings
    Average rating: 0.0 (0 votes)
Holdings
Cover image Item type Current library Home library Collection Shelving location Call number Materials specified Vol info URL Copy number Status Notes Date due Barcode Item holds Item hold queue priority Course reserves
Books Methodist University Library Main General Stacks Reference QA76.73.S67 .C44 (Browse shelf(Opens below)) Available 18702

Browsing Methodist University Library Main shelves,Shelving location: General Stacks,Collection: Reference Close shelf browser (Hides shelf browser)

Includes Index

1. Database Design --
2. Normalization --
3. Numeric Data in SQL --
4. Temporal Datatypes in SQL --
5. Character Datatypes in SQL --
6. NULLs --
Missing Data in SQL --
7. Other Expressions --
8. Other Schema Objects --
9. Table Operations --
10. Comparison or Theta Operators --
11. Valued Predicates --
12. LIKE and SIMILAR Predicates --
13. BETWEEN and OVERLAPS Predicates --
14. The [NOT] IN Predicate --
15. EXISTS () Predicate --
16. Quantified Subquery Predicate --
17. The SELECT Statement --
18. VIEWs and TEMPORARY TABLEs --
19. Partitioning Data --
20. Grouping Operations --
21. Aggregate Functions --
22. Auxiliary Tables --
23. Statistics in SQL --
24. Regions, Runs and Sequences --
25. Array Structures in SQL --
26. Set Operations --
27. Subsets --
28. Adjacency List Model of Trees in SQL --
29. Nested Set Model of Trees in SQL --
30. Graphs in SQL --
31. Optimizing Code.

There are no comments on this title.

to post a comment.
Share
Copyright © 2026  MUG Library