Professional SQL Server 2000 Programming

This book is a revised follow on from Professional SQL Server 7.0 Programming, to address the new features of this recent release. With a general understanding of programming principles, (eg familiarity with VB, C++, VB Script) Professional SQL Server 2000 Programming provides a comprehensive overview of the new areas of SQL Server, for programmers. There is an in-depth discussion of T-SQL, the query language of Microsoft SQL Server. From basic database design concepts a tutorial explains more advanced topics and specific areas including Stored Procedures and Advanced Queries. Advanced topics - performance tuning, security and a solid description of OLAP, which is built in with SQL Server, are then introduced. The new XML features are explored to provide an understanding of this important area. With over 1,500 pages this book covers the main topics to provide an in-depth understanding of concepts and procedures, so you can get the most out of SQL Server 2000.

The book is for readers with a general understanding of programming principles (eg familiarity with VB, C++, VBScript) and basic knowledge of Databases.

Contents

• Introduction
• Chapter 1: A Brief History Of Databases
• Chapter 2: Basic Objects in a SQL Server based relational database
• Chapter 3: Tools of The Trade
• Chapter 4: The Foundation Statements of SQL
• Chapter 5: Joining Tables
• Chapter 6: Creating and Altering Tables
• Chapter 7: Keys and Constraints
• Chapter 8: Normalization and Other Basic Design Issues
• Chapter 9: SQL Server Storage and Index Structures
• Chapter 10: Views
• Chapter 11: Writing Scripts and Batches
• Chapter 12: Stored Procedures
• Chapter 13: User Defined Functions
• Chapter 14: Transactions and Locks
• Chapter 15: Triggers
• Chapter 16: Advanced Query Topics
• Chapter 17: Distributed Transactions and Queries
• Chapter 18: SQL Cursors
• Chapter 19: XML
• Chapter 20: SQL Server and XML
• Chapter 21: The Bulk Copy Program
• Chapter 22: Beginning Data Transformation Services
• Chapter 23: Replication
• Chapter 24: Advanced Database Design
• Chapter 25: Analysis Services
• Chapter 26: Full Text Search
• Chapter 27: English Query
• Chapter 28: The Security Rounup
• Chapter 29: Performance Tuning
• Chapter 30: Administration Overview
• Chapter 31: Manipulating DTS using DSO
• Chapter 32: WMI
• Appendix A: System Functions
• Appendix B: Function Listing
• Appendix C: Tools for Working with SQL Server
• Appendix D: Access Upsizing