Professional SQL Server 7 Programming

The description below is the publishers own description.

Title: Professional SQL Server 7 Programming ISBN: 1861002319 Pub Date: September 1999

Subject Area

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.

Book Overview

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.

What's Great About this Book

• Provides a comprehensive roadmap of SQL Server for programmers.
• Real-world examples enable an in-depth understanding so programmers can get the most out of SQL Server 7.0.
• Covers all areas of SQL Server 7.0 of interest to programmers - from basic database design, to Stored Procedures, English Query, performance tuning, security, DTS and a solid description of OLAP.

Who is this Book for?

• Assumes general understanding of programming principles (eg familiarity with VB, C++, VB Script)
• assumes basic knowledge of Databases
• Anyone who needs to program with SQL Server 7.0

Summary 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

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