Chapter 3
Database for $100, Please
In This Chapter
Understanding some basic database concepts
Taking a quick look at SQL
Creating tables
Selecting data
Joining data
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, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access