SQL:1999 understanding relational language components
This book is the best way to make the leap from SQL-92 to SQL:1999, but it is much more than just a simple bridge between the two. The latest from celebrated SQL experts Jim Melton and Alan Simon, SQL:1999 is a comprehensive, eminently practical account of SQL's latest incarnation and a potent...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
San Francisco :
Academic Press
c2002.
|
| Edición: | 1st edition |
| Colección: | The Morgan Kaufmann Series in Data Management Systems
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627905606719 |
Tabla de Contenidos:
- Front Cover; SQL:1999 Understanding Relational Language Components; Copyright Page; Contents; Preface; Chapter 1. Database and Technology Foundations; 1.1 Introduction; 1.2 Introduction to Database Technology; 1.3 Database Languages; 1.4 The Transaction Model; 1.5 Chapter Summary; Chapter 2. Introduction to SQL:1999; 2.1 Introduction; 2.2 SQL History and Background; 2.3 SQL Concepts; 2.4 SQL Data Types; 2.5 Logic and Null Values; 2.6 Data Conversions; 2.7 SQL Statements; 2.8 Static Versus Dynamic Execution; 2.9 Conforming to SQL:1999; 2.10 Relationship to Products; 2.11 Identifiers
- 2.12 Chapter SummaryChapter 3. Basic Table Creation and Data Manipulation; 3.1 Introduction; 3.2 Our Example; 3.3 Basic Table Creation; 3.4 Set Orientation; 3.5 Basic Data Retrieval; 3.6 Updating Information; 3.7 Inserting Information; 3.8 Deleting Information; 3.9 Chapter Summary; Chapter 4. Basic Data Definition Language (DDL); 4.1 Introduction; 4.2 Data Definition Fundamentals; 4.3 Basic DDL Statements; 4.4 WITH CHECK OPTION; 4.5 Chapter Summary; Chapter 5. Values, Basic Functions, and Expressions; 5.1 Introduction; 5.2 Types of SQL Values; 5.3 Literals; 5.4 Parameters; 5.5 Special Values
- 5.6 Column References and Field References5.7 Some Terminology; 5.8 Set Functions; 5.9 Value Functions; 5.10 Value Expressions; 5.11 Chapter Summary; Chapter 6. Advanced Value Expressions: CASE, CAST, and Row Value Expressions; 6.1 Introduction; 6.2 The CASE Expression; 6.3 The CAST Expression; 6.4 Row Value Constructors; 6.5 Table Value Constructors; 6.6 Array Value Constructors; 6.7 Chapter Summary; Chapter 7. Predicates; 7.1 Introduction; 7.2 What Is a Predicate?; 7.3 Subqueries; 7.4 Comparison Predicate; 7.5 IS NULL Predicate; 7.6 IN Predicate; 7.7 LIKE and SIMILAR Predicates
- 7.8 EXISTS and UNIQUE Predicates7.9 OVERLAPS Predicate; 7.10 SOME, ANY, and ALL; 7.11 MATCH Predicate; 7.12 DISTINCT Predicate; 7.13 Type Predicate; 7.14 Search Conditions; 7.15 Chapter Summary; Chapter 8. Working with Multiple Tables: The Relational Operators; 8.1 Introduction; 8.2 Join Operations: An Overview; 8.3 Types of Join Operations; 8.4 The UNION Operator; 8.5 UNION JOIN; 8.6 The INTERSECT and EXCEPT Operators; 8.7 Another Example; 8.8 Chapter Summary; Chapter 9. Advanced SQL Query Expressions; 9.1 Introduction; 9.2 Query Specifications
- 9.3 Functional Dependencies: Rules for Updatability9.4 Query Expressions; 9.5 Joined Table; 9.6 Grouped Tables; 9.7 Result Data Types of Columns of UNION, EXCEPT, and INTERSECT; 9.8 Sequence of Evaluation within Query Expression; 9.9 Table Value Constructor; 9.10 Subqueries; 9.11 Table References; 9.12 CUBE and ROLLUP; 9.13 Recursive Queries; 9.14 Chapter Summary; Chapter 10. Constraints, Assertions, and Referential Integrity; 10.1 Introduction; 10.2 Column Constraints and Table Constraints; 10.3 Assertions; 10.4 PRIMARY KEY; 10.5 Referential Integrity; 10.6 Multiple Cascades
- 10.7 More about Referential Integrity Constraints
