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 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



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: