Skip to main content

SQL Server and ADO Programming Complete

SQL Server and ADO Programming Complete

Dave Evans, Greg Jarboe, Hollis Thomases, Mari Smith, Chris Treadaway

ISBN: 978-0-782-12974-8

Sep 2001

1024 pages

Select type: Paperback

Product not available for purchase


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.


PART I Database Basics and Structured Query Language.

Chapter 1 Database Access: Architectures and Technologies.

Chapter 2 Basic Concepts of Relational Databases.

Chapter 3 Structured Query Language.

Chapter 4 Transact-SQL.

Chapter 5 Making the Most of Stored Procedures.

Chapter 6 The Visual Database Tools.

PART II Programming with ADO.

Chapter 7 Overview of ADO and Visual Basic.

Chapter 8 Data Access.

Chapter 9 The ADO Object Model.

Chapter 10 Programming with ADO.

Chapter 11 More ADO Programming.

Chapter 12 Fine-Tuning ADO through Visual Basic Code.

PART III Web and XML Database Programming.

Chapter 13 Accessing Databases over the Web.

Chapter 14 Controlling Transactions in ASP.

Chapter 15 XML and MS Databases.

Chapter 16 Building an Online Store.

PART IV SQL Server Programming with Visual Basic.

Chapter 17 Overview of Visual Basic and SQL Server.

Chapter 18 SQL Distributed Management Objects.

Chapter 19 SQL Namespace.

Chapter 20 Data Transformation Services.

PART V OLAP and Analysis Services.

Chapter 21 OLAP and Data Mining Concepts.

Chapter 22 Analysis Services Architecture.

Chapter 23 Using Analysis Services.

Chapter 24 Using ADO MD to Summarize Data.


Download Tables from Chapter 23
Download a .zip file with the tables referenced in Ch. 23.
To uncompress the file, Windows users can use Windows built-in ZIP utilities or a 3rd party utility like WinZip or WinRAR. Macintosh users can simply double-click the downloaded file to extract using the built-in archive utility.