Introduction to SQL

Learn how to:

• Query data
• Update data
• Create tables and views
• Specify primary and foreign keys
• Use indexes
• Secure your data
• Develop stored procedures and triggers
• Develop applications with embedded SQL and ODBC
• Carry out transactions
• Optimize statements
• Deal with object-relational concepts such as subtables, references, sets and user-defined data types.

• Preface
• 1. Introduction
• 2. The tennis club sample database
• 3. Quadbase and entering SQL statements
• 4. SQL in a nutshell
• 5. Creating schemas
• 6. Creating tables
• 7. SELECT statement: common elements
• 8. Clauses of the SELECT statement
• 9. SELECT statement: the FROM clause
• 10. SELECT statement: the WHERE clause
• 11. SELECT statement: SELECT clause and functions
• 12. SELECT statement: GROUP BY and HAVING
• 13. SELECT statement: the ORDER BY clause
• 14. Combining SELECT statements
• 15. The subquery
• 16. SELECT statement: the join
• 17. Developing reports with Quadbase
• 18. Updating tables
• 19. Introduction to embedded SQL
• 20. Transactions and multi-user usage
• 21. Specifying integrity rules
• 22. Using indexes
• 23. Optimizing SQL statements
• 24. Views
• 25. Users and data security
• 26. Catalog tables
• 27. Database design guidelines
• Appendix A Answers
• Appendix B Syntax of SQL
• Appendix C Scalar functions
• Appendix D ASCII character set
• Appendix E Bibliography
• Index