Ch. 1. Introduction -- Ch. 2. Creating Tables and Indexes -- Ch. 3. Single Table Query Basics -- Ch. 4. Adding Power to Queries -- Ch. 5. Aggregate Functions and Grouping of Data -- Ch. 6. Joins -- Ch. 7. Subqueries -- Ch. 8. Views and Synonyms -- Ch. 9. Additional Functions -- Ch. 10. Stored Procedures and Triggers -- Ch. 11. SQL Server Database Administration -- Ch. 12. Embedded SQL -- App. A. Company Database Schema -- App. B. Riverbend Hospital Case -- App. C. End-of Chapter Solutions to Odd-Numbered Exercises.