CDN$ 39.17
  • List Price: CDN$ 47.99
  • You Save: CDN$ 8.82 (18%)
In Stock.
Ships from and sold by Gift-wrap available.
Beginning T-SQL with Micr... has been added to your Cart
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 3 images

Beginning T-SQL with Microsoft SQL Server 2005 and 2008 Paperback – Nov 17 2008

See all 3 formats and editions Hide other formats and editions
Amazon Price
New from Used from
Kindle Edition
"Please retry"
"Please retry"
CDN$ 39.17
CDN$ 21.44 CDN$ 22.51

Save An Additional 10% on Textbooks When you Join Amazon Student
click to open popover

Special Offers and Product Promotions

No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

Product Details

  • Paperback: 672 pages
  • Publisher: Wrox; Pap/Dol edition (Nov. 17 2008)
  • Language: English
  • ISBN-10: 0470257032
  • ISBN-13: 978-0470257036
  • Product Dimensions: 18.8 x 3.3 x 23.4 cm
  • Shipping Weight: 953 g
  • Average Customer Review: Be the first to review this item
  • Amazon Bestsellers Rank: #675,718 in Books (See Top 100 in Books)
  •  Would you like to update product info, give feedback on images, or tell us about a lower price?

  • See Complete Table of Contents

Product Description

From the Back Cover

Beginning T-SQL with Microsoft® SQL Server® 2005 and 2008

Nearly all business applications read, store, and manipulate data stored in relational databases. If you use Microsoft SQL Server in any way, you need to learn and use T-SQL,?Microsoft's powerful implementation of the ANSI-standard SQL database query language.

This book teaches all of the basics of T-SQL as it's used with SQL Server 2005 and 2008 databases. The authors, leading T-SQL experts, begin with the essentials of SQL Server that are needed to get the most from T-SQL. They then quickly move on to introduce T-SQL itself, including the core elements of data retrieval, SQL functions, aggregation and grouping, and multi-table queries, and they fully explain transaction processing and data manipulation using T-SQL.

The authors also show you how to create and manage T-SQL programming objects, including views, functions, and stored procedures. They detail how to optimize T-SQL query performance and design queries for real-world business applications. All of the methods and techniques in this book can be used with both Microsoft SQL Server 2005 and 2008 databases.

In addition, the book includes a comprehensive set of reference appendices, including T-SQL command syntax, system variables and functions, system stored procedures, information schema views, and FileStream 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-defined functions, and stored procedures

  • Methods for optimizing?query performance

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

Who this book is for
This book is for beginning SQL Server developers and administrators who need to learn how to use T-SQL. Basic familiarity with relational databases and a general understanding of?basic SQL functions is necessary.

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

About the Author

Paul Turley (Vancouver, WA) is a Manager of Specialized Services for Hitachi Consulting Education Services. Paul manages the Business Intelligence training team and teaches classes for companies throughout the world on Microsoft SQL Server technologies. He works with companies to architect and build BI and reporting solutions. He has been developing business database solutions since 1991 for companies like Microsoft, Disney, Nike, and Hewlett - Packard. He has been a Microsoft Certified Trainer since 1996 and holds several industry certifications, including MCTS and MCITP for BI, MCSD, MCDBA, MSF Practitioner, and IT Project+.
Paul has authored and co - authored several books and courses on database, business intelligence, and application development technologies. He is the lead courseware developer for the Hitachi Consulting courses: SQL Server 2008 Business Intelligence Solutions and SQL Server 2008 Reporting Services Solutions. Books include the prior edition of this book, the 2008, 2005 and 2000 editions of Professional SQL Server Reporting Services , Beginning SQL Server 2005 Administration , Beginning Access 2002 VBA , Data Warehousing with SQL Server 2000 Analysis Services , and Professional Access 2000 Programming — all from Wrox. He is also a contributing author for SQL Server 2005 Integration Services Step by Step from Microsoft Press.

Dan Wood (Silverdale, WA) is the senior database administrator for Avalara, a sales tax compliance company, where he both administers and develops database solutions for several enterprise applications that handle global address validation, tax rate calculation, and sales tax remittance for e - commerce and ERP clients. He has been working with SQL Server as a DBA, consultant, and trainer since 1999. Dan was a contributing author on Beginning Transact - SQL with SQL Server 2000 and 2005 and the lead author of Beginning SQL Server Administration , both from Wrox.

Customer Reviews

There are no customer reviews yet on
5 star
4 star
3 star
2 star
1 star

Most Helpful Customer Reviews on (beta) 4.4 out of 5 stars 12 reviews
3 of 3 people found the following review helpful
4.0 out of 5 stars Kiss your beginner status goodbye... Nov. 28 2009
By ewomack - Published on
Format: Paperback
Microsoft's now ubiquitous SQL Server database engine is far more complicated than it first appears. Apart from the voluminous administrative tasks it can accomplish and support, it provides a vast set of commands for data retrieval and manipulation known as "Transact-SQL" or "T-SQL." In the spirit of Wrox books, this book is big, red, and dedicated to a single topic: this very T-SQL toolset.

Fifteen chapters comprising over 600 pages covers everything a T-SQL beginner needs. Introductory chapters provide background information on Relational Databases, the versions of SQL Server, database normalization, and tools available in SQL Server (many of which are beyond this book's scope).

A detailed discussion of T-SQL syntax finally appears in Chapter 4, but the real meat begins in Chapter 5 with the universal command SELECT. Subsequqnt chapters provide explanations and copious code examples (for both SQL Server 2005 and 2008) for SQL Functions (e.g., AVG(), DATEADD(), CONVERT(), etc.), grouping, joins, subqueries, cursors, transactions (with error handling via TRY and CATCH), the handy but unintuitive PIVOT, a discussion of objects (in database speak this means things such as tables, views, procedures and functions), query optimization (with graphical execution plans) and a concluding chapter that rolls T-SQL into an application development and reporting context. Appendices follow with quick references to the tools discussed.

This is a beginner's book. Although it does delve into what some feel are more advanced topics such as transactions and stored procedures, these receive beginner to intermediate level coverage. In any case, even beginners should have some familiarity with these T-SQL features.

Those new to T-SQL or seeking a refresh will find ample discussions of the basics here. This gargantuan book won't get anyone up to speed quickly, but it provides enough detail so that beginners will exit this book as knowledgeable T-SQL users.
4 of 5 people found the following review helpful
4.0 out of 5 stars Good TSQL coverage, with some not so good advice Feb. 2 2010
By K. Ambrose - Published on
Format: Paperback
As a db professional for many years, I bought this to bring me up to speed on the 2005 and 2008 new features and tsql, and I feel it is serving that purpose well for me (I have not yet completed the book). The subject areas are well organized and well covered, and I find the writing style to be lucid and very readable.

I did notice what I consider to be some poor advice (hence only 4 star rating) related to data typings- specifically the advice to use numeric data type for data that would never make sense to apply mathematical operations. The author's rationale' for this is that numeric data is preferred for sorting and comparison over character data.

The flaw in that approach is thinking that a fast answer is better than a correct answer. And also that a fast answer is preferable over user's confusion on the meaning and use of a data item over the course of it's useful life.

Anyone who has been supporting data processing for years will know that half the battle is in keeping the semantics (meaning) of the data that is stored in the DB clear to all stakeholders in an enterprise.

Applying numeric data type to data where mathematical operations on it will produce nonsense practically guarantees that such nonsense will be at least attempted, and perhaps even distributed at some point in an organization. What is the meaning of adding two phone numbers together? Or two social security numbers? It's nonsense. In addition, it is not at all impossible over the course of time that a business concept that uses numerals but is not mathematical may need to include non-numeric characters at a later time- after all it is not mathematical data. When that happens you will be in for a big hassle if you have to change the type for a lot of data.

There are few more fundamental and important needs in database design than getting data types "right". It's too bad this book offers a bit of poor advice in that area.
5.0 out of 5 stars Thank you! I it helped me jump from my MySQL to T-SQL in just the right areas May 22 2013
By ebley - Published on
Format: Paperback Verified Purchase
What I needed from the book was, of course, in the last few chapters since I have been using MySQL for years. I told myserlf to go through all the chapters since I have not read a book on this stuff since 1998 as I use it all the time. "Who knows", I thought " I might need a refresher", BUT I forced myself through the first 12 chapters and I discovered many insightful nuggets about how the MS tool works, how it is optimized and therefore the ways I could steer things. They go through optimzation tests and how to these ourselves. The book is very well laid out, and if you do skip, they cover the important things quickly, but they do so with purpose so you won't miss important concepts. VERY well done with great explainations. Keep writing boys!
4.0 out of 5 stars Beginning T-SQL July 6 2012
By phatmoon - Published on
Format: Paperback Verified Purchase
Beginning T-SQL is a great place to start when you need to get off and running fast. I am the administrator of a 224 unit apartment complex. I began using MySQL but I quickly learned the benefits of using Microsoft Server. Beginning T-SQL allowed me to convert and expand my database in no time at all. If you have time, you can download the AdvertureWorks database and play around with it. I didn't have the time so I just plowed in. This is my goto reference for everything T-SQL.
4.0 out of 5 stars Introduction to SQL Query April 15 2009
By Floyd - Published on
Format: Paperback Verified Purchase
I purchased this book as an introduction to writing query scripts for SQL. We've a large database with many fields and I needed to know how to appropriately join and relate information in a well constructed manner. This book provides starter SQL queries in addition to explaining the foundation of databases (creating, adjusting, queries etc) The query information provided a more descriptive environment than what I had found on the web. A good beginner guide!