Murach's VB.NET Database Programming
with ADO.NET (1.x edition)

This chapter introduces you to the basic concepts and terms that apply to database applications. In particular, it explains what a relational database is and how you work with one using the SQL language.

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 the data in 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
Perspective 26
t


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

Murach's VB.NET Database Programming with ADO.NET

Learn more about this book

Add this book to your cart