O'Reilly logo

Java All-in-One For Dummies, 4th Edition by Doug Lowe

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3

Database for $100, Please

In This Chapter

arrow Understanding some basic database concepts

arrow Taking a quick look at SQL

arrow Creating tables

arrow Selecting data

arrow Joining data

arrow 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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required