Chapter 1 SQL, Vendor Implementations, and Some History

1. The Relational Database Model

2. The Databases Described in This Book

3. The SQL Standard

4. Dialects of SQL

5. Principles of Relational Databases

Chapter 2 Foundational Concepts

1. Row Processing Versus Set Processing

2. The Relational Model

3. SQL99 and Vendor-Specific Datatypes

4. Processing NULLS

5. Categories of Syntax

6. Using SQL

7. Conclusion

Chapter 3 SQL Statements Command Reference

1. Recommended Reading Approach

2. Quick SQL Command Reference

3. ALTER PROCEDURE

4. ALTER TABLE

5. ALTER TRIGGER

6. ALTER VIEW

7. CALL

8. CASE

9. CAST

10. CLOSE CURSOR

11. COMMIT TRANSACTION

12. Concatenation Operators

13. CONNECT

14. CREATE DATABASE

15. CREATE FUNCTION

16. CREATE INDEX

17. CREATE PROCEDURE

18. CREATE ROLE

19. CREATE SCHEMA

20. CREATE TABLE

21. CREATE TRIGGER

22. CREATE VIEW

23. DECLARE CURSOR

24. DELETE

25. DISCONNECT

26. DROP Statements

27. DROP DATABASE

28. DROP FUNCTION

29. DROP INDEX

30. DROP PROCEDURE

31. DROP ROLE

32. DROP TABLE

33. DROP TRIGGER

34. DROP VIEW

35. FETCH

36. GRANT

37. INSERT

38. LIKE Operator

39. OPEN

40. Operators

41. RETURN

42. REVOKE

43. ROLLBACK

44. SAVEPOINT

45. SELECT

46. SET CONNECTION

47. SET ROLE

48. SET TIME ZONE

49. SET TRANSACTION

50. START TRANSACTION

51. TRUNCATE TABLE

52. UPDATE

53. Conclusion

Chapter 4 SQL Functions

1. Deterministic and Nondeterministic Functions

2. Types of Functions

3. Vendor Extensions

Chapter 5 Unimplemented SQL99 Commands