SQL Server 2000 Design and T-SQL Programming

Build the best SQL Server 2000 database solution for your organization Design, develop, implement, and optimize a SQL Server 2000 database that meets your company's needs. SOL Server 2000 Design and T SQL Programming explains how to plan and build a database from the ground up in SQL Server 2000. You'll start with data modeling and database design and then you'll implement your database plan. Next, you'll learn to query the database, generate reports, and create custom views. Then, it's on to data integrity, triggers, stored procedures, and distributed data topologies. Throughout the book, you'll follow a real-world business model that demonstrates a SQL Server 2000 database plan in action.

Contents

Section I: Getting Started.

Chapter 1: Database Design.

Chapter 2: Principles of Design.

Chapter 3: Planning the Physical Design.

Section II: Implementation.

Chapter 4: Implementing the Design.

Chapter 5: Building Tables.

Section III: Querying the Database.

Chapter 6: Data Retrieval.

Chapter 7: Joins: Combining Data from Multiple Tables.

Chapter 8: Summarizing Data and Reporting.

Chapter 9: Data Modification.

Chapter 10: Subqueries.

Chapter 11: Views.

Section IV: Programming for Performance.

Chapter 12: Introduction to Transactions.

Chapter 13: Locking.

Chapter 14: Data Integrity.

Chapter 15: Control of Flow Languages.

Chapter 16: Indexes.

Chapter 17: Performance and Optimization.

Chapter 18: Stored Procedures.

Chapter 19: Triggers.

Chapter 20: Distributed Data.

Section V: Beyond Transact SQL.

Chapter 21: T-SQL from Other Applications.

Chapter 22: Text Queries.

Chapter 23: English Query.

Chapter 24: Cursors.