Beginning T-SQL 2008

4.11 - 1251 ratings - Source

Even if you have little or no knowledge of T-SQL, Beginning T-SQL 2008 will bring you up to intermediate level and teach you best practices along the way. You'll learn how to write code that will help you to achieve the best-performing applications possible. You'll find an introduction to databases, normalization, and SQL Server Management Studio. You'll understand how data is stored in a database and learn how to use at least one of the available tools to get to that data. Each subsequent chapter teaches an aspect of T-SQL, building on the skills learned in previous chapters. Exercises are included in each chapter because the only way to learn T-SQL is to write some code. This book will do more than just give the syntax and examples. It will teach you techniques to help you avoid common errors and create robust and well-performing code. Imparts best practices for writing T-SQL Helps readers avoid common errors Shows how to write scalable code that yields good performance What youall learn Understand the fundamentals of relational theory, upon which Transact-SQL is based Write accurate queries that are scalable and perform well Combine set-based and procedural processing, obtaining the best from both worlds Embed business logic in your database through stored procedures and functions Simplify your work through new and advanced features such as common-table expressions and virtual tables Enhance performance by knowing when to apply features such table value parameters Who this book is for This book is for developers who will be writing database applications against SQL Server databases. Table of Contents Getting Started Writing Simple SELECT Queries Using Functions and Expressions Querying Multiple Tables Grouping and Summarizing Data Manipulating Data Understanding T-SQL Programming Logic Moving Logic to the Database Working with New Data Types Writing Advanced Queries Where to Go Next?Chapter 7, aUnderstanding T-SQL Programming Logica: This chapter
demonstrates that T-SQL is more than just data ... This chapter provides
information about resources, many of them free, that you can use to enhance
your skills. Appendix, aSolutions to the Exercisesa: The appendix provides
solutions to the exercises in Chapter 2 through Chapter 8. ... The source code for
this book is available to readers at http://www.apress.com in the Downloads
section of this booka#39;s home page.

Title

:

Beginning T-SQL 2008

Author

:

Kathi Kellenberger

Publisher

:

Apress - 2009-10-15

ISBN-13

:

You must register with us as either a Registered User before you can Download this Book. You'll be greeted by a simple sign-up page.

Once you have finished the sign-up process, you will be redirected to your download Book page.