Tous nos rayons

Déjà client ? Identifiez-vous

Nouveau client ?

CRÉER VOTRE COMPTE
Votre panier contient 0 article
0,00 €
Beginning Visual Basic SQL Server 7

Librairie Eyrolles - Paris 5e
Indisponible

Beginning Visual Basic SQL Server 7

Beginning Visual Basic SQL Server 7

800 pages, parution le 15/01/2000

Résumé

Most Visual Basic applications involve database programming of some kind, and SQL Server 7.0 is the database of choice for many Visual Basic programmers. This book introduces SQL Server 7.0, covering all its essential features, and then moves on to discuss building VB applications using a SQL Server backend database.

After stepping through installation of the Desktop edition of SQL Server, you'll learn about its tools, in particular the Enterprise Manager and Query Analyzer, as we create, populate, and modify an example database. You'll see how to set up security on your database and you'll also learn how to write, debug, and execute increasingly complex stored procedures to manipulate the data. Data access from VB applications using ADO is also covered, and you'll see how to prepare your application for the production environment.

Hands on examples are a key part of the book; in each chapter you will work towards building a complete and comprehensive application. The book concludes with three extensive case studies that bring together all the knowledge that you've acquired.

Who is this book for?

This book is aimed at Visual Basic developers who wish to start using SQL Server 7.0 in their applications. No knowledge of SQL Server is required, although basic familiarity with a relational database such as Access is useful.

What does this Book Cover?

  • Basics of relational database design
  • Installation of SQL Server 7.0 Desktop edition
  • Creating and modifying a database in SQL Server
  • Defining primary and foreign key relationships, and indexes
  • Setting up security on the database
  • Using T-SQL to write stored procedures
  • Calling stored procedures from VB and business server components
  • Writing English Query applications

Table of contents

Introduction
Chapter 1: Introduction to SQL Server
Chapter 2: Installing the Desktop Edition of SQL Server
Chapter 3: Creating the Development Database
Chapter 4: SQL Server Security
Chapter 5: SQL Server Query Analyzer
Chapter 6: Database Connections
Chapter 7: Introduction to Stored Procedures
Chapter 8: Stored Procedures vs T-SQL Statements
Chapter 9: Selecting Data
Chapter 10: Inserting Data
Chapter 11: Updating Data
Chapter 12: Deleting Data
Chapter 13: Creating a Front-End Program
Chapter 14: Creating a Business Server Component
Chapter 15: Working With Text Data
Chapter 16: Preparing for the Test and Production Environments
Case Study 1 - Wrox Auto Works Customer Application
Case Study 2 - Wrox Auto Works Sales Staff Application
Case Study 3 - Customer English Query Application
Appendix A: T-SQL and VB Data Types
Appendix B: ADO 2.5 Object Model and Constants
Appendix C: SQL Server Functions
Appendix D: Support and Errata

L'auteur Thearon Willis

Thearon Willis - Thearon Willis is a senior consultant with 19 years of IT experience. He is currently a consultant for an International Insurance company, which provides Web programming services. His Web development tools of choice are ASP, Dynamic HTML, Visual Basic and SQL Server.

Caractéristiques techniques du livre "Beginning Visual Basic SQL Server 7"

  PAPIER
Éditeur(s) Wrox Press
Auteur(s) Thearon Willis
Parution 15/01/2000
Nb. de pages 800
Poids 1535g
EAN13 9781861003065

Avantages Eyrolles.com

Livraison à partir de 0,01 en France métropolitaine

Paiement en ligne SÉCURISÉ

Livraison dans le monde

Retour sous 15 jours

+ d'un million de livres disponibles

satisfait ou remboursé
Satisfait ou remboursé
Paiement sécurisé
modes de paiement
Paiement à l'expédition
partout dans le monde
Livraison partout dans le monde
Service clients 0 321 79 56 75 sav@commande.eyrolles.com
librairie française
Librairie française depuis 1925