Beginning T-SQL with Microsoft SQL Server 2005 and 2008

Overview

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

See more details below
Paperback
$26.65
BN.com price
(Save 33%)$39.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (14) from $21.98   
  • New (12) from $21.98   
  • Used (2) from $21.99   

Overview

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.

Read More Show Less

Product Details

  • ISBN-13: 9780470257036
  • Publisher: Wiley, John & Sons, Incorporated
  • Publication date: 11/10/2008
  • Pages: 672
  • Sales rank: 672,953
  • Product dimensions: 7.40 (w) x 9.10 (h) x 1.40 (d)

Meet 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.

Read More Show Less

Table of Contents

Introduction.

Chapter 1: Introducing T-SQL and Data Management Systems.

Chapter 2: SQL Server Fundamentals.

Chapter 3: SQL Server Tools.

Chapter 4: Introducing the T-SQL Language.

Chapter 5: Data Retrieval.

Chapter 6: SQL Functions.

Chapter 7: Aggregation and Grouping.

Chapter 8: Multi-Table Queries.

Chapter 9: Advanced Queries and Scripting.

Chapter 10: Transactions.

Chapter 11: Advanced Capabilities.

Chapter 12: T-SQL Programming Objects.

Chapter 13: Creating and Managing Database Objects.

Chapter 14: Analyzing and Optimizing Query Performance.

Chapter 15: T-SQL in Applications and Reporting.

Appendix A: Command Syntax Reference.

Appendix B: System Variables and Functions Reference.

Appendix C: System Stored Procedure Reference.

Appendix D: Information Schema Views Reference.

Appendix E: FileStream Objects and Syntax.

Appendix F: Answers to Exercises.

Index.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)