Book V

SQL and Programming


Contents at a Glance

Chapter 1: Database Development Environments

Microsoft Access

Microsoft SQL Server


Oracle 11gR2

SQL Anywhere



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

Get SQL All-in-One For Dummies®, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.