Professional Visual Basic 6 databases

Charles Williams

800 pages, parution le 01/08/1999

Ajouter à une liste

Indisponible

Résumé

This book has broad coverage of many issues relating to professional database design and implementation using VB6. An overview of relational database design and client server structure is given followed by an investigation into the various methods of database access available to VB programmers.

The author shows how to use SQL to manipulate data and investigates advanced topics such as data-warehousing (archiving data to larger database stores) and data-mining (retrieving the valuable data from these warehouses).

Finally, these concepts are brought together with a range of 2 and 3 tier solutions which demonstrate the techniques learned in a practical way. Sections on using VB to create and modify SQL Server 7 and Oracle 8 databases are also included.

Table of contents

Introduction
Chapter 1: The Client-Server Model
Chapter 2: Database Design
Chapter 3: A Guide to Data Access
Chapter 4: Working with the ADO Data Control
Chapter 5: Upsizing to SQL Server
Chapter 6: An Overview of Structured Query Language
Chapter 7: An Introduction to ADO
Chapter 8: Views, Stored Procedures and Triggers
Chapter 9: Implementing a 2-Tier Solution
Chapter 10: Data Validation, Transactions and Error Trapping
Chapter II: An Introduction to 3-Tier Solutions
Chapter 12: Passing Data In N-Tier Applications
Chapter 13: Implementing a Practical 3-Tier Solution
Chapter 14: The Three Class Concept
Chapter IS: The Microsoft Distributed Transaction Coordinator
Chapter 16: Securing Client-Server Applications
Chapter 17: Deploying Client-Server Applications
Chapter 15: Data Warehousing
Chapter 19: Generating Reports
Case Study: An Example 3-Tier Distributed Application using Microsoft Transaction Server
Appendix A: SQL: Overview and the ANSI SQL-92 Standard
Appendix B: Transact-SQL
Appendix C: PL/SQL
Appendix D: Jet SQL
Appendix E: ADO Object Summary
Appendix F: ADO Constants
Appendix G: ADO Properties Collection
Appendix H: ADO Error Codes
Appendix I: Database Data Types
Appendix J: Installing Microsoft Transaction Server
Appendix K: Active Server Pages

L'auteur - Charles Williams

Charles Williams naît en 1909 au Texas. Il s'engage dans la marine marchande, puis sert dans l’armée jusqu’à la fin de la Seconde Guerre mondiale. Il s’installe ensuite à Los Angeles après la guerre et travaille pour Mackay Radio. Il publie son premier roman en 1951 et rencontre immédiatemment le succès. Au total, il écrit vingt-deux romans, est adapté à treize reprises sur grand écran et collabore à l’écriture de plusieurs scénario. Bien-aimé du public français, il reçoit le Grand Prix de Littérature policière en 1956. Il se suicide en 1975 dans son appartement de Los Angele