Topic: SQL Server

Beginning T-SQL with Microsoft SQL Server 2005 and 2008 (0470440481) cover image

Beginning T-SQL with Microsoft SQL Server 2005 and 2008

Paul Turley, Dan Wood
ISBN: 978-0-470-44048-3
676 pages
December 2008
Other Available Formats: Paperback
Electronic Version: US $25.99 Purchase This E-book

About This Title  |  Errata  |  P2P Forum for This Title
Table of Contents

Chapter 1: Introducing T-SQL and Data Management Systems.

Chapter 2: SQL Server Fundamentals.

Chapter 3: SQL Server Tools.

Chapter 4: Introducing the T-SQL Language.

Chapter 5: Data Retrieval.

Chapter 6: SQL Functions.

Chapter 7: Aggregation and Grouping.

Chapter 8: Multi-Table Queries.

Chapter 9: Advanced Queries and Scripting.

Chapter 10: Transactions.

Chapter 11: Advanced Capabilities.

Chapter 12: T-SQL Programming Objects.

Chapter 13: Creating and Managing Database Objects.

Chapter 14: Analyzing and Optimizing Query Performance.

Chapter 15: T-SQL in Applications and Reporting.

Appendix A: Command Syntax Reference.

Appendix B: System Variables and Functions Reference.

Appendix C: System Stored Procedure Reference.

Appendix D: Information Schema Views Reference.

Appendix E: FileStream Objects and Syntax.

Appendix F: Answers to Exercises.