Introduction

The standard language of relational database access is SQL (Structured Query Language). SQL is not a conventional programming language. It was designed for the purpose of accessing tabular data. Every Relational Database Management System (RDBMS) implements a slightly different version of SQL. In this chapter, we examine the Apache Derby implementation of the SQL language. If you are familiar with other RDBMS products, you will already understand many aspects of the Apache Derby implementation of SQL, thanks to the industry acceptance of the ISO/ANSI SQL standard.

SQL is divided into three major categories:

  • DDL (Data Definition Language)— Used to create, modify, or drop database objects

  • DML (Data Manipulation Language)— Used to ...

Get Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape™ now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.