Skip to main content
  • Book
  • © 2012

Beginning T-SQL 2012

Apress
  • Beginning T-SQL 2012 is the first step toward learning the T-SQL language that underlies Microsoft’s SQL Server database engine.

Buy it now

Buying options

eBook USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 49.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

This is a preview of subscription content, log in via an institution to check for access.

Table of contents (12 chapters)

  1. Front Matter

    Pages i-xxi
  2. Getting Started

    • Scott Shaw, Kathi Kellenberger
    Pages 1-33
  3. Writing Simple SELECT Queries

    • Scott Shaw, Kathi Kellenberger
    Pages 35-77
  4. Using Functions and Expressions

    • Scott Shaw, Kathi Kellenberger
    Pages 79-129
  5. Querying Multiple Tables

    • Scott Shaw, Kathi Kellenberger
    Pages 131-167
  6. Grouping and Summarizing Data

    • Scott Shaw, Kathi Kellenberger
    Pages 169-202
  7. Manipulating Data

    • Scott Shaw, Kathi Kellenberger
    Pages 203-240
  8. Understanding T-SQL Programming Logic

    • Scott Shaw, Kathi Kellenberger
    Pages 241-283
  9. Working with XML

    • Scott Shaw, Kathi Kellenberger
    Pages 285-310
  10. Moving Logic to the Database

    • Scott Shaw, Kathi Kellenberger
    Pages 311-365
  11. Working with Data Types

    • Scott Shaw, Kathi Kellenberger
    Pages 367-390
  12. Writing Advanced Queries

    • Scott Shaw, Kathi Kellenberger
    Pages 391-417
  13. Where to Go Next?

    • Scott Shaw, Kathi Kellenberger
    Pages 419-422
  14. Back Matter

    Pages 423-433

About this book

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

About the authors

strongKathi Kellenberger/strong is a consultant with Linchpin People. She enjoys writing and speaking on SQL Server topics, having written over two dozen articles, contributed to four books, and presented at many SQL Server events. In her spare time, Kathi enjoys spending time with family and friends, singing and cycling.

Bibliographic Information

Buy it now

Buying options

eBook USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 49.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access