Just Java™ 2, Fifth Edition

Chapter 26. Relational Databases and SQL

• Introduction to Relational Databases

• Primary and Foreign Keys

• 1-Many, Many-Many Relationships

• Normal Forms

• Relational Database Glossary

• Basic SQL Primer

• Creating and Populating Tables

• Querying and Retrieving Data

• Subquery Selections

• Result Set of a Select Query

• Updating Values

• Deleting Records and Tables

• SQL Prepared Statements and Stored Procedures

• Further Reading

• Exercises

• Some Light Relief—Reading the Docs

In the first half of this chapter we’ll look at the most widely used kind of database, the relational database. We’ll examine the model for using it, and we’ll introduce some of the special terms that database experts ...