Εξώφυλλο

Joe Celko's SQL for smarties advanced SQL programming /

SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 10 years later and in the third edition, this classic still reigns supreme as the book written by an SQL master that teaches future SQL m...

Πλήρης περιγραφή

Κύριος συγγραφέας: Celko, Joe.
Μορφή: Ηλεκτρονική πηγή
Γλώσσα: English
Στοιχεία έκδοσης: Amsterdam ; Boston : Morgan Kaufmann, c2005.
Έκδοση: 3rd ed.
Σειρά: Morgan Kaufmann series in data management systems.
Θέματα:
SQL (Computer program language).
SQL.
Electronic books.
Διαθέσιμο Online: http://www.sciencedirect.com/science/book/9780123693792
Ετικέτες: Προσθήκη ετικέτας
Δεν υπάρχουν, Καταχωρήστε ετικέτα πρώτοι!
Πίνακας περιεχομένων:
  • Database design
  • Normalization
  • Numeric data in SQL
  • Temporal data types in SQL
  • Character data types in SQL
  • NULLs : missing data in SQL
  • Multiple column data elements
  • Table operations
  • Comparison or theta operators
  • Valued predicates
  • CASE expressions
  • LIKE predicate
  • Between and overlaps predicates
  • The [NOT] IN() predicate
  • EXISTS() predicate
  • Quantified subquery predicates
  • The SELECT statement
  • VIEWs, derived tables, materialized tables, and temporary tables
  • Partitioning data in queries
  • Grouping operations
  • Aggregate functions
  • Auxiliary tables
  • Statistics in SQL
  • Regions, runs, gaps, sequences, and series
  • Arrays in SQL
  • Set operations
  • Subsets
  • Trees and hierarchies in SQL
  • Temporal queries
  • Graphs in SQL
  • OLAP in SQL
  • Transactions and concurrency control
  • Optimizing SQL.

Παρόμοια τεκμήρια