Murach's ADO.NET 2.0 with VB 2005
An introduction to database programming

This chapter introduces you to the concepts that are essential to being an effective database programmer. In particular, it explains what a relational database is and shows you some of the basic SQL statements and features you use to work with a database from a VB application.

Chapter 1 An introduction to database programming
An introduction to client/server systems 4
The hardware components of a client/server system 4
The software components of a client/server system 6
Other client/server system architectures 8
An introduction to relational databases 10
How a table is organized 10
How the tables in a database are related 12
How to enforce referential integrity 14
How the columns in a table are defined 16
The design of the Payables database 18
How to use SQL to work with a relational database 20
How to query a single table 20
How to join data from two or more tables 22
How to add, update, and delete data in a table 24
How to work with other database objects and functions 26
How to work with views 26
How to work with stored procedures and triggers 28
How to work with functions 30


© Copyright 1998-2008 Mike Murach & Associates, Inc.  All rights reserved.

Murach's ADO.NET 2.0 with VB 2005

Learn more about this book

View the table of contents

Add this book to your cart



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.