SQL All-in-One Desk Reference For Dummies^®

by Allen G. Taylor (Database Consultant, Oregon City, Oregon)

• ISBN13: 9780470119280
• ISBN10: 0470119284
• Format: Paperback
• Copyright: 2007-07-01
• Publisher: For Dummies

Summary

SQL is the international standard language for creating and maintaining relational databases. This book is a compendium of information about SQL and relational database design, development, and maintenance. The nine mini-books cover the full spectrum of issues that arise in building, using, and maintaining relational database systems.Book I: SQL ConceptsBook II: Relational Database DevelopmentBook III: SQL QueriesBook IV: Data SecurityBook V: SQL and ProgrammingBook VI: SQL and XMLBook VII: Database Tuning OverviewBook VIII: Appendixes

Author Biography

Allen G. Taylor is a 30-year veteran of the computer industry and the author of 25 books, including SQL For Dummies, Crystal Reports 10 For Dummies, Database Development For Dummies, Access 2003 Power Programming with VBA, and SQL Weekend Crash Course. He lectures internationally on databases, networks, innovation, and entrepreneurship. He also teaches database development through a leading online education provider and teaches microprocessor design at Portland State University. For the latest news on Allen’s activities, check out www.DatabaseCentral.Info. You can contact Allen at [e-mail].

Table of Contents

Introduction

SQL Concepts

Relational Database Basics

Modeling a System

SQL Overview

SQL and the Relational Model

The Major Components of SQL

SQL Characteristics

Relational Database Development

System Development Overview

Building a Database Model

Balancing Performance and Correctness

Creating a Database with SQL

SQL Queries

Values, Variables, Functions, and Expressions

SELECT Statements and Modifying Clauses

Querying Multiple Tables with Subqueries

Querying Multiple Tables with Relational Operators

Data Security

Protecting Against Hardware Failure and External Threats

Protecting Against User Errors and Conflicts

Assigning Access Privileges

Error Handling

SQL and Programming

Database Development Environments

Interfacing SQL to a Procedural Language

Using SQL in an Application Program

Designing a Sample Application

Building a Sample Application

SQL's Procedural Capabilities

Connecting to a Remote Database

SQL and XML

XML/SQL Basics

Storing XML Data in SQL Tables

Retrieving Data from XML Documents

Database Tuning Overview

Tuning the Database

Tuning the Environment

Finding and Eliminating Bottlenecks

Appendixes

SQL: 2003 Reserved Words

Glossary

Index

Table of Contents provided by Publisher. All Rights Reserved.