In This Chapter
Understanding some basic database concepts
Taking a quick look at SQL
Updating and deleting data
SQL stands for Structured Query Language. SQL is the lingua franca (that's not a type of pasta but a type of tongue) of relational databases. It's the standard language used for creating and accessing relational databases and is the foundation of database processing in Java.
Java provides Java Database Connectivity (JDBC), which lets you formulate SQL statements, send them off to a database server, and process the results. To use JDBC, however, you need to know some basic concepts of SQL databases and at least enough SQL to formulate some sensible SQL statements.
This chapter won't make you a database guru or an expert on SQL — a complicated language that's the subject of many entire books, ...