Beginning Transact-SQL With SQL Server 2000 and 2005 [Paperback]

Paul Turley (Author), Dan Wood (Contributor)

Book Description

Publication Date: October 31, 2005 | ISBN-10: 076457955X | ISBN-13: 978-0764579554 | Edition: 1

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.

Editorial Reviews

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.

About the Author

Paul Turley (Seattle, WA) is a Senior Consultant for Hitachi Consulting, where he architects and develops business reporting solutions and database systems for many high-profile business clients. He has been developing database solutions since 1991 for companies such as Hewlett-Packard, Boise Cascade, Disney, and Microsoft. He has been a Microsoft Certified Professional and Trainer since 1996 and currently holds his MCDBA, MCSD, MSF Practitioner, IT Project+, and A+ certifications.
Paul designed and maintains www.Scout-Master.com, a web-based service that enables Boy Scouts and their leaders to manage their own unit web sites, membership, and advancement records on-line using SQL Server and ASP.NET. Paul has been a contributing or lead author on Professional SQL Server Reporting Services (1st and 2nd editions), Beginning Access 2002 VBA, Professional SQL Server 2000 Data Warehousing with Analysis Services, and Professional Access 2000 Programming from WROX Press.

Dan Wood (Silverdale, WA) is the Operations Manager, Database Administrator, and SQL Server Trainer for Netdesk Corporation, a Microsoft Gold Certified Partner for Learning Solutions in Seattle where he manages and develops database solutions as well as trains database professionals from organizations throughout the Northwest. He has been a Microsoft Certified Professional and Trainer since 1999 and currently holds his MCDBA, MCSD, and MCSE certifications.

Product Details

• Paperback: 600 pages
• Publisher: Wrox; 1 edition (October 31, 2005)
• Language: English
• ISBN-10: 076457955X
• ISBN-13: 978-0764579554
• Product Dimensions: 9.2 x 7.4 x 1.3 inches
• Shipping Weight: 2 pounds (View shipping rates and policies)
• Average Customer Review: 4.0 out of 5 stars  See all reviews (4 customer reviews)
• Amazon Best Sellers Rank: #924,873 in Books (See Top 100 in Books)

More About the Author

Paul Turley (Vancouver, WA) is a Manager of Specialized Services for Hitachi Consulting External 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 Professional SQL Server 2008 Reporting Services, Professional SQL Server 2005 Reporting Services, Professional SQL Server Reporting Services (SQL Server 2000,) Beginning Transact-SQL with SQL Server 2000 and 2005, Beginning SQL Server 2005 Administration, Beginning Access 2002 VBA, Data Warehousing with SQL Server 2000 Analysis Services, and Professional Access 2000 Programming ' from Wrox Press. He is also a contributing author for SQL Server 2005 Integration Services Step by Step from Microsoft Press.

Customer Reviews

Most Helpful Customer Reviews

13 of 13 people found the following review helpful:

5.0 out of 5 stars Practical and Usable, February 28, 2006

By 

James Counihan - See all my reviews
(REAL NAME)   

This review is from: Beginning Transact-SQL With SQL Server 2000 and 2005 (Paperback)

The authors have experience both as T-SQL developers and trainers, and it shows. Essential concepts and techniques are explained clearly without talking down to the reader. There's thorough coverage of the most commonly used T-SQL elements, in an easy-to-read style. It's well organized and includes appendices and a good index, making it easy to use as a reference. I work with both SQL Server 2000 and 2005, so it's ideal that the book covers both environments.

There are tons of code samples; most of them use the AdventureWorks database so reproducing them is easy. The exercises at the end of each chapter are good practice - not too difficult, but still good at reinforcing the content (answers are in the back of the book). Parts of my work involve reporting, so I found the chapter on doing Reporting Services development helpful as well. The biggest drawback I've found to this book is that my copy keeps getting borrowed..

12 of 12 people found the following review helpful:

5.0 out of 5 stars Good for non-techie beginners!, February 22, 2006

By 

Mareth A. Lee (Seattle, WA) - See all my reviews
(REAL NAME)   

This review is from: Beginning Transact-SQL With SQL Server 2000 and 2005 (Paperback)

I don't consider myself a techie but recently became interested in learning more about SQL and how it can help me do my job more efficiently. I found the structure, content and style of this book to be very useful in my quest to teach myself the program. It was easy to understand and helped me to learn the basics with a hands-on approach. My lack of experience caught up to me in some of the later chapters but overall I found the book extremely informative and I've benefited greatly from reading it.

12 of 13 people found the following review helpful:

5.0 out of 5 stars Paul Turley takes my TSQL blues away! Great Book!!, February 17, 2006

By 

Michael Clara (Seattle, WA USA) - See all my reviews
(REAL NAME)   

This review is from: Beginning Transact-SQL With SQL Server 2000 and 2005 (Paperback)

Paul's book was incredibly helpful with completing my T-SQL project. I was struggling with reading some stored procedures and DTS packages and couldn't get my brain around what the heck was going on inside management studio. So... I picked up Beginning Transact-SQL and had those sprocs pegged in no time! Paul made following the code a cinch and I'm now able to write and document ETL in no time. Paul's book really was a life (and job..?) saver!