CHAPTER

5

Relational Database Management Systems and SQL

TABLE OF CONTENTS

5.1    Brief History of SQL in Relational Database Systems

5.2    Architecture of a Relational Database Management System

5.3    Defining the Database: SQL DDL

5.4    Manipulating the Database: SQL DML

5.5    Active Databases

5.6    Using COMMIT and ROLLBACK Statements

5.7    Temporal Databases and SQL

5.8    SQL Programming

5.9    JDBC

5.10  The System Catalog

5.11  Chapter Summary

Exercises

CHAPTER OBJECTIVES

In this chapter you will learn the following:

  The history of relational database systems and SQL

  How the three-level architecture is implemented in relational systems

  How to create and modify a relational database using SQL DDL

  How to retrieve and ...

Get Databases Illuminated, 3rd Edition 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.