SQL All-in-One For Dummies®, 2nd Edition

Book V

SQL and Programming

Contents at a Glance

Chapter 1: Database Development Environments

Microsoft Access

Microsoft SQL Server

IBM DB2

Oracle 11gR2

SQL Anywhere

PostgreSQL

MySQL

Chapter 2: Interfacing SQL to a Procedural Language

Building an Application with SQL and a Procedural Language

Chapter 3: Using SQL in an Application Program

Comparing SQL with Procedural Languages

Difficulties in Combining SQL with a Procedural Language

Embedding SQL in an Application

Using SQL Modules with an Application

Chapter 4: Designing a Sample Application

Understanding the Client’s Problem

Approaching the Problem

Determining the Deliverables

Building an Entity-Relationship Model

Transforming the Model

Creating Tables

Changing Table Structure

Removing Tables

Designing the User Interface

Chapter 5: Building an Application

Designing from the Top Down

Coding from the Bottom Up

Testing, Testing, Testing

Chapter 6: Understanding SQL’s Procedural Capabilities

Embedding SQL Statements in Your Code

Introducing Compound Statements

Following the Flow of Control Statements

Using Stored Procedures

Working with Triggers

Using Stored Functions

Passing Out Privileges

Using Stored Modules

Chapter 7: Connecting SQL to a Remote Database

Native Drivers

ODBC and Its Major Components

What Happens When the Application Makes a Request