책 이미지
책 정보
· 분류 : 외국도서 > 컴퓨터 > 데이터베이스 관리 > 일반
· ISBN : 9780123693792
· 쪽수 : 840쪽
· 출판일 : 2005-07-29
목차
Chapter 1: Database Design
Chapter 2: Normalization
Chapter 3: Numeric Data in SQL
Chapter 4: Temporal Data Types in SQL
Chapter 5: Character Data Types in SQL
Chapter 6: NULLs
Chapter 7: Multiple Column Data Elements
Chapter 8: Table Operations
Chapter 9: Comparison or Theta Operators
Chapter 10: Valued Predicates
Chapter 11: CASE Expressions
Chapter 12: LIKE Predicate
Chapter 13: Between and Overlaps Predicates
Chapter 14: The [NOT] IN() predicate
Chapter 15: EXISTS() predicate
Chapter 16: Quantified Subquery Predicates
Chapter 17: The SELECT Statement
Chapter 18: VIEWs, Derived Tables, Materialized Tables, and Temporary Tables
Chapter 19: Partitioning Data in Queries
Chapter 20: Grouping Operations
Chapter 21: Aggregate Functions
Chapter 22: Auxiliary Tables
Chapter 23: Statistics in SQL
Chapter 24: Regions, Runs, Gaps, Sequences, and Series
Chapter 25: Arrays in SQL
Chapter 26: Set Operations
Chapter 27: Subsets
Chapter 28: Trees and Hierarchies in SQL
Chapter 29: Temporal Queries
Chapter 30: Graphs in SQL
Chapter 31: OLAP in SQL
Chapter 32: Transactions and Concurrency Control
Chapter 33: Optimizing SQL
References
General References
Logic
Mathematical Techniques
Random Numbers
Scales and Measurements
Missing Values
Regular Expressions
Graph Theory
Introductory SQL Books
Optimizing Queries
Temporal Data and the Year 2000 Problem
SQL Programming Techniques
Classics
Forum
Updatable VIEWs
Theory, Normalization, and Advanced Database Topics
Books on SQL-92 and SQL-99
Standards and Related Groups
Web Sites Related to SQL
Statistics
Temporal Databases
Index
About the Author
