Microsoft Sql Server 2000 Bible (w/cd)

Part - I

Laying the Foundation * Introducing SQL Server * Modeling the Logical
Database Schema * Installing and Configuring SQL Server * Using SQL Server's
Developer Tools

Part - II

Developing SQL Server Databases * Implementing the Physical Database Schema *
Retrieving Data with Select * Merging Data Using Relational Algebra * Searching
Full-Text Indexes * Creating Views * Modifying Data * Transactional Integrity *
Programming with Transact-SQL * Developing Stored Procedures * Building
User-Defined Functions * Implementing Triggers * Advanced Server - Side
Programming

Part - III

Data Connectivity * Transferring Databases * Working with Distributed Queries
* Migrating Data with DTS * Replicating Databases * ADO and ADO.NET * XML and
Web Publishing

Part - IV

Administering SQL Server * Configuring SQL Server * Maintaining the Database
* Automating Database Maintenance with SQL Server Agent * Recovery Planning *
Securing Databases

Part - V

Advanced Issues * Advanced Performance * Advanced Availability * Advanced
Scalability * Analysis Services * Advanced Portability.

 

The book is divided into 6 parts: Preparing to Develop with SQL Server; Building and Managing Databases with SQL Server; Managing Data with SQL Server; Implementing Business Rules with SQL Server; Monitoring and Performance Tuning with SQL Server; and Advanced Data Transfer and Analysis with SQL Server.
This Bible covers both beginning and advanced topics. Topics covered include: installing and configuring SQL Server; using SQL server's development tools; securing databases; retrieving data; SQL Server transactions; working with XML; understanding transact SQL language extensions; developing stored procedures; tuning queries and indexes; and developing for English query.
The book builds on sample database applications to demonstrate topics/concepts. So as readers can focus on practical information, the author is using sidebars throughout to explain the best practices associated with the product and highlight material.

Table of contents :
Preface
Acknowledgments
Part I: Laying the Foundation
Chapter 1: Introducing SQL Server
Chapter 2: Modeling the Logical Database Schema
Chapter 3: Installing and Configuring SQL Server
Chapter 4: Using SQL Servers Developer Tools
Part II: Developing SQL Server Databases
Chapter 5: Implementing the Physical Database Schema
Chapter 6: Retrieving Data with Select
Chapter 7: Merging Data Using Relational Algebra
Chapter 8: Searching Full-Text Indexes
Chapter 9: Creating Views
Chapter 10: Modifying Data
Chapter 11: Transactional Integrity
Chapter 12: Programming with Transact-SQL
Chapter 13: Developing Stored Procedures
Chapter 14: Building User-Defined Functions
Chapter 15: Implementing Triggers
Chapter 16: Advanced Server-Side Programming
Part III: Data Connectivity
Chapter 17: Transferring Databases
Chapter 18: Working with Distributed Queries
Chapter 19: Migrating Data with DTS
Chapter 20: Replicating Databases
Chapter 21: ADO and ADO.NET
Chapter 22: XML and Web Publishing
Part IV: Administering SQL Server
Chapter 23: Configuring SQL Server
Chapter 24: Maintaining the Database
Chapter 25: Automating Database Maintenance with SQL Server Agent
Chapter 26: Recovery Planning
Chapter 27: Securing Databases
Part V: Advanced Issues
Chapter 28: Advanced Performance
Chapter 29: Advanced Availability
Chapter 30: Advanced Scalability
Chapter 31: Analysis Services
Chapter 32: Advanced Portability
Appendix A: Resources
Appendix B: Sample Databases
Appendix C: SQL Server 2000 Specifications
Appendix D: Whats on the CD?
Index

Market Description :
This book is for database administrators (DBAs) and developers with or without prior knowledge of Microsoft SQL Server 2000. It assumes NO prior knowledge of SQL Server 2000. Some of the chapters provide general database material to get developers up to speed on database concepts.
Many companies have their DBA (or "database gurus") who perform both database administrative tasks and develop applications with SQL Server.

About Author :
Paul Nielsen has been a programmer, computer trainer, and consultant, focusing exclusively on database development. Currently, he is a SQL Server trainer at Learning Tree International and publishes "www.IsNotNull.com,"a free, weekly newsletter for SQL Server developers. Paul co-authored Inside the Norton Antivirus (Brady, 1993) with Peter Norton. He also served as the Technical Editor for "Access Advisor" Magazine and has written over 110 computer-related articles.