Advanced SQL

This chapter discusses:

• Accessing SQL From a Programming Language

  • Dynamic SQL: JDBC and ODBC

  • Embedded SQL

  • PHP Overview

• Accessing metadata

• Text Operations

• Functions and Procedural Constructs

• Triggers

• Advanced Aggregation Features

• OLAP