Professional SQL Server 7.0 Programming

Robert Vieira

800 pages, parution le 10/09/1999

Ajouter à une liste

Indisponible

Résumé

With the big step up from 6.5 to 7.0, SQL Server 7.0 is effectively a new product that can be installed on a PC. This enables a more flexible and powerful database for high database transaction volume. Microsoft SQL Server 7.0 is available as a standalone product and also as part of the Microsoft Backoffice suite of products. The adoption of SQL Server 7.0 is reflected in increasing sales figures for competing titles.

With a general understanding of programming principles, SQL Server 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 of performance tuning, security and a solid description of OLAP, which is built in with SQL Server, are then introduced. Data Transformation Services are explained in detail and Remote and Linked SQL Server Agents are covered. With over 1,000 pages this book covers the main topics to provide an in-depth understanding of concepts and procedures, so programmers can get the most out of SQL Server 7.0.

Table of contents

Chapter 1: SQL Server 7.0 - Particulars and History
Chapter 2: RDBMS Basics: What Makes Up a SQL Server Database?
Chapter 3: Tools of the Trade
Chapter 4: The Foundation Statements of T-SQL
Chapter 5: Joining Tables
Chapter 6: Creating and Altering Tables
Chapter 7: Constraints
Chapter 8: Normalization and Other Basic Design Issues
Chapter 9: Speeding Performance: SQL Server Storage and Index Structures
Chapter 10: Views
Chapter 11: Writing Scripts and Batches
Chapter 12: Code Storage: Stored Procedures
Chapter 13: Transactions and Locks
Chapter 14: Triggers
Chapter 15: Asking a Better Question: Advanced Queries
Chapter 16: Spreading Things Out: Distributed Queries and Transactions
Chapter 17: SQL Cursors
Chapter 18: Making a Change... Bulk Copy Program and Data Transformation Services
Chapter 19: Replication
Chapter 20: Advanced Design
Chapter 21: OLAP
Chapter 22: English Query and Full-Text Search
Chapter 23: Security
Chapter 24: Performance Tuning
Chapter 25: Administration Overview
Appendix A: Global Variables
Appendix B: Function Listing
Appendix C: Tools for Our Time
Appendix D: Error Listing
Appendix E: Access Upsizing