Murach's SQL Server 2005 for Developers
An introduction to relational databases and SQL

This chapter introduces you to the basic concepts and terms that apply to database systems. 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 SQL Server database.

Chapter 1 An introduction to relational databases and SQL
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 the relational database model 10
How a database table is organized 10
How the tables in a relational database are related 12
How the columns in a table are defined 14
How relational databases compare to other data models 16
An introduction to SQL and SQL-based systems 18
A brief history of SQL 18
A comparison of Oracle, DB2, and SQL Server 20
Other SQL-based systems 20
The Transact-SQL statements 22
An introduction to the SQL statements 22
Typical statements for working with database objects 24
How to query a single table 26
How to join data from two or more tables 28
How to add, update, and delete data in a table 30
SQL coding guidelines 32
How to work with other database objects 34
How to work with views 34
How to work with stored procedures, triggers, and user-defined functions 36
How to use SQL from an application program 38
Common data access models 38
How to use ADO.NET from a .NET application 40
Visual Basic code that retrieves data from a SQL Server database 42
C# code that retrieves data from a SQL Server database 44
Perspective 46
t


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

Murach's SQL Server 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.