Join Amazon Prime and get unlimited Free One-Day Delivery. Already a member? Sign in.

 

or
Sign in to turn on 1-Click ordering.
 
   
More Buying Choices
30 used & new from £14.40

Have one to sell? Sell yours here
 
   
Beginning Transact-SQL with SQL Server 2000 and 2005
 
 

Beginning Transact-SQL with SQL Server 2000 and 2005 (Paperback)

by Paul Turley (Author), Dan Wood (Author) "Welcome to the world of Transact-Structured Query Language programming ..." (more)
4.0 out of 5 stars See all reviews (1 customer review)
RRP: £25.99
Price: £16.89 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £9.10 (35%)
In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

Only 4 left in stock--order soon (more on the way).

Want guaranteed delivery by Wednesday, July 8? Choose Express delivery at checkout. See Details
23 new from £15.48 7 used from £14.40

Frequently Bought Together

Beginning Transact-SQL with SQL Server 2000 and 2005 + Sams Teach Yourself Transact-SQL in 21 Days + Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes
Price For All Three: £42.87

Show availability and shipping details


Customers Who Bought This Item Also Bought

Inside Microsoft® SQL Server™ 2005: T-SQL Querying (Solid Quality Learning)

Inside Microsoft® SQL Server™ 2005: T-SQL Querying (Solid Quality Learning)

by Lubor Kollar, Dejan Sarka Itzik Ben-Gan (Solid Quality Learning)
4.8 out of 5 stars (10)  £23.07
Inside Microsoft® SQL Server™ 2005: T-SQL Programming (Solid Quality Learning)

Inside Microsoft® SQL Server™ 2005: T-SQL Programming (Solid Quality Learning)

by Dejan Sarka; Roger Wolter Itzik Ben-Gan (Solid Quality Learning)
5.0 out of 5 stars (2)  £23.07
Sams Teach Yourself Transact-SQL in 21 Days

Sams Teach Yourself Transact-SQL in 21 Days

by Lowell Mauer
4.7 out of 5 stars (19)  £18.84
Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes

by Ben Forta
5.0 out of 5 stars (4)  £7.14
Beginning SQL Server 2005 Programming (Programmer to Programmer)

Beginning SQL Server 2005 Programming (Programmer to Programmer)

by Robert Vieira
4.0 out of 5 stars (2)  £16.89
Explore similar items

Product details

  • Paperback: 600 pages
  • Publisher: John Wiley & Sons (25 Oct 2005)
  • Language English
  • ISBN-10: 076457955X
  • ISBN-13: 978-0764579554
  • Product Dimensions: 22.9 x 18.8 x 3.6 cm
  • Average Customer Review: 4.0 out of 5 stars See all reviews (1 customer review)
  • Amazon.co.uk Sales Rank: 318,846 in Books (See Bestsellers in Books)

    Popular in this category:

    #51 in  Books > Computing & Internet > Databases > Beginners & Introduction > Introduction
  • See Complete Table of Contents

Customers Viewing This Page May Be Interested in These Sponsored Links

  (What is this?)
Sql Server 2000
   www.rackspace.co.uk/databasehosting    Fast, secure SQL hosting. Award winning support 24/7. 
Optimize SQL Server 2000
   www.Confio.com    Improve SQL Server Performance 65%, Save on Costs, Free Trial Download! 
Dell Servers
   www.Dell.com/uk    Wide Range Of Great Value Servers At Discounted Prices. Hurry Now! 
  
 

Product Description

Product Description
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.

From the Back Cover
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.

See all Product Description


Inside This Book (Learn More)
First Sentence
Welcome to the world of Transact-Structured Query Language programming. Read the first page
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Suggested Tags from Similar Products

 (What's this?)
Be the first one to add a relevant tag (keyword that's strongly related to this product)
Check a corresponding box or enter your own tags in the field below
technical
sql server 2005 t-sql
sql server 2005
sql

Your tags: Add your first tag
 

What Do Customers Ultimately Buy After Viewing This Item?

Beginning Transact-SQL with SQL Server 2000 and 2005
52% buy the item featured on this page:
Beginning Transact-SQL with SQL Server 2000 and 2005 4.0 out of 5 stars (1)
£16.89
Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes
20% buy
Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes 5.0 out of 5 stars (4)
£7.14
Sams Teach Yourself Transact-SQL in 21 Days
15% buy
Sams Teach Yourself Transact-SQL in 21 Days 4.7 out of 5 stars (19)
£18.84
Sams Teach Yourself SQL in 10 Minutes
7% buy
Sams Teach Yourself SQL in 10 Minutes 4.2 out of 5 stars (34)
£7.14

 

Customer Reviews

1 Review
5 star:    (0)
4 star:
 (1)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
4.0 out of 5 stars (1 customer review)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
11 of 11 people found the following review helpful:
4.0 out of 5 stars Serviceable...not great, just OK, 14 Jan 2006
Transact-SQL is the SQL Server dialect of the SQL language so if you are an Oracle or MySQL body (or any other DBMS except SQL Server), this book is not for you.

If you are looking for a book on SQL Server administration, please look elsewhere. This is not the book for you, as it covers the Transact-SQL language and nothing else.

Phew...now that we've gotten that out of the way, we can discuss the actual book. If you're new to SQL and use SQL Server exclusively, then this book is pretty darn good. I don't agree with the author that programming experience is helpful, though if all you need to do is write simple queries, this book is more than you need; check out Sam's Teach Yourself SQL in 10 Minutes. If you need to go beyond simple SELECT and INSERT and tap into aggregates, stored procedures, cursors, triggers, and views, then this book is certainly a serviceable tutorial, though I feel that the author focused too much on the HOW of Transact-SQL and not enough on the WHY. It's all well and good to teach us how to program a stored procedure, but in my opinion the book lacked practical advice on how to implement these new skills. Maybe that's where the 'programming experience helpful' part comes in, but I've found that I use the book far less than I thought I would.

If you're already fairly comfortable with SQL and need to do serious programming using SQL Server, Robert Vieira's Professional Programming in SQL Server 2000 is a better bet, and it includes a brief Transact-SQL tutorial. If you are looking for a Transact-SQL reference, this book will not fit the bill; I found it to be a poor reference (because it's an instruction manual), though it is well-indexed. I also found that it did not cover certain functions (namely CAST() and CONVERT()) clearly enough.

However, if you're a programmer who is new to the Transact-SQL language and don't know anything about writing queries and don't need to know much about SQL Server's administrative features, then this may very well be the book for you.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Only search this product's reviews



Customer Discussions

 Beta (What's this?)
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
  [Cancel]

   


Listmania!


Look for similar items by category


Look for similar items by subject


Feedback


Microsoft SQL Server 2000 Bible

Microsoft SQL Server...

"Something for everyone . . . this book includes examples to... Read more
£35.50 £30.18

Find similar items

 

More From Paul Turley

Professional SQL Server...

Professional SQL Server 2005...

SQL Server Reporting Services is the customizable reporting solution... Read more
£25.99 £19.49

 

We've Got Converse

Converse
Stock up on your favourite styles with great deals on Converse shoes.

Shop Converse

 

Treat Someone

Amazon.co.uk Gift Certificates--available in any amount from £5 to £500 With an Amazon.co.uk Gift Certificate, you can get them what they want (even if you don't know what that is).

Learn more about Gift Certificates

 
Ad

Where's My Stuff?

Delivery and Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

Look to the right column to find helpful suggestions for your shopping session.

Continue Shopping: Top Sellers

amazon.co.uk Amazon Home
International Sites:  United States  |  Germany  |  France  |  Japan  |  Canada  |  China
Business Programs: Sell on Amazon  |  Fulfilment by Amazon  |  Join Associates  |  Join Advantage
Customer Service  |  Help  |  View Basket  |  Your Account
About Amazon.co.uk  |  Careers at Amazon
Conditions of Use & Sale |  Privacy Notice  © 1996-2009, Amazon.com, Inc. and its affiliates