SQL Books

















Home
SQL Basics:

SQL HOME
SQL Introduction
SQL Select
SQL Where
SQL And & Or
SQL Between
SQL Distinct
SQL Order By
SQL Try It
SQL Insert
SQL Update
SQL Delete
SQL Count

SQL Advanced:

SQL Functions
SQL Group By
SQL Aliases
SQL Join
SQL Create
SQL Alter

SQL Quiz Test

Resources:

SQL Books












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



Jump to : Top Of Page or HOME.


We Help you for free. Please Help us!

Help us correct errors
Help us with spelling and grammar
Tell us what you think
Link to us from your pages



All information in this Web is for training only. We do not make any warranties of its correctness or
its fitness to be used. The risk of using it remains with the user.
Copyright © 1999-2001 by Refsnes Data. All Rights Reserved.










More Tutorials:


HTML  XHTML
XML  XSL
CSS  DTD
WAP  WML
JavaScript
DHTML  Flash
VBScript  ASP
SQL  AppML






News:

The Future ofProgramming

Web Security

Browser News

Web Standards






References:

HTML 4.01 Ref

XHTML 1.0 Ref

WML 1.1 Ref

CSS Reference

XSLT Elements

ASCII Reference

Entity Reference

HTML Colors

Color Values

Color Names

WAP Pages






Validation:


HTML  XHTML
CSS  DTD
XML  WML







About W3Scripts

Please link to us








Larger Text?








 XML Partners: