This book covers the essential technologies used for database programming on the Windows platform. SQL Server is Microsoft's corporate database solution and is the fastest growing database product, outselling Oracle in numbers of units shipped. (The information in this book applies to both SQL Server 7 and SQL Server 2000.) ADO is Microsoft's database access technology, which is used in conjunction with SQL Server.
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Illustrationen
Maße
Höhe: 209 mm
Breite: 151 mm
Gewicht
ISBN-13
978-0-7821-2974-8 (9780782129748)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Klassifikation
Sybex Inc.: Sybex editors and authors have created this book by pulling together the best information from our Microsoft database development books, including Mastering Database Programming with VB, VB Developer's Guide to ADO, VB Developer's Guide to SQL Server, SQL Server Developer's Guide to OLAP with Analysis Services, and XML Developer's Handbook.
Introduction. 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. Index.
