Introduction to SQL: Mastering the Relational Database Language / Edition 3
by Rick Van Der LansSQL was, is and always will be the database language for relational database systems such as Oracle, DB2, Sybase, Informix and Microsoft SQL Server. Introduction to SQL describes in depth the full capacity of SQL as it is implemented by the commercial databases, without neglecting the most recent changes to the standard, bringing the book up to date and fully… See more details below
Overview
SQL was, is and always will be the database language for relational database systems such as Oracle, DB2, Sybase, Informix and Microsoft SQL Server. Introduction to SQL describes in depth the full capacity of SQL as it is implemented by the commercial databases, without neglecting the most recent changes to the standard, bringing the book up to date and fully compliant with SQL3. Unique in the extent of its coverage, this book takes you from the beginning to the end of SQL, the concepts to the practice, the apprentice to the master.
Product Details
- ISBN-13:
- 9780201596182
- Publisher:
- Addison-Wesley
- Publication date:
- 11/12/1999
- Edition description:
- Older Edition
- Pages:
- 720
- Product dimensions:
- 6.86(w) x 9.24(h) x 1.41(d)
Table of Contents
| Preface | ||
| I | Introduction | |
| 1 | Introduction to SQL 1 | 3 |
| 2 | The tennis club sample database | 28 |
| 3 | Working with SOLID | 37 |
| 4 | SQL in a nutshell | 52 |
| II | Querying and updating data | |
| 5 | SELECT statement: common elements | 71 |
| 6 | Clauses of the SELECT statement | 100 |
| 7 | The SELECT statement: the FROM clause | 111 |
| 8 | SELECT statement the WHERE clause | 126 |
| 9 | SELECT statement: the SELECT clause and functions | 177 |
| 10 | SELECT statement: GROUP BY and HAVING | 200 |
| 11 | SELECT statement: the ORDER BY clause | 218 |
| 12 | Combining SELECT statements | 227 |
| 13 | The subquary | 249 |
| 14 | The FROM clause extended | 275 |
| 15 | Updating tables | 309 |
| III | Creating database objects | |
| 16 | Creating tables | 325 |
| 17 | Specifying constraints | 346 |
| 18 | Designing tables | 365 |
| 19 | Using indexes | 378 |
| 20 | Views | 405 |
| 21 | Users and data security | 425 |
| 22 | Catalog tables | 441 |
| IV | Programming with SQL | |
| 23 | Introduction to embedded SQL | 451 |
| 24 | Transactions and multi-user usage | 487 |
| 25 | Introduction to ODBC | 507 |
| 26 | Optimization of statements | 544 |
| V | Procedural database objects | |
| 27 | Stored procedures | 563 |
| 28 | Triggers | 583 |
| VI | Object relational concepts | |
| 29 | User-defined data types, functions and operators | 599 |
| 30 | Inheritance, references and collections | 617 |
| 31 | The future of SQL | 638 |
| App. A | Syntax of SQL | 641 |
| App. B | Scalar functions | 667 |
| App. C Bibliography | 681 | |
| Index | 683 |
Customer Reviews
Average Review: