Special Edition Using SQL

Special Edition Using SQL provides a comprehensive walk through of the SQL language. At the same time, this book is a useful reference to someone who is already an experienced database user and SQL programmer. It includes lots of information that will help you build, maintain, and manage a database. Topics covered include Database Design, Aggregating Query Results, Organizing Query Results, Real World Issues, Database Performance and Integrity, Database Security, Transactions, Stored Procedures, Database Management, Writing a Custom Loader in Perl, ODBC, DBI/DBD, JDBC, Web Publishing, and Tools for Web Publishing.

Rafe Colburn is a programmer working for Interpath Communications in the Professional Services department. He spends most of his time writing database-backed Web applications used on both public Web sites and Intranets. He has extensive experience designing both small and large scale databases using a number of popular relational database packages. He is also the author of Teach Yourself CGI Programming in a Week.

Introduction

1

(6)

Designing and Constructing a Database

The Structured Query Language

7

(20)

Database Design

27

(30)

Creatig Databases

57

(22)

Creating, Changing, and Removing Records

79

(20)

Retrieving Data from a Database

The SELECT Statement

99

(28)

Using the WHERE Clause

127

(22)

Aggregating Query Results

149

(22)

Combining Tables Using Joins

171

(30)

Subqueries

201

(28)

Database Management

Using Views

229

(26)

The SQL Security Model

255

(24)

Real-World Issues

Handling Specific Types of Data

279

(30)

Database Performance and Integrity

309

(22)

Transactions and Cursors

331

(26)

Stored Procedures

Writing Stored Procedures

357

(28)

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Special Edition Using SQL

Summary

Author Biography

Table of Contents

Supplemental Materials