Beginning T-SQL with Microsoft SQL Server 2005 and 2008
Publisher: Wiley / Wrox
Final Release Date: December 2008
Pages: 676

Beginning T-SQL with Microsoft® SQL Server® 2005 and2008

Nearly all business applications read, store, and manipulatedata stored in relational databases. If you use Microsoft SQLServer in any way, you need to learn and use T-SQL,?Microsoft'spowerful implementation of the ANSI-standard SQL database querylanguage.

This book teaches all of the basics of T-SQL as it's used withSQL Server 2005 and 2008 databases. The authors, leading T-SQLexperts, begin with the essentials of SQL Server that are needed toget the most from T-SQL. They then quickly move on to introduceT-SQL itself, including the core elements of data retrieval, SQLfunctions, aggregation and grouping, and multi-table queries, andthey fully explain transaction processing and data manipulationusing T-SQL.

The authors also show you how to create and manage T-SQLprogramming objects, including views, functions, and storedprocedures. They detail how to optimize T-SQL query performance anddesign queries for real-world business applications. All of themethods and techniques in this book can be used with both MicrosoftSQL Server 2005 and 2008 databases.

In addition, the book includes a comprehensive set of referenceappendices, including T-SQL command syntax, system variables andfunctions, system stored procedures, information schema views, andFileStream objects.

What you will learn from this book

  • How to add, modify, and remove records

  • How to query multiple tables

  • Ways to use views to modify data

  • How to create tools for managing databases using T-SQL

  • T-SQL programming techniques using views, user-definedfunctions, and stored procedures

  • Methods for optimizing?query performance

  • How to use?SQL Server Reporting Services to visualize T-SQLquery results

Who this book is for
This book is for beginning SQL Server developers andadministrators who need to learn how to use T-SQL. Basicfamiliarity with relational databases and a general understandingof?basic SQL functions is necessary.

Wrox Beginning guides are crafted to make learningprogramming languages and technologies easier than you think,providing a structured, tutorial format that will guide you throughall the techniques involved.

Product Details
About the Author
Recommended for You
Customer Reviews
 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook: $39.99
Formats:  ePub, Mobi, PDF