1. Understanding SQL -- 2. Introducing SQL Server -- 3. Working with SQL Server -- 4. Retrieving data -- 5. Sorting retrieved data -- 6. Filtering data -- 7. Advanced data filtering -- 8. Using wildcard filtering -- 9. Creating calculated fields -- 10. Using data manipulation functions -- 11. Summarizing data -- 12. Grouping data -- 13. Working with subqueries -- 14. Joining tables -- 15. Creating advanced joins -- 16. Combining queries -- 17. Full-text searching -- 18. Inserting data -- 19. Updating and deleting data -- 20. Creating and manipulating tables -- 21. Using views -- 22. Programming with T-SQL -- 23. Working with stored procedures -- 24. Using cursors -- 25. Using triggers -- 26. Managing transaction processing -- 27. Working with XML -- 28. Globalization and localization -- 29. Managing security -- 30. Improving performance -- App. A. Getting started with SQL Server and T-SQL -- App. B. The example tables -- App. C. T-SQL statement syntax -- App. D. SQL datatypes -- App. E. T-SQL reserved words
