Description |
1 online resource |
Contents |
1. Introduction to SQL -- 2. tennis club sample database -- 3. Installing the software -- 4. SQL in a nutshell -- 5. SELECT statement : common elements -- 6. SELECT statements, table expressions, and subqueries -- 7. SELECT statement : the FROM clause -- 8. SELECT statement : the WHERE clause -- 9. SELECT statement : SELECT clause and aggregation functions -- 10. SELECT statement : the GROUP BY clause -- 11. SELECT statement : the HAVING clause -- 12. SELECT statement : the ORDER BY clause -- 13. Combining table expressions -- 14. Updating tables -- 15. Creating tables -- 16. Specifying integrity contraints -- 17. Character sets and collating sequences -- 18. Changing and dropping tables -- 19. Designing tables -- 20. Using indexes -- 21. Views -- 22. Creating databases -- 23. Users and data security -- 24. Creating sequences -- 25. Creating schemas -- 26. Introduction to embedded SQL -- 27. Transactions and multi-user usage -- 28. Introduction to ODBC -- 29. Optimization of statements -- 30. Stored procedures -- 31. Stored functions -- 32. Triggers -- 33. User-defined data types, functions, and operators -- 34. Inheritance, references, and collections -- 35. future of SQL |
Bibliography |
Includes bibliographical references and index |
Notes |
Print version record |
Subject |
SQL (Computer program language)
|
|
SQL (Computer program language)
|
|
SQL (Computer program language)
|
Form |
Electronic book
|
Author |
Cools, Diane
|
ISBN |
0321305965 |
|
9780321305961 |
|