ISBN 9788126506590,Beginning Transact-Sql With Sql Server 2000 & 2005

Beginning Transact-Sql With Sql Server 2000 & 2005


Paul Turley



Wiley India Pvt Ltd

Publication Year 2005

ISBN 9788126506590

ISBN-10 8126506598


Number of Pages 572 Pages
Language (English)

Computer programming

Beginning Transact-SQL Programming teaches beginners who have not yet programmed with Transact-SQL. Some familiarity with relational databases and basic SQL is expected, and some programming experience is helpful. The primary audience is database developers; secondary markets include database administrators (DBAs) and business analysts. The book begins with an overview of SQL Server query operations and tools used with Transact-SQL. After a quick review of basic query language commands and syntax, the author quickly moves to show how to design and build applications of increasing complexity. He covers such important tasks as: ? Full text indexing ? Optimizing query performance ? Programming techniques using views and stored procedures ? Application design and security considerations. Table of contents : Acknowledgments Foreword Introducing Transact-SQL and Data Management Systems SQL Server Fundamentals Tools for Accessing SQL Server Introducing Transact-SQL Language Data Retrieval SQL Functions Aggregation and Grouping Multi-Table Queries Data Transactions Advanced Queries and Scripting Full-Text Index Queries Creating and Managing Database Objects Transact-SQL Programming Objects Transact-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: Answers to Exercises Index Market Description : Beginning Database Programmers About Author : Paul Turley teaches business intelligence, database design, decision-support reporting, application development, and project management courses for Netdesk in Seattle. He's the lead author of Wrox Professional SQL Server Reporting Services, and also co-authored SQL Server 2000 Data Warehousing with Analysis Services, Access 2003 VBA, and Professional Access 2000 Programming.