Professional SQL Server 2000 Programming

The description below is the publishers own description.

Title: Professional SQL Server 2000 Programming ISBN: 1861004486 Pub Date: December 2000

What does this book cover?

• A complete introduction to Transact-SQL
• Database design issues 
• Creating and using views, stored procedures, and user defined functions 
• Responding to events with triggers 
• Making your SQL Server secure 
• Retrieving your data as XML 
• An introduction to Analysis Services 
• Moving data using Data Transformation Services and the bulk copy program 
• Maintaining the integrity of distributed data with replication 
• Technology overview

SQL Server 2000 is the latest and most powerful version of Microsoft's data warehousing and relational database management system. This new release is tightly integrated with Windows 2000 and offers more support for XML, as well as improved Analysis Services for OLAP and data mining.

Professional SQL Server 2000 provides a comprehensive guide to programming with SQL Server 2000, from a complete tutorial on Transact-SQL to an in-depth discussion of new features, such as indexed views, user-defined functions, and the wealth of new SQL Server features to support XML. Whether you're coming to SQL Server 2000 from another relational database management system, upgrading your existing system, or perhaps want to add programming skills to your DBA knowledge, you'll find what you need in this book to get to grips with SQL Server 2000 development.

Who is this book for? 

This book is aimed at the SQL Server developer who wants to make the most out of the new features of SQL Server 2000. No knowledge of SQL Server is assumed, although in order to follow this book, you do need to have an understanding of programming basics such as variables, data types, and procedural programming. Database administration is also covered but only insofar as it affects the SQL Server developer

Summary of 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 Roundup
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 

Buy this book at Amazon USA

Buy this book at Amazon UK

Jump to: Top of Page or HOME or Printer friendly page

Search W3Schools:

What Others Say About Us

Does the world know about us? Check out these places:

Dogpile Alta Vista MSN Google Excite Lycos Yahoo Ask Jeeves

We Help You For Free. You Can Help Us!

• Tell your newsgroup or mailing list
• Link to us from your pages
• Help us correct errors and broken links
• Help us with spelling and grammar
• Validate the XHTML code of this page

W3Schools is for training only. We do not warrant its correctness or its fitness for use. The risk of using it remains entirely with the user. While using this site, you agree to have read and accepted our terms of use and privacy policy.

Copyright 1999-2002 by Refsnes Data. All Rights Reserved

How we converted to XHTML