SQL Server and ADO Programming Complete is a one-of-a-kind book--valuable both for its broad content and its low price. The book contains the essentials of building database applications with SQL Server, ADO, and Visual Basic--from database basics to OLAP and Analysis Services.

With SQL Server and ADO Programming Complete, you'll learn everything you need to know for database programming, including database access with ADO and Visual Basic as well as Web and XML database development. The book also details SQL Server and Visual Basic programming and interactions. Get up to speed on the ADO Object Model and conrolling transactions in ASP, use this knowledge to build an online store, and soon you'll be an expert!

SQL Server and ADO Programming Complete introduces you to the work of some of Sybex's finest authors, so you'll know where to go to learn even more about SQL Server and ADO programming with Visual Basic.

CONTENTS AT A GLANCE

Introduction

PART I: Database Basics and Structured Query Language

Chapter 1: Database Access: Architectures and Technologies
From Mastering Database Programming with Visual Basic 6

Chapter 2: Basic Concepts of Relational Databases
From Mastering Database Programming with Visual Basic 6

Chapter 3: Structured Query Language
From Mastering Database Programming with Visual Basic 6

Chapter 4: Transact-SQL
From Mastering Database Programming with Visual Basic 6

Chapter 5: Making the Most of Stored Procedures
From Mastering Database Programming with Visual Basic 6

Chapter 6: The Visual Database Tools
From Mastering Database Programming with Visual Basic 6

PART II: Programming with ADO

Chapter 7: Overview of ADO and Visual Basic
From Visual Basic Developer's Guide to ADO

Chapter 8: Data Access
From Visual Basic Developer's Guide to ADO

Chapter 9: The ADO Object Model
From Visual Basic Developer's Guide to ADO

Chapter 10: Programming with ADO
From Mastering Database Programming with Visual Basic

Chapter 11: More ADO Programming
From Mastering Database Programming with Visual Basic

Chapter 12: Fine-Tuning ADO through Visual Basic Code
From Visual Basic Developer's Guide to ADO

PART III: Web and XML Database Programming

Chapter 13: Accessing Databases over the Web
From Mastering Database Programming with Visual Basic

Chapter 14: Controlling Transactions in ASP
From Mastering Active Server Pages 3

Chapter 15: XML and MS Databases
From XML Developer's Handbook

Chapter 16: Building an Online Store
From Mastering Database Programming with Visual Basic

PART IV: SQL Server Programming with Visual Basic

Chapter 17: Overview of Visual Basic and SQL Server
From Visual Basic Developer's Guide to SQL Server

Chapter 18: SQL Distributed Management Objects
From Visual Basic Developer's Guide to SQL Server

Chapter 19: SQL Namespace
From Visual Basic Developer's Guide to SQL Server

Chapter 20: Data Transformation Services
From Visual Basic Developer's Guide to SQL Server

PART V: OLAP and Analysis Services

Chapter 21: OLAP and Data Mining Concepts
From SQL Server Developer's Guide to OLAP with Analysis Services

Chapter 22: Analysis Services Architecture
From SQL Server Developer's Guide to OLAP with Analysis Services

Chapter 23: Using Analysis Services
From SQL Server Developer's Guide to OLAP with Analysis Services

Chapter 24: Using ADO MD to Summarize Data
From Visual Basic Developer's Guide to ADO

Index