SQL: A Beginner's Guide, Second Edition (Paperback, 2nd)

Part I: SQL Databases

1: Introduction to Relational Databases and SQL

2: Working with the SQL Environment

3: Creating and Altering Tables

4: Enforcing Data Integrity

5: Creating SQL Views

6: Managing Database Security

Part II: Data Access and Modification

7: Querying SQL Data

8: Modifying SQL Data

9: Using Predicates

10: Working with Functions and Value Expressions

11: Accessing Multiple Tables

12: Using Subqueries to Access and Modify Data

Part III: Advanced Data Access

13: Creating SQL-Invoked Routines

14: Creating SQL Triggers

15: Using SQL Cursors

16: Managing SQL Transactions

17: Accessing SQL Data from Your Host Program

Part IV: Appendixes

A: Answers to Mastery Checks

B: SQL:1999 Keywords

C: SQL Code Used in the Book’s Projects