| Description |
xx, 695 pages : illustrations ; 24 cm + 1 computer laser optical disc (4 3/4 in.) |
| Contents |
I. Introduction. 1. Introduction to SQL 1. 2. The tennis club sample database. 3. Working with SOLID. 4. SQL in a nutshell -- II. Querying and updating data. 5. SELECT statement: common elements. 6. Clauses of the SELECT statement. 7. The SELECT statement: the FROM clause. 8. SELECT statement the WHERE clause. 9. SELECT statement: the SELECT clause and functions. 10. SELECT statement: GROUP BY and HAVING. 11. SELECT statement: the ORDER BY clause. 12. Combining SELECT statements. 13. The subquary. 14. The FROM clause extended. 15. Updating tables -- III. Creating database objects. 16. Creating tables. 17. Specifying constraints. 18. Designing tables. 19. Using indexes. 20. Views. 21. Users and data security. 22. Catalog tables -- IV. Programming with SQL. 23. Introduction to embedded SQL. 24. Transactions and multi-user usage. 25. Introduction to ODBC. 26. Optimization of statements -- V. Procedural database objects. 27. Stored procedures. 28. Triggers -- VI. Object relational concepts. 29. User-defined data types, functions and operators. 30. Inheritance, references and collections. 31. The future of SQL. App. A. Syntax of SQL -- App. B. Scalar functions |
| Summary |
"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."--BOOK JACKET |
| Notes |
"The SQL product SOLID is provided on the CD-ROM included in the book. We strongly advise you to use it when doing the exercises" -- introduction |
|
Previous ed.: 1993 |
| Bibliography |
Includes bibliographical references and index |
| Notes |
System requirements: Windows 95 or NT; 2 MB of free hard drive space |
| Subject |
SQL (Computer program language)
|
| LC no. |
00002130 |
| ISBN |
0201596180 (paperback) |
|
