Introduction to SQL Book

	Preface
1	Introduction	1
2	The tennis club sample database	13
3	Quadbase and entering SQL statements	21
4	SQL in a nutshell	39
5	Creating schemas	53
6	Creating tables	61
7	SELECT statement: common elements	79
8	Clauses of the SELECT statement	97
9	SELECT statement: the FROM clause	105
10	SELECT statement: the WHERE clause	117
11	SELECT statement: SELECT clause and functions	149
12	SELECT statement: GROUP BY and HAVING	167
13	SELECT statement: the ORDER BY clause	181
14	Combining SELECT statements	189
15	The subquery	207
16	SELECT statement: the join	223
17	Developing reports with Quadbase	239
18	Updating tables	255
19	Introduction to embedded SQL	265
20	Transactions and multi-user usage	295
21	Specifying integrity rules	311
22	Using indexes	323
23	Optimizing SQL statements	337
24	Views	349
25	Users and data security	365
26	Catalog tables	377
27	Database design guidelines	393
	Appendix A Answers	405
	Appendix B Syntax of SQL	437
	Appendix C Scalar functions	453
	Appendix D ASCII character set	459
	Appendix E Bibliography	463
	Index	465