Special Edition Using SQL

by Colburn, Rafe

• ISBN13: 9780789719744
• ISBN10: 0789719746
• Edition: 1st
• Format: Paperback
• Copyright: 1999-10-27
• Publisher: Que Publishing

Summary

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.

Author Biography

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.

Table of Contents

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)
More On Transact-SQL Stored Procedures	385	(18)
Writing Oracle PL/SQL Stored Procedures	403	(28)
Specific Databases
Oracle	431	(26)
Microsoft SQL Server and Sybase Adaptive Server	457	(28)
Microsoft Access	485	(24)
MSQL and MySQL	509	(24)
Publishing Databases on the Web
Web Programming Fundamentals	533	(20)
Web Application Servers	553	(26)
A Sample Web Application	579	(42)
Appendix
A System-Defined Exceptions in PL/SQ	619	(2)
Index	621