Beginning Transact-SQL With SQL Server 2000 and 2005

Beginning Transact-SQL With SQL Server 2000 and 2005
by Paul Turley

Beginning Transact-SQL With SQL Server 2000 and 2005
List Price: $39.99
Our Price: $6.92
You Save: $33.07 (83%)
Availability: Usually ships in 1-2 business days
Category: Book
See more book details and other editions


(Click here)
Buy this book at online book store in your country
Canada | UK | Germany | France

Book Summary Information

Author: Paul Turley
Contributor: Dan Wood
Edition: Paperback
Audio: English (Original Language); English (Unknown); English (Published)
Published: 2005-10-31
ISBN: 076457955X
Number of pages: 600
Publisher: Wrox

Book Reviews of Beginning Transact-SQL With SQL Server 2000 and 2005

Book Review: Does not cover the important new features
Summary: 1 Stars

I bought the book, based on previous positive critics here (Amazon). The implication was that this book covers the new features of SQL Server 2005. Well, the first one that I was looking for, the PIVOT (crosstab) is not even mentioned, let alone covered even briefly. I did not search all the new features, but if you want a book that cover both old and new features, this one is certainly NOT the one that you should look for.
The publisher rep tried to tell me that no one book could cover all subjects. This is true, but for a book that specialize in T-SQL and T-SQL only, the features should have been covered, or, at least mentioned briefly.
I've found books that cover the new features only, or the old features only. The quest is not over for me, yet.
ZA

Summary of Beginning Transact-SQL With SQL Server 2000 and 2005

Beginning Transact-SQL with SQL Server 2000 and 2005

Transact-SQL is a powerful implementation of the ANSI standard SQL database query language. In order to build effective database applications, you must gain a thorough understanding of these features. This book provides you with a comprehensive introduction to the T-SQL language and shows you how it can be used to work with both the SQL Server 2000 and 2005 releases.

Beginning with an overview of the SQL Server query operations and tools that are used with T-SQL, the author goes on to explain how to design and build applications of increasing complexity. By gaining an understanding of the power of the T-SQL language, you'll be prepared to meet the ever-increasing demands of programming.

What you will learn from this book

  • How T-SQL provides you with the means to create tools for managing hundreds of databases
  • Various programming techniques that use views and stored procedures
  • Ways to optimize query performance
  • How to create databases that will be an essential foundation to applications you develop later

Who this book is for

This book is for database developers and administrators who have not yet programmed with Transact-SQL. Some familiarity with relational databases and basic SQL is helpful, and some programming experience is helpful.

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.

General Books

Book Subjects
Most talked about in General Books
Beginning PHP and MySQL: From Novice to Professional, Third Edition (Beginning from Novice to Professional) ImageBeginning PHP and MySQL: From Novice to Professional, Third Edition (Beginning from Novice to Professional)
by W. Jason Gilmore
Apress; Published: 2008-03-24; Paperback; Book
Best price: $25.83
Price in other shops: $46.99
Mastering Regular Expressions ImageMastering Regular Expressions
by Jeffrey Friedl
O'Reilly Media, Inc.; Published: 2006-08-08; Paperback; Book
Best price: $24.69
Price in other shops: $44.99
Microsoft SQL Server 2005 Reporting Services 2005 ImageMicrosoft SQL Server 2005 Reporting Services 2005
by Brian Larson
McGraw-Hill Osborne Media; Published: 2005-12-12; Paperback; Book
Best price: $24.45
Price in other shops: $49.99
PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide ImagePHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide
by Larry Ullman
Peachpit Press; Published: 2007-12-29; Paperback; Book
Best price: $24.07
Price in other shops: $39.99
Microsoft SQL Server 2005 Unleashed ImageMicrosoft SQL Server 2005 Unleashed
by Ray Rankins, Paul Bertucci, Chris Gallelli, Alex T. Silverstein
Sams; Published: 2006-12-31; Paperback; Book
Best price: $35.72
Price in other shops: $59.99
High Performance MySQL: Optimization, Backups, Replication, and More ImageHigh Performance MySQL: Optimization, Backups, Replication, and More
by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko, Jeremy Zawodny, Arjen Lentz, Derek Balling
O'Reilly Media, Inc.; Published: 2008-06-26; Paperback; Book
Best price: $28.46
Price in other shops: $49.99
MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification) ImageMCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)
by Solid Quality Learning
Microsoft Press; Published: 2006-06-28; Hardcover; No Operating System; Book
Best price: $33.94
Price in other shops: $59.99
Sams Teach Yourself SQL in 10 Minutes (3rd Edition) (Sams Teach Yourself) ImageSams Teach Yourself SQL in 10 Minutes (3rd Edition) (Sams Teach Yourself)
by Ben Forta
Sams; Published: 2004-04-10; Paperback; Book
Best price: $11.94
Price in other shops: $19.99
PHP and MySQL Web Development (4th Edition) (Developer's Library) ImagePHP and MySQL Web Development (4th Edition) (Developer's Library)
by Luke Welling, Laura Thomson
Addison-Wesley Professional; Published: 2008-10-11; Paperback; Book
Best price: $31.28
Price in other shops: $49.99
Access 2007: The Missing Manual ImageAccess 2007: The Missing Manual
by Matthew MacDonald
Pogue Press; Published: 2006-12-29; Paperback; Book
Best price: $20.09
Price in other shops: $34.99
Similar Books and other products
Microsoft SQL Server 2005 Unleashed ImageMicrosoft SQL Server 2005 Unleashed
by Ray Rankins, Paul Bertucci, Chris Gallelli, Alex T. Silverstein
Sams; Published: 2006-12-31; Paperback; Book
Best price: $37.55
Price in other shops: $59.99
The Guru's Guide to Transact-SQL ImageThe Guru's Guide to Transact-SQL
by Ken Henderson
Addison-Wesley Professional; Published: 2000-03-04; Paperback; Book
Best price: $36.87
Price in other shops: $64.99
Professional SQL Server 2005 Programming (Programmer to Programmer) ImageProfessional SQL Server 2005 Programming (Programmer to Programmer)
by Robert Vieira
Wrox; Published: 2006-12-01; Paperback; Book
Best price: $26.67
Price in other shops: $49.99
Microsoft SQL Server 2005 Reporting Services 2005 ImageMicrosoft SQL Server 2005 Reporting Services 2005
by Brian Larson
McGraw-Hill Osborne Media; Published: 2005-12-12; Paperback; Book
Best price: $28.02
Price in other shops: $49.99
Professional SQL Server 2005 Reporting Services ImageProfessional SQL Server 2005 Reporting Services
by Paul Turley, Todd Bryant, James Counihan, Dave DuVarney
Wrox; Published: 2006-03-06; Paperback; Book
Best price: $18.99
Price in other shops: $39.99
Inside Microsoft SQL Server 2005: T-SQL Programming (Pro-Developer) ImageInside Microsoft SQL Server 2005: T-SQL Programming (Pro-Developer)
by Itzik Ben-gan, Dejan Sarka, Roger Wolter
Microsoft Press; Published: 2006-06-14; Paperback; Book
Best price: $22.95
Price in other shops: $44.99
 SQL Server 2005 Administration Image SQL Server 2005 Administration
by Dan Wood, Chris Leiter, Paul Turley
Wrox; Published: 2006-11-29; Paperback; Book
Best price: $20.90
Price in other shops: $39.99
Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes (Sams Teach Yourself) ImageSams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes (Sams Teach Yourself)
by Ben Forta
Sams; Published: 2007-08-12; Paperback; Book
Best price: $12.62
Price in other shops: $19.99
Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning) ImageInside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning)
by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka
Microsoft Press; Published: 2006-04-26; Paperback; Book
Best price: $24.89
Price in other shops: $44.99
Beginning SQL Server 2005 Programming (Programmer to Programmer) ImageBeginning SQL Server 2005 Programming (Programmer to Programmer)
by Robert Vieira
Wrox; Published: 2006-02-27; Paperback; Book
Best price: $21.88
Price in other shops: $39.99
Book store. Illustrated catalog of books on different categories