O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Beginning Transact-SQL with SQL Server 2000 and 2005

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

Table of Contents

  1. Cover Page
  2. Title Page
  3. Copyright
  4. About the Authors
  5. Credits
  6. Dedication
  7. Contents
  8. Acknowledgments
  9. Foreword
  10. 1: Introducing Transact-SQL and Data Management Systems
    1. Transact-Structured Query Language
    2. SQL Server as a Relational Database Management System
    3. SQL Server and Other Products
    4. Summary
  11. 2: SQL Server Fundamentals
    1. Who Uses SQL Server?
    2. SQL Server Editions and Features
    3. Semantics
    4. Normalization Rules
    5. Applying Normalization Rules
    6. Client/Server Processes
    7. The Mechanics of Query Processing
    8. The Adventure Works Cycles Database
    9. Summary
  12. 3: Tools for Accessing SQL Server
    1. Tools for SQL Server 2000
    2. Tools for SQL Server 2005
    3. Summary
    4. Exercises
  13. 4: Introducing Transact-SQL Language
    1. The Nature of SQL
    2. Where to Begin
    3. Data Manipulation Language (DML)
    4. Data Definition Language
    5. Data Control Language
    6. Summary
    7. Exercises
  14. 5: Data Retrieval
    1. Storage and Retrieval
    2. The SELECT Statement
    3. Summary
    4. Exercises
  15. 6: SQL Functions
    1. The Anatomy of a Function
    2. Aggregate Functions
    3. Configuration Variables
    4. Conversion Functions
    5. Summary
    6. Exercises
  16. 7: Aggregation and Grouping
    1. Using Aggregate Functions
    2. Understanding Statistical Functions
    3. Grouping Data
    4. Summary
    5. Exercises
  17. 8: Multi-Table Queries
    1. Understanding Subqueries and Joins
    2. Summary
    3. Exercises
  18. 9: Data Transactions
    1. Introducing Transactions
    2. Let's Do CRUD with Data
    3. Explicit Transactions
    4. Summary
    5. Exercises
  19. 10: Advanced Queries and Scripting
    1. Subqueries
    2. Cursors
    3. Summary
    4. Exercises
  20. 11: Full-Text Index Queries
    1. Microsoft Search Service
    2. Managing and Populating Catalogs
    3. Summary
  21. 12: Creating and Managing Database Objects
    1. Data Definition Language
    2. Securing Database Objects
    3. Summary
    4. Exercises
  22. 13: Transact-SQL Programming Objects
    2. Stored Procedures
    3. User-Defined Functions
    4. Transaction Management
    5. Summary
    6. Exercises
  23. 14: Transact-SQL in Applications and Reporting
    1. Application Programming Models
    2. Selecting a Model
    3. SQL Server Reporting Services
    4. Summary
  24. A: Command Syntax Reference
    1. Transact-SQL Commands, Clauses, and Predicates
  25. B: System Variables and Functions Reference
    1. System Global Variables
  26. C: System Stored Procedure Reference
  27. D: Information Schema Views Reference
  28. E: Answers to Exercises
  29. Index