Книга "Beginning T-SQL. A Step-by-Step Approach". 1. Getting Started 2. Exploring Database Concepts 3. Writing Simple SELECT Queries4. Using Built-In Functions and Expressions5. Joining Tables6. Building on Subqueries, Common Table Expressions, and Unions7. Grouping and Summarizing Data8. Discovering Windowing Functions9. Advanced WHERE Clauses10. Manipulating Data11. Managing Transactions12. Understanding T-SQL Programming Logic13. Implementing Logic in the Database 14. Expanding on Data Type Concepts15. Working with XML and JSON16. Writing Advanced Queries17. Where to Go Next?Appendix A: SQL Server for Linux and macOSAppendix B: Using SSMSAppendix C: SQL Notebooks