Beginning T-SQL 2012

✍ Scribed by Scott Shaw, Kathi Kellenberger (auth.)

• Publisher: Apress
• Year: 2012
• Tongue: English
• Leaves: 447
• Edition: 2
• Category: Library

✦ Synopsis

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

✦ Table of Contents

Front Matter....Pages i-xxi
Getting Started....Pages 1-33
Writing Simple SELECT Queries....Pages 35-77
Using Functions and Expressions....Pages 79-129
Querying Multiple Tables....Pages 131-167
Grouping and Summarizing Data....Pages 169-202
Manipulating Data....Pages 203-240
Understanding T-SQL Programming Logic....Pages 241-283
Working with XML....Pages 285-310
Moving Logic to the Database....Pages 311-365
Working with Data Types....Pages 367-390
Writing Advanced Queries....Pages 391-417
Where to Go Next?....Pages 419-422
Back Matter....Pages 423-433

✦ Subjects

Computer Science, general; Database Management