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

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: £22.09 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £3.90 (15%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

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

Want guaranteed delivery by Friday, November 13? Choose Express delivery at checkout. See Details
25 new from £11.74 6 used from £11.66

Frequently Bought Together

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

Show availability and delivery details


Customers Who Bought This Item Also Bought

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)  £5.47
Inside SQL Server 2005: T-SQL Programming (Solid Quality Learning)

Inside 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)  £20.08
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)  £14.49
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.9 out of 5 stars (11)  £27.27
SQL Server 2005 Administrator's Pocket Consultant (Pro-Administrator's Pocket Consultant)

SQL Server 2005 Administrator's Pocket Consultant (Pro-Administrator's Pocket Consultant)

by William R. Stanek
4.5 out of 5 stars (2)  £13.21
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: 412,524 in Books (See Bestsellers in Books)

    Popular in this category:

    #48 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 opens new browser window
www.rackspace.co.uk/databasehosting  -  Fast, secure SQL hosting. Award winning support 24/7. 
   Write Better Transact SQL opens new browser window
Red-Gate.com/Transact SQL  -  SQL Prompt™ completes and formats your T-SQL code. Free 14-day trial. 
   The SQL Server Experts opens new browser window
www.coeo.com  -  Complex upgrade requirements? We can take you through the options 
  
 

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.


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)
 
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?


 

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

This product's forum
Discussion Replies Latest Post
No discussions yet

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

   


Listmania!


Look for similar items by category


Look for similar items by subject


Feedback

Ad

Your Recent History

 (What's this?)

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