Advertisement

Beginning T-SQL 2012

  • Authors
  • Scott Shaw
  • Kathi Kellenberger

Table of contents

  1. Front Matter
    Pages i-xxi
  2. Scott Shaw, Kathi Kellenberger
    Pages 1-33
  3. Scott Shaw, Kathi Kellenberger
    Pages 35-77
  4. Scott Shaw, Kathi Kellenberger
    Pages 79-129
  5. Scott Shaw, Kathi Kellenberger
    Pages 131-167
  6. Scott Shaw, Kathi Kellenberger
    Pages 169-202
  7. Scott Shaw, Kathi Kellenberger
    Pages 203-240
  8. Scott Shaw, Kathi Kellenberger
    Pages 241-283
  9. Scott Shaw, Kathi Kellenberger
    Pages 285-310
  10. Scott Shaw, Kathi Kellenberger
    Pages 311-365
  11. Scott Shaw, Kathi Kellenberger
    Pages 367-390
  12. Scott Shaw, Kathi Kellenberger
    Pages 391-417
  13. Scott Shaw, Kathi Kellenberger
    Pages 419-422
  14. Back Matter
    Pages 423-433

About this book

Introduction

Beginning T-SQL 2012 is the first step toward learning the T-SQL language that underlies Microsoft’s SQL Server database engine. T-SQL is essential in writing SQL statements to get data into and out of a database. T-SQL is the foundation for business logic embedded in the database in the form of stored procedures and functions. Beginning T-SQL 2012 starts you on the path to mastering T-SQL, with an emphasis on best practices and sound coding techniques.

Beginning T-SQL 2012 begins with an introduction to databases, normalization, and to SQL Server Management Studio. Each subsequent chapter teaches an aspect of T-SQL, building on the skills learned in previous chapters. Exercises in each chapter give readers an opportunity for the hands-on practice that leads to true learning and distinguishes the competent professional.

  • Imparts best practices for writing T-SQL
  • Helps you avoid common errors
  • Shows how to write scalable code for good performance

Bibliographic information