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, including ...
Get Java All-in-One For Dummies, 5th 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.
